Overall Satisfaction with PostgreSQL
We use PostgreSQL as our database backend on the majority of our applications across the whole organization. It solves all of the problems that a relational database would solve. It's a very similar product to MySQL or Microsoft SQL Server and supports a very similar query syntax to both of those.
- Free relational SQL based database
- Tonnes of community support
- Fast, scalable database.
- Hard learning curve if you are unfamiliar with SQL databases
- The graphical tooling isn't as good as some of the tools provided by Microsoft for the example.
- Can be hard to figure out what went wrong unless you know how.
- A well supported database - makes development fast
- Can be hard to train new developers
- Takes time to learn, but other alternatives do too.
They each have their pros and cons. MySQL is probably the other popular "free" alternative in this space, but it's not as popular or have as much community support as PostgreSQL.
Microsoft SQL Server is amazing in the microsoft tech stack, but it's pretty useless and provides little benefit over postgres if you're developing outside of the Microsoft tech stack.
Microsoft SQL Server is amazing in the microsoft tech stack, but it's pretty useless and provides little benefit over postgres if you're developing outside of the Microsoft tech stack.