Re: [PDO] PDO transaction isolation level and firebird

2013/10/13 Lester Caine <lester@lsces.co.uk>: > > 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.