Documentation Source Text

Check-in [709a8a255b]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Update the "famous users" page to try to make it more mobile-friendly.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 709a8a255b24e57080247b6cd005e4ee14d26166
User & Date: drh 2016-09-02 18:36:42
Context
2016-09-02
19:04
Cause the comments within example code in sessionsintro.html to be in blue italic type. check-in: 59b5461497 user: dan tags: trunk
18:36
Update the "famous users" page to try to make it more mobile-friendly. check-in: 709a8a255b user: drh tags: trunk
18:35
Fix a mismatched tag in sessionintro.in. check-in: 1abe86b9d2 user: dan tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Deleted images/foreignlogos/realbasic.gif.

cannot compute difference between binary files

Deleted images/foreignlogos/toshiba.gif.

cannot compute difference between binary files

Added images/foreignlogos/xojo.png.

cannot compute difference between binary files

Changes to pages/famous.in.

13
14
15
16
17
18
19
20



21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130

131
132
133
134
135
136
137
138
139
140
141
142


143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225



226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257














258
259
260


261
262
263
264
265
266

267

268


in alphabetical order.
This is not a complete list.
SQLite is in the 
<a href="copyright.html">public domain</a> and so most
developers use it in their projects without ever telling us.
</p>

<table border="0" cellpadding="15">




