4 ms·
SQLite is a real database engine. I guess what you mean is that SQLite is not competing with database servers.
by ngrilly 2y ago
SQLite is a real database engine. I guess what you mean is that SQLite is not competing with database servers.
- ASalazarMX 2y agoAnd even that is questionable, since many web applications offer SQLite as another DB back end, and it works just fine for a wider range of workloads than one would expect.
- ngrilly 2y agoAgreed. SQLite is becoming popular on the server-side as well. The latest version of Rails making SQLite the default is particularly interesting.
- baq 2y agothe problem with sqlite has never been performance, it's always been extreme (dead)locking when writing concurrently - how does Rails get around that assuming this is actually recommended for prod deployments?
- ngrilly 2y agohttps://fractaledmind.github.io/2024/04/15/sqlite-on-rails-the-how-and-why-of-optimal-performance/ https://fractaledmind.github.io/2024/04/15/sqlite-on-rails-t...