Subject Re: [firebird-php] Choice of PHP Driver for Doctrine Implementation
Author Lester Caine
On 23/11/14 13:17, Daniel Falkner Hansen dfh@... [firebird-php]
wrote:
>
> I’m currently working with Schema/Migration support in Doctrine. So far
> I’ve concluded that in Doctrine we will not able to support 'CREATE
> DATABASE’.
>
> Is that a correct conclusion - and are the any plans for db creation
> support in the Interbase driver in the future ?

Since the model for Firebird/Interbase requires a database to connect
to, you can not create a database without an existing connection. ADOdb
on Bitweaver I 'exec' the create so I can then use the database in the
installer, but nowadays for security reasons the database will be
pre-created and I see no reason to open that possible security hole.
http://hg.lsces.org.uk/bw/bitweaver/install/file/adc48deec6fd/create_firebird_database.php

> As a sidenote, I’m proceeding with the PDOFirebird implementation as
> Jimi suggested, and will continue with the Interbase development afterwards.
I will not repeat my objections to PDO. They are well documented on the
PHP lists. It does a job, but not the one we actually need to do and
even the MySQL team only offer lip service to maintaining their PDO
driver, putting all the real work into the generic one. None of the
'promises' that got PDO moved into core have ever been addressed so you
will no doubt now spend a lot of time creating let another interface
layer rather than using one of the well established generic driver based
layers? The problem is not with data types, but with SQL and higher
level compatibility. Reserved words and the like.

--
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