News for hackers. Stuff that matters.
Re:SQLite is all you need for durable workflows by eterm on Friday May 29, 2026 @04:20PM (#48328677)
Or you can run postgres on the same machine as the application, which lets you much more easily migrate if the time comes when you need to scale to multiple application servers.

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.

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.
Re:SQLite is all you need for durable workflows by eterm on Friday May 29, 2026 @07:10PM (#48330558)
Obviously SQLite is the best choice for a mobile or desktop app, that's not what's being discussed here.
Re:SQLite is all you need for durable workflows by ummonk on Saturday May 30, 2026 @12:51AM (#48332700)
If someone is talking about "spinning up a separate machine" for Postgres, they're not talking about a desktop or mobile app...