What if we treated Postgres like SQLite?

Re:What if we treated Postgres like SQLite? by OutOfHere on Monday September 22, 2025 @11:51AM (#45335166)

If 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?

[ Parent | on HN ]

Re:What if we treated Postgres like SQLite? by datadrivenangel on Monday September 22, 2025 @12:53PM (#45336158)

DuckDB 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.

[ Parent | on HN ]

Re:What if we treated Postgres like SQLite? by Imustaskforhelp on Monday September 22, 2025 @04:54PM (#45339325)

is 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.

[ Parent | on HN ]