Re: [Zope-dev] Zope and Storm (SQL)

2008-05-25 Thread Andreas Jung
--On 24. Mai 2008 18:51:17 +0200 Brian Sutherland <[EMAIL PROTECTED]> wrote: On Sat, May 24, 2008 at 06:23:01PM +0200, Andreas Jung wrote: --On 24. Mai 2008 17:57:17 +0200 Brian Sutherland <[EMAIL PROTECTED]> wrote: On Sat, May 24, 2008 at 11:28:37AM +0200, Andreas Jung wrote: - how d

Re: [Zope-dev] Zope and Storm (SQL)

2008-05-25 Thread David Pratt
Hi Jurgen. Thank you for keeping this thread going. It is helpful and good to experiment with this further for light applications. I have not given much attention to storage with orm since the early days of sqlalchemy. There have been many improvements since then to the various implementations.

Re: [Zope-dev] Zope and Storm (SQL)

2008-05-24 Thread Jürgen kartnaller
On Sat, May 24, 2008 at 2:24 PM, David Pratt <[EMAIL PROTECTED]> wrote: > Hi Jurgen. Thank you for this informative post. I am particularly > interested in how this fits into the refactoring of legacy code. I > appreciate your sharing your experiences. I also think everyone has been > paying much

Re: [Zope-dev] Zope and Storm (SQL)

2008-05-24 Thread Brian Sutherland
On Sat, May 24, 2008 at 06:23:01PM +0200, Andreas Jung wrote: > > > --On 24. Mai 2008 17:57:17 +0200 Brian Sutherland <[EMAIL PROTECTED]> > wrote: > >> On Sat, May 24, 2008 at 11:28:37AM +0200, Andreas Jung wrote: >>> - how do you deal with hierarchical or semi-structured data >>> (e.g. SGML, XML

Re: [Zope-dev] Zope and Storm (SQL)

2008-05-24 Thread Andreas Jung
--On 24. Mai 2008 17:57:17 +0200 Brian Sutherland <[EMAIL PROTECTED]> wrote: On Sat, May 24, 2008 at 11:28:37AM +0200, Andreas Jung wrote: - how do you deal with hierarchical or semi-structured data (e.g. SGML, XML)? As a side note, PostgreSQL 8.3 has a native XML column type. It's fairl

Re: [Zope-dev] Zope and Storm (SQL)

2008-05-24 Thread Brian Sutherland
On Sat, May 24, 2008 at 11:28:37AM +0200, Andreas Jung wrote: > - how do you deal with hierarchical or semi-structured data > (e.g. SGML, XML)? As a side note, PostgreSQL 8.3 has a native XML column type. It's fairly basic still, but you can create indexes based on xpath queries. I think future

Re: [Zope-dev] Zope and Storm (SQL)

2008-05-24 Thread David Pratt
Hi Jurgen. Thank you for this informative post. I am particularly interested in how this fits into the refactoring of legacy code. I appreciate your sharing your experiences. I also think everyone has been paying much attention to the insight Lovely has been sharing on scaling and efficient del

Re: [Zope-dev] Zope and Storm (SQL)

2008-05-24 Thread Jürgen kartnaller
On Sat, May 24, 2008 at 11:28 AM, Andreas Jung <[EMAIL PROTECTED]> wrote: > > > --On 24. Mai 2008 10:47:54 +0200 Jürgen kartnaller < > [EMAIL PROTECTED]> wrote: > > There seems to be some interest on the use of SQL databases with Zope. >> >> Lovelysystems is now using SQL databases as the primary

Re: [Zope-dev] Zope and Storm (SQL)

2008-05-24 Thread Andreas Jung
--On 24. Mai 2008 10:47:54 +0200 Jürgen kartnaller <[EMAIL PROTECTED]> 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 r

[Zope-dev] Zope and Storm (SQL)

2008-05-24 Thread Jürgen kartnaller
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. Here is a short