3 ms·
I believe that this is also why we're starting to see a surge in people wanting to run SQLite as their backend database. It's similarly simple to start out wit
by petcat 2y ago
I believe that this is also why we're starting to see a surge in people wanting to run SQLite as their backend database. It's similarly simple to start out with, and also similarly flimsy when dealing with actual data integrity. Very limited types, limited isolation options, ref integrity disabled by default (Mongo DB also disables things by default that hurts their benchmarks).
But hey, SQLite is better than Mongo DB, at least. So we're making progress
- mergisi 2y agoGood point! SQLite is simple and great for small projects, but its limits with data integrity and concurrency show at scale. Still, it's a more predictable choice than MongoDB, which has its own quirks. Definitely progress!
- evantbyrne 2y agoThere might be some truth in that. I've come to respect SQLite more as a serious database though. It can perform well if you can manage the trade-offs of running on a single server and turn the right knobs. The upgrade path to Postgres is also a lot clearer than with Mongo.