On Jul 24, 2007, at 1:39 PM, Greg Smith wrote:
> On Tue, 24 Jul 2007, Jim Nasby wrote:
>
>> You can certainly make MySQL as robust as PostgreSQL; it's just
>> harder to do so.
>
> I'd recommend http://dev.mysql.com/tech-resources/articles/mysql-
> data-integrity.html as an intro for anyone who wants to catch up on
> the current state of MySQL data validation compared to how it used
> to be. It's really not so bad nowadays if you use the
> strict_all_tables feature. They still have the open issue of some
> older apps not working if you toggle this on, so it's not the
> default, but "good enough" validation is there.
I love how they can't keep the marketing stuff out of their docs...
"However, the meteoric rise in MySQL's popularity"
but I digress... the real reason I was looking at that is to confirm
that you can turn off strict checking within a session. So one
wayward command means all your safety just went away.
Like I said... safe data is possible with MySQL, it's just harder.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
