Overall Satisfaction with PostgreSQL
- 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
- Amazon Redshift and MySQL
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