[prev in list] [next in list] [prev in thread] [next in thread] 

List:       zope-db
Subject:    Re: [Zope-DB] Database independent SQL
From:       Dieter Maurer <dieter () handshake ! de>
Date:       2003-12-06 21:26:31
[Download RAW message or body]

Santi Camps wrote at 2003-12-5 22:21 +0100:
>I'm looking for a way to have advanced database independent SQL.  I know
>that ZSQL Methods provide some independent, but there is a lot of useful
>functions that vary between databases.  I'm thinking in functions like:
>
>coalesce in postgresql / nvl in oracle
>case when in postgresql / decode in oracle 
>
>I've had some searches, but nothing successful.  Anybody knows if there
>is some product / module / tool to convert SQL syntax between databases?
>
>If not, I'm thinking into implement some of this syntax conversions, at
>least for postgresql and mysql, perhaps also oracle or sql-server.  I'm
>not very sure, but it seems not to be a huge project.  What do you think
>about this?

ODBC might be an option for you.
It standardizes a large SQL subset.
It is available not only for Windows but for Unix, too.

-- 
Dieter

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db
[prev in list] [next in list] [prev in thread] [next in thread]