On 09/23/2014 10:53 PM, Don Kelly wrote:
On Tue, 23 Sep 2014, Steve Edwards wrote:
On 09/23/2014 02:17 PM, Steve Edwards wrote:
For some applications, storing recorded audio (prompts and caller
recordings) as a BLOB in MySQL has advantages.
On Tue, 23 Sep 2014, Don Kelly wrote:
I'm curious about what the advantages are of storing audio in a blob.
Wouldn't it be more efficient to store it in a file and just put the
filename in the database?
Multiple web servers, multiple Asterisk servers, multiple DB servers,
synchronizing filesystems vs db, etc.
It appears to eliminate some problems, but Asterisk limiting audio
playback to files seems like a tough obstacle.
Mike said:
Maybe make the audio files available to all servers via a single NFS
directory? Probably not a good solution if the servers aren't co-located.
Maybe someone could write a Linux device "file" that would return the blob's
content as a file read.
I beat you to that one ;) That is exactly what a named pipe (fifo) is.
Asterisk would read it like a sound file, and the AGI would dump the
BLOB to it on demand. It would work, but you can't have more than one
process at a time reading from it, so that's a further complication...
j
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
