I wish I could store and retrieve Sound to and from database. - Page 2

Lisa Jones

Hi

I donâ€™t want to change my name or anything :) but I wish I was able to save Sound into SQL server and retrieve it

So my question is How do you save a wav file into a SQL server and how do you retrieve it

Thanks so much

Lisa Jone

Nov 20 '05

Subscribe Reply

3847

Lisa Jones

Hi Cor
I am now looking into that... any suggestions
Thank
Lis

Nov 20 '05 #11

Herfried K. Wagner [MVP]

* "Cor Ligthert" <no**********@p lanet.nl> scripsit:
[...]

I don't have an opinion on this topic ;-).

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

Nov 20 '05 #12

Cor Ligthert

Not about the topic,

About my text I did give the advise to take a smaller sound format, and than
I think for that is Herfried my first man to give a good advise.

The database part is no problem for me at all, I can assure you that you are
not the first who I would ask for that.

Cor

Nov 20 '05 #13

Herfried K. Wagner [MVP]

Cor,

* "Cor Ligthert" <no**********@p lanet.nl> scripsit:

About my text I did give the advise to take a smaller sound format, and than
I think for that is Herfried my first man to give a good advise.

It depends on what you want to do with the audio data. If access must
be possible in little time, decompression should be fast. If data is
streamed over a network, the format must be "streamable " and often data
is heavily (lossy) compressed. There is no general answer.

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

Nov 20 '05 #14

Cor Ligthert

> * "Cor Ligthert" <no**********@p lanet.nl> scripsit:

About my text I did give the advise to take a smaller sound format, and than I think for that is Herfried my first man to give a good advise.

It depends on what you want to do with the audio data. If access must
be possible in little time, decompression should be fast. If data is
streamed over a network, the format must be "streamable " and often data
is heavily (lossy) compressed. There is no general answer.

Linda said that and I agree with here, so my idea was how can you get that
data smaller.
I have seen that serializing and deserializing is possible with any media.
(I have now a complete collection of samples for that in as I think in every
kind of way). I do not think that compressing a sound file makes sense
however if that is possible give your advise, I am absolute a nitwit in
that, without the fact that I know that a wav file is much larger than
nowadays is possible.

This is the text from Linda
----------------------------------------------------------------------------
---------------------
Yes I was thinking of storing only the path but there is only one problem
and that is security. These are for medical transcripts. So if i store it as
file how would i address the security consideration?
----------------------------------------------------------------------------
---------------------

So what is your opinion?

'Cor

Nov 20 '05 #15

Slonocode

> I have seen that serializing and deserializing is possible with any media.

(I have now a complete collection of samples for that in as I think in every kind of way). I do not think that compressing a sound file makes sense
however if that is possible give your advise, I am absolute a nitwit in
that, without the fact that I know that a wav file is much larger than
nowadays is possible.

There are many different compression formats to choose from. mp3, ogg, wma,
aac, realaudio...etc .
It does really depend on what kind of sound needs to be compressed. What
kind of sound is the OP storing with the medical transcripts? Is it 1
second sound effect or perhaps it is a doctor's audio notes that are a few
minutes in length?

How important is the quality of the sound? The more you compress the more
you degrade the quality.

Nov 20 '05 #16

Slonocode

"Lisa Jones" <an*******@disc ussions.microso ft.com> wrote in message
news:9C******** *************** ***********@mic rosoft.com...

Hi all
Thanks all for your comments. Thanks to Cor my name now is Linda :)
Question regarding what kind of vice, these are doc recording. the idea is offline the speech must be converted to text so Quality if recording is very
important. Thanks
Lisa

Speech can be compressed much more than music. There are codecs that are
designed specifically for speech.
You may take a look at the Speex codec which is open source and freely
available.
There are others such as GSM.

Nov 20 '05 #17

Lisa Jones

Thanks I don't know anything about them but will look them up
Lisa

Nov 20 '05 #18

Cor Ligthert

Hi *Lisa*

