Re:SQLite is all you need for durable workflows
by s_ting765 on Friday May 29, 2026 @04:43PM
(#48328979)
This decision tree doesn't make much sense to me. Why you someone forego performance today in favor of adding a completely unnecessary network layer to every DB query in order to "satisfy" future imaginary "scaling concerns"?
Re:SQLite is all you need for durable workflows
by eterm on Friday May 29, 2026 @07:08PM
(#48330540)
Because you don't add a network layer by running a database locally.
Re:SQLite is all you need for durable workflows
by eddd-ddde on Friday May 29, 2026 @04:48PM
(#48329039)
That's still orders of magnitude more complexity for no real benefit. A migration from sqlite to postgres, if really required, is not that hard.
Re:SQLite is all you need for durable workflows
by teaearlgraycold on Friday May 29, 2026 @06:43PM
(#48330299)
Yes, postgres should support a superset of SQLite functionality.
Re:SQLite is all you need for durable workflows
by wat10000 on Friday May 29, 2026 @06:19PM
(#48330065)
Now you've added a substantial dependency, and annoying setup requirements. Good luck doing this for a native app on mobile or desktop.
There's a world between "local file" and "network DB server", running a DB server locally has lots of benefits from being able to easily query from outside if needed to forcing you to consider concurrency without the latency overhead of a network hop.