Sadly, Mr. Saran wasted a lot of time writing a pluggable backend db layer, as one is built into PHP now, PDO: http://us2.php.net/pdo Sybase / MsSQL: http://www.php.net/manual/en/ref.pdo-dblib.php Postgres: http://us2.php.net/manual/en/ref.pdo-pgsql.php Oracle: http://us2.php.net/manual/en/ref.pdo-oci.php The only difference in using them is the dsn you pass to the constructor, which can even be dynamically generated if you see fit. The actual usage from driver-to-driver is the same; I've used it on postgres, mysql and sqlite. Based from the meeting notes of several 6.0 developer notes, it might or might not be the only database extension not in PECL soon. On Wed, Jun 3, 2009 at 8:51 AM, Bob McConnell <rvm@xxxxxxxxx> wrote: > From: Sancar Saran > > > And if you so much thinking about future DB change. Just wrote > compatible sql > > and use multi drive layer (phpADO db). > > > > And you are problem free > > I have some questions about this suggestion. We currently have > production systems using Postgres, Sybase ASA, Oracle and MS SQL Server. > Only one product currently supports more than one, it can be installed > with ASA or connect to an existing Oracle server. This unfortunate mix > was brought about by several acquisitions over the past ten years. We > also have a group talking about using MySQL for a portal project. One > product did use MySQL prior to their switch to per server license fees, > which made them far too expensive for the distributed system they were > used in. So that project switched to Postgres. > > But what is the ADO layer going to look like in order to support any or > all combinations of these back ends? How much of a kludge will it have > to become? > > Is there any code out there that will support most of these, or do we > have to write it all ourselves? > > Most of my SQL experience has been with Sybase ASA. I am playing with > Postgres a little bit now, and the differences can be both subtle and > glaring. But I don't know either one well enough to understand how to > design an ADO interface, let alone how to bring in the other options. > > Thank you, > > Bob McConnell > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >
