Mailing List Archive

On 2006-02-24 at 18:31:19 [+0100], Sanjay Arora <sanjay.k.arora@gmail.com>
wrote:
> We are considering Plone for CMS/Workflow app. However, some of the data
> from Zodb would need to be replicated into the existing postgreSQL CRM/SCM
> system, using triggers or something similar. What would be required to do
> the job?

You can use APE to configure where data which is normally stored in the
ZODB is stored. As for workflow there are a number of Products which you
can use such as CMF Workflow.

Charlie
--
Charlie Clark
eGenix.com

Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ... http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
________________________________________________________________________
2005-10-17: Released mxODBC.Zope.DA 1.0.9 http://zope.egenix.com/

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Charlie Clark wrote:
>
> You can use APE to configure where data which is normally stored in the
> ZODB is stored.

APE is dead, Shane said so himself...

Chris

--
Simplistix - Content Management, Zope & Python Consulting
- http://www.simplistix.co.uk
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

(make sure you CC in the mailing list when you reply...)

Sanjay Arora wrote:
> All I want is to zodb to trigger a script for every
> change/addition/deletion, that should update the postgreSQL
> database....or maybe even get zodb to use postgreSQL as object data
> store, after serialization of course.

Sounds like you might be after Shane's new product...

> I do intend to use Zope, which again uses CMF/zodb but don't really

Urm, CMF -> Zope -> ZODB is the correct chain of dependency...

> know how to integrate my data-replication from zodb to postgreSQL.

Why replicate? Why not just use an ORM like SQLOS?

cheers,

Chris

--
Simplistix - Content Management, Zope & Python Consulting
- http://www.simplistix.co.uk

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db