Re: Database Abstraction in Pear (Consistency)
| From: | Tomas V.V.Cox | Date: | Wed, 07 Aug 2002 14:33:41 +0000 |
| Subject: | Re: Database Abstraction in Pear (Consistency) | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-2069@lists.php.net to get a copy of this message | ||
Jeff wrote:
>
> How consistent is the DA in pear across the different supported
> databases. For example I read somewhere that the problem with DA is that
> some features in mysql are not supported in oracle, like the
> mysql_num_rows function.
>
> Is there ever a reason why my DB code created for mysql using the pear
> DA will not work naturally on Oracle? Where can I learn more about this
> topic?
If you use the "optimize" as "portability" connect option, the missing
native num_rows feature in Oracle is emulated by PEAR DB.
$db = DB::connect(DRIVER_DSN, array('optimize' => 'portability'));
Tomas V.V.Cox