From: Martijn Tonies
Date: August 10 2004 9:29pm
Subject: Re: Difference between PostgreSQL and MySQL
List-Archive: http://lists.mysql.com/mysql/170687
Message-Id: <017e01c47f21$2f0b1400$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


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