im sure, but honestly, i would love to have a db engine that just writes/reads csv or json. doe...

trgn • today at 5:44 PM • 3 replies • view on HN

im sure, but honestly, i would love to have a db engine that just writes/reads csv or json. does it exist?

banana_giraffe • today at 5:51 PM

DuckDB 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 ',');

herpdyderp • today at 5:47 PM

I wrote a CSV DB engine once! I can't remember why. For fun?

➕ show 1 reply

akdev1l • today at 6:29 PM

SQLite can do it

➕ show 1 reply

alt Hacker News