Subject | Re: [firebird-php] Choice of PHP Driver for Doctrine Implementation |
---|---|
Author | Lester Caine |
Post date | 2014-11-23T14:13:21Z |
On 23/11/14 13:17, Daniel Falkner Hansen dfh@... [firebird-php]
wrote:
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
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
wrote:
>Since the model for Firebird/Interbase requires a database to connect
> 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 ?
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 asI will not repeat my objections to PDO. They are well documented on the
> Jimi suggested, and will continue with the Interbase development afterwards.
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