Re: youtube video on pgsql integrity

On Fri, Nov 30, 2012 at 2:00 AM, Ray Stell <stellr(at)vt(dot)edu> wrote:
>
> On Nov 29, 2012, at 9:27 AM, Kevin Grittner wrote:
>> is everything shown there really
>> the behavior of the MySQL database itself?
>
> Good question. I intend to install mysql one day to explore, but just can't find the time. The particular engine is not disclosed and I've read some are better than others....

Far as I can see, none of the behaviour show there is the front end
(other than UI features like autocomplete). You should be able to
replicate everything demonstrated in that vid using any MySQL client.

I like his quoting of the error messages. MySQL: now()/0 -> NULL;
PostgreSQL: now()/0 -> "dude, what are you doing".

With at least some of the invalid-data-gets-modified examples, you can
tell MySQL to be more strict about things. However, the typical use of
MySQL is with those sorts of settings at their defaults. See:
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html and note
that an application is always free to violate any of those rules it
likes.

PostgreSQL puts the responsibility on the database schema designer and
the database admin; MySQL puts the responsibility on the application
developer. PostgreSQL builds a database and lets applications talk to
it; MySQL lets an application store its data. There's a huge
philosophical difference there.

ChrisA