Book Image

Delphi Cookbook - Second Edition

By : Daniele Teti
Book Image

Delphi Cookbook - Second Edition

By: Daniele Teti

Overview of this book

Delphi is a cross-platform Integrated Development Environment (IDE) that supports rapid application development for Microsoft Windows, Apple Mac OS X, Google Android, and Apple iOS. It helps you to concentrate on the real business and save yourself the pain of wandering amid GUI widget details, or having to tackle inter-platform incompatibilities. It also has a wide range of drag-and-drop controls, helping you code your business logic into your business model, and it compiles natively for desktop and mobile platforms. This book will teach you how to design and develop applications, deploy them on the cloud platform, and distribute them within an organization via Google Play and other similar platforms. You will begin with the basics of Delphi and get acquainted with JSON format strings, XSLT transformations, unicode encodings and various types of streams. We then move on to more advanced topics such as developing higher-order functions and using enumerators and RTTI. You will get an understanding of how Delphi RTL functions and how to use FireMonkey in a VCL application. We will then cover topics such as multithreading, using the parallel programming library and putting Delphi on a server. We will also take a look at the new feature of WebBroker Apache modules and then ride the mobile revolution with FireMonkey. By the end of the book, you will be able to develop and deploy cross-platform applications using Delphi .
Table of Contents (15 chapters)
Delphi Cookbook Second Edition
Credits
About the Author
About the Reviewer
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 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...