From: Craig James <craig_james@emolecules.com>
To: Rich <rhdyes@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: What is the best way to storage music files in Postgresql
Date: Sat, 15 Mar 2008 23:20:08 -0700
Message-ID: <47DCBC18.8000904@emolecules.com> (raw)
In-Reply-To: <8fb205ea0803152311n2c950758g253f4cefd20cff7d@mail.gmail.com>
References: <8fb205ea0803152311n2c950758g253f4cefd20cff7d@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: craig_james@emolecules.com, rhdyes@gmail.com
Subject: Re: What is the best way to storage music files in Postgresql
In-Reply-To: <47DCBC18.8000904@emolecules.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox