Re: Archtypes SQL Storage

On Tue, Oct 10, 2006 at 05:31:49PM +0200, Dennis Schulz wrote:
| Hello List,
| 
| I looked at the SQLStorage package that is part of Archtypes, but found out that Archetypes objects stored through SQLStorage still have a presence in the ZODB, which means it's not a solution if you totally want to get rid of Data.fs bloat. (It is also the policy and requirement in our company to have everything in outsourced in the MySQLDB and I can't change this)
| 
| I am looking for a way of using the Archetype Content Object only as the View (presentation layer) for easy rendering of the forms and mapping them directly to a relational database without any interference of the ZODB.
| 
| Is it possible to modify an Archetype that it looks up the content items completly in the relational database and not first in the zope DB (that maps to the rel. database like in SQLStorage)?
| I don't see a reason why one should store the same object 2 times in the ZODB and MySQL.
| 
| Any help and hint will be appreciated, Thank you very much!

It should be possible yes. The problem is that no-one did it before so
the effort to get it to work is unknown. With enough time it is
certainly doable.

-- 
Sidnei da Silva
Enfold Systems                http://enfoldsystems.com
Fax +1 832 201 8856     Office +1 713 942 2377 Ext 214

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV