Speech Recognition MySQL Database Management
We have developed a python library called MySQLvoice which will not require any coding for maintaining databases of MySQl, What it needs is just your simple regional language as voice input.
Created on 9th January 2022
•
Speech Recognition MySQL Database Management
We have developed a python library called MySQLvoice which will not require any coding for maintaining databases of MySQl, What it needs is just your simple regional language as voice input.
The problem Speech Recognition MySQL Database Management solves
This Project is limited to MySQL Database operations but it can be used in all regions of the world for handeling databases as
it is very easy to develop for regional languages. We are mostly working in common English language but it has the capability
to be coded for any languages spoken in the world like Kannada, Korean, Japenese, Hindi, Gujrati etc. It will help the Non-Technical
person to handle databases with ease.
MySQLvoice is a pip library created by us during Hackathon DotSlash 5.0 (SVNIT,Surat, India). This library falls under developer tools
which helps the developer to take inputs from the user via voice recognition technology developed using prebuilt python library called
SpeechRecognition to recognize the keywords and use them as Standard Query generators. Using this library user doesn't need to know
SQL database languages to make any changes or to know anything about their database. We have announced eight new keywords as follows:
1)mycursor -> To name yout MySQL cursor
2)tablename1 -> To name your First table
3)tablename2 -> To name your second table
4)t1c1 ->To name first column of your tablename1
5)t1c2 ->To name second column of your tablename1
6)t1c3 ->To name third column of your tablename1
7)t2c1 ->To name first column of your tablename2
8)t2c2 ->To name second column of your tablename2
Apart from this we need three preinstalled pip libraries as follows:
- speech_recognition
- pyaudio
- mysql.connector
Challenges we ran into
Firstly there was problem in keyword comparison while generating standard query for sql as Python is case sensitive, we solved it by first looking into how the speech recognition converts voice to text, then we used the same text as keyword for searching sql commands.
We also had an error of "circular import error" which we resolved by importing the libraries in correct sequence by writing the code according an algorithm of human listening , processing and then working on it analogy.