Hi Brian:
On Wed, Feb 14, 2007 at 10:19:09AM -0500, Brian Dailey wrote:
> different database backends without significant (or maybe any) changes to
> your code. Pear::DB seems to really do a good job with this. However...
The new PEAR MDB2 package does an even better job. Deals with building
schemas nicely too.
> In the past, I've always used MySQL or Oracle, but mostly MySQL. Each SQL
> distribution has its own peculiar ways of doing some things, and I know that
> using some of the MySQL functions makes the code far easier to write and
> also optimizes the speed of the query.
In general, good SQL is good SQL, no matter what the platform is.
The question you need to face is how important performance is vs how
important portability is. The answer depends on what you're doing.
--Dan
--
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
data intensive web and database programming
http://www.AnalysisAndSolutions.com/
4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
