Re: storing comment in the database

On Fri, Sep 05, 2014 at 11:25:41AM -0600, Stuart McGraw wrote:
> 
> The problem is that Roundup stores issue comments in files rather
> than in the database.  Quite a bit of past experience here has
> convinced many that sooner or later they will become separated.
> (I have some archives of an older app's database but attachments
> saved as files are nowhere to be found. :-(.
> 
> 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.
> 
> In my case I would be happy with something more hackish than
> a production-quality modification that could be included in 
> Roundup's distribution -- perhaps replacing the code in 
> blobfiles.py with code that would save to the database instead
> of files -- and would be willing to undertake the maintenance
> burden of merging my local changes with new Roundup versions 
> -- provided I could accomplish what I want without too extensive
> hacking.

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.

Ralf

-- 
Dr. Ralf Schlatterbeck                  Tel:   +43/2243/26465-16
Open Source Consulting                  www:   http://www.runtux.com
Reichergasse 131, A-3411 Weidling       email: [email protected]
allmenda.com member                     email: [email protected]

------------------------------------------------------------------------------
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/