Peter, Simon:
First off, Simon, could you look at the Press FAQ to see if there's
anything missing based on your experience at LWE-SF?
http://pgfoundry.org/docman/view.php/1000047/26/press_faq.xhtml
> And of course they are right. Porting from MySQL to PostgreSQL is a
> problem, one which could only be solved by dumbing down PostgreSQL to
> accept many of MySQL's idiosyncracies, which isn't going to happen.
Well, better migration tools would be a start. PHP's gradual transition to
PDO (and working with the PDO folks to make PDO_pgsql better, like not
doing count(*)) will help a lot too; the biggest MySQL migration
complaints I here are from users of PHP stuff like *Nuke and various Wikis
which sprinkle SQL throughout the interface code.
More important than any of these would be a 5-page guide, "Migration Tips
from MySQL to PostgreSQL."
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco