Tag Archive: SQLite



I have been making some good progress on my first app and getting it slowly working the way I want it to. I have added Speech Recognition that will allow the user to say what they think the Spanish word is in English and I compare that word with the one from my database then notify the user if they are correct or not. I have also added Text-to-Speech (TTS) so the user can hear how the word is pronounced correctly when learning how to speak the language. The next items that I will be working on will be the settings database, the menu and the settings page. I don’t think it will be very hard to get those working but it will take a little time to get everything I need created.

When trying to copy my premade SQLite database into my app I found this website on ReignDesign that helped a lot. It showed me how to modify the database to work with Android and some code to get it working. It took me some time to play with the code in order to get it to work for me but I was able to get it working. Bellow is the code from the website that I used.

Continue reading

Advertisements

Project update


My first attempt at creating an Android app is going along very well. Now that I am over that first big wall of figuring out how to copy the premade SQLite database into usable space, I am now adding features left and right and getting the results that I wanted. So far I have been able to pull a random word from the table, pull a random word from a category and a random word that has been marked by the user for needing more practice. The latest part of the code that I have been able to get working is updating the marked word column with a toggle button. Next I will be working on creating the screen menu and a full menu screen as well as creating an Android made database. That database should be very easy and should not give me very many problems. Famous last words as one would say.

I have been talking with a friend and I have decided to post all of my code on this site. I really want to clean up the code a little and add some notes before posting. Hopefully someone will find some of it useful when trying to build an app. If you think my code may be able to help you with your project, let me know and I will post it early and just make edits as needed.


I have been reading the Android Development site trying to find exactly what I need to copy my SQLite database into the usable area of my app. Also, one of my friends let me borrow an Android Development book that he bought some time ago and I have started to read it. The book covers up to Android 2.0 and still works very well today because most of the important APIs were created in Android 1.5 and the book goes into great detail of the major functions of apps. I have found a few methods that should work that I want to try out and all I need now is some of that all important free time to sit down and experiment with the code. I plan on finding some of this free time soon and I will let you know about my findings.


Since I have finished the main GUI of my first Flashcard app I will need to start working on getting the SQLite Database created and working. Using SQLite Database Browser I have created a test database that is small and has at all the different kinds of information in it that I will need to test the function of. I have the _id field, a word category field, English word field, Spanish word field, a note field for future use, and a mark field to set words for future studying.

Now comes the fun part. Figuring out what features I want and need in order to get the SQLite Database created in android and work the way I want it to. I will be going over what I have learned in a future post and I am planing on making a page that covers everything in great detail on working with an SQLite Database in Android.

First App Idea


For my first set of apps I will be creating a flashcard app that will be useful for learning different languages. It will be using a SQLite database that I will create and Android will use to copy into and use the data for the apps use. My first creation will be simple and have English and Spanish words. You will be able to touch the displayed word and hear the punctuation and when ready you will have to say the correct translation and the app will verify if you are correct. There will be a few other features that I will be working on to enhance the user’s experience. I will add another post about my progress and things that I have learned along the way hopefully not too far from now.