Streaming Audio From a Database
Das
I have a number of .wav files stored in a SQL Server database. When a user
requests one of these via an HTML page on the internet I wanted to send the
file to them using streaming. All the media streaming servers I can find
require the file to be stored in a directory, is there a Streaming server
that can take the binary data direct from a database? Or prehaps someone
has some other suggestions (other than writing the data to a file).
p.s. Im using IIS & Cold Fusion for my web/html scripting servers if thats
relevent
Das
jmedland@INTUVISION
source I would imagine it would still have to be written to a temp file to
be streamed. Is there a particular reason they have to be stored like that
instead of using pointers?
Das <NOSPAM#ds...@blueyonder.co.uk> wrote in message
news:1014746305.19164....@news.demon.co.uk...
Thomas Carlshavsen
> requests one of these via an HTML page on the internet I wanted to send
the
> file to them using streaming. All the media streaming servers I can find
> require the file to be stored in a directory, is there a Streaming server
> that can take the binary data direct from a database? Or prehaps someone
> has some other suggestions (other than writing the data to a file).
>
Why not Store the .wavs in a file..? You can then store the path in your
DB.
Thomas
Das
reasons we have decided to only provide access to the data + audio through
the database. Im also investigating other methods of securly transfering
the audio data to the web server.
Another problem I have is that a separate task deletes old audio data, the
data could be being transmitted when it gets deleted if I dont put a
reliable control mechanisum in place.
Das
"jmedland@INTUVISION" <jmed...@intuvision.com> wrote in message
news:hITe8.124$_%1.31...@rdr1.wms.teleglobe.net...
J. Medland
I don't know about the specifics of your context and it's limitations but
here a few suggestions
a) put an new drive in the server to hold only the audio data, and set
drive/directory permissions accordingly
b) set up a dedicated audio server
c) implement SSL
I don't see any way to be able to stream without moving the data to file,
esp considering "data could be being transmitted when it gets deleted"
I also don't see how being file based would be any less secure than using
the DB
if your security is properly implemented.
If your security issues are access to your server's file system and not
the "proprietary-ness" of the audio look at an external shout cast service.
that's all I can see without a little more detail on what and why.
j-
Das <NOSPAM#ds...@blueyonder.co.uk> wrote in message
news:1015323220.8776.0...@news.demon.co.uk...
Das
over a private WAN, therefor we have to ensure this WAN is isolated as far
as possible from the internet, as my db/file server sits on the WAN
gathering data, it's only interface to the web server is via a firewall, my
task is to get the data through the firewall and out to the customer, I
can't allow computers on the internet direct access to a PC on my private
WAN. Additionaly I dont want to enable directory sharing throught the
firewall, FTP isn;t all that safe either. Currently the only ports open
through the firewall are for the database access which we already use, I was
hoping to keep it that way, although I has considered opening up ports to
allow data to be streamed from the database server and then redirected of
the web server.
J. Medland
much response.
Sorry for the delay and the lack of anything useful. :-(
Das <NOSPAM#ds...@blueyonder.co.uk> wrote in message
news:1015407521.6231.0...@news.demon.co.uk...