Oracle vs. PostreSQL vs. MySQL
Google search: database feature postgres mysql
Database market share graphs
Recent article - PostgreSQL looks best as a free alternative to Oracle
Non standard MySQL stuff
Why PostgreSQL Instead of MySQL: Comparing Reliability and Speed in 2007
Five Compelling Reasons to Use MySQL
History and Licensing Postgres vs. MySQL 2004
Why is MySQL more popular than PostgreSQL?
Josh Berkus: Two great open source databases: a comparison (2008-06-26) - While it seems to favor Postres, after reading it, I felt more confident in MySQL.
Summary:
The biggest gripe I have with MySQL is its deviation from standards. MySQL's acceptance and adoption by heavyweights are votes of confidence and proof of capability. Given that the cost, feature matrices, and performance are comparable, I would put my support behind the industry leader. Of course in the interest of full disclosure, I would pick Unix/Linux over Microsoft.
MySQL Customer list
PostreSQL Customer List
Sabre Holdings Corporation - a transactional example
"The MySQL database version 4.0 with the transactional engine is the data management backbone supporting the memory intensive searches performed on Sabre Holdings Air Shopping products. "
"We benchmarked our application on several databases, including open source, commercial and a specialized in-memory relational database, and MySQL was the best performing database, said Alan Walker", vice president of Sabre Labs.
My analysis:
- MySQL deviates from standards, however Hibernate and tools insulate application developers from it
- PostgreSQL has the advantage that it is much closer to Oracle and an easier migration to/from Oracle
- MySQL has much more market share, vendor, and partner support than PostgreSQL
- MySQL is used by the top high volume web sites
- Security is less important considering the db is a back-office service behind a firewall
- Ease of setup and administration is very important to lower TCO
- Performance through horizontal scaling is the best approach and MySQL makes clustering and replication simpler reducing cost
Database market share graphs
Recent article - PostgreSQL looks best as a free alternative to Oracle
Non standard MySQL stuff
Why PostgreSQL Instead of MySQL: Comparing Reliability and Speed in 2007
Five Compelling Reasons to Use MySQL
History and Licensing Postgres vs. MySQL 2004
Why is MySQL more popular than PostgreSQL?
Josh Berkus: Two great open source databases: a comparison (2008-06-26) - While it seems to favor Postres, after reading it, I felt more confident in MySQL.
Summary:
The biggest gripe I have with MySQL is its deviation from standards. MySQL's acceptance and adoption by heavyweights are votes of confidence and proof of capability. Given that the cost, feature matrices, and performance are comparable, I would put my support behind the industry leader. Of course in the interest of full disclosure, I would pick Unix/Linux over Microsoft.
MySQL Customer list
PostreSQL Customer List
Sabre Holdings Corporation - a transactional example
"The MySQL database version 4.0 with the transactional engine is the data management backbone supporting the memory intensive searches performed on Sabre Holdings Air Shopping products. "
"We benchmarked our application on several databases, including open source, commercial and a specialized in-memory relational database, and MySQL was the best performing database, said Alan Walker", vice president of Sabre Labs.
My analysis:
- MySQL deviates from standards, however Hibernate and tools insulate application developers from it
- PostgreSQL has the advantage that it is much closer to Oracle and an easier migration to/from Oracle
- MySQL has much more market share, vendor, and partner support than PostgreSQL
- MySQL is used by the top high volume web sites
- Security is less important considering the db is a back-office service behind a firewall
- Ease of setup and administration is very important to lower TCO
- Performance through horizontal scaling is the best approach and MySQL makes clustering and replication simpler reducing cost
Comments