4 ms·
Sqawk: A fusion of SQL and Awk: Applying SQL to text-based data files
- smitty1e 1y agoNow I must work on a hieroglyphic extension, so that I can "Sqawk Like an Egyptian". I'll show myself out.
- sargstuff 1y ago(IMHO) perhaps ide box as an intermediate step. aka sqwak box with support for ascii animations.[0] Then, can present a "sqwak like an egyptian" demo. Perhaps extened support for converting data to floppy[1] / modem[2] sounds. [0] : https://github.com/octobanana/asciimation https://github.com/octobanana/asciimation [1] :a) https://www.youtube.com/watch?v=D2iswCnV9ec https://www.youtube.com/watch?v=D2iswCnV9ec b) https://www.youtube.com/watch?v=kCCXRerqaJI [2] : https://www.youtube.com/watch?v=k992RwXBbrY https://www.youtube.com/watch?v=k992RwXBbrY
- augusto-moura 1y agoAlso relevant, SQLite supports loading CSV files as virtual tables [1] [1]: https://sqlite.org/csv.html https://sqlite.org/csv.html
- mrbungie 1y agoAnd don't forget DuckDB [1]. [1] https://duckdb.org/docs/stable/data/csv/overview.html https://duckdb.org/docs/stable/data/csv/overview.html
- samgranieri 1y agoAnd also there’s the \COPY command in postgresql
- zabzonk 1y agoas has odbc from way back when
- alisonatwork 1y agoI was hoping this was going to be a magnificent awk script that somehow implemented an SQL parser. It is not. This is the one time where "written in Rust" in the headline could have been useful, since it would have avoided me wasting a click. This is more like a simple implementation of ClickHouse/DuckDB/SQLite/etc than anything awkish - it's not a streaming tool, it loads the entire dataset into RAM before doing anything.
- garciasn 1y agoAgree; I don’t see how this is anything but SQLite-esque. Other than -F for field separators, I see nothing awkish about this at all, but perhaps I didn’t go into the docs enough?
- deleted 1y ago[deleted]
- aslakhellesoy 1y agoI wonder how this compares to csvkit [1]. [1]: https://csvkit.readthedocs.io/ https://csvkit.readthedocs.io/
- sargstuff 1y agosqawk "oberts" extension adding julia and R would faciliate a "something to sqawk about" demo.