MySQL vs PostgreSQL (was "RE: MySQL install from source??")

[Rob Brandt]

Yes, as long as you are looking only at file structures and not GUI;

1) MySQL is similar to Filemaker - they are flat files that you can 
do relational things with.
2) PostgreSQL is similar to Oracle - they are the 'real deal' 
relational databases.

Where MySQL falls over relationally (so I'm told) is when you try to 
do outer join SQL calls, populating an array from two tables in one 
call.  I believe you can do it in MySQL, but it's really slow.  Also, 
MySQL doesn't do transactions (rollback), although someone told me 
that that's coming.



>On Wed, 3 Apr 2002, Pete Peters wrote:
>>I eventually plan to install one of those database programs on my Linux
>>box for my own learning and edification. I'm curious. Would you consider
>>MySQL vs PostgreSQL similar to MS Access vs MS SQL or Filemaker vs 4D?
>
>  I really can't say. The only databases I've used are MySQL, PostgreSQL,
>Oracle and FileMaker.
>
>  However, I find it really hard to compare MySQL with PostgreSQL as they
>are really in different classes. MySQL is closer to a flat file scheme
>with a limited SQL interface, whereas PostgreSQL is much closer to Oracle,
>and is considered by some to be an Oracle competitor.
>
>Cheers,
>
>Chris
>
>--
>
>Christopher Murtagh
>Webmaster / Sysadmin
>Web Communications Group
>McGill University
>Montreal, Quebec
>Canada
>
>Tel.: (514) 398-3122
>Fax:  (514) 398-2017
>
>
>_______________________________________________
>yellowdog-general mailing list
>yellowdog-general@lists.terrasoftsolutions.com
>http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-general


--