Database Front end suggestion

[Bill Campbell]

On Wed, Nov 10, 2004, Tim Wunder wrote:
>On 11/10/2004 7:20 AM, I believe that David Bandel wrote:
>>On Tue, 9 Nov 2004 21:49:35 -0800, Shawn Tayler <stayler at xmtservices.net> 
>>wrote:
>>
>>>Thanks...  I'll give that a whirl too.
>>>
>>>On a side note,
>>>
>>>Would any of you care to put your $0.02 in on the merits or advantages of
>>>either postgresql or mysql over the other?
>>
>>
>>MySQL:  not a true database.  More like a _very_ fast file system you
>>access with SQL commands.  Great for web logs, but a recipe for
>>disaster with any application where data integrity is important (like
>>accounting).
>>mysql is not ACID.
>>ACID stands for: Atomicity, Consistency, Integrity, Durability (search
>>Google, you'll find sites to explain all this in minute detail).
>>
>
>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
>
>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 Latest & Greatest versions of mysql have added support for things like
transaction commit and rollback, etc., but this is a very recent
development.  IHMO, I would expect this to be immature at this time, so
wouldn't do anything mission-critical with it until it's had some time to
work out the inevitable bugs and problems.  I think that mysql relies on
the underlying berkeley database routines from sleepycat, and rely on that
for the transaction support.

Postgresql has had these features, stored procedures, triggers, and other
more advanced features for years now so I would expect far fewer problems
than with mysql.

Mysql is used extensively for web server support, radius logging, and
similar applications that require a very fast, simple, server.  There are
probably some very sophisticated applications built around mysql (but then
the same could be said for FilePro which is hardly a robust database).

Bill
--
INTERNET:   bill at Celestial.COM  Bill Campbell; Celestial Software LLC
UUCP:               camco!bill  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676
URL: http://www.celestial.com/

When you have an efficient government, you have a dictatorship.
                -- Harry Truman