Overall Satisfaction with PostgreSQL
PostgreSQL is the primary datastore for Sphere. All of the mission-critical customer and product data which underpins the product offering is there. PostgreSQL was the right choice because so many of the data models that we use are relational to the customer's user account,.
- Reliability - There is absolutely no issue with uptime or data integrity.
- Flexibility - The wide range of data types which are supported gives us immense flexibility in terms of what data we can store.
- Speed - Even at our busiest, we are able to count on the performance of the engine matching our needs.
- Internal features - Thanks to the wealth of internal features, we have less external dependencies to perform common business tasks.
- The query syntax for JSON fields is unwieldy when you start getting into complex queries with many joins.
- I wish there was a distinction (a flag) you could set for automated scripts vs working in the psql CLI, which would provide an 'Are you sure you want to do X?' type prompt if your query is likely to affect more than a certain number of rows. Especially on updates/deletes. Setting the flag in the headless(scripted) flow would disable the prompt.
- Better documentation around JSON and Array aggregation, with more examples of how the data is transformed.
- Reliability
- Scalability
- Flexibility
- Maintainability
- Easy to administer so our DevOps team has only ever used minimal time to setup, tune, and maintain.
- Easy to interface with so our Engineering team has only ever used minimal time to query or modify the database. Getting the data is straightforward, what we do with it is the bigger concern.
- It's free. You can't beat that.
PostgreSQL outperforms every other option. It is faster, more flexible, more reliable, easier to maintain, and more consistent in behaviour than any of the other offerings.
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?
Yes
Did implementation of PostgreSQL go as expected?
Yes
Would you buy PostgreSQL again?
Yes