Let's get this show on the road

We will now go through all the steps required to build our application.

The database

Before we dive into the application's look and feel, we need to define how our application will store the information. Titanium provides us with an embedded relational database management system (RDMS) called SQLite. It is a widely used open source database, which has very low memory consumption, making it the natural choice for mobile development where resources are limited.

Like most relational databases, the information is stored in tables and is accessed using the SQL query language. There are plenty of books and online articles covering all the intricacies of relational databases and SQL. So, we will not go into much detail on this subject, but will cover the basics that are necessary to store, update, and delete information from a database.

Defining the structure

Every time we need to store information in a database, we need to define a structure. For our application...