Delphi Cookbook

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 ...