Tag Archive: Google

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.


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.

The Magic of Layouts

I have been playing around with layouts and figuring out what each layout is best used for. The Android Layout Tutorials does a nice job going over the basics of the layouts and widgets (objects visible to the user) and I highly recommend at lease looking the code over. I have not found a use for the Linear Layout in my projects yet but I think I have fallen in love with the Relative Layout. The Relative Layout is so easy to use, you create a widget and tell it where on the screen you want it to be located then you can tell another widget to sit next to the first one and so on. Here is a screen shot of a layout that I created using the Relative Layout.

I will be working on using the Tab Layout, List View and Table Layout in my project as well and I look forward to master those layouts as well. Android has made it very easy to create a good-looking GUI (Graphical User Interface).

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.