But the ZSQL-methods should be DB independent and the DB adapters should all have the same interface - that would rock!
 
\Oliver
-----Original Message-----
From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of nitin@borwankar.com
Sent: 28. maj 2002 22:18
To: zope@zope.org
Subject: Re: [Zope] Database abstraction layer

You may want to look at the Python DB API which is a database abtrsaction layer in its second version
This has been around for a while.  haven't used it as I do most of my Python DB interfacing via ZSQL methods in Zope.

http://www.python.org/topics/database/

Nitin Borwankar.


Chris McDonough wrote:
That's right.  There really is no canonical database abstraction layer
for Python relational database adapters that I've seen. I think the
best you can do is either code to the lowest-common-denominator SQL
dialect (probably impossible) or code for as many databases as you need.

Sorry,

- C


On Sun, 2002-05-26 at 05:36, Oliver Marx wrote:
Greetz

I'm looking for a DAL to use with Python but can't find any.
There seems to be adapters for a range of sql servers, but not one which
unifies the interfaces; sql syntax varies with each server (fx LIMIT and
TOP).

\Oliver



_______________________________________________
Zope maillist - Zope@zope.org
http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-announce
http://rd.mailshell.com /lists.zope.org/mailman/listinfo/zope-dev )




_______________________________________________
Zope maillist - Zope@zope.org
http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-announce
http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-dev )