-
Notifications
You must be signed in to change notification settings - Fork 365
SQLite version (bundled with OS)
Cezar edited this page Sep 27, 2017
·
41 revisions
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 |
| 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 !