Re:Appropriate Uses for SQLite
by gaius on Monday February 12, 2018 @08:55AM
(#16358525)
Bulk loading a CSV or similar into SQLite for analysis with SQL statements is an incredibly productive technique. With a few lines of code you can load any log file, load and merge multiple logs by timestamp, whatever you like
[ Parent
| on HN ]
Re:Appropriate Uses for SQLite
by chrisweekly on Monday February 12, 2018 @02:14PM
(#16361124)
The amazing but criminally under-appreciated 'lnav' (https://lnav.org) facilitates exactly this approach. SQLite under the hood.
Oh, I hope there is a Windows-compatible way to use this (i.e.: in a .NET dev environment), if not now, then in the future.
Would probably work under the Windows Subsystem for Linux (WSL), in Win10, or via Docker for Windows.
I've done similar with node.js streams pretty easily.