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
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
pgsql-novice by date
|Next:||From: Jean-Yves F. Barbier||Date: 2009-11-29 06:55:40|
|Subject: Re: bytea and text|
|Previous:||From: Tom Lane||Date: 2009-11-29 05:10:12|
|Subject: Re: Problem loading data from Intro to Postgis |