[Seaside] Database

[Alain Fischer]

Hi Adrian,

Squeak seem to have a lot of success in Bern.

On the persistance side, I was able to use Tantalus with postgreSQL=20
through ODBC
on Mac OS X. I have the project change set with all the modification if=20=

it could help
you, but I think you must fish for what you are interested in because,=20=

it has also
modification even for glorp. I think the code explorer is a good tool=20
for this.

Your team project management tool seem interesting.

Hope I see you in a nexter SqueakNic.
Alain


Le Vendredi 6 d=E9cembre 2002, =E0 10:11 , Adrian Lienhard a =E9crit :

> Hi all
>
> What kind of databases do you use for your Seaside applications?
>
> The first question for me is if to use a Relational DB or a Object DB.=20=

> Most
> of the time I don't have much data to store. But I would also want to =
be
> prepared  for a project with much data and fulltext search queries.=20
> What's
> quite important is reliability. What would also be nice is if I could=20=

> access
> the database from over ODBC (so it would be a RDB). Furthermore it=20
> should be
> accessible over the network. If a RDB then prferably Postgres
>
> What I found to be interesting (anything missing?)...
>
> O/R-Mappings:
> -----------------
> Tantalus=20
> (http://www.whistler.com/aboutus/index.php?inc=3DtantalusDocs.inc)
> maturity (from SqueakMap): "Useable by daredevils. Probably still full=20=

> of
> bugs." So maybe not the the choice for productive apps(?)
>
> GLORP port
> maturity: "Useable but still not stable, probably has bugs."
> same as above
>
> Object DB
> -------------
> MinneStore (http://minnestore.sourceforge.net)
> maturity: "Useable by all. Bugs are rare."
> So, this seams to be interesting. Search queries..
>
> Magma
> http://minnow.cc.gatech.edu/squeak/2665
> probably not tested in productive environments..(?)
>
> Other
> --------
> - Berkeley DB (http://www.sleepycat.com/). Plugin for Squeak:
> http://spair.swiki.net/27 from Stephen Pair
> The DB may be very good in some areas (according to the webpage..). =
But=20
> eg.
> for doing a fulltext search it's quite useless because all data would=20=

> have
> to be loaded into the client application... And second, it can't be =
used
> over the network.
>
> So, I really don't know... I think to tend to Postgres and try to use
> Tantalus. On the other hand it would be probably more comfortable to=20=

> use a
> object database.
>
> What are your experiences?
>
> Thanks
> Adrian
> _____________________
> Adrian Lienhard
> www.adrian-lienhard.ch
> www.netstyle.ch
>
> _______________________________________________
> Seaside mailing list
> Seaside@lists.squeakfoundation.org
> http://lists.squeakfoundation.org/listinfo/seaside
>