For this use case contentmirror is almost certainly what you need. It is a one way mirroring of in zodb plone content into an rdbms structure. Any changes made directly to the database will not be reflected back in Plone.
Taking the opposite approach is collective.tin, which is designed to bring arbitrary rdbms structures into the plone content space. There is support for updating plone's catalog (which drives much of the gui) when another application writes to the database. There is no support for building ad hoc content trees, being designed for an intranet workflow project rather than content management. I've not yet made a release of collective.tin (it sits in the plone collective svn repo), and it needs much more documentation. I don't have a current customer requirement for it so development has slowed a lot. alchemist offers similar functionality, though is not tied so closely with Plone, also working in a pure zope 3 context. I had trouble understanding it and ended up writing collective.tin for my project, which is not to say collective.tin is necessarily easier to understand for anyone else... I don't know enough about z3c.sqlalchemy to comment on it. Laurence Michael Bayer wrote: > hi list - > > for once, I have a question for you. I am examining the usage of > Plone for a project that would like to use a pre-existing CMS > solution. I'm interested in Plone being integrated with a relational > database such that the "website" side of the project can be built > using Pylons, or any relational-enabled framework, without the need to > interface with ZODB or plone directly. Reasons for this include that > the vast consensus on Plone seems to be that its slow under load, and > I also can build a pylons site on top of an RDBMS much more quickly > and easily than trying to work around ZODB and various zope > methodologies which I'm generally not familiar with. > > So the most interesting extension I've found is contentmirror > http://code.google.com/p/contentmirror/ > . I also noticed alchemist at http://plone.org/products/alchemist > but its not clear to me if this is not just a previous version of the > same thing. There's also z3c.sqlalchemy > http://pypi.python.org/pypi/z3c.sqlalchemy/ > , but from my "I haven't downloaded anything yet" perspective it > doesn't seem like this is as closely tailored to Plone...i.e. > contentmirror looks more like an easy "offramp" from a plain vanilla > plone system, so you can spend most of your time on the RDB side. > > Since I know the authors of these systems hang around on the SQLA > list, what do I need to know about using SQLAlchemy with Plone ? Is > there some other methodology or CMS i should be looking at ? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
