Debian Codegraph @

www/about.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>About SQLite</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 <h1 align=center>About SQLite</h1>
121
122 <div class="rightsidebar border2px">
123 <h4 align="center">Executive Summary</h4>
124 <ul>
125 <li> <a href="fullsql.html">Full-featured SQL</a>
126 <li> <a href='mostdeployed.html'>Billions and billions of deployments</a>
127 <li> <a href='onefile.html'>Single-file database</a>
128 <li> <a href='copyright.html'>Public domain source code</a>
129 <li> All source code in one file (<a href='amalgamation.html'>sqlite3.c</a>)
130 <li> <a href='footprint.html'>Small footprint</a>
131 <li> Max DB size: <a href='limits.html'>281 terabytes</a>
132 (2<sup><small>48</small></sup> bytes)
133 <li> Max row size: <a href='limits.html'>1 gigabyte</a>
134 <li> <a href='fasterthanfs.html'>Faster than direct file I/O</a>
135 <li> <a href='testing.html'>Aviation-grade quality and testing</a>
136 <li> <a href='zeroconf.html'>Zero-configuration</a>
137 <li> <a href='transactional.html'>ACID transactions, even after power loss</a>
138 <li> <a href='fileformat.html'>Stable, enduring file format</a>
139 <li> <a href='doclist.html'>Extensive, detailed documentation</a>
140 <li> <a href='lts.html'>Long-term support</a>
141 </div>
142
143 <p>SQLite is an in-process library that implements a
144 <a href="selfcontained.html">self-contained</a>,
145 <a href="serverless.html">serverless</a>,
146 <a href="zeroconf.html">zero-configuration</a>,
147 <a href="transactional.html">transactional</a>
148 SQL database engine.
149 The code for SQLite is in the
150 <a href="copyright.html">public domain</a> and is thus free for
151 use for any purpose, commercial or private.
152 SQLite is the <a href="mostdeployed.html">most widely deployed</a> database in the world
153 with more applications than we can
154 count, including several <a href="famous.html">high-profile projects.</a></p>
155
156 <p>SQLite is an embedded SQL database engine.
157 Unlike most other SQL databases, SQLite does not have a separate
158 server process. SQLite reads and writes directly to ordinary disk
159 files. A complete SQL database with multiple tables, indices,
160 triggers, and views, is contained in a single disk file.
161 The database <a href="fileformat2.html">file format</a> is cross-platform - you can freely copy a database
162 between 32-bit and 64-bit systems or between
163 <a href="http://en.wikipedia.org/wiki/Endianness">big-endian</a> and
164 <a href="http://en.wikipedia.org/wiki/Endianness">little-endian</a>
165 architectures. These features make SQLite a popular choice as
166 an <a href="appfileformat.html">Application File Format</a>. SQLite database files are a
167 <a href="locrsf.html">recommended storage format</a> by the US Library of Congress.
168 Think of SQLite not as a replacement for
169 <a href="http://www.oracle.com/database/index.html">Oracle</a> but
170 as a replacement for <a href="http://man.he.net/man3/fopen">fopen()</a></p>
171
172 <p>SQLite is a compact library.
173 With all features enabled, the <a href="footprint.html">library size</a> can be less than 900KiB,
174 depending on the target platform and compiler optimization settings.
175 (64-bit code is larger. And some compiler optimizations
176 such as aggressive function inlining and loop unrolling can cause the
177 object code to be much larger.)
178 There is a tradeoff between memory usage and speed.
179 SQLite generally runs faster the more memory
180 you give it. Nevertheless, performance is usually quite good even
181 in low-memory environments. Depending on how it is used, SQLite can be
182 <a href="fasterthanfs.html">faster than direct filesystem I/O</a>.</p>
183
184 <p>SQLite is
185 <a href="testing.html">very carefully tested</a> prior to every
186 release and has a reputation for being very reliable.
187 Most of the SQLite source code is devoted purely to testing and
188 verification. An automated test suite runs millions and millions of
189 test cases involving hundreds of millions of individual SQL statements
190 and achieves <a href="testing.html#coverage">100% branch test coverage</a>.
191 SQLite responds gracefully to memory
192 allocation failures and disk I/O errors. Transactions are
193 <a href="http://en.wikipedia.org/wiki/ACID">ACID</a>
194 even if interrupted by system crashes or power failures.
195 All of this is verified by
196 the automated tests using special test harnesses which simulate
197 system failures.
198 Of course, even with all this testing, there are still bugs.
199 But unlike some similar projects (especially commercial competitors)
200 SQLite is open and honest about all bugs and provides
201 <a href="https://sqlite.org/src/rptview?rn=1">bugs lists</a> and
202 minute-by-minute <a href="https://sqlite.org/src/timeline">
203 chronologies</a> of code changes.</p>
204
205 <p>The SQLite code base is supported by an
206 <a href="crew.html">international team</a> of developers who work on
207 SQLite full-time.
208 The developers continue to expand the capabilities of SQLite
209 and enhance its reliability and performance while maintaining
210 backwards compatibility with the
211 <a href="c3ref/intro.html">published interface spec</a>,
212 <a href="lang.html">SQL syntax</a>, and database <a href="fileformat2.html">file format</a>.
213 The source code is absolutely free to anybody who wants it,
214 but <a href="prosupport.html">professional support</a> is also available.</p>
215
216 <p>The SQLite project was started on
217 <a href="https://sqlite.org/src/timeline?c=2000-05-29+14:26:00">2000-05-09</a>.
218 The future is always hard to predict, but the intent of the developers
219 is to support SQLite through the year 2050. Design decisions are made
220 with that objective in mind.</p>
221
222 <p>We the developers hope that you find SQLite useful and we
223 entreat you to use it well: to make good and beautiful products that
224 are fast, reliable, and simple to use. Seek forgiveness for yourself
225 as you forgive others. And just as you have received SQLite for free,
226 so also freely give, paying the debt forward.</p>
227 <p align="center"><small><i>This page was last updated on 2025-11-13 07:12:58Z </small></i></p>
228