3 ms·
im sure, but honestly, i would love to have a db engine that just writes/reads csv or json. does it exist?
by trgn 6mo ago
im sure, but honestly, i would love to have a db engine that just writes/reads csv or json. does it exist?
- herpdyderp 6mo agoI wrote a CSV DB engine once! I can't remember why. For fun?
- zabzonk 6mo agoMicrosoft actually provide an ODBC CSV data source out of the box.
- banana_giraffe 6mo agoDuckDB can do exactly this, once you get the API working in your system, it becomes something simple like SELECT \* from read_csv('example.csv'); Writing generally involves reading to an in-memory database, making whatever changes you want, then something like COPY new_table TO 'example.csv' (HEADER true, DELIMITER ',');
- akdev1l 6mo agoSQLite can do it
- trgn 6mo agoit's storage file is a csv? or do you mean import/export to csv?
- akdev1l 6mo agoYou can import csv files into in memory tables and query them or you can use the csv extensions $ sqlite3 :memory: .import myfile.csv mytable SELECT * FROM mytable; $ sqlite3 :memory: SELECT * FROM csv_read('myfile.csv');
- hunterpayne 6mo agoPostgres can do that as well.