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.
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.
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.