News for hackers. Stuff that matters.

A comment on SQLite the only database you will ever need in most cases. Parent comment

Re:SQLite the only database you will ever need in most cases by paranoidrobot on Wednesday February 15, 2023 @11:04PM (#34814853)
I think we disagree on the "most cases" aspect that

For most of the things I touch, having a single-point-of-failure data store is typically not acceptable for production environments, except perhaps caching.

[ Parent | on HN ]
Re:SQLite the only database you will ever need in most cases by danielmarkbruce on Wednesday February 15, 2023 @11:34PM (#34815065)
If you are a good software engineer, you probably work at a place that needs good software engineers, which by definition tends to be a place with a system that needs high availability or low latency or both or something else all of which basically results in a pretty complicated distributed system...

So in your day to day job as a good software engineer, yeah sqlite isn't going to be a good choice. It doesn't work well for the sorts of systems you work on. But if you were going to build a new social network for your college or something trivial like that, and you just want to move fast and have a crazy simple deployment setup, you might well use sqlite.

[ Parent | on HN ]