I investigated these last month.
At the high-level there are two options, ORM or Direct SQL.
If you are going down the route of ORM, there are two well supported and
active ORMs, SQLAlchemy and Storm.
If you are going with alchemy, there are several options. I made a few
notes as I was looking at them. For my purposes ore.alchemist and storm
suited best. Here are my notes...
dobbin:
- Works like ZODB
- Creates tables on the fly
- No control over the schema
- built on ore.alchemist
- I failed to get this working. The documentation is not
ZCML friendly. The connection mechanism is undocumented.
It requires that UUID functionality is installed in
postgreSQL.
z3c.sqlalchemy
- intergrates zope.sqlalchemy (see below)
- provides a configuration mechanism
- No integration to interfaces
z3c.zalchemy (abandoned)
- Integration of SQLAlchemy to Zope Transactions
- Integration of interfaces - objects work like zope objects
collective.lead
- See Martin Aspellis book
- Not zope objects (plone - archetypes)
- see zope.sqlalchemy below
zope.sqlalchemy
- attempt to unify the integration of SQLAlchemy to the Zope
transaction management machinery
- Allows sqlalchemy to work in a Zope instance.
- provides NO configuration mechanism
z3c.saconfig
- layer to provide 'scoped session support' on top of
zope.sqlalchemy
- SQLAlchemy session factory is a zope utility
- Note: you cannot connect to the database during the
xmlconfig pass.
<include package="z3c.saconfig" file="meta.zcml" />
<db:engine
url="posgres://name:[EMAIL PROTECTED]/databasename"
echo="True"
/>
<db:session
twophase="True"
/>
ore.alchemist
- of the alchemy ORM approaches, this worked best for me
- simple container based mechanism for mapping a file to the ORM
- 'bind' meta directive controls meta-data lookup after
database connect
Also, if you are going with SQL database only, have a look at lovey.zetup.
This provides a ZODB'less mechanims for building your site.
I hope this helps,
Kevin
> Hi,
>
> I currently have to integrate an SQL database (PostgreSQL, with PostGIS
> extensions) into my Zope3 application.
> I'd like to use SQLAlchemy to handle this, and I've seen that several
> packages are available : z3c.zalchemy, z3c.sqlalchemy,
> zope.sqlalchemy...
>
> So my questions are simple :
> - what package is the best to plug into my Zope (3.3.1) application ?
> - do all these packages handle the same features ??
>
> Thanks for any information,
>
> Thierry Florac
> --
> Chef de projet intranet/internet
> Office National des Forêts - Département Informatique
> 2, Avenue de Saint-Mandé
> 75570 PARIS Cedex 12
> Mél : [EMAIL PROTECTED]
> Tél. : +33 01.40.19.59.64
> Fax. : +33 01.40.19.59.85
>
> _______________________________________________
> Zope3-users mailing list
> Zope3-users@zope.org
> http://mail.zope.org/mailman/listinfo/zope3-users
>
> --
> ** Email Scanned by Elive's Virus Scanning Service -
> http://www.elive.net **
>
>
>
>
>
_______________________________________________
Zope3-users mailing list
Zope3-users@zope.org
http://mail.zope.org/mailman/listinfo/zope3-users
