Re: Use PSQLFS for photo storage

bytea was what I was going for.

Does anyone have a script they would share for this purpose?

If not I will probably use Java because this is what I am familiar with.

The web app I will write for managing my photos will be written in Java.  I want to be able to categorize, label, search,.... my photos.

Alan Hodgson wrote:

On Tuesday 13 January 2009, Jason Long <mailing.list@supernovasoftware.com> 
wrote: 

I would like to use PSQLFS(http://www.edlsystems.com/psqlfs/)
to store 100 GB of images in PostgreSQL.

Once they are in there I can deal with them.  My main purpose is to use
rsync to get the files into the database.

Is there a better way to load 20,000 plus files reliably into Postgres?   

A perl script using either bytea fields or the lo_ interface via DBD::Pg 
would work well.