And if you are further,
Herfried knows how to compress
Slonocode knows what sound codec
I know how to serialize

(And probably we know all something about it)

Feel free to ask again.

Success

:-)

Cor

Nov 20 '05 #19

Lisa Jones

Thanks so much
Lisa

Nov 20 '05 #20

Similar topics

3743

STL Help with Store/Retrieve .. Maps

by: forums_mp | last post by:

I've got an STL class (see below) with two functions to store and retrieve data - msg structs. The "Store" function when called will copy the received message (depending on which message) into the appropriate array. For instance if I receive a RCVD_MSG1, I'll copy into msg1 . Upon receipt of the next RCVD_MSG1. I'll copy into msg1 . The Retrieve function when called should retrieve the latest copy. ie. msg1 or msg1 .

C / C++

1825

how to store the password in the ENCRYPT form using castor jdo

by: Senthil Kannan | last post by:

Hi all, Currently i have a FORM_BASED Authentication of tomcat5.0 to store and retrieve passwords in my homepage.Now when i try to Store my password in a encrypted form i am having some problems,i am listing the problems here.do help me to fix this. when a new user signup to my homepage his datas are to be stored in database.while storing this i need to store the password in encrypted manner,when i insert it manually in comman line it...

MySQL Database

1939

Wish List Item

by: Darryl Kerkeslager | last post by:

I frequently use OpenArgs to pass a value to a form; it would be nice if there was a similarly easy way to return a value from a called form. Darryl Kerkeslager

Microsoft Access / VBA

2931

I want to create a database and store and retrieve information

by: Roy Gourgi | last post by:

Hi, I am used to working in Visual FoxPro and I would like to be able to create a database and store and retrieve information from it. What is the simplest way to do it and what should I be using as there are many choices to choose from. My database will contain a lot of records. TIA

C# / C Sharp

1915

to store or not to store an image

by: Rudy | last post by:

Hello all! I am amazed how many posts I have read to store an image in SQL, and just as many against it. So I learned how to store an image in a SQL db and retrieve the image. A little tricky, but not too bad. But then I thought I wanted to try the other way, by putting the file location in SQL and storing the actual image in another directory. I plan to have many images on my web application, up to as many as 5000. Not to mention the...

ASP.NET

2859

Need a Strategy to store the Single Quotes in the Database

by: Solution Seeker | last post by:

I want to Store the String value with Single Quotes in the Field of Database where if i try to Store the String value with Single Quotes (as it is) then it is throwing the error as SQL String Truncated. so we need a solution to store and retrieve user Entered value along with single quotes into the Database. i am using the String variable to frame the Qry(that is then passed to Database for execution) which is as follows

Visual Basic .NET

2425

where to store sound file

by: martin1 | last post by:

Hi, All, The app retrieve sound.wav file from my loacal C drive, is there anyway the sound file can be stored in the app? then when building, it goes with app rather than sending sound file seperate with app when deploying the app. Thanks

Visual Basic .NET

3622

problems with saving and retrieving data with new line (\n and \r\n)and slashes from mysql database

by: JM | last post by:

Before storing information from a form in database I perform follwing operations on it : $path = mysql_real_escape_string(strip_tags(trim(urldecode($_POST)))); $summary = mysql_real_escape_string(strip_tags(trim(urldecode($_POST)))) When I look in database I see '\r\n' in the text for the summary wherever I pressed return-key. When i retrieve the information from database and display it on webpage

PHP

4842

How to Store Outlook Mails as such in sql server 2000

by: angel1982 | last post by:

I have this requirement where I have to store outlook mails into database and retrieve as necessary. The mail has to be retrieved back in outlook window itself, and not in any other format. The intention is to give him all the features available in the outlook. So can someone please guide me as how to store the .msg file in the database and retrieve back? Am using VB 6.0 and SQL 2000

Visual Basic 4 / 5 / 6

8683

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9170

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9031

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8902

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8873

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6528

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4372

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3052

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2007

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General