Comment by jstummbillig
6 hours ago
I mean as in: Most web stacks do not default to sqlite over MySQL or postgres. Why not? Best default for most users, apparently.
6 hours ago
I mean as in: Most web stacks do not default to sqlite over MySQL or postgres. Why not? Best default for most users, apparently.
I think in the past it was more obvious. Rails switched to SQLite as the default somewhat recently
Yeah, that's the one prominent example but, like you said, also just rather recently. Since "the network is slow, duh" has always been true, I wonder why.
My guess would be that performance improvements (mostly hardware from Moore's law and the proliferation of SSDs, but also SQLite itself) have led to far fewer websites needing to run on more than 1 computer, and most are fine on a $5/month VPS
And stuff like https://litestream.io/ or SQLite adding STRICT mode
It took a lot: https://news.ycombinator.com/item?id=39835496