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(dot)list(at)supernovasoftware(dot)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.
>
>