A solid solution for data teams
May 14, 2021

A solid solution for data teams

Valeri Karpov | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with PostgreSQL

We've used PostgreSQL for years as a tool for our data team. We use MongoDB for operational data, but we pipe MongoDB data into Postgres. If we need a chart for an investor deck or someone has a non-trivial data question, our data team queries Postgres.
  • BI tool integration - Periscope/Sisense, Looker, etc.
  • SQL is a common skill, and Postgres' dialect strikes a good balance between stability and usability
  • JSON support
  • Running PostgreSQL locally is a nightmare
  • Hosted solutions like Amazon RDS are hard to use
  • Did I mention how difficult it is to run Postgres locally?
  • BI integration
  • JSON support
  • Cloud hosting solutions
  • SQL
  • We don't need as many developers because we can hire analysts to write dashboards in BI tools
  • Minimize risk of errant queries slowing down the production database
When we were originally evaluating Redshift we ran into some issue with dates. Either way, Postgres is a better choice than Redshift because it avoids vendor lockin. We ended up choosing Postgres over MySQL because it was easier at the time to get a hosted Postgres cluster up and running, and we haven't re-evaluated since.

Do you think PostgreSQL delivers good value for the price?

Yes

Are you happy with PostgreSQL's feature set?

Yes

Did PostgreSQL live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of PostgreSQL go as expected?

Yes

Would you buy PostgreSQL again?

Yes

I wouldn't use Postgres for a production application, but I would recommend it if you're looking for a decent data store that anyone with SQL skills can use via BI tools.