that depends on your needs and requirements. zope support all known databases like mysql, postgres and oracle with the corresponding database adapters. -aj -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org] On Behalf Of Ronald Mangaliag Sent: Mittwoch, 18. September 2002 10:07 To: zope@zope.org Subject: [Zope] database in zope according to the documentation, gadfly is not really there for implementation purposes but for learning or sample only... my question is.... what do you think is the best database for zope??? i just downloaded firebird... is it good, atleast for zope??? how about mysql??? i'm using a win2k box so i guess postgresql is not a good choice for windows... please advice... thanks... ------------------------------------------------ E-mail service provided by SLUNET Saint Louis University ( http://www.slu.edu.ph ) ------------------------------------------------ _______________________________________________ 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 )

Ronald Mangaliag wrote:

according to the documentation, gadfly is not really there for implementation purposes but for learning or sample only...

What's wrong with ZODB, which is what Zope is built on? cheers, Chris

my question is.... what do you think is the best database for zope???

Well ZODB works very well fopr certain types of problem. If you mean relational database, I've had good success with both MySQL and SQL Server 7 on Windows. I have one app based on SQL Server which returns multi-thousand row recordsets to Zope and caches them and it works fine - it's extremely reliable. Depends on your requirements and budget really - do you need to be able to use stored procs, triggers, blah blah, or are you just looking to store a bit of data in tabular form. PostgreSQL, AFAIK, only runs on Windows under the Cygwin environment so it'd probably be a bit more fiddly to deal with. Julian.