PostgreSQL Review

It is a very safe and stable solution.​ ​A better export facility which is GUI friendly would be an improvement.

What is most valuable?

JSON data support is most valuable to me as it saves design and maintenance time. It is a very safe and stable solution.

How has it helped my organization?

We are spending less time parsing API response and more time exploring data. We spend time understanding APIs and how to interact with them, If we can load responses directly to the database that saves many man hours for a project.

What needs improvement?

A better export facility which is GUI friendly would be an improvement. Also if we could export data from grid that would have been helpful.I have used HeidiSQL for MySQL which is very user friendly, pgAdmin III is not that helpful when it comes to different features we need to use like export,filtering and connections.

For how long have I used the solution?

I've been using it for one year and am still exploring it.

What was my experience with deployment of the solution?

We had no deployment issues.

What do I think about the stability of the solution?

We had no issues with the stability.

What do I think about the scalability of the solution?

We had no issues scaling it.

Which solution did I use previously and why did I switch?

I have worked with MySQL, Microsoft SQL, db2, and Oracle. We chose PostgreSQL for its JSON support as our APIs are sending JSON responses and PostgreSQL is like home for JSON. Choosing it has helped our cloud computing requirements a lot.

How was the initial setup?

On Windows it's straightforward, but on Ubuntu, it was a bit complex when it came to database and tablespace division through PSQL.

What about the implementation team?

We did it in-house.

What other advice do I have?

If you are thinking of using PostgreSQL, all database names, table names and column names should be in small letters. PostgreSQL requires every capital letter to be quoted which makes life difficult for developer.

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More PostgreSQL reviews from users
...who work at a Comms Service Provider
...who compared it with MySQL
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: May 2021.
510,882 professionals have used our research since 2012.
Add a Comment
ITCS user