Debian Codegraph @

www/mostdeployed.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="sqlite.css" rel="stylesheet">
6 <title>Most Widely Deployed SQL Database Engine</title>
7 <!-- path= -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="index.html">
12 <img class="logo" src="images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='about.html'>About</a>
23 <li class='desktoponly'><a href="docs.html">Documentation</a>
24 <li class='desktoponly'><a href="download.html">Download</a>
25 <li class='wideonly'><a href='copyright.html'>License</a>
26 <li class='desktoponly'><a href="support.html">Support</a>
27 <li class='desktoponly'><a href="prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='about.html'>About</a>
35 <li><a href='docs.html'>Documentation</a>
36 <li><a href='download.html'>Download</a>
37 <li><a href='support.html'>Support</a>
38 <li><a href='prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118
119
120
121 <h2>Most Widely Deployed and Used Database Engine</h2>
122
123 <p>SQLite is likely used more than all other database engines
124 combined. Billions and billions of copies
125 of SQLite exist in the wild. SQLite is found in:
126
127 <ul>
128 <li>Every Android device
129 <li>Every iPhone and iOS device
130 <li>Every Mac
131 <li>Every Windows 10/11 installation
132 <li>Every Firefox, Chrome, and Safari web browser
133 <li>Every instance of Skype
134 <li>Every instance of iTunes
135 <li>Every Dropbox client
136 <li>Every TurboTax and QuickBooks
137 <li>PHP and Python
138 <li>Most television sets and set-top cable boxes
139 <li>Most automotive multimedia systems
140 <li>Countless millions of other applications
141 </ul>
142
143 <p>Since SQLite is used extensively in every smartphone, and there are
144 more than 4.0 billion (4.0e9) smartphones in active use, each holding
145 hundreds of
146 SQLite database files, it seems likely that there are over one trillion
147 (1e12) SQLite databases in active use.
148
149 <h2>Most Widely Deployed Software Module of Any Type?</h2>
150
151 <p>SQLite is probably one of the top five most deployed
152 software modules of any description.
153 Other libraries with similar reach include:
154
155 <ul>
156 <li>
157 The original <a href="http://zlib.net">zlib</a> implementation by
158 Jean-loup Gailly and Mark Adler.
159 <li>
160 The original reference implementation for
161 <a href="http://www.libpng.org">libpng</a>
162 <li>
163 Libjpeg from the <a href="http://ijg.org">Independent JPEG Group</a>
164 </ul>
165
166 <p>
167 Libc is omitted from the above list even though
168 it is more common than SQLite because
169 libc is not a single software component but rather several
170 competing implementations (ex: BSD vs. GNU) with similar interfaces.
171 There are also independent implementations of libjpeg and libpng,
172 though in those cases the canonical implementations are very popular.
173 </p>
174
175 <p>
176 Precise numbers are difficult to obtain and so exact rankings
177 are impossible. But our best guess is that SQLite is the second
178 mostly widely deployed software library, after libz.
179 Some commentators observe that SQLite tends
180 to be statically linked and thus have multiple instances on
181 each machine, whereas libz tends to have just
182 a single instance per machine in the form of a shared library or DLL.
183 So even though the number of devices containing libz
184 may be greater than the number of
185 devices that contain SQLite, the total number of instances per device
186 <em>might</em> be higher for SQLite and so SQLite <em>might</em>
187 be the single most widely deployed and used software component.
188 </p>
189 <p align="center"><small><i>This page was last updated on 2026-04-21 10:28:59Z </small></i></p>
190