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-05 04:25:59
Message-ID: 1175747163.410425@jet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Postgres User пишет:
> I recently heard from Josh Berkus that at least one major CMS
> application uses Postgres to store entire HTML pages (including image
> files) in order to support full versioning.
>
> As a general rule, I prefer not to store BLOBS in a DB- I'd rather
> leave the BLOB in the file system and let the db save only a pointer

Yes, current solution uses the similar approach

> to it. However, if you need to store BLOBs in a database, Postgres is
> one of the better platforms for it.
>
Thanks

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-04-05 05:10:19 Re: Problem with oids for table names getting out of sync?
Previous Message Oleg Bartunov 2007-04-05 04:16:40 Re: Using MS Access front-end with PG]