Linux.com

Limitations of Postgres and MySQL

Posted by: Anonymous Coward on September 16, 2002 08:29 PM
Both MySQL and Postgres have limitations in comparison to existing Oracle functionality.

Postgres lacks just in time recovery. The WAL has now been implemented but can’t yet be backed up. This is coming soon.

MySQL has lacked nested SQL statements. This should be in version 4.0.

Both of these are fundamental failings for production databases.

Both databases are much easier to configure and work with than Oracle. Both of these failings are being addressed in the next releases of these products.

#

Return to Why I prefer Open Source databases