DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=gpVXvLos35TfLJLqi3ytsdu6SYica1hTbDPqMFd2ifmtnYAWBkJKbLk1eN30rObDtClxpS01QUrTbvU6Na/2hjJbkdOwb4RhxQB4TjlUm9q5DKjhMlhFN129I+RGDlPFiH7+ydXKYP38Ummn/0PzIdQcINal2s+kce0mLowCfaE=
Message-ID: <8fb205ea0803171140q3167aca9j190e192a40ef911d@mail.gmail.com>
Date: Mon, 17 Mar 2008 14:40:05 -0400
From: Rich <rhdyes@gmail.com>
To: "Craig Ringer" <craig@postnewspapers.com.au>
Subject: Re: What is the best way to storage music files in Postgresql
Cc: pgsql-performance@postgresql.org
In-Reply-To: <47DCBD63.9050109@postnewspapers.com.au>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <8fb205ea0803152311n2c950758g253f4cefd20cff7d@mail.gmail.com>
	<47DCBD63.9050109@postnewspapers.com.au>

On Sun, Mar 16, 2008 at 2:25 AM, Craig Ringer
<craig@postnewspapers.com.au> wrote:
> 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?
>
>  Your options are either to use a BLOB within the database or to store
>  paths to normal files in the file system in the database. I suspect
>  using normal files will make backup and management a great deal easier
>  than using in-database BLOBs, so personally I'd do it that way.
>
>  Storing the audio files in the database does make it easier to keep the
>  database and file system backups in sync, but I'm not really sure that's
>  worth the costs.
What costs are to speaking of?
>
>  I'm sure that what you're doing has been done many times before, though,
>  so even if you're not going to use one of the existing options you might
>  at least  want to have a look at how they work.
>
>
>  > Which file type should I use?
>
>  I'm not sure I understand this question. Are you asking which audio
>  compression codec and audio container file type (like "mp3", "aac", etc)
>   you should use? If so, this is really not the right place to ask that.
>
>  Do you mean which file /system/ ?
>
>  --
>  Craig Ringer
>
>