<br><br><div class="gmail_quote">On Sat, May 24, 2008 at 11:28 AM, Andreas Jung <<a href="mailto:lists@zopyx.com">lists@zopyx.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d"><br>
<br>
--On 24. Mai 2008 10:47:54 +0200 Jürgen kartnaller <<a href="mailto:juergen.kartnaller@gmail.com" target="_blank">juergen.kartnaller@gmail.com</a>> wrote:<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
There seems to be some interest on the use of SQL databases with Zope.<br>
<br>
Lovelysystems is now using SQL databases as the primary storage for their<br>
applications. We use Zope and Postgres with Storm as ORM.<br>
The main reason for switching to SQL database were speed issues with<br>
queries.<br>
<br>
</blockquote>
<br></div>
Thanks for this interesting mail.<br>
<br>
Some questions:<br>
<br>
- how to you deal with binary large objects?</blockquote><div><br>z3c.extfile<br> <br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
<br>
- how do you deal with changes in the data model and<br>
related migrations?</blockquote><div><br>Our SQL-Scripts contain alter-table to update existing tables.<br> <br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
<br>
- how do you deal with hierarchical or semi-structured data<br>
(e.g. SGML, XML)?</blockquote><div><br>We have no use case for this right now.<br> <br></div><br>Jürgen</div>