SQLite databases

SQLite is an open source, in-process library that implements a self-contained, zero configuration, and transactional SQL database engine. It's a complete database with multiple tables, triggers, and views that are contained in a single cross-platform file. As SQLite is portable, reliable, and small, it is a popular database format that appears in many mobile platforms.

Apple iOS devices, like other smartphones, make heavy use of SQLite databases for data storage. Many of the built-in applications such as Phone, Messages, Mail, Calendar, and Notes store data in SQLite databases. Apart from that, third-party applications installed on the device also leverage SQLite databases for data storage.

SQLite databases are created with or without a file extension. They typically have .sqlitedb or .db file extensions, but some databases are given other extensions as well. Data in SQLite files is broken up into tables that contain the actual data. To access the data stored in these...