Re: Archtypes SQL Storage

Dennis Schulz wrote:
>> 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.
> 
> I also think it is doable, but I am relativly new to plone and
> unfortunately don't have the time now ;-)
> 
> But I am wondering how the other companies manage their long time and
> shard data storage. I think it is not a problem from out of space. It
> is quite a common and trivial szenario for a company to have long
> time stored data outsourced in a RDBMS and yet having the desire to
> get everything beautifully mangaged by an (maybe content type like)
> object, something similar to a EJB in J2EE, that offers automatic
> form generation.

Look out for the Relational Alchemist product. In general, though, 
anything that will "magically" consume your database with no 
development/configuration involved at all will likely be too simplistic 
to be very useful.

I'd encourage you to look at Flay as well, though, which promises some 
out-of-the-box solution.

Most people would store content in the ZODB (RDBMS' are not very good at 
semi-structured content) and write whatever integration code they'd need.

If you can handle SQL and HTML and a bit of learning (not too much) 
looking at ZSQL methods + Zope Page Templates (see Zope book on 
plope.org) would get you a long way I think.

> Or are all of you using the ZODB for long time and application shared
> storage and dont feel the need to outsource at all?
> 
> Well, I am quite new to Plone and I feel there is something
> missing... but I don't know. Just can't believe that there is no
> product out there that supports this.

It's a fairly tall order to expect some product to understand your 
organisation-specific database just-like-that, but the solutions 
recommended above deserve a closer look. They may get you close enough 
or even do exactly what you need.

Martin


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642