On Thu, 31 Jul 2003, Gregg C Levine wrote:
> Hello again from Gregg C Levine
> I thought penguins were small birds to begin with? (Sorry I thought a
> joke was in order.)
> Every time I've experimented with a database for a customer, it's been
> MySQL on Intel. Distribution neutral, since the customer was of the
Please, don't confuse MySQL as a relational database manager. It lacks
several important features, deliberately omitted "for performance
reasons."
In some cases, it parses SQL to implement those features and accepts the
syntax, but doesn't do the grunt work, so a developer trying to use
those features might not recognise there's a problem.
Also, some years ago now, I was on a MySQL list and took up the issue of
using floating point arithmetic for counting money. The MySQL people
didn't see there's a problem, though others tried to explain it more
eloquently than I can.
Find archives for the sql-ledger list, and find there why sql-ledger
does not, will not support MySQL.
There are uses for MySQL, just as there are for db{1,2,3,4}, but not
where referential integrity matters.
--
Cheers
John.
Join the "Linux Support by Small Businesses" list at
http://mail.computerdatasafe.com.au/mailman/listinfo/lssb
Copyright John Summerfield. Reproduction prohibited.
