At 10:15 AM 8/30/2006, Mark Stosberg wrote:
Cees Hek wrote: > On 8/22/06, Rob Kinyon <[EMAIL PROTECTED]> wrote: >> On 8/18/06, Robert Hicks <[EMAIL PROTECTED]> wrote: >> > Sam Tregar wrote: >> > > On Thu, 17 Aug 2006, Mark Stosberg wrote: >> > > >> > >> - Storing photos in PostgreSQL for easy deployment on load-balanced >> > >> web servers. (So far, that's worked surprising well) >> > > >> > > That is surprising! Why would you do that instead of using NFS? >> > > >> > >> > I am curious about that as well... >> >> I've never understood this fascination with storing files instead of a >> DB instead of storing filenames and keeping the actual files on a NFS >> or NAS. It just seems so ... wasteful. > > I have never done it myself either, but there are pros and cons to > every solution. I can see the benefits of keeping files in the DB, > since it keeps all of your data in one location (and uploaded image > files are really just data to your applicaton). It makes backing up > the data easier, and it makes redundancy easier by just replicating > your database.
Another use is for webapps where the same data, pictures, and in our case templates, are used on a number of sites. Putting the HTML in the database allows us to use it for any number of domains in the datacentre and to also allow easy access using SOAP form remote machines.
John
We have used the NFS route in the past with great success, and suggested it as an option in this project as well. Our opinion was not be the only factor in coming to the decision. We evaluated the files-in-DB solution and found it provides "good enough" performance while meeting the other needs of the application. I like that files can now be easily considered as part of transactions, but I certainly see the benefits of NFS, too. I would consider both approaches in the future, depending on the project requirements. Mark --------------------------------------------------------------------- Web Archive: http://www.mail-archive.com/[email protected]/ http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2 To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- Web Archive: http://www.mail-archive.com/[email protected]/ http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2 To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
