MYSQL and SQLite in Android Apps

tenderlaΛογισμικό & κατασκευή λογ/κού

13 Δεκ 2013 (πριν από 3 χρόνια και 5 μήνες)

76 εμφανίσεις

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