Parses a log file and writes it to a [SQLite] database for better querying.
log2sql --help
For example,
log2sql -f myfile.log -d ";" colname1 colname2 colname3 colname4
will parse the file myfile.log with four columns, separated by ;s,
and write the output to myfile-out.db.
Likewise, you could do
cat myfile.log | log2sql -d ";" colname1 colname2 colname3 colname4
by leaving the -f flag off. This will write a database called
log-data.db.
log2sql will always merge superfluous colmuns into the last one.
For example, if you specify two columns but your data has three, then
log2sql will merge the third column into the second.
Install stack and run stack setup && stack build.
Copyright © Covenant Eyes 2015
This package is licensed under the MIT license
(see LICENSE).