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

▲ banana_giraffe 3 hours ago | parent | next [-]

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 3 hours ago | parent | prev | next [-]

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

	▲	zabzonk an hour ago \| parent [-]
		Microsoft actually provide an ODBC CSV data source out of the box.

▲ akdev1l 2 hours ago | parent | prev [-]

SQLite can do it

	▲	trgn an hour ago \| parent [-]
		it's storage file is a csv? or do you mean import/export to csv?