Re: [asterisk-users] Playback/background audio from MySQL BLOB

2014-09-24 Thread A J Stiles
On Tuesday 23 Sep 2014, Steve Edwards wrote: For some applications, storing recorded audio (prompts and caller recordings) as a BLOB in MySQL has advantages. So, once I have the audio in the database, how can I play it? Creating temporary files seems so tacky. Is there another way to

Re: [asterisk-users] Playback/background audio from MySQL BLOB

2014-09-24 Thread Hoggins!
Hello, Le 23/09/2014 23:38, Steve Edwards a écrit : 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

Re: [asterisk-users] Playback/background audio from MySQL BLOB

2014-09-24 Thread Chris Bagnall
On 24/9/14 10:36 am, A J Stiles wrote: But personally, I'd just store the filenames in the database; and rely on the unix filesystem for storing the actual file contents. After all, that's what a filesystem is for. This. Shocking as it might appear, filesystems are remarkably good at storing

Re: [asterisk-users] Playback/background audio from MySQL BLOB

2014-09-24 Thread Jeff LaCoursiere
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

[asterisk-users] Playback/background audio from MySQL BLOB

2014-09-23 Thread Steve Edwards
For some applications, storing recorded audio (prompts and caller recordings) as a BLOB in MySQL has advantages. So, once I have the audio in the database, how can I play it? Creating temporary files seems so tacky. Is there another way to playback or background audio either by specifying a

Re: [asterisk-users] Playback/background audio from MySQL BLOB

2014-09-23 Thread Jeff LaCoursiere
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. So, once I have the audio in the database, how can I play it? Creating temporary files seems so tacky. Is there another way to

Re: [asterisk-users] Playback/background audio from MySQL BLOB

2014-09-23 Thread Don Kelly
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. Jeff sez: How about a named pipe (fifo)? Of course then you might have issues with simultaneous calls. You would have to have a pool of

Re: [asterisk-users] Playback/background audio from MySQL BLOB

2014-09-23 Thread Steve Edwards
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

Re: [asterisk-users] Playback/background audio from MySQL BLOB

2014-09-23 Thread Mike
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

Re: [asterisk-users] Playback/background audio from MySQL BLOB

2014-09-23 Thread Don Kelly
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