Re: SV: [PHP4BETA] Easier Porting To Different Databases

Johan Ekenberg wrote: > In my experience ODBC is *a lot* slower than > direct interfaces. If Perl DBI can do without ODBC, > I really hope PHP can too. > For instance, see the benchmarks at > http://www.mysql.com/benchmark.html > > /Johan Ekenberg > > > How about ODBC :) > > That is sorta what it's for.... :) > > > > Andrew > > > > > > -----Original Message----- > > From: Andrei Zmievski [mailto:andrei@ispi.net] > > Sent: Wednesday, March 01, 2000 5:15 PM > > To: Mark Kirkwood > > Cc: php4beta@lists.php.net > > Subject: Re: [PHP4BETA] Easier Porting To Different Databases > > > > > > On Thu, 02 Mar 2000, Mark Kirkwood wrote: > > > I am curious to know if there are plans to "regularise" > > database calls in > > PHP so that it > > > is simpler to port a PHP application from one database to another. > > > > > > For instance Mysql and Postgresql have very similar PHP calls, > > but Oracle > > is completely > > > different. > > > > > > I guess I am thinking of Perl DBI where you can always do > > "$handle->fetchrow_array()" > > > no matter what the database actually is. > Even Microsoft gives you alternatives to ODBC, although ODBC is useful for the occasional database that may not have a direct driver. For example, you can use MS Jet to connect directly to an Access database, or OLE DB to connect directly to several other types of database. IMHO ODBC should be considered a temporary fix until you can write a PHP module that will connect to the database directly. And keep in mind that Perl DBI can only handle databases for which DBD modules have been written... -- North Shore Technologies, Cleveland, OH http://NorthShoreTechnologies.net Steve Sobol, President, Chief Website Architect and Janitor sjsobol@NorthShoreTechnologies.net - 888.480.4NET - 216.619.2NET