Sqawk: A fusion of SQL and Awk: Applying SQL to text-based data files
1–10 of 12 posts
Re: Sqawk: A fusion of SQL and Awk: Applying SQL to text-based data files
#2Now I must work on a hieroglyphic extension, so that I can "Sqawk Like an Egyptian".
I'll show myself out.
Re: Sqawk: A fusion of SQL and Awk: Applying SQL to text-based data files
#3Also relevant, SQLite supports loading CSV files as virtual tables [1]
Re: Sqawk: A fusion of SQL and Awk: Applying SQL to text-based data files
#4Also relevant, SQLite supports loading CSV files as virtual tables [1] [1]: https://sqlite.org/csv.html
And don't forget DuckDB [1].
Re: Sqawk: A fusion of SQL and Awk: Applying SQL to text-based data files
#5Now I must work on a hieroglyphic extension, so that I can "Sqawk Like an Egyptian". I'll show myself out.
(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
[1] :a) https://www.youtube.com/watch?v=D2iswCnV9ec
b) https://www.youtube.com/watch?v=kCCXRerqaJI
Re: Sqawk: A fusion of SQL and Awk: Applying SQL to text-based data files
#6Also relevant, SQLite supports loading CSV files as virtual tables [1] [1]: https://sqlite.org/csv.html
as has odbc from way back when
Re: Sqawk: A fusion of SQL and Awk: Applying SQL to text-based data files
#7I 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.
Re: Sqawk: A fusion of SQL and Awk: Applying SQL to text-based data files
#8I 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 any…
Agree; 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?
Re: Sqawk: A fusion of SQL and Awk: Applying SQL to text-based data files
#9I 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 any…
Agree; 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]
Re: Sqawk: A fusion of SQL and Awk: Applying SQL to text-based data files
#10I wonder how this compares to csvkit [1].