After having spent some time doing exactly that, I would say it works, its not quite simple but definitely the way to go. For e.g. for my site I used a MySQL db as user source, and not being an expert at either python and DTML it was tought to bring that about, but I simply modified mysqluserfolder for my purposes and it works beutifully. ZMySQLDA also performs nicely although I have observed some speed issues on Win2k, but fortunately they are not that bad. I tried to use Access (came with Office, hence gave a shot) and couldnt get anywhere. Also running Postgresql with cygwin proved to be a real pain. Mebbe if I knew Zope or python better it would have been easier but, given the fact that MySQL now ships with InnoDB the only thing lacking is sub-queries, full foreign key support, row-level locking (am not sure about that, but its in the docs) and trigger support. But all of these probs can be worked around, with a little bit of fancy SQL. I would certainly back MySQL. just my $0.02 AM Day Irmiter wrote:
Having read a bit, I concluded the open source DBMS to use with Zope was mySQL. Easier said than done under win32, I've discovered.
Am I correct in thinking mySQL is the way to go? How about using an ODBC adapter to connect to mySQL? Possible? Advisable?
Thank you.
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
-- ================================================================== Aseem Mohanty Neurobehavioral Systems Inc, 828 San Pablo Ave, Albany, CA 94706 (R) 510 7696011 (M) 510 3014871 (O) 510 5279231 ================================================================== "I saw `cout' being shifted "Hello world" times to the left and stopped right there!!" -- Steve Gonedes ==================================================================