December 21, 2024
PostgreSQL 7 MySQL 4
Licensing Free Free unless distributed
Views Yes No
Triggers Yes No

Constraints
Yes No
Stored
Procedures
Yes No
Subselects Yes No
User defined
datatypes
Yes No
Single-master/multi-slave
replication
Yes Yes
Supports paging through
records
Yes (limit/offset) Yes (limit)
Supports
clustering
Yes Yes
Replication Yes Yes
Support PostgreSQL, Inc MySQL AB
Admin Tools pgAdmin
pgAccess
phpPgAdmin
MySQL Administrator
phpMyAdmin

Vendors:

MySQL
PostgreSQL

Comparison Charts:

WLUG
FNAL

Articles:

PostgreSQL vs. MySQL vs. Commercial Databases – DevX
PostgreSQL vs MySQL: Which is better?
MySQL and PostgreSQL Compared
MySQL vs. PostgreSQL

Case Studies:
MySQL
PostgreSQL