SQLite version (bundled with OS)
Iulian Onofrei edited this page Dec 1, 2020
·
40 revisions
Wondering what version of SQLite you're using? With YapDatabase you can run this code:
print("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 |
12.0 | 3.24.0 |
12.1 | 3.24.0 |
13.1.3 | 3.28.0 |
14.1 | 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 |
Feel free to add additional data points to the tables. It's a wiki!