From: Rich <rhdyes@gmail.com>
To: Craig Ringer <craig@postnewspapers.com.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: What is the best way to storage music files in Postgresql
Date: Mon, 17 Mar 2008 14:40:05 -0400
Message-ID: <8fb205ea0803171140q3167aca9j190e192a40ef911d@mail.gmail.com> (raw)
In-Reply-To: <47DCBD63.9050109@postnewspapers.com.au>
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
>
>
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: rhdyes@gmail.com, craig@postnewspapers.com.au
Subject: Re: What is the best way to storage music files in Postgresql
In-Reply-To: <8fb205ea0803171140q3167aca9j190e192a40ef911d@mail.gmail.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