3 ms·
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
by gaius 9y ago
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
- piyh 9y agoAnd automate it easily.
- chrisweekly 9y agoThe amazing but criminally under-appreciated 'lnav' (https://lnav.org https://lnav.org) facilitates exactly this approach. SQLite under the hood.
- flamtap 9y agoOh, 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.
- tracker1 9y agoWould 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.