Re: What is the best way to storage music files in Postgresql

Поиск
Список
Период
Сортировка
От Craig James
Тема Re: What is the best way to storage music files in Postgresql
Дата
Msg-id 47DCBC18.8000904@emolecules.com
обсуждение исходный текст
Ответ на What is the best way to storage music files in Postgresql  (Rich <rhdyes@gmail.com>)
Список pgsql-performance
Rich wrote:
> I am going to embarkon building a music library using apache,
> postgresql and php.  What is the best way to store the music files?
> Which file type should I use?

In Postgres, its all just binary data.  It's entirely up to you which particular format you use. mp2, mp3 mp4, wmv,
avi,whatever, it's all the same to Postgres. 

A better question is: Should you store the binary data in Postgres itself, or keep it in files and only store the
filenames? The Postgres archives have several discussions of this topic, and the answer is, "it depends." 

Craig


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

Предыдущее
От: Rich
Дата:
Сообщение: What is the best way to storage music files in Postgresql
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: What is the best way to storage music files in Postgresql