3 ms·
You can do that with SQLite too: https://til.simonwillison.net/sqlite/one-line-csv-operations https://til.simonwillison.net/sqlite/one-line-csv-operations (Duc
by simonw 4y ago
You can do that with SQLite too: https://til.simonwillison.net/sqlite/one-line-csv-operations https://til.simonwillison.net/sqlite/one-line-csv-operations
(DuckDB is a lot more ergonomic for that kind of thing though - it's really fantastic tech)
- sam_lowry_ 4y agoUnlike sqlite, DuckDB is a very complex and much less polished.
- pletnes 4y agoCool! Although I believe duckdb can do it on disk / out of memory, so querying huge files are possible. I also like its syntax, I tend to CREATE VIEW mycsv AS SELECT * FROM ‘my.csv’ (or similar). Then I think you can select or join even across files, although I haven’t gotten that far yet.