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.
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 an 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 mobile database, you have two choices in Delphi: SQLite (an open source...
