Re: Difference between PostgreSQL and MySQL

[Martijn Tonies]

Subject: Re: Difference between PostgreSQL and MySQL


> Well, since you admitted to being a newbie, I would suggest that you learn
> with MySQL. It supports several types of data storage (memory only, ISAM,
> full-relational) and both transacted and non-transacted execution models.

Ehm no - not FULLY relational ... InnoDB doesn't do CHECK constraints.
Then again, no DBMS is to be said "fully relational" anyway.

> That's just about everything you could want a database to do. Development
> is nearing completion on Stored Procedures which means that Triggers are
> not far away. Those last two elements really round out the already
> impressive features built into MySQL.

From what I've heard, Triggers will be included in the next 5 beta.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com