Ellen, >From a strict database perspective, PostgreSQL has a bit more power than MySQL. In particular, support for transactions (and database integrity) is very complete with PostgreSQL. With that being the case, the disadvantage would be with MySQL, not PostgreSQL.
In addition, Tim Purdue (sourceforge.net) has done some excellent work to compare MySQL and PostgreSQL. His investigation concluded that PostgreSQL was not only stronger in terms of database features, but was also able to completely outperform MySQL, particularly on complex queries. In particular, the main reason for this was due to MySQL's table-level locking as compared to PostgreSQL's 'better than row level' locking. In my personal experiences, I've used PostgreSQL a lot more than MySQL. It's been rock solid underneath a survey and assessment application that would bring MySQL to it's knees. Most of my career has been spent with very large databases, including Oracle and others. For my work, I can quite happily say I'll never have to suffer through Oracle again! Good luck with the project! -- William D. 'Diggy' Bell Principal DB Software Development http://www.dbsoftdev.com "Ellen Solomon" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I'm starting a project for which the lead programmer wants to use > postgresql. I'll be working in php. Any major disadvantages to > postgresql over mysql, other than mysql seems to be more widespread? > > TIA > Ellen > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
