←back to thread

What if we treated Postgres like SQLite?

(www.maragu.dev)
75 points markusw | 3 comments | 22 Sep 25 13:29 UTC | HN request time: 0.635s | source
Show context
munchlax ◴[22 Sep 25 15:40 UTC] No.45334980[source]▶
From what I've read about it, DuckDB comes close. Regular files, like sqlite, but pg functionality.
replies(2): >>45335166 #>>45336160 #
1. OutOfHere ◴[22 Sep 25 15:51 UTC] No.45335166[source]▶
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?
replies(1): >>45336158 #
2. datadrivenangel ◴[22 Sep 25 16:53 UTC] No.45336158[source]▶
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.
replies(1): >>45339325 #
3. Imustaskforhelp ◴[22 Sep 25 20:54 UTC] No.45339325[source]▶
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.