Re: usage on blobs

Поиск
Список
Период
Сортировка
От Joel Rodrigues
Тема Re: usage on blobs
Дата
Msg-id B9E6E0AA-4AFF-11D7-8372-0005024EF27F@Phreaker.net
обсуждение исходный текст
Ответ на Re: usage on blobs  (Aarni Ruuhimäki <aarni.ruuhimaki@kymi.com>)
Список pgsql-novice
On Friday, February 28, 2003, at 03:09 , Aarni Ruuhimäki wrote:

> Unless you want a HUGE db, consider using link / paths.

Why would (and why should !) this result in a 'HUGE' database ?

I too am just beginning to encounter these issues & came across
similar advice for storing images. To which my answer is that
*if* this is so, that we should store only text in database
tables and we're better off storing binary files in the file
system, then it diminishes (and depending on the application,
defeats) the purpose of using PostgreSQL.

Storing file in the files system could mean a lot of additional,
redundant work.

- Joel

>
> On Thursday 27 February 2003 22:23, you wrote:
>> Hello everyone.   I wanted to create a mp3 database and I was
>> woundering
>> should I actually place mp3 binaries with in a database
>> table?   Should
>> I just use blobs or links to where the binaries are stored on the file
>> system?



В списке pgsql-novice по дате отправления:

Предыдущее
От: "Christian Stuhldreier"
Дата:
Сообщение: Synchronisationproblems
Следующее
От: Antti Haapala
Дата:
Сообщение: Re: GPL Licence