[Zope] Database abstraction layer

Tue, 28 May 2002 22:30:50 +0200

This is a multi-part message in MIME format.

------=_NextPart_000_0025_01C20697.52326D20
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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 )

------=_NextPart_000_0025_01C20697.52326D20
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dus-ascii" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3502.4856" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D954502020-28052002>But=20
the ZSQL-methods should be DB independent and the DB adapters should all =
have=20
the same interface - that would rock!</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D954502020-28052002></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D954502020-28052002>\Oliver</SPAN></FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: =
5px">
  <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> =
zope-admin@zope.org=20
  [mailto:zope-admin@zope.org]<B>On Behalf Of=20
  </B>nitin@borwankar.com<BR><B>Sent:</B> 28. maj 2002 =
22:18<BR><B>To:</B>=20
  zope@zope.org<BR><B>Subject:</B> Re: [Zope] Database abstraction=20
  layer<BR><BR></DIV></FONT>You may want to look at the Python DB API =
which is a=20
  database abtrsaction layer in its second version<BR>This has been =
around for a=20
  while. &nbsp;haven't used it as I do most of my Python DB interfacing =
via ZSQL=20
  methods in Zope.<BR><BR><A class=3Dmoz-txt-link-freetext=20
  =
href=3D"http://www.python.org/topics/database/">http://www.python.org/top=
ics/database/</A><BR><BR>Nitin=20
  Borwankar.<BR><BR><BR>Chris McDonough wrote:<BR>
  <BLOCKQUOTE cite=3D"mid:1022550800.1816.34.camel@james" =
type=3D"cite"><PRE wrap=3D"">That's right.  There really is no canonical =
database abstraction layer<BR>for Python relational database adapters =
that I've seen.  I think the<BR>best you can do is either code to the =
lowest-common-denominator SQL<BR>dialect (probably impossible) or code =
for as many databases as you need.<BR><BR>Sorry,<BR><BR>- =
C<BR><BR><BR>On Sun, 2002-05-26 at 05:36, Oliver Marx wrote:<BR></PRE>
    <BLOCKQUOTE type=3D"cite"><PRE wrap=3D"">Greetz<BR><BR>I'm looking =
for a DAL to use with Python but can't find any.<BR>There seems to be =
adapters for a range of sql servers, but not one which<BR>unifies the =
interfaces; sql syntax varies with each server (fx LIMIT =
and<BR>TOP).<BR><BR>\Oliver<BR><BR><BR><BR>______________________________=
_________________<BR>Zope maillist  -  <A =
class=3Dmoz-txt-link-abbreviated =
href=3D"mailto:Zope@zope.org">Zope@zope.org</A><BR><A =
class=3Dmoz-txt-link-freetext =
href=3D"http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope">htt=
p://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope</A><BR>**   No =
cross posts or HTML encoding!  **<BR>(Related lists - <BR> <A =
class=3Dmoz-txt-link-freetext =
href=3D"http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-anno=
unce">http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-announ=
ce</A><BR> <A class=3Dmoz-txt-link-freetext =
href=3D"http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-dev"=
>http://rd.mailshell.com
/lists.zope.org/mailman/listinfo/zope-dev</A> =
)<BR></PRE></BLOCKQUOTE><PRE =
wrap=3D""><!----><BR><BR><BR><BR>________________________________________=
_______<BR>Zope maillist  -  <A class=3Dmoz-txt-link-abbreviated =
href=3D"mailto:Zope@zope.org">Zope@zope.org</A><BR><A =
class=3Dmoz-txt-link-freetext =
href=3D"http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope">htt=
p://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope</A><BR>**   No =
cross posts or HTML encoding!  **<BR>(Related lists - <BR> <A =
class=3Dmoz-txt-link-freetext =
href=3D"http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-anno=
unce">http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-announ=
ce</A><BR> <A class=3Dmoz-txt-link-freetext =
href=3D"http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-dev"=
>http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-dev</A> =
)<BR></PRE></BLOCKQUOTE><BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0025_01C20697.52326D20--