Subject Re: [firebird-php] Re: What is the best DB abstraction for Firebird?
Author Darren Thompson
yes use the PHP functions.
unless you want to be able to use mysql or any other database for the same
application then you will need an abstaraction layer i would suggest
something that is light weight not ADOdb.

On 3/7/06, nn33dl3 <nn33dl3@...> wrote:
>
> --- 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?
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>


[Non-text portions of this message have been removed]