<pre><tt><tt>I hope this can help you.<br><br>|Thanks for responding. Well, I choose this list because I thought<br>|(without extensive Zope knowledge) a possible solution would be to use<br>|an external DB, like MySQL for example, on a separate server for all<br>|client data and only use the ZoDB for site/programming related data.<br>|My thought was then that I could point both the production server and<br>|the test server at that DB server. I take it this isn't easy to<br>|achieve ?<br><br>Yes. You can separate client data from ZODB. I uses 2 PC - one PC as production<br>server and the other PC as Development Server and Test Server. Note: 2 server<br>applications on same PC. I uses the Postgresql database on same PC to store my client data.<br>What you need is database adapter to connect Zope to Postgresql.<br><br>|> and you have found the fatal flaw with Zope:<br>|> it is really hard to separate programming/configuration from the site<br>|> data. Those two
things are intertwined in a single binary file, the<br>|> ZODB and things that are easy to do from the admin interface (2 <br>|second<br>|> changes) take a long time to script.<br><br>I use Zope as Application Server: meaning all my application<br>coding are kept in Zope. No client data is store in ZODB other<br>than the required user id. Zope allows you (2.7 or later) multiple<br>instance of Zope on the same PC. I used once instance to run <br>Development Server and a 2nd instance for Test server. Separate<br>zope instance is like having separate zope server. The application<br>code between the two instances are synchronize manually using<br>IMPORT/EXPORT function. Hence, separate team can test the<br>system separate without affecting each other.<br><br>|It was my understanding though that you can use an external DB in<br>|conjunction with the ZoDB, wouldn't it be possible to put my<br>|client-entered data (form responses mostly) on this external DB
?<br><br></tt></tt><tt><tt><tt><tt>Postgresql allows you to create multiple database - developmentDB<br>testDB. So, I can connect development server to development DB<br>and testServer to testDB. However, database synchronizing is<br>performed manually (through backup & restore function) - data<br>is mainly static.<br><br><br>When the application is fully tested, it then exported<br>to Zope Production Server using IMPORT/EXPORT function.</tt></tt></tt></tt> <br><br>CY<br></pre><p>
<hr size=1>Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. <a href="http://us.rd.yahoo.com/mail_us/taglines/postman7/*http://us.rd.yahoo.com/evt=39666/*http://beta.messenger.yahoo.com"> Great rates starting at 1¢/min.