<br><div class="gmail_quote">On Wed, Jan 20, 2010 at 12:17 PM, Racinet Georges <span dir="ltr"><<a href="mailto:georges@racinet.fr">georges@racinet.fr</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi there,<br>
<br>
First post on this list, feel free to redirect If this isn't the right<br>
place !<br>
<br>
Let me introduce myself : I am currently the main maintainer of CPS,<br>
the content management framework developped by Nuxeo on top of Zope 2<br>
and CMF prior to their switch to the Java world.<br>
<br>
I've never had the opportunity to really work myself with ZSQLCatalog,<br>
although I've seen a few in the wild being used as a ZCatalog<br>
replacement in CPS installations, but today might be interested with<br>
that option.<br>
Depending on the environment and actual usage, such a solution can be<br>
more effective and/or manageable than the Lucene based ZCatalog<br>
replacement we have (NXLucene server and CPSLuceneCatalog).<br>
<br>
Now the questions :<br>
<br>
- is ZSQLCatalog considered an active project ? There are recent<br>
changesets in svn, but that doesn't really look like active development.<br>
- what is the transactional behaviour ? Am I right to think it's<br>
simply not part of the overall transaction ? Any plans to leverage<br>
something like z3c.sqlalchemy (provides two-phase commit out of the<br>
box) ?<br>
- what are the currently supported Zope versions ? For the record,<br>
right now, CPS runs on Zope 2.9.x (x >= 7)<br>
<br>
Needless to say, if we were to make ZSQLAlchemy a standard option in<br>
CPS, we would be glad to contribute.<br>
<br>
Thanks for your attention<br>
--<br>
Georges Racinet, <a href="http://www.racinet.fr" target="_blank">http://www.racinet.fr</a><br>
Zope/CPS/Plone expertise, assistance & development<br>
GPG: 0x4862FFF7<br>
<br>
<br></blockquote><div><br>Hi Georges<br><br>I'm the main developer of KMKey (based on CPS 3). We have had similar ideas, I think. We already have a version of ZSQLCatalog adapted to work with Zope 2.9.4, and using postgresql instead of mysql. It needs some more fixes, but is still working in testing environments<br>
<br>You can obtain it using subversion at <a href="https://svn.forge.osor.eu/svn/kmkey/vendors/ZSQLCatalog/branches/kmkey">https://svn.forge.osor.eu/svn/kmkey/vendors/ZSQLCatalog/branches/kmkey</a><br> <br>We also have a branch of CPSSchemas that writes to / reads from postgresql tables data of portal_schemas market with an specific SQL attribute. This is working in production environments and we are planning to write adapters for other databases <br>
<br><span class="gI"><span class="gD" style="color: rgb(0, 104, 28);">svn co <a href="https://svn.forge.osor.eu/svn/kmkey/vendors/CPSSchemas/branches/kmkey">https://svn.forge.osor.eu/svn/kmkey/vendors/CPSSchemas/branches/kmkey</a></span><span class="go"></span></span><br>
<br>All this works within the overall transaction, the only problem is that the Undo feature is broken<br><br>If you find something interesting, it will be a pleasure to see some of this features back to CPS<br>
<br>Best regards<br></div></div>-- <br>Santi Camps <br>KMKey hacker (<a href="http://www.kmkey.com">http://www.kmkey.com</a>)<br>Earcon S.L. (<a href="http://www.earcon.com">http://www.earcon.com</a>)<br><br><br>