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
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://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 )
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 )
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 )
On Wed, 2002-05-29 at 01:30, Oliver Marx wrote:
But the ZSQL-methods should be DB independent and the DB adapters should all have the same interface - that would rock!
They are, if you stick to the lowest common subset :) ------------------ Hannu
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 )
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 )
participants (4)
-
Chris McDonough -
Hannu Krosing -
nitin＠borwankar.com -
Oliver Marx