Sqawk: A fusion of SQL and Awk: Applying SQL to text-based data files

by ossusermivami on 5/26/2025, 9:11:58 PM with 10 comments

  • by alisonatwork on 5/27/2025, 2:39:56 AM

    I 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.

  • by aslakhellesoy on 5/27/2025, 7:53:24 AM

    I wonder how this compares to csvkit [1].

    [1]: https://csvkit.readthedocs.io/

  • by augusto-moura on 5/27/2025, 12:05:31 AM

    Also relevant, SQLite supports loading CSV files as virtual tables [1]

    [1]: https://sqlite.org/csv.html

  • by smitty1e on 5/26/2025, 11:38:40 PM

    Now I must work on a hieroglyphic extension, so that I can "Sqawk Like an Egyptian".

    I'll show myself out.

  • by sargstuff on 5/29/2025, 10:02:41 PM

    sqawk "oberts" extension adding julia and R would faciliate a "something to sqawk about" demo.