> 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
> > 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
> People use MYSql because it's so widely available, just like people use
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]