Re: [PHP] mysql , postgres
MySQL is easier to use and faster to develop with for 90% of web applications. Sure, PostgreSQL has some huge advantages, but not everyone needs the same thing. /* Chris Lambert, CTO - [EMAIL PROTECTED] WhiteCrown Networks - More Than White Hats Web Application Security - www.whitecrown.net */ - Original Message - From: nafiseh saberi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 19, 2001 4:24 AM Subject: [PHP] mysql , postgres | | hi. | why most of you , use mysql and not | postgres? | nafiseh. | | -- | PHP General Mailing List (http://www.php.net/) | To unsubscribe, e-mail: [EMAIL PROTECTED] | For additional commands, e-mail: [EMAIL PROTECTED] | To contact the list administrators, e-mail: [EMAIL PROTECTED] | | | -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] mysql , postgres
Rules, triggers, subselects, built in transactions, etc. I haven't used it myself, but it does have features which relieve a lot of the client programming (PHP) required with MySQL. /* Chris Lambert, CTO - [EMAIL PROTECTED] WhiteCrown Networks - More Than White Hats Web Application Security - www.whitecrown.net */ - Original Message - From: Tom Carter [EMAIL PROTECTED] To: Chris Lambert [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, August 19, 2001 5:41 AM Subject: Re: [PHP] mysql , postgres | What would you say the advantages were? | | other than just the fact the the postgres implementation of sql is more | powerful (sub-selects etc). | | I'ld be very interested to see some performance comparisions if anyone has | any | - Original Message - | From: Chris Lambert [EMAIL PROTECTED] | To: [EMAIL PROTECTED] | Sent: Sunday, August 19, 2001 10:21 AM | Subject: Re: [PHP] mysql , postgres | | | MySQL is easier to use and faster to develop with for 90% of web | applications. Sure, PostgreSQL has some huge advantages, but not everyone | needs the same thing. | | /* Chris Lambert, CTO - [EMAIL PROTECTED] | WhiteCrown Networks - More Than White Hats | Web Application Security - www.whitecrown.net | */ | | - Original Message - | From: nafiseh saberi [EMAIL PROTECTED] | To: [EMAIL PROTECTED] | Sent: Sunday, August 19, 2001 4:24 AM | Subject: [PHP] mysql , postgres | | | | | | hi. | | why most of you , use mysql and not | | postgres? | | nafiseh. | | | | -- | | PHP General Mailing List (http://www.php.net/) | | To unsubscribe, e-mail: [EMAIL PROTECTED] | | For additional commands, e-mail: [EMAIL PROTECTED] | | To contact the list administrators, e-mail: [EMAIL PROTECTED] | | | | | | | | | -- | PHP General Mailing List (http://www.php.net/) | To unsubscribe, e-mail: [EMAIL PROTECTED] | For additional commands, e-mail: [EMAIL PROTECTED] | To contact the list administrators, e-mail: [EMAIL PROTECTED] | | | | -- | PHP General Mailing List (http://www.php.net/) | To unsubscribe, e-mail: [EMAIL PROTECTED] | For additional commands, e-mail: [EMAIL PROTECTED] | To contact the list administrators, e-mail: [EMAIL PROTECTED] | | | -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] mysql , postgres
Chris Lambert wrote: MySQL is easier to use and faster to develop with for 90% of web applications. Sure, PostgreSQL has some huge advantages, but not everyone needs the same thing. easier to use ? I'm not sure why anyone would say that faster to develop ? nope - I find postgresql quicker to develop with, I can use triggers to cut out a whole heap of extra php code. MYsql lacks subselects which forces you to do extra code, it lacks true foreign keys which means you need to add extra code to check data integrity. People use MYSql because it's so widely available, just like people use Windows. /* Chris Lambert, CTO - [EMAIL PROTECTED] WhiteCrown Networks - More Than White Hats Web Application Security - www.whitecrown.net */ | | -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] mysql , postgres
Tom Carter wrote: What would you say the advantages were? Well just my opinion but I think that Postgresql development is advancing quicker. With Red Hat joining in development and no infighting bewteen Postgresql developers things are looking good for the future. other than just the fact the the postgres implementation of sql is more powerful (sub-selects etc). Foreign keys, triggers both make life a lot easier. Also once your used to Postgresql, moving onto Sybase, Interbase etc isn't near as hard as making the jump from MYsql. I'ld be very interested to see some performance comparisions if anyone has any Dig around greatbridge.org and you might find some. - Original Message - From: Chris Lambert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 19, 2001 10:21 AM Subject: Re: [PHP] mysql , postgres MySQL is easier to use and faster to develop with for 90% of web applications. Sure, PostgreSQL has some huge advantages, but not everyone needs the same thing. /* Chris Lambert, CTO - [EMAIL PROTECTED] WhiteCrown Networks - More Than White Hats Web Application Security - www.whitecrown.net */ - Original Message - From: nafiseh saberi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 19, 2001 4:24 AM Subject: [PHP] mysql , postgres | | hi. | why most of you , use mysql and not | postgres? | nafiseh. | | -- | PHP General Mailing List (http://www.php.net/) | To unsubscribe, e-mail: [EMAIL PROTECTED] | For additional commands, e-mail: [EMAIL PROTECTED] | To contact the list administrators, e-mail: [EMAIL PROTECTED] | | | -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] mysql , postgres
Chris Lambert wrote: MySQL is easier to use and faster to develop with for 90% of web applications. Sure, PostgreSQL has some huge advantages, but not everyone needs the same thing. easier to use ? I'm not sure why anyone would say that faster to develop ? nope - I find postgresql quicker to develop with, I can use triggers to cut out a whole heap of extra php code. MYsql lacks subselects which forces you to do extra code, it lacks true foreign keys which means you need to add extra code to check data integrity. People use MYSql because it's so widely available, just like people use Windows. I would definately agree with the points about psotgresql having better functionallity, but it doesn't solely come down to availablility. MySQL is a simpler RDBMS.. this doesn't mean it is strictly worse than postgresql. In comes to one of those fundamental questions in IT... best tool for the job. What MySQl is good at is handling small (in both byte and row sense) tables which are frequently accessed, eg user authenitcatino. At the other extreme are the big boys of DB2, Oracle etc which can handle an awful lot and cope which much more complex structures and heavy usage. postgresql, IMHO, is a few steps from the MySQL extreme towards DB2. What I basically mean is that postgre has some features and functionallity which make it more suited to some tasks, and mysql has a place too. /* Chris Lambert, CTO - [EMAIL PROTECTED] WhiteCrown Networks - More Than White Hats Web Application Security - www.whitecrown.net */ | | -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] mysql , postgres
Hi, Well just my opinion but I think that Postgresql development is advancing quicker. With Red Hat joining in development and no infighting bewteen Postgresql developers things are looking good for the future. just to clear one issue - there has never been a fight between mysql developers. the thing you're probably referring to above is the MySQL-vs-NuSphere fight. NuSphere was to add their Gemini table handler (MySQL has an abstraction table handler layer, so you can add many different table handlers) to MySQL. it has not and won't affect the general development of MySQL. Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] mysql , postgres
Indrek Siitan wrote: Hi, Well just my opinion but I think that Postgresql development is advancing quicker. With Red Hat joining in development and no infighting bewteen Postgresql developers things are looking good for the future. just to clear one issue - there has never been a fight between mysql developers. the thing you're probably referring to above is the MySQL-vs-NuSphere fight. NuSphere was to add their Gemini table handler (MySQL has an abstraction table handler layer, so you can add many different table handlers) to MySQL. it has not and won't affect the general development of MySQL. Rgds, Indrek fair enough - slip of the tongue there but it does highlight the differences in in development style between MYsql and Postgresql. For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
