Delphi Cookbook - Third Edition

Using SQLite databases to handle a to-do list

Usually, mobile apps read or write data using the network. In many cases, however, you need 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 at the office
• To allow you a fast search on a relatively small set of data retrieved from a central database 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.