Hacker News Reader

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

View on HN

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.

And automate it easily.

Reply on news.ycombinator.com