[Owncloud] redundant data in oc db

[Bartek Przybylski]

Hi!
Right now we have a FSCache feature which is great, but we can use it
even better to avoid data redundancy.
For instance media app holds mp3 data in DB but its also holds path to
file which is the same as in fscache
at this point data synchronization is needed which cause troubles and
increase amount of resources needed (not drastically but always).
Same thing is with gallery it holds metadata for thumbnail so it can
speedup previews, and also path to file which is redundant.

I would like to propose expand of fscache db by 2 or 3 additional, one
of type text and one of type blob so it can store simple and binary
data.
For instance media app could hold mp3 tags in additional blob,
pictures could hold images metadata there, and ebook app could hold
tags in there too.

That way less data duplication will occur and synchronization problem
will also be avoided.


What do you all think ?

Bartek