4 ms·
From what I've read about it, DuckDB comes close. Regular files, like sqlite, but pg functionality.
by munchlax 1y ago
From what I've read about it, DuckDB comes close. Regular files, like sqlite, but pg functionality.
- OutOfHere 1y agoIf I am not mistaken, DuckDB is suitable for columnar analytics queries, less so for multi-column row extractions. Which PG-like functionality does it offer on top?
- datadrivenangel 1y agoDuckDB does aim to be Postgres compatible from a SQL syntax perspective, but you are 100% correct that it is not optimized for individual transactions. I'm a huge advocate of DuckDB, but strongly consider your life choices if you want to use it as a transactional database.
- Imustaskforhelp 1y agois there something like duckdb but suited for transactional database while still being postgres compatible It might sound confusing but I wish to genuinely have something of a simpler postgres (in sqlite?) and then later if need be, i could migrate to postgres I suppose.
- nullzzz 1y agoNo it’s not ”pg functionality”. It’s close to SQL standard compliance but not close to what Postgres has to offer. Also, single transaction writing at a time, in-process etc.