RE: [PHP-DB] db abstraction: sql design
| From: | Michael Rudel | Date: | Wed, 20 Jun 2001 08:19:48 +0000 |
| Subject: | RE: [PHP-DB] db abstraction: sql design | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9650@lists.php.net to get a copy of this message | ||
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@suchtreffer.de
internet: http://www.suchtreffer.de
_______________________________________________________________
> -----Original Message-----
> From: Michael P. Mehl [mailto:abo@silentpower.de]
> Sent: Tuesday, June 19, 2001 11:35 PM
> To: php-db@lists.php.net
> 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@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
>