Overall Satisfaction with PostgreSQL
We have used PostgreSQL as an application database for PHP, Ruby, and Java based applications. It has been used primarily for our customers' internet facing application. PostgreSQL presents a feature-rich open source database with many of the same capabilities as enterprise databases.
PostgreSQL presents a better stored procedure language as well as having better integration for geo spatial capabilities than MySQL. For setup and administration it is more flexible than SQL Server or Oracle.
In general, PostgreSQL tends to be overlooked.
PostgreSQL presents a better stored procedure language as well as having better integration for geo spatial capabilities than MySQL. For setup and administration it is more flexible than SQL Server or Oracle.
In general, PostgreSQL tends to be overlooked.
- The backend stored procedure language is complete, and lends itself to better programming and data manipulation tasks than MySQL.
- PostgreSQL has complex data types like object columns and record data types that allow it to better mirror object relational structures directly within tables.
- It is a fully SQL 92 compliant database even in its fully open source version.
- For some more advanced features like replication, PostgreSQL can be a pain.
- PostgreSQL can experience some bottlenecks under heavy read query load.
- An in-memory or similar transaction caching strategy could greatly expand the appeal of PostgreSQL as developers look for other solutions such as Reddis to do in memory processing.
PostgreSQL lacks the scalability of a commercial database such as SQL Server or Oracle. For this reason, it has been a difficult sale for some customers. However, PostgreSQL has more features, including a better programming language than MySQL. It is much more feature rich than embedded databases such as Berkeley DB and SQLLite, which have very limited applications.