[PHP-DB] db abstraction: sql design
Hi! 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. Thanks a lot in advance! Michael -- 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]
Re: [PHP-DB] db abstraction: sql design
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: http://phpclasses.UpperDesign.com/browse.html/package/20 Watch also for ready to use components based on Metabase: Query result table display class http://phpclasses.UpperDesign.com/browse.html/package/130 Database access class http://phpclasses.UpperDesign.com/browse.html/package/231 Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [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]
RE: [PHP-DB] db abstraction: sql design
Hi Michael, since U R using an abstraction-layer, most of Ur problems should be solved. U should have no problems if U reduce Ur SQL-statements to SQL92-standard. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicherstraße 20 D-78467 Konstanz Germany fon: +49-(0)7531-89207-17 fax: +49-(0)7531-89207-13 e-mail: mailto:[EMAIL PROTECTED] internet: http://www.suchtreffer.de ___ -Original Message- From: Michael P. Mehl [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 11:35 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] db abstraction: sql design Hi! 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. Thanks a lot in advance! Michael -- 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] -- 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]
[PHP-DB] DB Abstraction
Hi, I thought it was about time I started using a db abstraction class. Problem is, there are so many out there that I don't which one to start using? I've heard of ADODB (I think). Anyone have any suggestions? Cheers, Jord -- 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]