Re: Use PSQLFS for photo storage

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.

--
Alan