Mailing List Archive: Any success with storing photos in a database?

Mailing List Archive: ModPerl: ModPerl
Any success with storing photos in a database?

Index | Next | Previous | View Flat

mark at summersault

Sep 29, 2008, 8:21 PM

Views: 1644
Permalink

Any success with storing photos in a database?

This question isn't so much a mod_perl question, as it is a question
about building high performance websites with Perl.

We have a large, busy, database application that relates to millions of
photos, which we also need to store and display. We've been keeping the
meta data about the photos in PostgreSQL, and the files on the file
system. (Implemented much like CGI::Uploader ).

This has worked great in terms of performance, but with so much data to
manage, over time we have run into data inconsistency issues between the
file system and the database.

So, I'm asking if anyone has had experience successfully storing photos
(or othe files) directly in database? That would solve the consistency
issue, but may create a performance issue. Perhaps the right kind of
caching layer could solve that.

Mark

--
. . . . . . . . . . . . . . . . . . . . . . . . . . .
Mark Stosberg Principal Developer
mark[at]summersault.com Summersault, LLC
765-939-9301 ext 202 database driven websites
. . . . . http://www.summersault.com/ . . . . . . . .

Subject	User	Time
Any success with storing photos in a database?	mark at summersault	Sep 29, 2008, 8:21 PM
Re: Any success with storing photos in a database?	aw at ice-sa	Sep 29, 2008, 1:16 PM
Re: Any success with storing photos in a database?	davidnicol at gmail	Sep 29, 2008, 1:36 PM
Re: Any success with storing photos in a database?	frank at wiles	Sep 29, 2008, 1:52 PM
Re: Any success with storing photos in a database?	himanshu.garg at gmail	Sep 29, 2008, 6:48 PM
Re: Any success with storing photos in a database?	mark at summersault	Sep 30, 2008, 10:20 AM
Re: Any success with storing photos in a database?	geekout at gmail	Sep 29, 2008, 1:42 PM
Re: Any success with storing photos in a database?	frank at wiles	Sep 29, 2008, 1:49 PM
Re: Any success with storing photos in a database?	mark at summersault	Sep 30, 2008, 10:20 AM
Re: Any success with storing photos in a database?	perrin at elem	Sep 29, 2008, 2:04 PM
Re: Any success with storing photos in a database?	cosimo at streppone	Sep 29, 2008, 2:04 PM
Re: Any success with storing photos in a database?	js5 at sanger	Sep 29, 2008, 2:45 PM
Re: Any success with storing photos in a database?	cosimo at streppone	Sep 29, 2008, 2:55 PM
Re: Any success with storing photos in a database?	js5 at sanger	Sep 29, 2008, 3:09 PM
Re: Any success with storing photos in a database?	aw at ice-sa	Sep 29, 2008, 3:07 PM
Re: Any success with storing photos in a database?	cosimo at streppone	Sep 29, 2008, 3:24 PM
Re: Any success with storing photos in a database?	js5 at sanger	Sep 29, 2008, 4:11 PM
Re: Any success with storing photos in a database?	pangj at laposte	Sep 30, 2008, 5:11 AM
Re: Any success with storing photos in a database?	perrin at elem	Sep 30, 2008, 9:40 AM
Re: Any success with storing photos in a database?	mpeters at plusthree	Sep 30, 2008, 6:11 AM
Re: Any success with storing photos in a database?	davidnicol at gmail	Sep 30, 2008, 10:11 AM
Re: Any success with storing photos in a database?	mark at summersault	Sep 30, 2008, 10:20 AM
Re: Any success with storing photos in a database? (prevents double-submits)	mark at summersault	Oct 15, 2008, 10:20 AM
Re: Any success with storing photos in a database? (prevents double-submits)	perrin at elem	Oct 15, 2008, 9:41 AM
Re: Any success with storing photos in a database? (prevents double-submits)	cosimo at streppone	Oct 15, 2008, 11:11 AM
Re: Any success with storing photos in a database? (prevents double-submits)	eric at pieinsky	Oct 15, 2008, 8:45 PM
Re: Any success with storing photos in a database?	jonathan at 2xlp	Nov 24, 2008, 1:40 PM
Re: Any success with storing photos in a database? (prevents double-submits)	mark at summersault	Oct 15, 2008, 12:20 PM
Re: Any success with storing photos in a database? (prevents double-submits)	mpeters at plusthree	Oct 15, 2008, 10:51 AM
Re: Any success with storing photos in a database? (prevents double-submits)	mark at summersault	Oct 15, 2008, 12:20 PM
Re: Any success with storing photos in a database? (prevents double-submits)	mpeters at plusthree	Oct 15, 2008, 12:46 PM
Re: Any success with storing photos in a database? (prevents double-submits)	simon-lists at ldml	Oct 15, 2008, 11:02 AM
Re: Any success with storing photos in a database? (prevents double-submits)	mark at summersault	Oct 15, 2008, 12:20 PM
Re: Any success with storing photos in a database?	perrin at elem	Sep 30, 2008, 10:24 AM

Index | Next | Previous | View Flat

Interested in having your list archived? Contact lists@gossamer-threads.com