Re: Advice needed: Hibernate and MySQL?

David Harper wrote:


Also, MySQL is a perfectly good database system, despite the disparaging comments made elsewhere. It provides transactional tables for those mission-critical applications that require them, and that includes foreign key constraints and the whole range of transaction isolation levels.


If you absolutely must use MySQL make sure it is -- as mentioned elsewere -- the latest possible version so that you get a database where at least an effort towards standards compliance has been made, otherwise you'll just get your hands on a version that, well, simply behaves a little different from other databases. Also make sure to run in strict mode so that the insane value coercion strategy implemented in MySQL is turned off.

MySQL is a heck of a lot easier to set up and start working with than PostgreSQL (which is, notwithstanding, also an excellent database system) and Oracle.

MySQL and PostgreSQL are equally easy to set up, Oracle is a "bit" more complicated if you want to tune and utilize all bells and whistles.

.