Re: 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 - chris@whitecrown.net > > WhiteCrown Networks - More Than White Hats > > Web Application Security - www.whitecrown.net > > */ > > > > > | > > | > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >