I would like to see this discussion continue and get everyone's opinion on this. I have been building a simple Document Library; you can see the demo at http://www.kchost.net/DocLib/. I want to continue the development of this adding more features (Printing, sharing, updating). This system only stores the file info and location in the database but stores the files in a directory for each Library owner. All the files for each Library are stored in the same database but can only be viewed by the users created by the owners.
Rick Eidson -----Original Message----- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 9:27 PM To: CF-Talk Subject: RE: BLOBs and CF > -----Original Message----- > From: Donnie Bachan [mailto:[EMAIL PROTECTED] > Sent: Monday, June 23, 2003 9:33 PM > To: CF-Talk > Subject: OT: BLOBs and CF > > This is a slightly OT question and I know it has been debated before but > we > have a client that is intent on having us store all their files in a DB > and > I can not for the life of me come up with any good reason to do that. So I > would like to ask the community to help me out here: > > What are the Pros and Cons of storing files as BLOBs? And The biggest one to me is the simple fact that all data is maintained in the same place. Back up the DB and you've got everything. Make the DB accessible to a client and they've got everything. Multiple client apps can access all information via the same methods. > What are the Pros and Cons of storing files in the file system with the > names stored in the DB? Well - it can be easier. It does also reduce the stress on the DB server. You can also do a hybrid approach: keep the data in the DB for integrity reasons but also cache the files on the web server file system for speed. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4