Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What version of sqlite does iOS provide?

Tags:

sqlite

ios

iphone

What version of Sqlite does iOS include?

like image 250
Aaron Zinman Avatar asked Jan 11 '13 23:01

Aaron Zinman


People also ask

Does iOS come with SQLite?

SQLite is available by default on iOS. In fact, if you've used Core Data before, you've already used SQLite.

What is SQLite database in iOS?

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.

What is SQLite in iOS Swift?

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.


2 Answers

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

like image 104
Iulian Onofrei Avatar answered Sep 21 '22 23:09

Iulian Onofrei


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 
like image 34
Aaron Zinman Avatar answered Sep 23 '22 23:09

Aaron Zinman