Rapid Android Development

Working with SQLite Databases

Now that we’ve seen most of Processing’s Table features, it’s time we take a look at the widely used SQLite database management system for local clients. It is based on the the popular Structured Query Language syntax for database queries and will look very familiar if you’ve worked with SQL before. Ketai gives us access to Android’s SQLiteDatabase class and provides us with the essential methods we need to create, query, and update content in the database tables.

The Ketai KetaiSQLite class is what we need to create full-fledged local SQLite databases on the device. For the projects in this chapter, we’ll use it to store a number of points that we’ll create by tapping the touch screen interface, and later we’ll ...