[Zope] Database abstraction layer

[Chris McDonough]

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 )
> >
>