Re: Storing many big files in database- should I do it? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Storing many big files in database- should I do it?
Date
Msg-id 201004271932.38494.adrian.klaver@gmail.com
Whole thread Raw
In response to Re: Storing many big files in database- should I do it?  (Anthony <osm@inbox.org>)
Responses Re: Storing many big files in database- should I do it?  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
List pgsql-general
On Tuesday 27 April 2010 5:45:43 pm Anthony wrote:
> On Tue, Apr 27, 2010 at 5:17 AM, Cédric Villemain <
>
> cedric.villemain.debian@gmail.com> wrote:
> > store your files in a filesystem, and keep the path to the file (plus
> > metadata, acl, etc...) in database.
>
> What type of filesystem is good for this?  A filesystem with support for
> storing tens of thousands of files in a single directory, or should one
> play the 41/56/34/41563489.ext game?
>
> Are there any open source systems which handle keeping a filesystem and
> database in sync for this purpose, or is it a wheel that keeps getting
> reinvented?
>
> I know "store your files in a filesystem" is the best long-term solution.
> But it's just so much easier to just throw everything in the database.

In the for what it is worth department check out this Wiki:
http://sourceforge.net/apps/mediawiki/fuse/index.php?title=DatabaseFileSystems

--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Bryan Murphy
Date:
Subject: Re: Postgresql on EC2/EBS in production?
Next
From: Chris Velevitch
Date:
Subject: Is the wiki down?