90 likes | 342 Views
MYSQL and SQLite in Android Apps. Mike Freedman. Uses. Ability for your app to store new data and receive it later Game Scores Contact information Taking Notes Easily pre-store large amounts of data in your application Trivia Game (Questions and Answers) Random Text Generator.
E N D
MYSQL and SQLite in Android Apps Mike Freedman
Uses • Ability for your app to store new data and receive it later • Game Scores • Contact information • Taking Notes • Easily pre-store large amounts of data in your application • Trivia Game (Questions and Answers) • Random Text Generator
SQLite and Creating a Database • Download SQLite Database Browser: http://sourceforge.net/projects/sqlitebrowser/ • Create a file name with extension .db • Create basic table for android development:android_metadata • Create fields _id and locale • Add value en_US • Add the rest of the tables like any other database, except be sure to use _id instead of id. • Store database file in the assets folder of the project you are implementing.
Database Helper Complete code can be found on Class Blog.