[Zope] should files be stored in RDBs?

[Andreas Jung]

Have you thought about storing the data inside the ZODB?

Andreas
----- Original Message -----
From: "Charlie Fulton" <ccfulton@unity.ncsu.edu>
To: <zope@zope.org>
Sent: Monday, May 20, 2002 14:56
Subject: [Zope] should files be stored in RDBs?


> I'm setting up a database to store data file for a scientific research
> group.  I'm thinking of writing the data into a MySQL table rather than
> storing them externally in the filesystem.  The files are generally small
> but the number of them will grow quickly.
>
> Are there opinions as to whether this is a good or bad idea?
>
> I know there's overhead and a (severe?) throughput penalty, but I was
> thinking this would be simple to manage (and back up) as well as being
easy
> to search.  The load on the server won't be much anyway.
>
> Can collecting binary data in a web form and writing it to MySQL be done
> totally in DTML?  I've found some past threads in the list dealing with
this
> kind of thing (and an old how-to) but there doesn't seem to be a consensus
> on a "right" way to implement it.
>
> Thanks,
> Charlie
>
>
>
> _______________________________________________
> 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 )
>