Postgres - A blessing for small businesses
August 01, 2016

Postgres - A blessing for small businesses

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with PostgreSQL

We use Postgres for our core product - a SaaS application. We have around 200 users and a lot of backend processes that use PostgreSQL.
  • Postgres is open source and works very well with Django (web framework written in Python) that we use.
  • Postgres has significant performance improvements over MySQL and other relational databases
  • Postgres supports storing JSON which makes retrieval easy
  • Lack of replication but I think that's been fixed in Postgres recently. Still MySQL has better replication mechanisms.
  • MySQL has more documentation and community support
  • It's Open source so hard to go wrong here.
  • It supports ACID properties of relational SQL. That's a big advantage.
  • Can take some time for someone to learn the inner technicalities of Postgres
As I said, Postgres and MySQL are open source which is important for small start ups. Oracle is EXPENSIVE :)
Postgres is faster than MySQL (Big factor)
MySQL supports replication which makes it more scalable.
In short, if you are a small company just starting, Postgres would be a very good option for you to go with.
It works very well as a relational database. I think it's much better that MySQL. It supports a lot of advanced features. Also, all advanced data types are supported.
Avoid Postgres if replication is important for you. I think MySQL scores over Postgres in that regard. Both have pretty decent community and user group but I think Postgres is still behind MySQL. Could be a a little hard to find answers to uncommon questions.