Hello Michael,

On 19-Jun-01 23:57:31, you wrote:

>I'm new to this mailing list. So if this post is off-topic, please tell
>me and I will try to post it in other lists.

>I'm currently developing an intranet solutions targeted to run with
>several different SQL database system such as MySQL, PostgreSQL, Oracle,
>Microsoft SQL Server and so on. For the database abstraction I use the
>abstraction layer provided by the PEAR class collection. And for the
>design of the tables I use a software called DeZign for database (very
>good, by the way; more information at http://www.datanamic.com/). With
>this software it's possible to develop tables and to export a SQL script
>for creating those tables on several different database server,
>especially those mentioned above.

>The problem I have is how to develop SQL querys (SELECT, INSERT, UPDATE)
>that are compatible with all the SQL database I wrote about before. Does
>anyone know whether a software like DeZign is also available for the
>development of SQL querys? Or is there any _good_ resource on the
>internet comparing the syntax of _all_ the SQL implementations of
>databases? I didn't find any such information at all.

You may want to try Metabase instead of PEAR because it helps you to write
database independent code that works seeminglessly with many different
databases so you don't have to rewrite your queries for each database you
want to support.

Metabase is also able to abstract the creation of databases and their
tables, fields, indexes and sequences.  You only need to describe your
database in a specific XML format.

Metabase manager is able to interpret your schema descriptions and install
it in your database of choice.  If later you decide to change your schema,
Metabase manager is also able to apply the changes without disturbing the
data inserted after you installed the database for the first time or
updated the schema for the last time.

Metabase is freely available and you can download it from here:


Watch also for ready to use components based on Metabase:

Query result table display class

Database access class

Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED]
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to