Richard Welty wrote:
> On Wed, 8 Oct 2003 11:28:00 -0400 (EDT) John Wells <jb@sourceillustrated.com> wrote:
>
>
>>It's my opinion that we should be using PG, because of the full ACID
>>support, and the license involved. A consultant my company hired before
>>bringing me in is pushing hard for MySql, citing speed and community
>>support, as well as ACID support.
>
>
> you should also cite conformity to standards. MySQL is significantly
> different from SQL standards in a number of regards. not that any are fully
> conformant, but there are spots where MySQL is seriously "out there".
Yeah.. like inserting a biiig number in integer field in a transaction without
error and not getting it back after commit.. or accepting '00-00-00 00:00:00' as
a valid datetime stamp.. something like that..
How much deviation is that from ACID? 180 degrees...:-)
One of my friend lost data with mysql yesterday.. The machine was taken down for
disk upgrade and mysql apperantly did not commit the last insert.. OK he was
using myisam but still..:-)
Shridhar