Re: Storing blobs in PG DB

From: Nikolay Moskvichev <mnv(at)papillon(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Storing blobs in PG DB
Date: 2007-04-06 06:46:16
Message-ID: 1175841962.931010@jet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Naz Gassiep пишет:
> This doesn't answer your question, but I thought I'd throw my opinion in
> anyway.
>
> My personal view is that in general, binary files have no place in
> databases. Filesystems are for files, databases are for data. My design
> choice is to store the files in a fileystem and use the database to hold
> metadata as well as a pointer to the file.
>

By the way, not exactly the same case, but just some pros and cons:

http://en.wikibooks.org/wiki/Programming:WebObjects/Web_Applications/Development/Database_vs_Filesystem

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2007-04-06 07:56:33 Re: Storing blobs in PG DB
Previous Message Vladimir Zelinski 2007-04-06 03:19:52 Re: Migrate postgres DB to oracle