[Zope] Zope's database capability

[Thomas B. Passin]

[Tom Nixon]

> I am in the process of evaluating Zope and so far it looks great.
>
> I have one question about Zope's database: How does it compare in
> performance to a relational database server? I am think about a scenario
> such as a recruitment site with a large database of jobs and candidates.
> Would the Zope database manage it OK or is it normal to run a database
> server such as mySQL alongside it for the heavy-duty stuff?

Yes, it is feasible and normal to use a relational database with Zope.  Zope
gives you very good support for working with relational databases.  You can
use ODBC or various database-specific database drivers.  Zope will  manage
transactions for you.

> Is it possible to build complex queries on the Zope database?

The Zope database doesn't have an extensive query language comparable to
SQL, and there is no native join-like construction as best I understand
things.

Cheers,
Tom P