[Zope] Database abstraction layer

[Oliver Marx]

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 )