RE: [PHP-DB] db abstraction: sql design
Hello Michael, On 20-Jun-01 05:16:32, you wrote: > 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. Not if you use an abstraction layer that does not do for instance data type conversion. For instance, not all databases takes dates formatted in the same way. AFAIK, PEAR-DB is like Perl-DBI and so it does not support datatype conversion and many other things important for assuring SQL code portability. Metabase and ADO-DB support datatype conversion. 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]
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]