Re: DB to ADODB

Hello Mohan If you know oracle/mssql/postgresql, they are all very different beasts. We use MySQL and Oracle everyday at work and I know you will need a good wrapper then. Oracle is the most complicated rdbms of all, but a quick scan of the source of PEAR DB's oci8 vs mysql implementation will show you that the oci8 is far less complete (16K) than mysql's (22K). Ditto for mssql (13K). That will tell you something. You will see the reverse in ADODB, where the oci8 implementation is one of the larger files. Parts of ADODB will probably be ported to C eventually, and I can tell you that startup time will increase significantly then (well maybe not if u use the Zend Accelerator), but I do not really expect that much speed improvement - the bottleneck is the SQL execution - of course I might be wrong... If you need power, ADODB has more functionality, particularly for oci8. ADODB can simulate SELECT ...LIMIT and PEAR DB currently doesn't. If your needs are simple, stop worrying about which one to use - start coding - it doesn't matter! John Lim Mohan <saradiya@ameba6.com> wrote in message news:200110080226.f982Qhk05006@antaraconsolidated.com... > Hi guys, > > I am currently working on a php project and was seriously considering DB over > ADODB. This was mainly due to the fact that > > 1.THere has been rumbles that they are porting DB to C ? > 2.DB is used by all the other PEAR classes > 3.ADODB seems a tad complex , since we will mainly be using only postgresql > and might need support for oracle/mssql > > Why would I choose ADODB over DB ? Is there someway to abstract it such that > we could enjoy the best of both world ? Maybe use some Factory patterns ? > > Mohan