David,<br> Good point! I found same problem with ZAlchmey, and SQLOs<br> could you please share your RBDMS package and procedures with me? maybe we can establish a new open source project <br> to develop it.<br> thanks.
<br><br><div><span class="gmail_quote">On 3/3/07, <b class="gmail_sendername">David Johnson</b> <<a href="mailto:djohnson@jsatech.com">djohnson@jsatech.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
> 1. Is Zope3 already in use in productive environments? Where are<br>> they (URLs)?<br>We are using Zope 3 pretty heavily in a productive environment, but<br>unfortunately the URLs are secure at this point. We build financial
<br>applications and we are building more. Our live RDBMS application is<br>an administrative tool that queries 4 different financial databases.<br><br>> 2. Are there any bigger sites running on Zope3 (> 5 mio. accesses
<br>> per month)?<br>We expect to have loads much greater than this when we are completed,<br>but we do not have any in production.<br><br>><br>> 3. Our main problem is: in our Zope2-application we stored our<br>
> content in a<br>> RDBMS, we avoided ZODB for that stuff. We are definitely going to<br>> use an RDBMS<br>> (PostgreSQL/MySQL) for the new (Zope3 or Django)-project and still<br>> want to avoid<br>> ZODB where possible. This architectural decision is carved out of
<br>> stone.<br>><br>> Now, where should we start with it in Zope3 to connect it to an RDBMS?<br>We do mostly SQL/RDBMS. We have tried ZAlchmey, and SQLOs, but we<br>find them both a bit limiting and simultaneous complex to get them to
<br>work they way we wanted. In general when one develops and RDBMS<br>application of any size, the database structure can get very<br>complex. In order to integrate them into Zope 3 just right, it's<br>best to manually code the containers and objects. We have been able
<br>to simplify the process quite a bit and we are very happy with it.<br>It's amazing scalable. If you do decide to go this way, I would be<br>glad to share our RBDMS package and procedures. We've developed some
<br>guidelines to improve development. We use MySQL exclusively.<br><br>><br>> 3.1 We have found 'PostGreSQL Database Adapter' and 'MySQL Database<br>> Adapter'. Both are from the Isar sprint (2004-11-06). Are they out
<br>> of date,<br>> or just 'nearly perfect'? Is anybody using these adapters?<br>><br>We use the MySQL adapter. Zope 3 has a bug in the database adapters<br>that requires having to use global utilities (etc/overrides.zcml). It
<br>is otherwise stable. In otherwords you cannot currently add and use<br>database adapters in Zope 3 through the ZMI but can through<br>overrides.zcml.<br><br>> 3.2 sqlos - SQLObject Support package (<a href="http://codespeak.net/z3/">
http://codespeak.net/z3/</a><br>> sqlos/):<br>> Is it stable? Has someone experiences with it?<br>> In <a href="http://mail.zope.org/pipermail/zope3-users/2006-January/001797.html">http://mail.zope.org/pipermail/zope3-users/2006-January/001797.html
</a><br>> Stephan Richter says: "On the other hand, not many people use<br>> sqlos, so<br>> it might not be as supported as you wish it would be." Is that<br>> still right?<br>><br>> 3.3 Also there is 'zsqlmap: Zope3 wrapper for SQLObject'
<br>> (<a href="http://www.zope.org/Members/garanin/zsqlmap">http://www.zope.org/Members/garanin/zsqlmap</a>). This is not really a<br>> solution for us because the version number is 0.01b and the author<br>> says:
<br>> 'NOTE: i tested only postgres.' Not really a capable product...<br>I find it easier to hand code than use the third party packages. We<br>have created our own classes that we find a bit more simple and<br>
versatile. I suppose this is a preference thing.<br><br><br>> 4. Has anybody practical experience and hints with Zope3 and RDBMS?<br>><br>> 5. The ZMI: In Zope2 we never used it.<br>> Do we need the ZMI in Zope 3 just if we will not use the ZODB for
<br>> storing our<br>> content objects but an RDBMS instead. According to 'Web Component<br>> Development<br>> with Zope 3' by Philipp von Weiterhausen the ZMI is used to manage<br>> content objects
<br>> stored in the ZODB, so our assumption is, if we do not store them<br>> in the ZODB,<br>> we do not need the ZMI. Is that right or do we need the ZMI for<br>> anything else?<br>> Do we need ZMI in Zope3 for administration or can we do that with
<br>> scripts etc.?<br>The ZMI is everything in regards to management. The new approach is<br>to skin the ZMI to match your own design scheme. The staff who uses<br>our old management applications in UNIX and PHP loves the new Zope 3
<br>stuff we've done. It's so simple that we plan on extending some of<br>the administrative functionality to our clients.<br><br>><br>> 6. Last but not least two quotes from the zope3-dev mailinglist<br>> (
<a href="http://mail.zope.org/pipermail/zope3-dev/2006-February/018217.html">http://mail.zope.org/pipermail/zope3-dev/2006-February/018217.html</a>):<br>>> >Shane Hathaway wrote:<br>>>> >> It could
<br>>>> >> turn out that people who don't want ZODB really shouldn't use<br>>>> Zope at<br>>>> >> all.<br>>> >This has been the case in my experience...<br>>> >Chris Withers
<br>I disagree completely. We use SQL although I do wish that SQL<br>integration was stronger. The structure of Zope is excellent for<br>scalability. You'll pay up front a little, but the simplicity and<br>versatility is really great. We've basically only found 2 platforms
<br>that scaled well, J2EE and Zope 3. Zope 3 is vastly better in nearly<br>every way in my opinion, except perhaps documentation. The<br>documentation is very weak, but it is a young platform. The content<br>view model of Zope 3 and the clean API's is wonderful. The platform
<br>as a whole allows us to develop clean stable scalable code.<br><br>--<br>David<br><br><br><br><br>_______________________________________________<br>Zope3-users mailing list<br><a href="mailto:Zope3-users@zope.org">Zope3-users@zope.org
</a><br><a href="http://mail.zope.org/mailman/listinfo/zope3-users">http://mail.zope.org/mailman/listinfo/zope3-users</a><br></blockquote></div><br><br clear="all"><br>-- <br>cheers<br>best regards