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 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 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 how to do it.
Getting ready
This recipe is about a to-do list. It is similar to the Using TListView to show and search local data recipe, but in this case, we'll use a SQL database and will 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 mobile database, you have two choices in Delphi: SQLite (an open...
