Re: comparaison between adodb/ DB /MDB | MDB2

On Thu, 28 Oct 2004 22:00:51 +0200, Benoit Chesneau <bchesneau@gmail.com> wrote: > Hi, > > I woul d like to use a database abstraction layer in my app. I use php > version 5. What should I use as database abstraction layer ? What is > the fastest or more portable ? > Well, PEAR::DB is the current standard, but it doesn't do type abstraction on its own. You have to use DB_Table to a similar package to do that (DB_DataObject does this as well, but not for as many types and it doesn't create the tables for you). MDB/MDB2 has built in type abstraction and overall seems like a great product. MDB2 is supposed to be come the new DB (standard PEAR DB abstraction layer) once it's stable. Personally I like what it's done very much, but I'm fairly reliant on DB_DataObject so I haven't switched. I also have some concerns about type info being "lost" after the create (i.e. you have to specify the types *again* in your code). Someone please correct me if MDB2 has fixed this. I have never used adodb and never will. The standards don't fit PEAR at all and I just don't like the MS-like API. -- paperCrane --Justin Patrin--