Win32+Zope+Python+Databases: What are my options?

[Michael Loritsch]

Peter Hansen <peter at engcorp.com> wrote in message news:<v82dnbiwouf3L-PcRVn-1Q at powergate.ca>...
> Carl wrote:
> > Using COM and ADO on Win32, it is very easy to access databases (eg MySql,
> > MS SQL Server, etc) from Python.
> > 
> > Does anybody know if it is possible to access databases from Zope (which is
> > written in Python) using COM and ADO? 
> 
> Do you mean "Does Zope have built-in support for this?"
> or "Does such a facility already exist for Zope?" or something else?
> 
> Because if, as you note, Zope is written in Python, then it
> should be reasonably obvious that you can write a Zope
> extensions/script/product which will do exactly what you need,
> if one doesn't already exist.
> 
> By the way, Python has a "DB API", which pair of acronyms may help
> direct your web searches for a solution...
> 
> -Peter

As Peter said, Python has a database API specification.  The idea is
to encourage the similarity between python modules that are used to
access databases.  The DB API uses a different interface than ADO on
Win32, but you could choose to access databases in that way as well
using Python if you desired to do so.

For more information on the DB API, check out
http://www.python.org/topics/database/.  Here you will find not only
the specification, but also the different modules which implement it. 
If would like to buy a book on the subject, I recommend Steve Holden's
Python Web Programming, as it has a great introduction on the DB API.

Now, concerning Zope...  Zope has quite a few 'products' that can
access relational databases directly.  Although, since Zope has an
object database built in, there is often no need for a Zope
application to access a relational database.

Anyways, to get back to answering your question, Zope can be used to
access relational databases using Zope products.  Whether or not there
are any products using COM and ADO for this database access, I do not
know.  If you would like to find out, go to http://zope.org/ and
search 'Zope Products' for what you're looking for.

Last, but not least... If there are no suitable products in Zope for
your needs, you can certainly write your own Zope product that access
database using COM and ADO.

Regards,

Michael Loritsch