Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0A59C2E2E58 for ; Sun, 16 Mar 2008 03:20:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 02401-10 for ; Sun, 16 Mar 2008 03:20:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.emolecules.com (66-226-76-106.dedicated.abac.net [66.226.76.106]) by postgresql.org (Postfix) with ESMTP id C08E72E2E57 for ; Sun, 16 Mar 2008 03:20:21 -0300 (ADT) Received: (qmail 26636 invoked by uid 2020); 15 Mar 2008 22:20:14 -0800 Received: from wsip-68-224-174-233.sd.sd.cox.net (HELO lisa-james-computer.local) (68.224.174.233) by 192.168.0.4 with SMTP; 15 Mar 2008 22:20:13 -0800 Message-ID: <47DCBC18.8000904@emolecules.com> Date: Sat, 15 Mar 2008 23:20:08 -0700 From: Craig James User-Agent: Thunderbird 2.0.0.12 (Macintosh/20080213) MIME-Version: 1.0 To: Rich CC: pgsql-performance@postgresql.org Subject: Re: What is the best way to storage music files in Postgresql References: <8fb205ea0803152311n2c950758g253f4cefd20cff7d@mail.gmail.com> In-Reply-To: <8fb205ea0803152311n2c950758g253f4cefd20cff7d@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/331 X-Sequence-Number: 29285 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