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.
Limitations of Postgres and MySQL
Posted by: Anonymous Coward on September 16, 2002 08:29 PMPostgres 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.
#