Difference between revisions of "MAP524/DPS924 Lecture 6"
(Created page with '= SQLite = This is a semi-structured data store from your application on the phone. To store and retrieve data in the database you use SQL-like query strings, but SQLite isn't n…') |
(No difference)
|
Revision as of 15:51, 18 July 2015
SQLite
This is a semi-structured data store from your application on the phone. To store and retrieve data in the database you use SQL-like query strings, but SQLite isn't nearly as powerful as a typical SQL server. Only the very simplest parts of SQL are supported.
There's a lot of good material describing SQLite use on Android on this website.
Command-line
Often the easiest way to create an empty database, insert test data, and test your app's usage of SQLite is the command-line tool sqlite3. On Linux it should be installed by default, on other platforms you can download and install it yourself.
