4 ms·
> 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
by samatman 3y ago
> 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 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.
- blagie 3y agoInteresting. Thank you. It's intentionally available as a single source file: https://www.sqlite.org/src/artifact?ci=trunk&filename=ext/misc/csv.c 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.