Skip to content

SQLite version (bundled with OS)

Oleksii Kalentiev edited this page Apr 29, 2016 · 40 revisions

####What version of SQLite does iOS / Mac OS X 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.2 3.8.5
9.0 3.8.8
9.3.1 3.8.10.2
Mac OS X 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

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