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

From: Craig James <craig_james(at)emolecules(dot)com>
To: Rich <rhdyes(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: What is the best way to storage music files in Postgresql
Date: 2008-03-16 06:20:08
Message-ID: 47DCBC18.8000904@emolecules.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2008-03-16 06:25:39 Re: What is the best way to storage music files in Postgresql
Previous Message Justin 2008-03-16 06:19:37 Re: Benchmark: Dell/Perc 6, 8 disk RAID 10