MYSQL and SQLite in Android Apps

tenderlaSoftware and s/w Development

Dec 13, 2013 (3 years and 5 months ago)

75 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

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.

SQLite

and Creating a Database

Database Helper