Documentation Source Text

Check-in [bf79c7d26b]
Login

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

Overview
Comment:Updates to the famous users list.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: bf79c7d26b6321f94a0e56855ecd455e2d39c501
User & Date: drh 2015-12-09 14:13:17.465
Context
2015-12-11
15:50
Improved javascript for randomizing the order of sponsor icons. Remove the document.write() calls. (check-in: 4f106d99e8 user: drh tags: trunk)
2015-12-09
14:13
Updates to the famous users list. (check-in: bf79c7d26b user: drh tags: trunk)
11:51
Merge the revised sponsor icon layout into trunk. (check-in: 7251ac0674 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Added images/foreignlogos/rpm_logo.png.

cannot compute difference between binary files

Changes to pages/famous.in.
1
2
3






4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
<title>Well-Known Users Of SQLite</title>

<h2>Well-Known Users of SQLite:</h2>







<p>
A few of the better-known users of SQLite are shown below
in alphabetical order.
There is no complete list of projects and companies
that use SQLite.
SQLite is in the 
<a href="copyright.html">public domain</a> and so many groups use SQLite
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>


|
>
>
>
>
>
>




|
<

|
|







1
2
3
4
5
6
7
8
9
10
11
12
13
14

15
16
17
18
19
20
21
22
23
24
<title>Well-Known Users Of SQLite</title>

<h2>Well-Known Users of SQLite</h2>

<p>
SQLite is used by literally millions of applications
with literally billions and billions of deployments.
SQLite is the [most widely deployed] database engine in the
world today.

<p>
A few of the better-known users of SQLite are shown below
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>
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
</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 for many functions 
within Mac OS X, including 
[http://www.apple.com/macosx/features/mail.html | Apple Mail], 
[http://www.apple.com/macosx/features/safari.html | Safari], 
and in [http://www.apple.com/aperture/ | Aperture].
Apple uses SQLite in
the [http://www.apple.com/iphone/ | iPhone] and in the
[http://www.apple.com/ipodtouch/ | iPod touch] and in



[http://www.apple.com/itunes/ | iTunes] software.



</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">







<
<





|
|
|
|
|
|
|
|
>
>
>
|
>
>
>







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
</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">
74
75
76
77
78
79
80























81
82
83
84
85
86
87
</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="http://www.mozilla.com/">
<img src="images/foreignlogos/firefox.gif" border="0">
</a>
</td>
<td>







>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







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
</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>
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


<tr><td valign="top">
<a href="http://www.google.com/">
<img src="images/foreignlogos/google.gif" border="0"></a>
</td>
<td>
It is known that
[http://www.google.com/ | Google]
uses SQLite in their 
[http://desktop.gooogle.com/mac/legal.html | Desktop for Mac],
in [http://code.google.com/apis/gears/api_database.html | Google Gears],
in the [http://code.google.com/android/ | Android] cell-phone 
operating system, and in the 
[http://www.google.com/chrome | Chrome Web Browser].
People are suspicious that Google uses SQLite for lots of other things
that we do not know about yet.
Engineers at Google have made extensive contributions to the
full-text search subsystem within SQLite.
</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 







<
|

<
<



<
<
<
<







147
148
149
150
151
152
153

154
155


156
157
158




159
160
161
162
163
164
165


<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 
157
158
159
160
161
162
163
164


165
166







167
168
169
170
171
172
173


<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] is known to use SQLite in


Windows 10, and there are unconfirmed reports that SQLite is used
in products like Excel for iPad.







</td>


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







|
>
>
|
|
>
>
>
>
>
>
>







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


<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>
189
190
191
192
193
194
195








196
197
198
199
200
201
202
<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">
<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]







>
>
>
>
>
>
>
>







223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
<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]
Changes to pages/index.in.
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
<p>Continuing enhancement and maintenance of SQLite is made possible
by <a href="consortium.html">SQLite Consortium</a> members, including:</p>

<a name="consortium_members"></a>
<center>
<table border="0" cellpadding="15">

<tcl>hd_puts {
<script language="JavaScript">
  var sponsors = [{


    "name":"Mozilla",
    "url":"https://www.mozilla.com/",
    "image":"mozilla.gif",
    "blurb":"Working to preserve choice and innovation on the internet."
  },{

    "name":"Bloomberg",
    "url":"https://www.bloomberg.com/",
    "image":"bloomberg.gif",
    "blurb":"A world leader in financial-information technology."
  },{

    "name":"Bentley",
    "url":"https://www.bentley.com/",
    "image":"bentley.gif",
    "blurb":"Comprehensive software solutions for Sustaining Infrastructure."
  },{

    "name":"NDS",
    "url":"http://www.nds-association.org/",
    "image":"nds.png",
    "blurb":"The leading map standard for automotive infotainment and autonomous driving."
  },{

    "name":"Expensify",
    "url":"https://www.expensify.com/",
    "image":"expensify.png",
    "size":"width=\"225\" height=\"32\"",
    "blurb":"We power the most exciting companies in the world using SQLite."
  },{

    "name":"Facebook",
    "url":"https://www.facebook.com/",
    "image":"fb.gif",
    "blurb":"Giving people the power to share and make the world more open and connected."

  }];














  var count = sponsors.length
  var len = count
  var n = 0
  var htxt = "";

  while( count>0 ){
    i = Math.floor(Math.random()*len)
    if( sponsors[i]!=null ){
      if( sponsors[i].size==null ) sponsors[i].size = "";
      var x = ((++n)%2)==1;
      if( x ) htxt += "<tr>\n";
      htxt += "<td align='center'>\n"+
         "<a href='"+sponsors[i].url+"'><img src='images/foreignlogos/"+sponsors[i].image+
         "' "+sponsors[i].size+" border='0' alt='"+sponsors[i].name+"'></a></td>";
      sponsors[i] = null
      count--
    }
  }
  document.write(htxt)
</script>
}</tcl>

</table>
</center>


</td>
<td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td>







|
|
|
>
>
|
|
|
|
<
>
|
|
|
|
<
>
|
|
|
|
<
>
|
|
|
|
<
>
|
|
|
|
|
<
>
|
|
|
|
>
|
>
>
>
>
>
>
>
>
>
>
>
|
>
>
|
<
|
|
>

|

<








|
|
|
|







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
<p>Continuing enhancement and maintenance of SQLite is made possible
by <a href="consortium.html">SQLite Consortium</a> members, including:</p>

<a name="consortium_members"></a>
<center>
<table border="0" cellpadding="15">

<tcl>
hd_puts "<script language=\"JavaScript\">\n"
set sep {var sponsors = [}
set nspons 0
foreach spons {
  {name   Mozilla
   url    https://www.mozilla.com/
   image  mozilla.gif
   blurb  "Working to preserve choice and innovation on the internet."

  }
  {name   Bloomberg
   url    https://www.bloomberg.com/
   image  bloomberg.gif
   blurb  "A world leader in financial-information technology."

  }
  {name   Bentley
   url    https://www.bentley.com/
   image  bentley.gif
   blurb  "Comprehensive software solutions for Sustaining Infrastructure."

  }
  {name   NDS
   url    http://www.nds-association.org/
   image  nds.png
   blurb  "The leading map standard for automotive infotainment and autonomous driving."

  }
  {name   Expensify
   url    https://www.expensify.com/
   image  expensify.png
   size   "width=\"225\" height=\"32\""
   blurb  "We power the most exciting companies in the world using SQLite."

  }
  {name   Facebook
   url    https://www.facebook.com/
   image  fb.gif
   blurb  "Giving people the power to share and make the world more open and connected."
  }
} {
  hd_puts $sep\173\n
  set sep ","
  unset -nocomplain x
  set x(size) {}
  array set x $spons
  hd_puts "  \"name\":\"$x(name)\",\n"
  hd_puts "  \"url\":\"$x(url)\",\n"
  hd_puts "  \"image\":\"$x(image)\",\n"
  hd_puts "  \"size\":\"[string map {\" \\\"} $x(size)]\"\n"
  hd_puts "  \175"
  incr nspons
}
unset -nocomplain x
hd_puts "\];\n"
hd_puts "var count = $nspons;\n"

hd_puts "var n = 0;\n"
hd_puts "var htxt = \"\";\n"
hd_puts [subst -nocommands -nobackslashes {
  while( count>0 ){
    i = Math.floor(Math.random()*$nspons)
    if( sponsors[i]!=null ){

      var x = ((++n)%2)==1;
      if( x ) htxt += "<tr>\n";
      htxt += "<td align='center'>\n"+
         "<a href='"+sponsors[i].url+"'><img src='images/foreignlogos/"+sponsors[i].image+
         "' "+sponsors[i].size+" border='0' alt='"+sponsors[i].name+"'></a></td>";
      sponsors[i] = null
      count--
    }
  }}]\n
hd_puts "document.write(htxt)\n"
hd_puts "</script>"
</tcl>

</table>
</center>


</td>
<td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td>
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111

<h3>Common Links</h3>

<p><ul>
<li> <a href="features.html">Features</a> </li>
<li> <a href="whentouse.html">When to use SQLite</a> </li>
<li> <a href="faq.html">Frequently Asked Questions</a> </li>
<li> <a href="famous.html">Well-known Users</a> </li>
<li> <a href="quickstart.html">Getting Started</a> </li>
<li> <a href="lang.html">SQL Syntax</a>
<ul>
<li> <a href="pragma.html#toc">Pragmas</a>
<li> <a href="lang_corefunc.html">SQL functions</a>
<li> <a href="lang_datefunc.html">Date &amp; time functions</a>
<li> <a href="lang_aggfunc.html">Aggregate functions</a>







<







112
113
114
115
116
117
118

119
120
121
122
123
124
125

<h3>Common Links</h3>

<p><ul>
<li> <a href="features.html">Features</a> </li>
<li> <a href="whentouse.html">When to use SQLite</a> </li>
<li> <a href="faq.html">Frequently Asked Questions</a> </li>

<li> <a href="quickstart.html">Getting Started</a> </li>
<li> <a href="lang.html">SQL Syntax</a>
<ul>
<li> <a href="pragma.html#toc">Pragmas</a>
<li> <a href="lang_corefunc.html">SQL functions</a>
<li> <a href="lang_datefunc.html">Date &amp; time functions</a>
<li> <a href="lang_aggfunc.html">Aggregate functions</a>