Re: [Gnumed-devel] Re: GNUmed needs your help

[Karsten Hilbert]

On Mon, Oct 10, 2005 at 11:02:32PM -0700, Jim Busser wrote:

> I believe that MySQL achieves some measure of ACID compliance if the 
> db manager(s) choose to apply Inno DB tables.
Well, yes.

a) IF ... choose to ...

   - there shouldn't be a choice about this for a medical record

b) if there is a spelling error, say you wrote "IMMODB"   
   instead of "INNODB" MySQL will silently fall back to MyISAM
   without ACIDity

   - of course, in a perfect world, there are no mistakes in speling

c) it is possible to *mix* ACID and non-ACID tables

   - the result is undefined

d) MySQL allows to insert invalid dates into timestamp fields

d) MySQL silently truncates numbers if they are too large for a field

There's a MySQL GOTCHAs page on the web. There's one for
PostgreSQL, too, to be open about it. No doubt MySQL is
slowly getting better once v5 comes out and eventually
starts consolidating.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346