SQLite, introduction |
SQL stands for Structured Query Language. SQL allows working with relational databases. SQLite is the most widely deployed database in the world, with many millions of installations. You can find it on Windows, on all iOS and Android mobile devices and on Mac OS desktops. It is used by The United States Library of Congress (a recommended storage format for preservation of digital content), Firefox, Skype, Google, McAfee anti-virus, and many more. StorageA complete SQLite database with multiple tables, indices, and so on, is contained in a single disk file. Field types, aka "storage classes":
There is no separate Boolean
storage class. Instead, Boolean
values are stored as integers 0 (false) and 1 (true).
Information held in an SQLite database file is easily accessible using commonly available open-source tools, such as DB Browser for SQLite (more info: sqlitebrowser.org) SQLite and DelphiYou find the necessary Delphi components on the FireDAC tab of the component palette. The advantage of using FireDAC is that it is fairly easy to change to a different type of database, such MSAccess or InterBase, without changing your program too much. Tutorial project: GeoWe'll show you how to set up and program a Database Management System (DBMS) for maintaining a table with countries and some of their properties. ![]() |
Table of contents
1. Intro to SQLite 2. Tutorial project 3. SQL statements 4. The WHERE clause 5. Browser for SQLite |
Crash Course Delphi Database tutorials FAQ Tips Source Code Downloads Links