Robust, resiliant, performant - ready for enterprise work!
Anonymous | TrustRadius Reviewer
October 18, 2018

Robust, resiliant, performant - ready for enterprise work!

Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with PostgreSQL

I personally have used PostgreSQL for several personal projects. I've also used PostgreSQL in previous roles at other companies. In my current role, I mainly rely on APIs and other systems built on PostgreSQL. In all instances, PostgreSQL was chosen because of its performance and versatility. Also a consideration was its longevity and market penetration - this product has been around for a long time and is well used in the industry.
  • Flexible data types
  • Very efficient and performant I/O
  • Robust table relationship mapping (ie. primary keys, sequences, etc.)
  • Better official documentation
  • Better official GUI - the current main option (PgAdmin III) is pretty terrible, especially on Mac.
  • A lot of "bang for your buck" - a lot of power at a low cost
  • Flexibility of data types and storage means this product can handle just about all of our needs
MySQL is a popular open-source alternative to PostgreSQL, but in my experience it lacks the robustness, durability, and flexibility of PostgreSQL. It has also changed hands frequently, so support isn't the greatest. MongoDB and other NoSQL databases are helpful in certain programming environments and for certain use cases, but sometimes you just need a really robust relational database.
One thing that I/my companies use it for and that it is most frequently used for is applications with some sort of API. Storage and retrieval is very fast and performant, and the data types (including JSON natively) bring together the best aspects of traditional SQL databases and newer NoSQL databases (ie. MongoDB and others)