Difference between revisions of "Databases"

From The iPhone Wiki
Jump to: navigation, search
(meh)
(Versions)
 
(17 intermediate revisions by the same user 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 <code>sqlite3 -version</code> 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 ==
Line 9: Line 9:
 
| 3.4.0
 
| 3.4.0
 
|-
 
|-
| 3.0
+
| 3.x
| rowspan="2" | 3.6.12
+
| 3.6.12
|-
 
| class="rborderplz" | 3.1
 
 
|-
 
|-
 
| 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
  +
|-
  +
| 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
| class="rborderplz nobrradiusplz" | 7.0
 
  +
| 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