3 ms·
I've written a log file viewer (http://lnav.org http://lnav.org) that exports log messages as SQLite virtual tables. I was hoping this project also leveraged v
by tstack 13y ago
I've written a log file viewer (http://lnav.org http://lnav.org) that exports log messages as SQLite virtual tables. I was hoping this project also leveraged virtual tables since they're one of the coolest features in SQLite.
lnav tries to push things a little further and extract data from unstructured log messages. For example, given the following message:
"Registering new address record for 10.1.10.62 on eth0."
It will create a virtual table with two columns that capture the IP address (10.1.10.62) and the device name (eth0). Queries against this table will return the values from all messages with the same format (Registering new address record for COL_0 on COL_1). See http://lnav.readthedocs.org/en/latest/data.html http://lnav.readthedocs.org/en/latest/data.html for more info.
- pfraze 13y agoVery cool! Looking forward to trying this out today.