What version of Sqlite does iOS include?
SQLite is available by default on iOS. In fact, if you've used Core Data before, you've already used SQLite.
The database that can be used by apps in iOS (and also used by iOS) is called SQLite, and it's a relational database. It is contained in a C-library that is embedded to the app that is about to use it. Note that it does not consist of a separate service or daemon running on the background and attached to the app.
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. It is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day.
This wiki has the latest list, which is currently:
╔═════════════╦════════════════╗ ║ iOS Version ║ SQLite Version ║ ╠═════════════╬════════════════╣ ║ 2.2 ║ 3.4.0 ║ ║ 3.1.3 ║ 3.6.12 ║ ║ 4.0.2 ║ 3.6.22 ║ ║ 4.1.0 ║ 3.6.23.2 ║ ║ 4.2.0 ║ 3.6.23.2 ║ ║ 5.1.1 ║ 3.7.7 ║ ║ 6.0.1 ║ 3.7.13 ║ ║ 7.0 ║ 3.7.13 ║ ║ 7.0.6 ║ 3.7.13 ║ ║ 8.0.2 ║ 3.7.13 ║ ║ 8.2 ║ 3.8.5 ║ ║ 9.0 ║ 3.8.8 ║ ║ 9.3.1 ║ 3.8.10.2 ║ ║ 10.0 beta 2 ║ 3.13.0 ║ ║ 10.0 GM ║ 3.14.0 ║ ║ 10.2 ║ 3.14.0 ║ ║ 10.3.1 ║ 3.16.0 ║ ║ 11.0 ║ 3.19.3 ║ ║ 12.0 ║ 3.24.0 ║ ║ 12.1 ║ 3.24.0 ║ ║ 13.1.3 ║ 3.28.0 ║ ║ 14.1 ║ 3.32.3 ║ ║ 14.2 ║ 3.32.3 ║ ╚═════════════╩════════════════╝
╔═══════════════╦════════════════╗ ║ macOS Version ║ SQLite Version ║ ╠═══════════════╬════════════════╣ ║ 10.9 ║ 3.7.13 ║ ║ 10.10 ║ 3.8.5 ║ ║ 10.10.3 ║ 3.8.5 ║ ║ 10.11 ║ 3.8.10.2 ║ ║ 10.12 ║ 3.14.0 ║ ║ 10.13 ║ 3.19.3 ║ ║ 10.14.2 ║ 3.24.0 ║ ╚═══════════════╩════════════════╝
Iulian Onofrei edited that wiki on 1 Dec 2020
Using SELECT sqlite_version() on various iOS versions:
From the internets:
2.2: 3.4.0 3.1.3: 3.6.12 4.0.2: 3.6.22 4.1.0: 3.6.23.2 4.2.0: 3.6.23.2
I just tested now:
6.0.1: 3.7.13
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With