Re: [PDO] PDO transaction isolation level and firebird

Vjacheslav V. Borisov wrote:
> 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.
The lightest weight layer is a generic driver.

> 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)
ADOdb sorts out many of the SQL differences ... PDO does not ... you still need 
to 'wrap' PDO to get that level of support.

> 3) pdo has named placeholders ( using positonal placeholders in
> interbase really painfull)
I use parameters extensively cross database and normally don't have to worry 
about differences between different engines.

> 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.
You miss the point here. These are not parallel transactions, but ones which 
wrap commits between TWO databases in the ONE transaction. You CAN'T do that 
with different PDO instances. Maintaining transfers of data from live to 
historic databases ensuring that one commits before the other is dropped.

-- 
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk