1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
3
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
4
<title>Most Widely Deployed SQL Database Engine</title>
5
<style type="text/css">
8
font-family: Verdana, sans-serif;
13
a:visited { color: #734559 }
15
.logo { position:absolute; margin:3px; }
31
.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }
32
.toolbar a:visited { color: white; }
33
.toolbar a:hover { color: #044a64; background: white; }
35
.content { margin: 5%; }
36
.content dt { font-weight:bold; }
37
.content dd { margin-bottom: 25px; margin-left:20%; }
38
.content ul { padding:0px; padding-left: 15px; margin:0px; }
41
.se { background: url(images/se.gif) 100% 100% no-repeat #044a64}
42
.sw { background: url(images/sw.gif) 0% 100% no-repeat }
43
.ne { background: url(images/ne.gif) 100% 0% no-repeat }
44
.nw { background: url(images/nw.gif) 0% 0% no-repeat }
46
/* Things for "fancyformat" documents start here. */
47
.fancy img+p {font-style:italic}
48
.fancy .codeblock i { color: darkblue; }
49
.fancy h1,.fancy h2,.fancy h3,.fancy h4 {font-weight:normal;color:#044a64}
50
.fancy h2 { margin-left: 10px }
51
.fancy h3 { margin-left: 20px }
52
.fancy h4 { margin-left: 30px }
53
.fancy th {white-space:nowrap;text-align:left;border-bottom:solid 1px #444}
54
.fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top}
55
.fancy #toc a { color: darkblue ; text-decoration: none }
56
.fancy .todo { color: #AA3333 ; font-style : italic }
57
.fancy .todo:before { content: 'TODO:' }
58
.fancy p.todo { border: solid #AA3333 1px; padding: 1ex }
59
.fancy img { display:block; }
60
.fancy :link:hover, .fancy :visited:hover { background: wheat }
61
.fancy p,.fancy ul,.fancy ol { margin: 1em 5ex }
62
.fancy li p { margin: 1em 0 }
63
/* End of "fancyformat" specific rules. */
69
<div><!-- container div to satisfy validator -->
72
<img class="logo" src="images/sqlite370_banner.gif" alt="SQLite Logo"
74
<div><!-- IE hack to prevent disappearing logo--></div>
75
<div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
77
<table width=100% style="clear:both"><tr><td>
78
<div class="se"><div class="sw"><div class="ne"><div class="nw">
79
<table width=100% style="padding:0;margin:0;cell-spacing:0"><tr>
82
<a href="about.html">About</a>
83
<a href="sitemap.html">Sitemap</a>
84
<a href="docs.html">Documentation</a>
85
<a href="download.html">Download</a>
86
<a href="copyright.html">License</a>
87
<a href="news.html">News</a>
88
<a href="support.html">Support</a>
91
gMsg = "Search SQLite Docs..."
92
function entersearch() {
93
var q = document.getElementById("q");
94
if( q.value == gMsg ) { q.value = "" }
95
q.style.color = "black"
96
q.style.fontStyle = "normal"
98
function leavesearch() {
99
var q = document.getElementById("q");
100
if( q.value == "" ) {
102
q.style.color = "#044a64"
103
q.style.fontStyle = "italic"
108
<div style="padding:0 1em 0px 0;white-space:nowrap">
109
<form name=f method="GET" action="http://www.sqlite.org/search">
110
<input id=q name=q type=text
111
onfocus="entersearch()" onblur="leavesearch()" style="width:24ex;padding:1px 1ex; border:solid white 1px; font-size:0.9em ; font-style:italic;color:#044a64;" value="Search SQLite Docs...">
112
<input type=submit value="Go" style="border:solid white 1px;background-color:#044a64;color:white;font-size:0.9em;padding:0 1ex">
116
</div></div></div></div>
118
<div class=startsearch></div>
122
<h2>Most Widely Deployed SQL Database</h2>
124
<p>We <em>believe</em> that there are more copies of SQLite
125
in use around the world than any other SQL database engine,
126
and possibly all other SQL database engines combined. We cannot
127
be certain of this since we have no way of measuring either
128
the number of SQLite deployments nor the number of deployments
129
of other databases. But we believe the claim is defensible.</p>
131
<p>The belief that SQLite is the most widely deployed SQL
132
database engine stems from its use as an embedded database.
133
Other database engines, such as MySQL, PostgreSQL, or Oracle,
134
are typically found one to a server. And usually a single
135
server can serve multiple users. With SQLite, on the other
136
hand, a single user will typically have exclusive use of
137
multiple copies of SQLite. SQLite is used on servers, but
138
it is also used on desktop PC, and in cellphones, and PDAs,
139
and MP3-players, and set-top boxes.</p>
143
<p>At the end of 2006, there were 100 million websites on the internet.
144
<a href="http://news.netcraft.com/archives/2006/11/01/november_2006_web_server_survey.html">[1]</a>
145
Let us use that number as a proxy for the number of deployed
146
SQL database engines other than SQLite. Not every website
147
runs an SQL database engine and not every SQL database engine
148
runs a website. Larger websites run multiple
149
database engines. But the vast majority of smaller websites
150
(the long tail) share
151
a database engine with several other websites,
152
if they use a database engine at all.
153
And many large SQL database installations have nothing to do with
155
So using the number of websites as a surrogate for the number of operational
156
SQL database engines is a crude approximation, but it is the best
157
we have so we will go with it. (Readers are encouraged to submit
158
better estimates.)</p>
160
<p>Now let's consider where SQLite is used:</p>
163
<li>300 million copies of Mozilla Firefox.</li>
164
<li>20 million Mac computers, each of which contains multiple
165
copies of SQLite</li>
166
<li>20 million websites run PHP which has SQLite built in.
167
<a href="http://www.php.net/usage.php">[3]</a> We have no
168
way of estimating what fraction of those sites actively use
169
SQLite, but we think it is a significant fraction.</li>
170
<li>450 million registered <a href="http://www.skype.com/">Skype</a> users.</li>
171
<li>20 million Symbian smartphones shipped in Q3 2007
172
<a href="http://www.symbian.com/news/pr/2007/pr20079552.html">[5]</a>
173
Newer versions of the SymbianOS have SQLite built in. It is unclear
174
exactly how many Symbian phones actually contain SQLite, so we will
175
use a single quarter's sales as a lower bound.</li>
176
<li>10 million Solaris 10 installations, all of which require SQLite in
178
<li>Millions and millions of copies of
179
<a href="http://www.mcafee.com/">McAfee</a> anti-virus software all
180
use SQLite internally.</li>
181
<li>Millions of iPhones use SQLite</li>
182
<li>Millions and millions of other cellphones from
183
manufactures other than Symbian and Apple use SQLite.
184
This has not been publicly acknowledged by the manufactures
185
but it is known to the SQLite developers.</li>
186
<li>There are perhaps millions of additional deployments of
187
SQLite that the SQLite developers do not know about.</li>
191
By these estimates, we see at least 500 million SQLite deployments
192
and about 100 million deployments of other SQL database engines. These
193
estimates are obviously very rough and may be off significantly.
194
But there is a wide margin. So the SQLite
195
developers think it is likely that SQLite is the most widely deployed
196
SQL database engine in the world.