Difference between revisions of "Databases"

From The iPhone Wiki
Jump to: navigation, search
(Versions: According to the iOS 7 SDK, it is the same for 6 and 7.)
(Versions)
 
(18 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The iPhone uses [http://www.sqlite.org/ SQLite] for most (all?) of its database storage. To find the version, type "sqlite3 -version" in MobileTerminal or via SSH.
+
The iPhone uses [http://www.sqlite.org/ SQLite] for most (all?) of its database storage. To find the version, type <code>sqlite3 -version</code> in a terminal app such as MobileTerminal or NewTerm or via SSH.
   
=Versions=
+
== Versions ==
{| class="wikitable" style="font-size: smaller; text-align: center; table-layout: fixed; border-collapse: collapse;" border="1"
+
{| class="wikitable" style="font-size: smaller; text-align: center;"
!iOS
+
! iOS version
!SQLite Version
+
! SQLite version
 
|-
 
|-
|2.2.1
+
| 2.2.1
|3.4.0
+
| 3.4.0
 
|-
 
|-
|3.0/3.1
+
| 3.x
|3.6.12
+
| 3.6.12
 
|-
 
|-
|4.0
+
| 4.0
|3.6.22
+
| 3.6.22
 
|-
 
|-
|4.3
+
| 4.3.x
|3.7.2
+
| 3.7.2
 
|-
 
|-
|5.0
+
| 5.x
|3.7.7
+
| 3.7.7
 
|-
 
|-
|6.0
+
| 6.x
| rowspan="2" | 3.7.13
+
| rowspan="3" | 3.7.13
 
|-
 
|-
  +
| class="rborderplz nobrradiusplz" | 7.x
|7.0
 
  +
|-
| class="rborderplz" |
 
  +
| class="rborderplz nobrradiusplz" | 8.0
  +
|-
  +
| 8.4
  +
| 3.8.5
  +
|-
  +
| 9.x
  +
| 3.8.10.2
  +
|-
  +
| 10.1.1
  +
| rowspan="2" | 3.14.0
  +
|-
  +
| 10.2
  +
|-
  +
| 10.3.3
  +
| 3.16.0
  +
|-
  +
| 11.x
  +
| 3.19.3
  +
|-
  +
| 12.0 beta 1-3
  +
| 3.22.0
  +
|-
  +
| 12.0 beta 4 and later
  +
| 3.24.0
  +
|-
  +
| 13.0 beta and later
  +
| 3.28.0
  +
|-
  +
| 14.0 beta and beta 2
  +
| 3.31.1
  +
|-
  +
| 14.0 beta 3 and later
  +
| 3.32.3
 
|}
 
|}

Latest revision as of 17:49, 22 July 2020

The iPhone uses SQLite for most (all?) of its database storage. To find the version, type sqlite3 -version in a terminal app such as MobileTerminal or NewTerm or via SSH.

Versions

iOS version SQLite version
2.2.1 3.4.0
3.x 3.6.12
4.0 3.6.22
4.3.x 3.7.2
5.x 3.7.7
6.x 3.7.13
7.x
8.0
8.4 3.8.5
9.x 3.8.10.2
10.1.1 3.14.0
10.2
10.3.3 3.16.0
11.x 3.19.3
12.0 beta 1-3 3.22.0
12.0 beta 4 and later 3.24.0
13.0 beta and later 3.28.0
14.0 beta and beta 2 3.31.1
14.0 beta 3 and later 3.32.3