On Mon, 2006-02-20 at 21:23 +0100, Daniel McBrearty wrote: > I'm currently using mysql, but I'm considering changing over to > firebird or postgre. > > Anyone have any reasoned loves/hates/useful experiences to pass on?
If you aren't already using InnoDB tables in MySQL, try that first. It may save you the trouble of porting to PostgreSQL. (Nothing against Pg, but why port if you don't have to?) The transaction and replication support for InnoDB tables is good, and the locking system works on the same principles as the PostgreSQL one. With MySQL 5, you can also get rid of some annoying MySQLisms (like inserting default values into NOT NULL columns when passed a NULL) by turning on strict mode. - Perrin
