Re: mySQL vs pgSQL | php vs others

> Is pgsql , better ? faster ? more reliable than mysql ? I won't speculate on which one is faster (although I think both camps would claim ownership of the trump card). But Postgresql does conform closer to the SQL standard, and there are a number of features available in it that are not yet even supported in the Alpha version of mySQL and will not be for some time. For instance, triggers -- upon some insertion into one table do something else. You need to look at what will be the best database for the job. There are many people who will claim that Postgresql is the best opensource equivalent to Oracle out there. There are others who will point out that the difference in license alone is worthwhile (while mySQL is licensed under the GNU Public License, Postgresql is licensed under a BSD style license). But you need to seriously look at what you are doing and what would be the best choice. -Dan