From: | Jason Long <mailing(dot)list(at)supernovasoftware(dot)com> |
---|---|
To: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Use PSQLFS for photo storage |
Date: | 2009-01-13 19:40:40 |
Message-ID: | 496CEE38.60604@supernovasoftware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Atkins | 2009-01-13 20:41:44 | Re: Use PSQLFS for photo storage |
Previous Message | Alan Hodgson | 2009-01-13 19:32:27 | Re: Use PSQLFS for photo storage |