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#a11991466 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 _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
