Most databases of interest should follow SQL 92. As long as you don't use the abstraction layer for creating tables it should be possible. \Oliver
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Chris McDonough Sent: 28. maj 2002 22:45 To: nitin@borwankar.com Cc: zope@zope.org Subject: Re: [Zope] Database abstraction layer
The Python DB-API does not abstract the SQL, it just abstracts the semantics for connection, execution, commit, abort, and so on. You still need to provide it with SQL queries that match the kind of database you're using it with.
- C
On Tue, 2002-05-28 at 16:18, nitin@borwankar.com wrote:
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 )
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )