Using SQLite databases to handle a to-do list
Usually, the mobile apps read or write data using the network. In many cases, however, you need a local storage to save your data. A local database can be useful for a number of things:
To buffer information while the Internet connection is not available
To save information that will be realigned on the central server when back to the office
To allow you a fast search on a relatively small set of data retrieved from the central databases and stored on the device
To store some structured data.
In all these cases, you have to handle a database. This recipe will show you how to do it.
Getting ready
This recipe is about a to-do list. It is similar to the Using listview to show and search local data recipe, but in this case, we'll use a SQL database and show data to the user using LiveBindings. Moreover, we'll see how to create output converters for LiveBindings.
How to do it...
When you need a database on the mobile, you have two choices in Delphi: SQLite...
