3 ms·
> if you use an ORM that supports both SQLite and Postgres you'll have the option to upgrade if your site brings in enough traffic I'll never understand this i
by VWWHFSfQ 2y ago
> if you use an ORM that supports both SQLite and Postgres you'll have the option to upgrade if your site brings in enough traffic
I'll never understand this idea that Postgres and SQLite are somehow interchangeable when the time is right.
My database and Postgres are _literally_ the core definition of everything that my application does. My app is written in Rust, but that doesn't matter because it's a _Postgres_ application. I use Postgres-specific features extensively. Converting the application to SQLite would be essentially a re-write, and it would be worse in every way.
Also, I generally just don't understand this fad of running production backends on SQLite. SQLite is great for what it is, a tiny little embeddable client-side database. But it is a _terrible_ database for non trivial business applications where ref integrity, real types instead of "everything is a string", and battle-tested scaling is essential.
- rcarmo 2y agoThe fact that you use Postgres-specific features extensively is a design decision that many people would never make, regardless of their trust in the engine.
- VWWHFSfQ 2y agoThat's like saying I use Rust but I don't want to use any Rust specific features because I might want to port it to Python someday. It's complete nonsense.
- rcarmo 2y agoIn the enterprise space, it isn't. You often have to build software that will run on different database back-ends. Just because your worldview doesn't align with other people's doesn't mean you own the truth...
- deleted 2y ago[deleted]
- sampullman 2y agoI don't think people often switch from Postgres to SQLite, it's probably more common (and much easier) to prototype with SQLite lite first and then switch. If by referential integrity you just mean FK constraints, you can turn that on in sqlite3. I think SQLite is pretty good for a lot of use cases. An Axum/sqlite CRUD app should be able to handle at least few hundred requests per second on a medium powered box, which is good enough for a lot of things. Postgres is really powerful but I don't think it's actually that common to structure your app around it's unique features.
- mnahkies 2y agoLately I've been using sqlite in this way on small projects I'm just hacking at, but after seeing pglite this week (https://news.ycombinator.com/item?id=41224689 https://news.ycombinator.com/item?id=41224689) I'll probably give that a try next time
- xcdzvyn 2y ago[dead]