By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,187 Members | 1,630 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,187 IT Pros & Developers. It's quick & easy.

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

P: n/a
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?

Carl

Jul 18 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Jul 18 '05 #2

P: n/a
Peter Hansen <pe***@engcorp.com> wrote in message news:<v8********************@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
Jul 18 '05 #3

P: n/a
Peter Hansen <pe***@engcorp.com> wrote in message news:<v8********************@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
Jul 18 '05 #4

P: n/a
Hi Carl,
Does anybody know if it is possible to access databases from Zope (which is
written in Python) using COM and ADO?

I know there are different DAs for zope; however, I don't know if any of
them uses COM or ADO. You could search/ask on:
http://mail.zope.org/mailman/listinfo/zope-db
which is the official zope list for relational database connectivity.

You could also take a look at:
http://zope.org/Products/external_access
and see if you find some DA that do this.

Regards,
Josef
Jul 18 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.