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 layerfor Python relational database adapters that I've seen. I think thebest you can do is either code to the lowest-common-denominator SQLdialect (probably impossible) or code for as many databases as you need.Sorry,- COn Sun, 2002-05-26 at 05:36, Oliver Marx wrote: GreetzI'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 whichunifies the interfaces; sql syntax varies with each server (fx LIMIT andTOP).\Oliver_______________________________________________Zope aillist - Zope@zope.orghttp://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.orghttp://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 )