On Sat, May 24, 2008 at 11:28 AM, Andreas Jung <lists@zopyx.com> wrote:

--On 24. Mai 2008 10:47:54 +0200 Jürgen kartnaller < juergen.kartnaller@gmail.com> wrote:

There seems to be some interest on the use of SQL databases with Zope.

...

Lovelysystems is now using SQL databases as the primary storage for their applications. We use Zope and Postgres with Storm as ORM. The main reason for switching to SQL database were speed issues with queries.

Thanks for this interesting mail.

Some questions:

- how to you deal with binary large objects?

z3c.extfile

- how do you deal with changes in the data model and related migrations?

Our SQL-Scripts contain alter-table to update existing tables.

- how do you deal with hierarchical or semi-structured data (e.g. SGML, XML)?

We have no use case for this right now. Jürgen