Skip site navigation (1) Skip section navigation (2)

Re: bytea and text

From: Didier Gasser-Morlay <didiergm(at)gmail(dot)com>
To: 12ukwn(at)gmail(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: bytea and text
Date: 2009-11-29 06:50:10
Message-ID: 608b66ce0911282250i1d054e0h4b46f2603affbc17@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
I hope you won't mind if I had my 2 cents to this conversation; aside from
the actual format, this question comes up with regularity on various
database lists.

I have never understood the need for storing images inside a database (and
to some extend blob data) because:
  - being a blog you do not query it just store and retrieve, you rarely
update, so the need for a fancy SQL and DB engine is somewhat limited;

  - storing images is heavy, makes the database grow, thus makes
backup/restore that bit more painful and possibly that bit less stable. ..

For years I designed system for picture libraries where numbers like 10s of
thousands to millions of images are common place, we would never have
contemplated to store images on anything more complex than a file system.
using the database to store a URL to that resource.

Hope this helps

Didier

Responses

pgsql-novice by date

Next:From: Jean-Yves F. BarbierDate: 2009-11-29 06:55:40
Subject: Re: bytea and text
Previous:From: Tom LaneDate: 2009-11-29 05:10:12
Subject: Re: Problem loading data from Intro to Postgis

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group