Debian Codegraph @

www/features.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>Features Of 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>Features Of SQLite</h1>
121
122 <p><ul>
123 <li><a href="transactional.html">Transactions</a>
124 are atomic, consistent, isolated, and durable (ACID)
125 even after system crashes and power failures.</li>
126 <li><a href="zeroconf.html">Zero-configuration</a>
127 - no setup or administration needed.</li>
128 <li><a href="fullsql.html">Full-featured SQL</a> implementation
129 with advanced capabilities like <a href="partialindex.html">partial indexes</a>,
130 <a href="expridx.html">indexes on expressions</a>, <a href="json1.html">JSON</a>,
131 <a href="lang_with.html">common table expressions</a>, and <a href="windowfunctions.html">window functions</a>.
132 (<a href="omitted.html">Omitted features</a>)</li>
133 <li>A complete database is stored in a
134 <a href="onefile.html">single cross-platform disk file</a>.
135 Great for use as an <a href="appfileformat.html">application file format</a>.</li>
136 <li>Supports terabyte-sized databases and gigabyte-sized strings
137 and blobs. (See <a href="limits.html">limits.html</a>.)
138 <li>Small code <a href="footprint.html">footprint</a>:
139 less than 900KiB fully configured or much less
140 with optional features omitted.</li>
141 <li>Simple, easy to use <a href="cintro.html">API</a>.</li>
142 <li>Fast: In some cases, SQLite is
143 <a href="fasterthanfs.html">faster than direct filesystem I/O</a>
144 <li>Written in ANSI-C. <a href="tclsqlite.html">TCL bindings</a> included.
145 Bindings for dozens of other languages available separately.</li>
146 <li>Well-commented source code with
147 <a href="testing.html#coverage">100% branch test coverage</a>.</li>
148 <li>Available as a
149 <a href="amalgamation.html">single ANSI-C source-code file</a>
150 that is <a href="howtocompile.html">easy to compile</a> and hence is easy
151 to add into a larger project.
152 <li><a href="selfcontained.html">Self-contained</a>:
153 no external dependencies.</li>
154 <li>Cross-platform: Android, *BSD, iOS, Linux, Mac, Solaris, VxWorks,
155 and Windows (Win32, WinCE, WinRT)
156 are supported out of the box. Easy to port to other systems.
157 <li>Sources are in the <a href="copyright.html">public domain</a>.
158 Use for any purpose.</li>
159 <li>Comes with a standalone <a href="cli.html">command-line interface</a>
160 (CLI) client that can be used to administer SQLite databases.</li>
161 </ul>
162 </p>
163
164 <h2>Suggested Uses For SQLite:</h2>
165
166 <p><ul>
167 <li><p><b>Database For The Internet Of Things.</b>
168 SQLite is a popular choice for the database engine in cellphones,
169 PDAs, MP3 players, set-top boxes, and other electronic gadgets.
170 SQLite has a small code footprint, makes efficient use of memory,
171 disk space, and disk bandwidth, is highly reliable, and requires
172 no maintenance from a Database Administrator.</p></li>
173
174 <li><p><b>Application File Format.</b>
175 Rather than using fopen() to write XML, JSON, CSV,
176 or some proprietary format into
177 disk files used by your application, use an SQLite database.
178 You'll avoid having to write and troubleshoot a parser, your data
179 will be more easily accessible and cross-platform, and your updates
180 will be transactional. (<a href="appfileformat.html">more...</a>)</p></li>
181
182 <li><p><b>Website Database.</b>
183 Because it requires no configuration and stores information in ordinary
184 disk files, SQLite is a popular choice as the database to back small
185 to medium-sized websites.</p></li>
186
187 <li><p><b>Stand-in For An Enterprise RDBMS.</b>
188 SQLite is often used as a surrogate for an enterprise RDBMS for
189 demonstration purposes or for testing. SQLite is fast and requires
190 no setup, which takes a lot of the hassle out of testing and which
191 makes demos perky and easy to launch.</p></li>
192
193 <li><p><a href="./whentouse.html">More suggestions...</a></p></li>
194 </ul>
195 <p align="center"><small><i>This page was last updated on 2025-11-13 07:12:58Z </small></i></p>
196