4 ms·
I think tools like this don’t exist much because it typically makes more sense to just put it into a database or at least SQLite ... then do whatever you want f
by usgroup 8y ago
I think tools like this don’t exist much because it typically makes more sense to just put it into a database or at least SQLite ... then do whatever you want from there.
Meanwhile for all your streaming, filtering and aggregating need there is awk.
I’ve never been board enough to write my own little sql library for awk, but I’d be surprised if it doesn’t exist.
- TkTech 8y agoThat's exactly what q (the linked tool) and almost all other tools like it do - it loads into an sqlite database and provides some handy wrappers, that's it.
- IOT_Apprentice 8y agoSqawk is an Awk-like program that uses SQL and can combine data from multiple files. It is powered by SQLite. https://github.com/dbohdan/sqawk https://github.com/dbohdan/sqawk
- dima55 8y agoThere's also this: https://github.com/dkogan/vnlog This is effectively a set of wrappers around awk, sort, join, etc that knows about field names, and lets you use the vanilla shell tools in a much nicer way. It's exactly what you want for the 99% use case. If your problem is complicated enough that you feel like sql is what you want, maybe leaving the shell is ok at that point.