Re:SQLite is all you need for durable workflows
by ai_fry_ur_brain on Friday May 29, 2026 @03:38PM
(#48328183)
I use postgres for very simple apps. I have a Dockerfile I use in my boilerplate repo. It takes a single make cmd for me to build, start and run migrations. Its as simple as using sqlite.
[ Parent
| on HN ]
Re:SQLite is all you need for durable workflows
by tasuki on Friday May 29, 2026 @05:05PM
(#48329260)
But now you have another process to babysit. How do you keep it healthy? And you have to ensure the client-server communication won't break.
For me the main benefit of sqlite is that it's a library rather than an app.
Re:SQLite is all you need for durable workflows
by not_kurt_godel on Friday May 29, 2026 @08:01PM
(#48330923)
> But now you have another process to babysit. How do you keep it healthy?
I've been assured by many HN users that running apps/sites on a single VPS requires near-zero maintenance or monitoring to achieve acceptable uptime 24/7/365 for years on end, sooooo...just pretend it will never fail like your main server process?
Re:SQLite is all you need for durable workflows
by ai_fry_ur_brain on Friday May 29, 2026 @08:33PM
(#48331120)
Ive been assured by many HN users that you must have 24/7/365 uptime for everything in case one of your 10 bi-monthly users decides to log on.
Re:SQLite is all you need for durable workflows
by not_kurt_godel on Friday May 29, 2026 @09:19PM
(#48331387)
Call me old-fashioned and quaint, but I don't like to build software that doesn't work all the time if I can help it, whether it's for 10 users or 10 million.
Re:SQLite is all you need for durable workflows
by bdangubic on Friday May 29, 2026 @08:45PM
(#48331204)
24/7/365 is needed (or achieved) just about never. our big tech is proving 90% will soon be utopia as well. being down has always been fine for 99.999975% of all projects on the planet.
Re:SQLite is all you need for durable workflows
by not_kurt_godel on Friday May 29, 2026 @09:13PM
(#48331355)
Ok, now tell me the stat by percentage of overall market revenue rather than project count
Re:SQLite is all you need for durable workflows
by ai_fry_ur_brain on Friday May 29, 2026 @05:33PM
(#48329606)
I have boilerplate for client-server communication that makes it pretty trivial to build on top of.
Im not saying that sqlite isn't useful, im mostly saying that using postgres doesnt have to be complicated.
Re:SQLite is all you need for durable workflows
by turtlebits on Friday May 29, 2026 @05:59PM
(#48329858)
Its 2x the infra. You have to manage an additional process, auth, backups, logging, etc.