Foreign keys / Transactions in MySQL.. WTF?

[Ovid]

--- Jonathan Stowe <jns at gellyfish.com> wrote:

> Oooh good points, combine those with "consistent and largely ANSI
> compliant SQL implementation", "scalable and flexible storage model",
> "reliable and easy to configure replication", "advanced query
> optimisation" and "comprehensive performance and fault monitoring
> facilities" and I'm sure I'd be almost be convinced if it wasn't for
> the stupid name and the frothing geeks.

Other points aside, MySQL should default to 'strict' mode and by
default be as ANSI compliant as possible.  Because it's not and many
developers don't even know about these options, we've sacrificed
correctness for ease of use.  If MySQL would do the right thing and at
least change the defaults, many of my complaints would be moot.

Then they need to add trigger support for views, but that's another
story :)

Cheers,
Ovid

--
Buy the book  - http://www.oreilly.com/catalog/perlhks/
Perl and CGI  - http://users.easystreet.com/ovid/cgi_course/
Personal blog - http://publius-ovidius.livejournal.com/
Tech blog     - http://use.perl.org/~Ovid/journal/