Remix.run Logo
Remix clone Hacker News
new | show | ask | jobsGithub
▲ banana_giraffe 6 hours ago

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