[Zope] win32 - best DBMS with Zope?

[Aseem Mohanty]

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  
==================================================================