why-is-postgres-default
Serious question. No one ever got fired for choosing PostgreSQL # 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 # 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 # 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 # 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 # Want to run your new feature with prod data? Pull a replica or backup. It’s a file, you can cp, s…