To explain Why is way too long to list here but here is part of the thing: PG developed since 1986 and is one of the most stable DB out there, and it is real RDBMS while MySQL is not. PG support real transactions and for long time. PG support Forigen Keys which for my openion is reason number one becouse when you delete of a row you can tell the DB to delete all the otheres which connected to it automaticly and dont have to send a delete querry for each time. PG support stored procedure - in other word you can run your small internal program in the server written in plpgsql, python, perl and now even php. this is a major benefit as you can run lots of querry in one call + lots of calculation much faster then MySQL.
And much much more :) PG is more like Oracle, MySQL is a thin DB with few capabilities, which I will use only on one level database websites who needs only simple queris. About postgres: http://advocacy.postgresql.org/advantages/ http://www.eweek.com/article2/0,1759,1587748,00.asp more can be read here: http://openacs.org/philosophy/why-not-mysql another old compare http://phpbuilder.com/columns/tim20000705.php3?aid=14 -------------------------- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 Fax: 972-4-6990098 http://www.canaan.net.il -------------------------- ----- Original Message ----- From: "Omer Zak" <[EMAIL PROTECTED]> To: "Ben-Nes Michael" <[EMAIL PROTECTED]> Cc: "Linux-IL mailing list" <[EMAIL PROTECTED]> Sent: Thursday, June 17, 2004 12:27 PM Subject: Re: quick MySQL howto, anyone? > Why? > I specified MySQL for two applications which I am developing. So, I > would like to know whether I should switch to PostgreSQL, based upon my > applications' requirements and your reported MySQL problems. > > Ben-Nes Michael wrote: > > Dont do my mistake, start with postgresql if you can. > > > > MySQL is a bad DB unless you need one table Web Site. > > Thanks, > --- Omer > My own blog is at http://www.livejournal.com/users/tddpirate/ > > My opinions, as expressed in this E-mail message, are mine alone. > They do not represent the official policy of any organization with which > I may be affiliated in any way. > WARNING TO SPAMMERS: at http://www.zak.co.il/spamwarning.html > > > ================================================================= > To unsubscribe, send mail to [EMAIL PROTECTED] with > the word "unsubscribe" in the message body, e.g., run the command > echo unsubscribe | mail [EMAIL PROTECTED] > > ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
