Обсуждение: handle audiofiles in postgres

Поиск
Список
Период
Сортировка

handle audiofiles in postgres

От
edisan
Дата:
Can anyone used or tell me how to handle audio files in postgres

Audio files may be in  wav / vox / dss format and each have average 30 min running time.

Thanks in advance

Regards
edi

Re: handle audiofiles in postgres

От
John R Pierce
Дата:
edisan wrote:
> Can anyone used or tell me how to handle audio files in postgres
>
> Audio files may be in  wav / vox / dss format and each have average 30
> min running time.

probably too large to want to store in the database, as a 30 minute PCM
.WAV file in CD quality could easily be 300 megabytes, even in a MP3
format it might be 30MB if high-fidelity, and maybe 6MB if lower voice
quality, thats -still- larger than I'd want to store as database rows,
anyways, there's nothing really relational about the audio data.

I'd suggest storing them as standard disk files, and putting the
location (path, filename) in the database.    if you need to access them
from multiple systems, store them on an http or similar server....

Re: handle audiofiles in postgres

От
"Harvey, Allan AC"
Дата:
 
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of edisan
Sent: Thursday, 3 September 2009 2:48 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] handle audiofiles in postgres

Can anyone used or tell me how to handle audio files in postgres

Audio files may be in  wav / vox / dss format and each have average 30 min running time.

Thanks in advance

Regards
edi
 
I store several hundred as blobs.
 
Allan
 

The material contained in this email may be confidential, privileged or copyrighted. If you are not the intended recipient, use, disclosure or copying of this information is prohibited. If you have received this document in error, please advise the sender and delete the document. Neither OneSteel nor the sender accept responsibility for any viruses contained in this email or any attachments.

Re: handle audiofiles in postgres

От
Christopher Browne
Дата:
urs.edisan@gmail.com (edisan) writes:
> Can anyone used or tell me how to handle audio files in postgres
>
> Audio files may be in  wav / vox / dss format and each have average 30 min
> running time.

In principle, you could store these as "BLOB" data; I'd quite prefer
storing this as "bytea" data.

The TOAST capability
<http://www.postgresql.org/docs/8.4/interactive/storage-toast.html>
means that these "BLOBs" are actually stored in side tables, which
should be good for efficiency in that they won't make data tuples
enormous even though there's enormous data tied to them.

As a result, queries on metadata (e.g. - the other attributes of the
data) can be nicely efficient despite the bulky data.

It's not obvious, however, that storing the files in the database is
preferable to:

 - Putting the files in a filesystem, perhaps with cryptic names
   (hashes?)

 - Storing the metadata about the files in the database, referencing the
   files' names

If there's good reason to store the files in the DBMS, then do so; just
make sure there's good reason for it!
--
let name="cbbrowne" and tld="ca.afilias.info" in name ^ "@" ^ tld;;
Christopher Browne
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"