[Zope] Classes & Objects Vs Relational Databases

[Joachim Werner]

I'd suggest our new DBObjects. They implement REAL classes, that are stored
in a relational database - PostgreSQL, as MySQL
is not too well-suited for transactions etc. But DBObjects are not for
starters yet. Be prepared for reading the code and stuff like that.

Currently, DBObjects just stores a very small footprint in the ZODB to make
sure the objects can use all the Zope security etc. The data is stored in
the SQL DB,
so you can just use SQL for queries. The basic queries are auto-generated,
like INSERTs or DELETEs, ...

Joachim.

> i'd like to know whether it is best to use classes or relational databases
> for a (medium ?) sized project involving about 1000 new documents a month
> (average interconnection between them) and about 2 years of backlogs (each
> doc being about 1500 signs).
>
> i would love to do it entirely in zope (classes + methods + dtml) but i'm
> not sure wheter this is a good idea or if i can make everything i'm used
to
> like in a relational database.
>
> to make it more clear, i'll make an example. let's say i am dealing with
> news-like sutff i have the following tree :
>
> news
> news/sport
> news/sport/20010406_0236
> news/sport/20010406_0345
> news/sport/XXXXXXXXXXXXX (being yyyymmdd_hhmm)
> news/art
> news/art/20010406_0236
> news/art/20010406_0345
> news/art/XXXXXXXXXXXXX (being yyyymmdd_hhmm too)
>
> i'm using classe for these yyyymmdd_hhmm objects and i'd like to sort them
> according to date or author both in separate folders (newest items in
> sports) or to pick them from both (5 most recent items from both folders
for
> example).
>
> how do i do that in dtml ? (i'd prefer doing it in dtml than in python
> because people who will be in charge afterwards will have less trouble
> managing it).
>
> <dtml-in xxx sort="date"> would do the trick inside a folder, but how do i
> do it in both folders ????
>
> furthermore, is it a good idea to keep this in the zodb or is it best to
put
> it in another outside database (mysql most probably) ?
>
> thx,
>
> $ven
>
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
>
>