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.
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.
If you are trying to replicate or make available to a bunch of machines or similar - it's likely the wrong thing (although there are tools to do this, I've never used them). If you are just trying to back it up there is a pretty simple back up command.