Re: bytea and text

Поиск
Список
Период
Сортировка
От Jean-Yves F. Barbier
Тема Re: bytea and text
Дата
Msg-id 4B121AEC.2010508@gmail.com
обсуждение исходный текст
Ответ на Re: bytea and text  (Didier Gasser-Morlay <didiergm@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Didier Gasser-Morlay
Дата:
Сообщение: Re: bytea and text
Следующее
От: Didier Gasser-Morlay
Дата:
Сообщение: Re: bytea and text