Re: [PDO] PDO transaction isolation level and firebird

2013/10/13 Lester Caine <[email protected]>:

>
> PDO only supports a single database in a transaction while Firebird ( and
> Interbase ) support cross database transactions. So we have to use the
> generic driver a lot of the time anyway. Why also support a badly restricted
> one? ADOdb will quite happily handle PDO as well as the generic drivers and
> creates a 'flat field' without many of the restrictions PDO created.

There is many advantages in using PDO
1) not need to use bloated framework to access database, just
lightweght wrapper or even without it.
2) not need to think how to execute queries do different databases,
you have to learn single syntax. and this is common approach (jdbc in
java, odbc, adodb, etc  in windows)
3) pdo has named placeholders ( using positonal placeholders in
interbase really painfull)
4) php scripts typcally have short life, so using parallel
trasnactions to single db rarely need. parallel transactions to
different db of course supported. this is simply different pdo
instances.