News for hackers. Stuff that matters.
Re:Wddbfs – Mount a SQLite database as a filesystem by samatman on Sunday February 18, 2024 @01:39PM (#39421716)
> For your model to work, what would be needed is the reverse: a system which allows me to interact with TSV files with SQL.

Several such systems exist, one of which is SQLite. https://www.sqlite.org/csv.html

I don't know if there's a virtual table extension for tab separated values, but SQLite imports them just fine.

Re:Wddbfs – Mount a SQLite database as a filesystem by blagie on Tuesday February 20, 2024 @08:28PM (#39449192)
Interesting. Thank you.

It's intentionally available as a single source file:

https://www.sqlite.org/src/artifact?ci=trunk&filename=ext/mi...

For easy modification to handle TSV, TSVx, JSON, Pandas, YAML, or whatever else my heart desires.