Re: bytea and text - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject Re: bytea and text
Date
Msg-id 4B121AEC.2010508@gmail.com
Whole thread Raw
In response to Re: bytea and text  (Didier Gasser-Morlay <didiergm@gmail.com>)
List pgsql-novice
Didier Gasser-Morlay a écrit :
> 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;

this is not a blog, but pictures aren't updated

>   - 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.

hmmmm, just a one shot backup for "just users".

I'm not going to feed this troll, this is MY choice.

--
Being stoned on marijuana isn't very different from being stoned on gin.
        -- Ralph Nader

pgsql-novice by date:

Previous
From: Didier Gasser-Morlay
Date:
Subject: Re: bytea and text
Next
From: Didier Gasser-Morlay
Date:
Subject: Re: bytea and text