Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001062

RE: [PHP-DB] db abstraction: sql design From: Michael Rudel (mru <email protected>)
Date: 06/20/01

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:mru <email protected>
internet: http://www.suchtreffer.de
_______________________________________________________________

> -----Original Message-----
> From: Michael P. Mehl [mailto:abo <email protected>]
> Sent: Tuesday, June 19, 2001 11:35 PM
> To: php-db <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: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail:
> php-list-admin <email protected>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>