<tr><td valign="top">
<a href="http://www.adobe.com/">
<img src="images/foreignlogos/adobe.gif" border="0"></a>
</td><td valign="top">
[http://www.adobe.com/ | Adobe] uses SQLite as the 
<a href="whentouse.html#appfileformat">application 
file format</a> for their 
[http://www.adobe.com/products/photoshoplightroom/ | Photoshop Lightroom]
product.
SQLite is also a standard part of the
[http://labs.adobe.com/technologies/air/ | Adobe Integrated Runtime (AIR)].
It is reported that 
[http://www.adobe.com/products/acrobat/readstep2.html | Acrobat Reader]
also uses SQLite.
</td></tr>

<tr><td valign="top">
<a href="http://www.airbus.com/">
<img src="images/foreignlogos/airbus2.gif" border="0"></a>
</td><td valign="top">
[http://www.airbus.com/ | Airbus] confirms that SQLite is being
used in the flight software for the 
[http://www.airbus.com/en/aircraftfamilies/a350 | A350 XWB] family
of aircraft.
</td></tr>

<tr><td valign="top">
<a href="http://www.apple.com/">
<img src="images/foreignlogos/apple.gif" border="0">
</a></td>
<td valign="top">
[http://www.apple.com/ | Apple] uses SQLite in many (most?) of the
native applications running on Mac OS-X desktops and servers and
on iOS devices such as iPhones and iPods.  SQLite is also used in
[http://www.apple.com/itunes/ | iTunes], even on non-Apple hardware.
</td></tr>

<tr><td valign="top">
<a href="http://www.bentley.com/">
<img src="images/foreignlogos/bentley.gif" width="215" height="52" border="0">
</a></td>
<td valign="top">
[http://www.bentley.com/ | Bentley Systems] uses SQLite as the
[affshort | application file format] for their
[https://www.bentley.com/en/products/product-line/modeling-and-visualization-software/microstation | Microstation]
CAD/CAM product.
</td></tr>

<tr><td valign="top">
<a href="http://oss.bosch-cm.com/index.html">
<img src="images/foreignlogos/bosch_logo1.gif" border="0">
</a></td>
<td valign="top">
[http://www.bosch.com/ | Bosch] uses SQLite in the multimedia
systems install on GM, Nissan, and Suzuki automobiles.
(<a href="http://oss.bosch-cm.com/index.html">link</a>)
</td></tr>

<tr><td valign="top">
<a href="http://www.dropbox.com/">
<img src="images/foreignlogos/dropbox.gif" border="0">
</a>
</td>
<td>
The increasingly popular [http://www.dropbox.com/ | Dropbox] file
archiving and synchronization service is reported to use SQLite as
the primary data store on the client side.
</td></tr>

<tr><td valign="top">
<a href="https://www.expensify.com/">
<img src="images/foreignlogos/expensify.png" width=215 height=31 border="0">
</a>
</td>
<td>
[https://www.expensify.com/ | Expensify] uses SQLite as a server-side
database engine for their enterprise-scale expense reporting software.
</td></tr>


<tr><td valign="top" align="center">
<a href="https://www.facebook.com/">
<img src="images/foreignlogos/fb.gif" border="0">
</a>
</td>
<td>
[https://www.facebook.com/ | Facebook] uses SQLite as the SQL database
engine in their 
[https://code.facebook.com/projects/658950180885092 | osquery] product.
</td></tr>


<tr><td valign="top">
<a href="http://www.mozilla.com/">
<img src="images/foreignlogos/firefox.gif" border="0">
</a>
</td>
<td>
SQLite is the primary meta-data storage format for
the [http://www.mozilla.com/ | Firefox Web Browser] and the
[http://www.mozilla.com/thunderbird/ | Thunderbird Email Reader] from
Mozilla.
</td></tr>


<tr><td valign="top" align="center">
<img src="images/foreignlogos/flame.gif" border="0">
</td>
<td>

<a href="http://en.wikipedia.org/wiki/Flame_%28malware%29">Flame</a>
is a malware spy program that is reported to make heavy use of SQLite.
</td></tr>


<tr><td valign="top">
<a href="http://www.ge.com/">
<img src="images/foreignlogos/ge.gif" border="0"></a>
</td><td>
We believe that [http://www.ge.com/ | General Electric]
uses SQLite in some product or 
another because they twice wrote to the SQLite developers requesting 


the US Export Control Number for SQLite. So presumably GE is using
SQLite in something that they are exporting. But nobody
(outside of GE) seems to know what that might be.
</td>


<tr><td valign="top">
<a href="http://www.google.com/">
<img src="images/foreignlogos/google.gif" border="0"></a>
</td>
<td>
[http://www.google.com/ |Google]
uses SQLite in their 
in the [http://code.google.com/android/ | Android] cell-phone 
operating system, and in the 
[http://www.google.com/chrome | Chrome Web Browser].
</td>

<tr><td valign="top">
<a href="http://www.intuit.com/">
<img src="images/foreignlogos/intuit.gif" border="0"></a></td>
<td>
[http://www.intuit.com/ | Intuit] apparently uses SQLite in 
[http://www.quickbooks.com/ | QuickBooks] and in
[http://turbotax.intuit.com/ | TurboTax] to judge from some error
reports from users seen 
[http://community.intuit.com/posts/database-error-sqlite-error-code1 | here] and
[https://ttlc.intuit.com/post/show_full/cJf8mIhC4r4jjracfArQzM/when-i-try-to-update-turbotax-i-receive-an-unexpected-error-message | here].
</td>

<tr><td valign="top">
<a href="http://www.mcafee.com/">
<img src="images/foreignlogos/mcaffee.gif" border="0"></a></td>
<td>
[http://www.mcafee.com/ | McAfee] uses SQLite in its antivirus 
programs.  
Mentioned [http://www.mail-archive.com/sqlite-users@sqlite.org/msg16931.html | here] and implied 
[http://forums.mcafeehelp.com/showthread.php?t=173519 | here].
</td>


<tr><td valign="top">
<a href="http://www.microsoft.com/">
<img src="images/foreignlogos/microsoft.gif" border="0"></a>
</td>
<td>
[http://www.microsoft.com/ | Microsoft] uses SQLite as a core component
of Windows 10, and in individual numerous products.
</td>


<tr><td valign="top">
<a href="http://www.nds-association.org/">
<img src="images/foreignlogos/nds.png" border="0" width=215 height=44></a>
</td>
<td>
[http://www.nds-association.org/ | The Navigation Data Stanard] uses 
SQLite as its [affshort | application file format].
</td>


<tr><td valign="top">
<a href="http://www.php.net/">
<img src="images/foreignlogos/php.gif" border="0"></a>
</td><td>
The popular 
[http://www.php.net/ | PHP]
programming language comes with both SQLite2 and SQLite3 built in.
</td></t>

<tr><td valign="top">
<a href="http://www.python.org/">
<img src="images/foreignlogos/python.gif" border="0"></a>
</td><td>
SQLite comes bundled with the 
[http://docs.python.org/lib/module-sqlite3.html | Python]
programming language since Python 2.5.
</td></tr>

<tr><td valign="top">
<a href="http://www.realbasic.com/">
<img src="images/foreignlogos/realbasic.gif" border="0"></a>
</td><td>



The [http://www.realbasic.com/ | REALbasic]
programming environment comes bundled with an enhanced version of 
SQLite that supports AES encryption.
</td></tr>

<tr><td valign="top" align="center">
<a href="https://en.wikipedia.org/wiki/RPM_Package_Manager">
<img src="images/foreignlogos/rpm_logo.png" border="0" width=120 height=70></a>
</td><td>
The [https://en.wikipedia.org/wiki/RPM_Package_Manager | RedHat Package Manager (RPM)]
uses SQLite to track its state.
</td></tr>

<tr><td valign="top">
<a href="http://www.skype.com/">
<img src="images/foreignlogos/skype.gif" border="0"></a>
</td><td>
There are 
[http://www.mail-archive.com/sqlite-users%40sqlite.org/msg27326.html | multiple]
[http://www.mail-archive.com/sqlite-users%40sqlite.org/msg27332.html|sightings]
of SQLite in the Skype client for Mac OS X and Windows.
</td></tr>

<tr><td valign="top">
<a href="http://www.tcl-lang.org/">
<img src="images/foreignlogos/tcl.gif" border="0"></a>
</td><td>
The Tcl/Tk programming language now comes with SQLite built-in.  SQLite works
particularly well with Tcl since SQLite was originally a Tcl extension that
subsequently "escaped" into the wild.
</td>















<tr><td valign="top">
<a href="http://www.toshiba.com/">
<img src="images/foreignlogos/toshiba.gif" border="0"></a>


</td><td>
A representative of 
[http://www.toshiba.com/ | Toshiba] wrote to the SQLite developers 
and requested the US Export Control Number for SQLite. We infer from this 
that Toshiba is exporting something from the US that uses SQLite, but we 
do not know what that something is.

</td></tr>

</table>









|
>
>
>
|
<
|
<
<
|
|
|
|
|
|
|
|
|
|
<
|
<
|
<
<
|
|
|
|
<
|
<
|
<
<
<
|
|
|
|
<
|
<
|
<
<
<
|
|
|
|
<
|
<
|
<
<
<
|
|
|
<
|
<
|
<
<
<
<
|
|
|
<
|
<
|
<
<
<
<
|
|
<
|
<
<
|
<
<
<
<
|
|
|
<
|
<
<
|
<
<
<
<
|
|
|
|
<
|
<
<
<
<
<
>
|
|
<
|
<
<
|
<
<
|
|
<
>
>
|
|
|
<
|
<
<
<
<
<
<
|
|
|
|
|
<
|
<
|
<
<
|
|
|
|
|
|
<
|
<
|
<
<
|
|
|
|
<
|
<
<
|
<
<
<
|
|
<
|
<
<
|
<
<
<
|
|
<
|
<
<
|
<
<
<
|
|
<
|
<
|
<
<
|
|
|
<
|
<
<
<
<
>
>
>
|
<
<
<
|
<
|
<
<
|
|
<
|
<
|
<
<
|
|
|
|
<
|
<
|
<
<
|
|
|
<
|
>
>
>
>
>
>
>
>
>
>
>
>
>
>
|
<
<
>
>
|
<
<
<
<
<
>
|
>
|
>
>
13
14
15
16
17
18
19
20
21
22
23
24

25


26
27
28
29
30
31
32
33
34
35

36

37


38
39
40
41

42

43



44
45
46
47

48

49



50
51
52
53

54

55



56
57
58

59

60




61
62
63

64

65




66
67

68


69




70
71
72

73


74




75
76
77
78

79





80
81
82

83


84


85
86

87
88
89
90
91

92






93
94
95
96
97

98

99


100
101
102
103
104
105

106

107


108
109
110
111

112


113



114
115

116


117



118
119

120


121



122
123

124

125


126
127
128

129




130
131
132
133



134

135


136
137

138

139


140
141
142
143

144

145


146
147
148

149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164


165
166
167





168
169
170
171
172
173
in alphabetical order.
This is not a complete list.
SQLite is in the 
<a href="copyright.html">public domain</a> and so most
developers use it in their projects without ever telling us.
</p>

<tcl>
set lx {}
proc famous_user {sortkey link logo verbage} {
  lappend ::lx [list $sortkey $link $logo $verbage]
}

famous_user adobe http://www.adobe.com/ adobe.gif {


  [http://www.adobe.com/ | Adobe] uses SQLite as the 
  <a href="whentouse.html#appfileformat">application 
  file format</a> for their 
  [http://www.adobe.com/products/photoshoplightroom/ | Photoshop Lightroom]
  product.
  SQLite is also a standard part of the
  [http://labs.adobe.com/technologies/air/ | Adobe Integrated Runtime (AIR)].
  It is reported that 
  [http://www.adobe.com/products/acrobat/readstep2.html | Acrobat Reader]
  also uses SQLite.

}

famous_user airbus http://www.airbus.com/ airbus2.gif {


  [http://www.airbus.com/ | Airbus] confirms that SQLite is being
  used in the flight software for the 
  [http://www.airbus.com/en/aircraftfamilies/a350 | A350 XWB] family
  of aircraft.

}

famous_user apple http://www.apple.com/ apple.gif {



  [http://www.apple.com/ | Apple] uses SQLite in many (most?) of the
  native applications running on Mac OS-X desktops and servers and
  on iOS devices such as iPhones and iPods.  SQLite is also used in
  [http://www.apple.com/itunes/ | iTunes], even on non-Apple hardware.

}

famous_user bentley http://www.bentley.com/ bentley.gif {



  [http://www.bentley.com/ | Bentley Systems] uses SQLite as the
  [affshort | application file format] for their
  [https://www.bentley.com/en/products/product-line/modeling-and-visualization-software/microstation | Microstation]
  CAD/CAM product.

}

famous_user bosch http://oss.bosch-cm.com/index.html bosch_logo1.gif {



  [http://www.bosch.com/ | Bosch] uses SQLite in the multimedia
  systems install on GM, Nissan, and Suzuki automobiles.
  (<a href="http://oss.bosch-cm.com/index.html">link</a>)

}

famous_user dropbox http://www.dropbox.com/ dropbox.gif {




  The increasingly popular [http://www.dropbox.com/ | Dropbox] file
  archiving and synchronization service is reported to use SQLite as
  the primary data store on the client side.

}

famous_user expensify https://www.expensify.com/ expensify.png {




  [https://www.expensify.com/ | Expensify] uses SQLite as a server-side
  database engine for their enterprise-scale expense reporting software.

}


famous_user facebook https://www.facebook.com/ fb.gif {




  [https://www.facebook.com/ | Facebook] uses SQLite as the SQL database
  engine in their 
  [https://code.facebook.com/projects/658950180885092 | osquery] product.

}


famous_user mozilla http://www.mozilla.com/ firefox.gif {




  SQLite is the primary meta-data storage format for
  the [http://www.mozilla.com/ | Firefox Web Browser] and the
  [http://www.mozilla.com/thunderbird/ | Thunderbird Email Reader] from
  Mozilla.

}





famous_user flame http://en.wikipedia.org/wiki/Flame_%28malware%29 flame.gif {
  <a href="http://en.wikipedia.org/wiki/Flame_%28malware%29">Flame</a>
  is a malware spy program that is reported to make heavy use of SQLite.

}


famous_user ge http://www.ge.com/ ge.gif {


  We believe that [http://www.ge.com/ | General Electric]
  uses SQLite in some product or 

  another because they written to the SQLite developers at 
  least four separate times requesting 
  the US Export Control Number for SQLite. So presumably GE is using
  SQLite in something that they are exporting. But nobody
  (outside of GE) seems to know what that might be.

}






famous_user google http://www.google.com/ google.gif {
  uses SQLite in their 
  in the [http://code.google.com/android/ | Android] cell-phone 
  operating system, and in the 
  [http://www.google.com/chrome | Chrome Web Browser].

}

famous_user intuit http://www.intuit.com/ intuit.gif {


  [http://www.intuit.com/ | Intuit] apparently uses SQLite in 
  [http://www.quickbooks.com/ | QuickBooks] and in
  [http://turbotax.intuit.com/ | TurboTax] to judge from some error
  reports from users seen 
  [http://community.intuit.com/posts/database-error-sqlite-error-code1 | here] and
  [https://ttlc.intuit.com/post/show_full/cJf8mIhC4r4jjracfArQzM/when-i-try-to-update-turbotax-i-receive-an-unexpected-error-message | here].

}

famous_user mcafee http://www.mcafee.com/ mcaffee.gif {


  [http://www.mcafee.com/ | McAfee] uses SQLite in its antivirus 
  programs.  
  Mentioned [http://www.mail-archive.com/sqlite-users@sqlite.org/msg16931.html | here] and implied 
  [http://forums.mcafeehelp.com/showthread.php?t=173519 | here].

}


famous_user microsoft http://www.microsoft.com/ microsoft.gif {



  [http://www.microsoft.com/ | Microsoft] uses SQLite as a core component
  of Windows 10, and in other products.

}


famous_user nds http://www.nds-association.org/ nds.png {



  [http://www.nds-association.org/ | The Navigation Data Stanard] uses 
  SQLite as its [affshort | application file format].

}


famous_user php http://www.php.net/ php.gif {



  The popular [http://www.php.net/ | PHP]
  programming language comes with both SQLite2 and SQLite3 built in.

}

famous_user python http://www.python.org/ python.gif {


  SQLite comes bundled with the 
  [http://docs.python.org/lib/module-sqlite3.html | Python]
  programming language since Python 2.5.

}




famous_user xojo http://www.xojo.com/ xojo.png {
  SQLtie comes bundled with the [http://www.xojo.com/|Xojo]
  programming environment
  (formerly [http://www.realbasic.com/ | REALbasic])



}

famous_user rpm https://en.wikipedia.org/wiki/RPM_Package_Manager rpm_logo.png {


  The [https://en.wikipedia.org/wiki/RPM_Package_Manager | RedHat Package Manager (RPM)]
  uses SQLite to track its state.

}

famous_user skype http://www.skype.com/ skype.gif {


  There are 
  [http://www.mail-archive.com/sqlite-users%40sqlite.org/msg27326.html | multiple]
  [http://www.mail-archive.com/sqlite-users%40sqlite.org/msg27332.html|sightings]
  of SQLite in the Skype client for Mac OS X and Windows.

}

famous_user tcl http://www.tcl-lang.org/ tcl.gif {


  The Tcl/Tk programming language now comes with SQLite built-in.  SQLite works
  particularly well with Tcl since SQLite was originally a Tcl extension that
  subsequently "escaped" into the wild.

}

hd_putsnl "<div class='mobileonly'>"
foreach entry [lsort -index 0 $lx] {
  foreach {key url logo verbage} $entry break
  hd_putsnl "<hr class='xhr'>"
  hd_putsnl "<center><a href='$url' border=0>"
  hd_putsnl "<img src='images/foreignlogos/$logo' width=215></a></center>"
  hd_resolve "<p>$verbage</p>\n\n"
}
hd_putsnl </div>
hd_putsnl "<div class='desktoponly'>"
hd_putsnl "<table border=0 cellpadding=15>"
foreach entry [lsort -index 0 $lx] {
  foreach {key url logo verbage} $entry break
  hd_putsnl "<tr><td valign='top'>"


  hd_putsnl "<a href='$url' border=0>"
  hd_putsnl "<img src='images/foreignlogos/$logo' width=215></a>"
  hd_putsnl "</td><td valign='top'>"





  hd_resolve "$verbage"
  hd_putsnl "</td></tr>"
}
hd_putsnl "</table>"
hd_putsnl "</div>"
</tcl>