29 Mar
2008
29 Mar
'08
10:48 p.m.
Hi Squirrel,
Squirrel wrote:
Hi guys,
As I understand from the archive, attachments are stored in the DB itself,
is that correct?
Yeap.
That's not very handy for my personal use. I have
written an automated
backup bash-script, which dumps all DB's from my MySQL-installation into a
backup folder and store it there (a daily folder with the last 7 dumps, a
weekly folder and a monthly) and pushes once a night the backup folder to a
backup-server. Now if every attachment is stored into the DB, the DB will
grow extensively (versioning?, picture album), while with an ordinary
file-store system you just backup files, who have changed or are new....in
my use scenario, attachments are way more stable than the actual content in
the XWiki...
Out of curiosity, what's exactly the benefit to store files in a DB? For the
XWiki, is that the way you go or are you planning to implement a choice?
Well, obviously I am not a XWiki guru, but it seems to me that it was,
and in fact it is, a good idea to have a single access control system.
If you have the whole system in a database, you have not to be concerned
about how to control access to other repositories. And at at the same
time, to have the whole thing in a single database gives, at least to
me, an feeling of full control about what is going on with the contents
I've to manage. Other idea: you easy can index and search the whole
content with a single search engine. And control access to the results!
But, as you says, there are a number of problems with this approach.
I am sure this thread will be useful for you...
http://www.nabble.com/Xwiki-file-and-attachment-storage-td11991466.html#a11…
And as a last minute entry, see this...
http://dev.xwiki.org/xwiki/bin/view/GoogleSummerOfCode/WebDAVApi2008
Hope this helps,
Ricardo
--
Ricardo Rodríguez
Your EPEC Network ICT Team