News for hackers. Stuff that matters.
Re:SQLite is all you need for durable workflows by abtinf on Friday May 29, 2026 @03:37PM (#48328167)
There are many cases where SQLite + concurrent front end (like a go net/http server) can handle all the load that a service might ever conceivably have to handle, especially if allowed to scale up hardware over time. You can trivially scale up SQLite to, what, hundreds of thousands of tps?

The only thing you really give up is HA/failover and DR. But there are solutions to deal with those. And single-server systems are generally surprisingly robust (since, in the absence of very complex control planes, uptime goes down with more systems).

Re:SQLite is all you need for durable workflows by kellogah on Friday May 29, 2026 @07:35PM (#48330751)
I was thinking of using SQLite on top of k3s/Longhorn to replicate it. Anyone do something similar? Folks mention light steam and aws but Jeff Bezos’s biceps are too much for me to handle.
Re:SQLite is all you need for durable workflows by andix on Friday May 29, 2026 @08:56PM (#48331261)
A longhorn volume can only be attached to one node at at time. It can share it with other nodes over nfs. I don't think this is going to scale well.

Just use Postgres with ro replicas.

Re:SQLite is all you need for durable workflows by horsawlarway on Friday May 29, 2026 @09:04PM (#48331312)
I'll echo the other response.

I've had pretty terrible experiences with SQLite and Longhorn/NFS.

It's just not the right database for pretty much ANY network based filesystem, where the locking primatives aren't as robust, and you might get two processes trying to hit it at the same time.

Frankly - they say this themselves: https://sqlite.org/howtocorrupt.html

As someone who runs a fairly big personal cluster backed by a mix of giant NFS storage for media, and relatively large longhorn SSD drives for configs/temp data...

I avoid sqlite backing like the plague. It will get corrupted. Period. It's not the db for this use-case, and I'll take postgres/maria/mysql/mongo/ANYTHING else over it.

If you do it - back it up ALL THE TIME, because it's going to get corrupted.

Re:SQLite is all you need for durable workflows by andersmurphy on Saturday May 30, 2026 @02:57PM (#48339527)
Yeah sqlite on anything but a directly attached nvme is a bad time if you're using it for a web server.
Re:SQLite is all you need for durable workflows by ummonk on Saturday May 30, 2026 @12:43AM (#48332666)
Why go through the trouble of shoehorning SQLite into a cloud database by getting solutions for HA/failover and DR, when you can just use Postgres off the shelf?
Re:SQLite is all you need for durable workflows by jappgar on Saturday May 30, 2026 @08:18AM (#48335394)
So you can post about it on HN, obviously
Re:SQLite is all you need for durable workflows by cortesoft on Saturday May 30, 2026 @03:21PM (#48339733)
You also have the issue or normal maintenance (patching, OS upgrades, etc). You can’t do those without downtime if you are using SQLite.