Book Image

Delphi Cookbook

By : Daniele Teti
Book Image

Delphi Cookbook

By: Daniele Teti

Overview of this book

Table of Contents (14 chapters)
Delphi Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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