On Monday 12 March 2007 20:47, Alan Lord wrote: > Yes there are quite a few differences between Postgresql and MySQL in > syntax, SQL implementation (PGSQL is fully ACID compliant whereas MySQL > is apparently not)
MySQL is actually ACID compliant, but only if you use the InnoDB storage engine. InnoDB is *not* the default storage engine - for some strange reason upstream provide a default (MyISAM) that has non-ACID transactions on tables that don't support referential integrity via foreign key constraints. Quite how that equates to a relational database I have no idea! Personally, I use PostgreSQL wherever possible. Regards, Matt. -- http://linuxfromscratch.org/mailman/listinfo/blfs-support FAQ: http://www.linuxfromscratch.org/blfs/faq.html Unsubscribe: See the above information page
