Re: storing comment in the database

Hello Stuart,

Stuart McGraw schrieb am Samstag, den 06.09.2014 um 22:20:
> On 09/06/2014 10:29 AM, Ralf Schlatterbeck wrote:
> > On Fri, Sep 05, 2014 at 11:25:41AM -0600, Stuart McGraw wrote:
> > [...]
> >> Thus I would like to somehow modify Roundup to save comments 
> >> and other attachments in the database.  I have seen comments 
> >> around (on wiki, in code?) that such might be desirable as a
> >> future enhancement.
> > [...]
> > Yes, looking at blobfiles.py and trying to place attachements into the
> > database as blobs (if the database supports this) is probably feasible.
> > Note, however, that mail attachments can get quite large these days and
> > you end up with lots of large files in the DB. On the other hand a good
> > DB will probably handle this fine.
> > 
> > So if you want to do this: patches are welcome. This should be
> > implemented as a configurable option, however, as was already pointed
> > out not everybody want all the files in the database. If you need
> > specific help navigating the code, feel free to ask here on the list.
> 
> Thanks.  I'll play around with the code some and see if it seems 
> like something I could undertake.  Of course I have to learn how
> to *use* Roundup first... :-)

Just to give some more data: As Ralf already pointed out the attachments
are what makes a roundup tracker instance really huge:  In our case the 
comments are also small (256 MB) compared to the attachments (28 GB).

Best regards, Peter Funk
-- 
Peter Funk, home: ✉Oldenburger Str.86, D-27777 Ganderkesee
mobile:+49-179-640-8878 phone:+49-421-20419-0 <http://www.artcom-gmbh.de/>
office: ArtCom GmbH, ✉Haferwende 2, D-28357 Bremen, Germany

------------------------------------------------------------------------------
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/
_______________________________________________
Roundup-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/roundup-users