Monday, March 24, 2008

Mysql and Postgresql

Why we use MYSQL

MySQL is relatively faster than PostgreSQL.
Database design will be simpler.
You can create a basic Web-driven Web site.
MySQL’s replication has been thoroughly tested.
There’s no need for cleanups in MySQL (Vacuum).

Why we use POstgresql

* Complex database design
* Moving away from Oracle, Sybase, or MSSQL
* Complex rule sets (i.e., business rules)
* Use of procedural languages on the server
* Transactions
* Use of stored procedures
* Use of geographical data
* R-Trees (i.e., used on indexes)

No comments: