why-is-postgres-default
Serious question.
No one ever got fired for choosing PostgreSQL # [1]
But, why. It’s the most loved db, right? Right? Maybe it’s time to rethink
it.
Don’t get me wrong, if I need a relational db as a service, PostgreSQL is going
to be my first choice, but why do I need to run a separate application for it?
Tutorials use sqlite # [2]
Why is that? Because there is nothing else to stand up. Nothing else to
maintain. And you probably already have it installed on just about anything
that has a battery.
SQLite runs in memory # [3]
Don’t need, or maybe don’t want to persist state. Run it in memory. This is a
nice feature for running tests.
Less exposure # [4]
SQLite is a file on your filesystem. It’s not a web service. It’s not a cloud
service. Not that postgres is insecure, but it is one more endpoint that you
have to think about securing.
this means that is probably also cheaper 🤑
SQLite is easy to replicate # [5]
Want to run your new feature with prod data? Pull a replica or...