Subject | Re: [firebird-support] Firebird 3.0 RC1 - SQL optimization help |
---|---|
Author | Lester Caine |
Post date | 2016-01-25T20:10:37Z |
On 24/01/16 08:04, Ertan Küçükoğlu ertan.kucukoglu@...
[firebird-support] wrote:
browser. I've used a library called ADOdb since day one, and this
massages a large section of the SQL into a format that can be used by
any of the large number of databases it supports. It also has a meta
data management tool that allows a generic table description to be used
to provide metadata changes cross database. All one has to ensure is
that field and table names are not reserved words across all the
database engines that are being used.
It may not be something you can use, but it will provide an insight as
to how it can be done.
--
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
[firebird-support] wrote:
> I needed some time to understand (at least try to understand) your post. Please, note that my SQL knowledge is very limited. I really don’t know internals of database any system. Though, I need to develop an application which can use Firebird, Interbase, MSSQL, MySQL, Oracle. Some of users databases may be Firebird, others MSSQL, and an Oracle maybe. User decides what to use.I currently develop projects using PHP which users access via a web
browser. I've used a library called ADOdb since day one, and this
massages a large section of the SQL into a format that can be used by
any of the large number of databases it supports. It also has a meta
data management tool that allows a generic table description to be used
to provide metadata changes cross database. All one has to ensure is
that field and table names are not reserved words across all the
database engines that are being used.
It may not be something you can use, but it will provide an insight as
to how it can be done.
--
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