|
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@xxxxxxxxxxxxxxxxxxxxx> 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. |
