aC forum: Question on the file uploads http://www.activecollab.com/forums/topic/1797/ Recent posts on topic: Question on the file uploads en-us Sat, 19 Jul 2008 02:05:26 CDT http://www.activecollab.com/forums/post/10327/#post10327 http://www.activecollab.com/forums/post/10327/#post10327 Post #3 by clegallic clegallic Hi,

Did you have any anwser to this question ?

I also wish to know if it's possible to store files into a Linux FS instead of storing them into the database. Without any additional coding, of course ;)

Regards,

Charles

]]> Tue, 23 Oct 2007 05:08:46 CDT http://www.activecollab.com/forums/post/8366/#post8366 http://www.activecollab.com/forums/post/8366/#post8366 Post #2 by sbongoni sbongoni Also, I may be able to contribute in the development during my free time, either in fixing any issues and/or implementing any features.

]]> Mon, 06 Aug 2007 14:04:28 CDT http://www.activecollab.com/forums/post/8365/#post8365 http://www.activecollab.com/forums/post/8365/#post8365 Post #1 by sbongoni sbongoni If a file is upload on activeCollab, is the file added to the mySQL database, or just stored on the OS file system. If it is stored on OS file system (Linux system, in my case, as a regular file), how does it handle 2 uploads with the same file name? Thanks!


While the general data (messages/tasks/milestone/people/client info) could and should go to mySQL db, I think the uploaded files should NOT be stored in the database, for following reasons:

1. Database could possibly mess with file format, like zip,pdf, xl, .doc etc

2. The attached files could be really huge few running into MBs. And the DB may not efficiently handle such big entries in single rows.



On the flip side, using file storage for ONLY attachments is better way, if the following things is handled better way ….

1.Probably seperate folders are created for each new file upload, and each such folder is uniquely named so that two files uploads with the same filename do not clash/corrupt each other (in placed in single folder)

2.The activeCollab application somehow intelligently links an uploaded file in the OS file system to map to a particular message/task/milestone/etc … and create appropriate links … so that all this background stuff is transparent to the end-user.


Thanks in advance for any response on this.
Srinivas

]]> Mon, 06 Aug 2007 14:03:24 CDT