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.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: bf79c7d26b6321f94a0e56855ecd455e2d39c501
User & Date: drh 2015-12-09 14:13:17
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
Hide Diffs Unified Diffs 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
..
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
..
74
75
76
77
78
79
80























81
82
83
84
85
86
87
...
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
...
157
158
159
160
161
162
163
164
165
166









167
168
169
170
171
172
173
...
189
190
191
192
193
194
195








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


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


<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>
................................................................................
<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]


|
>
>
>
>
>
>




|
<

|
|







 







<
<





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







 







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







 







<
|

<
<



<
<
<
<







 







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







 







>
>
>
>
>
>
>
>







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

15
16
17
18
19
20
21
22
23
24
..
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
..
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
...
147
148
149
150
151
152
153

154
155


156
157
158




159
160
161
162
163
164
165
...
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
...
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
<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>
................................................................................
</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">
................................................................................
</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>
................................................................................


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


<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>
................................................................................
<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
..
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
<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>
................................................................................

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







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

|

<








|
|
|
|







 







<







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
...
112
113
114
115
116
117
118

119
120
121
122
123
124
125
<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>
................................................................................

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