Consider cache "table"

[Elrond]

Currently, computed (processed) data is stored alongside "original"
data in the database. Most notable example are comments and the
rendered html for them.

There are various reasons for not storing them at the same place:


-  If the options for processing (the created html) changes, a
   migration must be added to convert all existent entries. Or if the
   user changes the options, they have to let every entry be updated.
   Think of large installations! With a cache style setup, one simply
   drops the cache and it will be recreated as needed.
-  It's cleaner layout of the db.
-  Also maybe an option for backup: Many people only want the
   "original" stuff in the backup, as everything else can be
   regenerated as needed.

An alternative is to drop the pre-rendered stuff from the db and
create it "on the fly" as needed.
Or cache it in some (beaker?) memory cache.

[Caleb Davis]

+1! This is where tag clouds would go

[Will Kahn-Greene]

The original url for this bug was ​http://bugs.foocorp.net/issues/456 .
Relations:
#183: blocks, #212: blocked

[Christopher Allan Webber]

This is the "longcache" system, right?

Elrond, do you think this still applies post-SQL? Do you imagine we'd just use a json field?

[Christopher Allan Webber]

Note that spaetz has built a tag clouds prototype plugin.

There hasn't been any ticket on this for a while, though I assume there's still interest. Spaetz, I am somewhat curious if you think you could make use of such a thing.

[Christopher Allan Webber]

Having talked about it with spaetz this doesn't look like something that would use longcache, it would use normal caching.

This longcache stuff would be more useful if we had a generic way of reprocessing originals. Since we don't have that, this ticket isn't very useful for now. I'm lowering priority to trivial. Once we have reprocessing stuff figured out we can re-raise the priority.

[Christopher Allan Webber]

No movement has been made on this yet, but for reference, reprocessing may happen in GSoC/OPW; here's a link to the draft ideas doc ​http://wiki.mediagoblin.org/Feature_Ideas/Reprocessing

[Christopher Allan Webber]

Hi! I'm moving this ticket from "assigned" to in_progress per our new workflow. Please update the ticket and let us know if you're still working on this. If you are, super great! If not, we'll remove the claim and move it back to "accepted" in a couple of weeks.

Thanks!

[Christopher Allan Webber]

I'm unclaiming this because I haven't been doing anything on it for some time.