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#a119... 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