sure: http://sql-info.de/mysql/gotchas.html

In particular the fact that MyISAM tables do not support transaction semantics. Don't worry I am not trying to spread FUD or vilify ClearHealth.

Karsten

• Re: PR: ClearHealth Demo Available by Tim Cook on Thursday May 19, 2005 @ 06:14 PM

  I don't believe that you could say that your data is anymore at risk because of using the MyISAM tables. The impact is on performance due to the fact that you must use complete table locking to perform writes. Due to, as you stated, the lack of transaction capabilities. However, I still standby my often stated position that complex (read EHR) systems cannot be properly modeled using SQL database management systems anyway. See: http://web.onetel.com/~hughdarwen/TheThirdManifesto/ and http://www.firstsql.com/dbdebunk/ But that is all an entirely different story to be published later. :-)

  [ Reply to this ]

• Re: PR: ClearHealth Demo Available by Karsten Hilbert on Friday May 20, 2005 @ 10:16 PM

  Well, the MyISAM/missing atomicity issue was just one of the worries I would have about trusting my data to MySQL. The others are listed on the page I gave such as the database allowing invalid data in date fields and truncating integers when they are too big. Notice that there's such a list for "other databases", too. Karsten

  [ Reply to this ]