[Erp5-dev] Status of ZSQLCatalog

[Jean-Paul Smets]

Hi,

ZSQLCatalog was ported ages ago to be used in CPS, together with
ERP5SyncML and CMFActivity. We could, at that time (2004 ?), demonstrate
    - fast queries in CPS
    - replication of CPS documents

It was working really well but... CPS developers did not really have a
look at it and kept on using ZCatalog.

It is very nice to see that Santi understood how ZSQLCatalog can be
useful. Porting to Plone would be also very easy. I think we stated a
few years ago that we are happy that anyone ports ZSQLCatalog to be used
in other frameworks. We will be happy to incorporate any patches which
do not degrade performance. Any dependency to ERP5 can be removed or 
catched if needed to make ZSQLCatalog friendly to other frameworks.

We also wrote some years ago a document about parts of ERP5 which can be
used in other frameworks to make them as scalable as ERP5 is:
    http://www.erp5.com/kb/enterprise-High.Performance.Zope?format=pdf

FYI, ERP5 and ZSQLCatalog are handling everyday somewhere in a company 
in Europe 100,000 scanned PDF mails, processed by OCR, searchable in 
full text or by SQL queries and accessed by 300 concurrent users. 
Handling 1,000,000 would not be an issue.

Regards,

JPS.


Santi Camps wrote:
>
> On Wed, Jan 20, 2010 at 12:17 PM, Racinet Georges <georges at racinet.fr 
> <mailto:georges at racinet.fr>> wrote:
>
>     Hi there,
>
>     First post on this list, feel free to redirect If this isn't the right
>     place !
>
>     Let me introduce myself : I am currently the main maintainer of CPS,
>     the content management framework developped by Nuxeo on top of Zope 2
>     and CMF prior to their switch to the Java world.
>
>     I've never had the opportunity to really work myself with ZSQLCatalog,
>     although I've seen a few in the wild being used as a ZCatalog
>     replacement in CPS installations, but today might be interested with
>     that option.
>     Depending on the environment and actual usage,  such a solution can be
>     more effective and/or manageable than the Lucene based ZCatalog
>     replacement we have (NXLucene server and CPSLuceneCatalog).
>
>     Now the questions :
>
>        - is ZSQLCatalog considered an active project ? There are recent
>     changesets in svn, but that doesn't really look like active
>     development.
>        - what is the transactional behaviour ? Am I right to think it's
>     simply not part of the overall transaction ? Any plans to leverage
>     something like z3c.sqlalchemy (provides two-phase commit out of the
>     box) ?
>        - what are the currently supported Zope versions ? For the record,
>     right now, CPS runs on Zope 2.9.x (x >= 7)
>
>     Needless to say, if we were to make ZSQLAlchemy a standard option in
>     CPS, we would be glad to contribute.
>
>     Thanks for your attention
>     --
>     Georges Racinet, http://www.racinet.fr
>     Zope/CPS/Plone expertise, assistance & development
>     GPG: 0x4862FFF7
>
>
>
> Hi Georges
>
> 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
>
> You can obtain it using subversion at 
> https://svn.forge.osor.eu/svn/kmkey/vendors/ZSQLCatalog/branches/kmkey
>  
> 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
>
> svn co 
> https://svn.forge.osor.eu/svn/kmkey/vendors/CPSSchemas/branches/kmkey
>
> All this works within the overall transaction, the only problem is 
> that the Undo feature is broken
>
> If you find something interesting, it will be a pleasure to see some 
> of this features back to CPS
>
> Best regards
> -- 
> Santi Camps
> KMKey hacker (http://www.kmkey.com)
> Earcon S.L. (http://www.earcon.com)
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Erp5-dev mailing list
> Erp5-dev at erp5.org
> http://mail.nexedi.com/mailman/listinfo/erp5-dev
>   


-- 
Jean-Paul Smets-Solanes, Nexedi CEO - Tel. +33(0)6 29 02 44 25
ERP5 Enterprise: Open Source ERP/CRM for Mission Critical Applications
http://www.erp5.com
TioLive SaaS: run your business online, with more freedom
http://www.tiolive.com
Nexedi: Consulting and Development of Free / Open Source Software
http://www.nexedi.com