- Standard SQL for ease of development with pre-existing knowledge
Postgres is for our systems a very solid database, easy to use in development and easy also to manage in production environment, and that's valuable because in the end it cuts a lot of costs (also during the upgrading processes).
The Postgres team is already doing an amazing job in putting in features to ease the life of developers and sys admins, such as JSON support and database replication.
A feature that is still a work in progress and it would be nice to have would be native master-master replication, we don't have a need for it right now but it's something that should be addressed in the future.
I've used it for five years.
There have been no issues with the deployment.
We have had no stability issues.
It has been able to scale it for our needs.
I've had no need to use any.Technical Support:
I've had no need to use any.
I used MySQL and Oracle previously, PostgreSQL is open source and fully ACID and SQL standard
It was easy.
We deployed it in-house.
It's a great database engine that is easy to use, powerful, and scalable.