Skip to content

SQLite version (bundled with OS)

Jan Berkel edited this page Sep 28, 2017 · 40 revisions

What version of SQLite does iOS/macOS come with?

Wondering what version of SQLite you're using? With YapDatabase you can run this code:

NSLog(@"SQLite version = %@", yapdbInstance.sqliteVersion);

Wondering what SQLite features are available? That depends what version of sqlite you use at runtime. You can use the version of SQLite that comes pre-installed with the OS. Or you can explicitly include your own version of sqlite (in order to ensure a particular feature-set). This decision is largely based on what OS versions you're targeting.

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.1 3.7.13
8.2 3.8.5
8.4 3.8.5
9.0 3.8.8
9.3.1 3.8.10.2
9.3.5 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
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

Feel free to add additional data points to the tables. It's a wiki!