nn33dl3 wrote:

> Hi,
> What would be the best DB abstraction to use with Firebird, firebird
> PDO, ADOdb or another if there is one?

using PDO would be equivalent to taking firebird and cutoff its arms, legs
and reproductive organs off. (on top of the fact that half of firebirds features
are not available via PDO, there is the issue of parameter binding in queries and
resultsets: the firebird extension does that out of the box (the functionality is
merely exposed by the extension), without requiring you to writing tons of lines of
repetitive code - where as PDO has php level parameter binding functionality
(so the underlying DB receives interpolated SQL - i.w. no more SQL injection protection
from the DB engine itself) which requires every freaking bound parameter to
be explicitly defined)

ADOdb is good by all accounts here - |I have no personal exprience.

personally I roll my own DB wrapper classes (I don't call it abstraction
because I have never intended on making my DB classes interchangeable)
- why would I want an abstracted firebird connection?? it just means I can't make
use of any of firebird's professional features - If I wanted MySQL I'd use it.

now if someone would come up witha DB abstraction class that only covered
DBMS' that support a decent feature set (e.g. Oracle, Postgres, Firebird)
then maybe it would be worth it.

> I was thinking of using PDO but there is only the beta version available.
> What are you using?
> Regards
> Rob
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>