| 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
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