Database Front end suggestion

[David Bandel]

[snip]

> 
> Can you please clarify this claim? According to the mysql website, mysql
> with InnoDB is ACID compliant:
> http://dev.mysql.com/doc/mysql/en/ANSI_diff_Transactions.html

MySQL, out of the box, in NOT ACID (the word compliant is not
appropriate, we're not talking a standard here, there's nothing to
comply with).

InnoDB is a patch.  If you want a system that's patched from one end
to the other run M$.  It's a stand-alone, one-user, non-networked
system patched to the gills.  Need I say more?

> 
> So it would seem the general statement that mysql is not ACID compliant
> would be wrong. Mysql using the InnoDB storage engine is ACID compliant, but
> mysql using the MyISAM storage engine (which, I suppose, is the default) is not.

The question was about PostgreSQL vs MySQL, not MySQL patched with
InnoDB (which I wouldn't recommend anyway).

> 
> But... I reserve the right to be completely clueless regarding ACID
> compliance and defer to your much broader level of knowledge and experience
> WRT databases.
> 

Ciao,

David A. Bandel
-- 
Focus on the dream, not the competition.
            - Nemesis Air Racing Team motto