Subject Re: What is the best DB abstraction for Firebird?
Author nn33dl3
--- In firebird-php@yahoogroups.com, Jochem Maas <jochem@...> wrote:
>
> 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
> >
> >
> >
> >
> >
> >
>

So if I want to get the most out of Firebird I would be better of
using Firebirds own PHP Functions instead of using ADOdb, PDO or whatever?