Re: [Webware-discuss] Database ORM's

[Frank B. <fb...@fo...>]

Hallo,
jo...@cy... hat gesagt: // jo...@cy... wrote:

> I've got a non webware, but related question to ask the group.  What
> Object Relational Model software is being used out there.  I've
> recently come the conclusion that we will need to move out database
> layer to some type of ORM system, especially since we are in the
> process of moving from one database system to a different one, and I
> had I used an ORM in the first place it would have been easy, now we
> will have to redesign much of the website.  I've some looking and there
> are really quite a few out there the ones that I've seen are:
> 
> middlekit (webware)
> sqlobject

I have briefly tried to use Webware long time ago, when there was no
PostgreSQL support, which I needed, as it turned out. I was a bit put
off by the need to specify the model in CSV format. I just coded
directly then.

As soon as SQLObject showed up, I checked it out because it was
invented by Ian Bicking, also Webware developer and so I thought to
it would fit into Webware well, too. IMO it does, if you take care to
maybe handle some threading issues, but you need to take care of them
with databases anyway. 

So far I have used SQLObject in two Webware projects. One is small: my
site is running the Teeny Tiny CMS I wrote which is also in the
webware-sandbox. The other is a bigger project, a webshop at
http://www.normalmailorder.de 

It still runs SQLObject 0.5, but does so quite well. For this I also
had to overcome some "limitations" as the database is quite big and I
wanted to do some tuning like using a fulltext index. This required a
bit more thinking and tinkering, like writing custom query methods for
the index I'm using. In the end I was glad to be using SQLObject,
because it made the common things easy while also keeping some hard
things still possible. 

Ciao
-- 
 Frank Barknecht                               _ ______footils.org__
             
             _ __latest track: fqdn _ http://footils.org/cms/show/38