An amazing free option for an enterprise level database tool
October 18, 2018

An amazing free option for an enterprise level database tool

Richard Rout | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

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.
If you're using C# and other products from Microsoft then you get a lot of benefit from Microsoft SQL Server and the Entity Framework ORM. However if you're building an app in almost anything else, then there is almost guaranteed PostgreSQL tooling, utilities or packages for that environment, it's a great database to use.