concept SQLite in category android

appears as: SQLite, SQLite
50 Android Hacks

This is an excerpt from Manning's book 50 Android Hacks.

Note the annotation on the field id. We specify the parameter generatedId = true to signify that this field is our primary key, and it should be automatically assigned by SQLite. Also note that, by default, ORMLite uses our class name as the SQL table and the names of the member variables as the columns of the table.

Hack 42 Creating custom functions in SQLite: Android v1.6+

Android uses SQLite for its databases. Although it offers a good API, you’ll sometimes feel a bit limited. What would you do if you want to sort results using a comparator? Did you ever try to implement a query that returns the distance between two GPS coordinates? One of SQLite’s biggest limitations is its lack of math functions, making some queries impossible to achieve.