Re: [phpesp-dev] ODBC support rewrite

[Charlie S. <Sm...@ld...>]

I just noticed the PEAR supported databases are listed as follows at =
pear.php.net. See =
http://pear.php.net/manual/en/package.database.mdb.intro-dsn.php
mysql  -> MySQL
pgsql  -> PostgreSQL
ibase  -> InterBase
mssql  -> Microsoft SQL Server
oci8   -> Oracle 7/8/8i
=66bsql  -> FrontBase

Stephan indicates that he prefers ODBC over PEAR because of poor benchmarks=
,=
 but it looks like
he's going to do a pear port anyway:  He stated:
"... Here's what I'll do=20
: as soon as I got a dev environment with Oracle/ODBC running, I'll test th=
e=
=20
Pear connectivity. If it works, I'll move my phpEsp to PEAR. But,=20
unfortunatley, I have also several additional features that I have to add t=
o=
=20
the code that are not necessarily good for everyone ..."

However, I'll need to interface with OCI8 right away.   Would it be =
beneficial for me to get started on a PEAR port?   I need to get phpESP =
going with OCI8 anyway - and right now.
Where are the benchmarks and what kind of time frame are we looking at to =
get the PEAR stuff done with Stephan doing it?



>>> "Matthew Gregg" <gr...@mu...> 09/25/03 07:59AM >>>
Why I favor Pear...
PearDB currently supports:
MySQL
PostgreSQL
InterBase
Mini SQL
Microsoft SQL Server
Oracle 7/8/8i
ODBC (Open Database Connectivity)
SyBase
Informix
=46rontBase

A port to PearDB will give us connectivity to all of these DB's almost
=66or free.  And I'm sure more thought and development time has gone
into these libraries that we would ever do in a generic solution.

How does a "generic" solution give us more choice?


On Thu, Sep 25, 2003 at 06:46:34PM +1000, Kon wrote:
> Guys,
>=20
> I think that the generic functions would be OK as it provides greater
> choice.
>=20
> Regards
>=20
> Kon
>=20
>=20
> On Thu, 2003-09-25 at 04:04, Matthew Gregg wrote:
> > I would prefer a PEAR solution, but something like this would be ok.
> >=20
> > On Wed, Sep 24, 2003 at 11:59:32AM -0600, Charlie Smith wrote:
> > > So instead of mysql_connect or @OCIPLogon($oracleUser, =
$oraclePassword, $oracleSid);
> > > you could have:
> > >=20
> > > function genDBConnect($genDBSid, $genDBUser, $genDBPassword) {
> > >   if (DB =3D=3D 'Oracle) {
> > >       $connected =3D @OCIPLogon($genDBUser, $genDBPassword, =
$genDBSid);
> > >=20
> > >       if($error =3D OCIError()) {
> > >         die("<font color=3Dred>ERROR!! Couldn't connect to =
server!</font>");
> > >       }
> > >       return $connected;
> > >   }
> > >   else if (DB =3D=3D 'MySQL' {
> > >       mysql_connect($genDBSid, $genDBUser, $genDBPassword)
> > >   }
> > > }
> > >=20
> > > Something like this?  along with other generic functions to handle =
each of the mysql/oracle functional pieces?
> > >=20
> > >=20
> > > >>> "Matthew Gregg" <gr...@mu...> 09/24/03 10:56AM >>>
> > > This does sound good.  But instead of porting to Oracle, a port to
> > > PEAR or some other "generic" database abstraction layer would be even
> > > better.
> > >=20
> > > On Wed, Sep 24, 2003 at 09:38:28AM -0600, Charlie Smith wrote:
> > > > I'm starting a project to give us an oracle interface ie. replacing=
 =
mySQL calls with Oracle.  Sounds like this could be beneficial to others, =
especially you.   Hope to be done by end of  day today.  Will let you know =
if sounds good to you.
> > > >=20
> > > > >>> "Stefan Champailler" <sch...@ea...> 09/22/03 08:09AM=
 =
>>>
> > > > Dear all,
> > > >=20
> > > >=20
> > > > I'm going to use phpESP for a project inside a big tyre company. =
However, I'll=20
> > > > need to interface it with Oracle through ODBC. So, what do you thin=
k=
 is=20
> > > > better :
> > > >=20
> > > > - use normal ODBC (iODBC, unixODBC)
> > > > - use PEAR libs
> > > >=20
> > > > Personally, I prefer ODBC because I read very poor benchmarks for =
PEAR=20
> > > > database access.
> > > >=20
> > > > Any suggestions ?
> > > >=20
> > > > Stefan
> > > >=20
> > > >=20
> > > >=20
> > > > This sf.net email is sponsored by:ThinkGeek
> > > > Welcome to geek heaven.
> > > > http://thinkgeek.com/sf=20
> > > > _______________________________________________
> > > > phpESP-devel mailing list
> > > > php...@li...=20
> > > > https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20
> > > >=20
> > > >=20
> > > >=20
> > > > This message may contain confidential information, and is intended =
only for the use of the individual(s) to whom it is addressed.
> > > >=20
> > > >=20
> > > > =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
> > > >=20
> > > >=20
> > > >=20
> > > > This sf.net email is sponsored by:ThinkGeek
> > > > Welcome to geek heaven.
> > > > http://thinkgeek.com/sf=20
> > > > _______________________________________________
> > > > phpESP-devel mailing list
> > > > php...@li...=20
> > > > https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20
> > > >=20
> > >=20
>=20

--=20
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf=20
_______________________________________________
phpESP-devel mailing list
php...@li...=20
https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20


---------------------------------------------------------------------------=
---
This message may contain confidential information, and is intended only for=
 =
the use of the individual(s) to whom it is addressed.


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D