From: George Moschovitis Date: 2004-11-25T00:33:00+09:00 Subject: Re: Other ORMs [was: rails is awesome] > Other than the wonky SQL-MySQL compliance divide, are there specific > features that you can get out of PostgreSQL, or are a lot easier to use > in PostgreSQL, that might encourage a MySQL user like myself to change? > I've seriously considered switching to PostgreSQL 'cause it has a good > rep with people I trust, but every time I try to Google this topic I > never find something that convinces me to switch. The most annoying thing with MySQL is that various features work with various table types or version. For example: There are subseleicts in 4.1, stored procedures in 5.0, other features will only be available in 5.1, there are transactions in InnoDB tables, but a freetext index only in MyISAM tables and stuff like that. PostgreSQL has all the features right here, right now, has robust libraries, is fast and has excellent documentation. The latest version (8.0) works on Windows too. In short, it just rocks! George. -- www.navel.gr | tel: +30 2106898050 | fax: +30 2106898437 web appliction engine: http://www.navel.gr/nitro object relational mapping: (Og) http://www.navel.gr/nitro have fun: http://www.joy.gr