Debian Codegraph @

www/doclist.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>Alphabetical List Of SQLite Documents</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 <h2 align=center>Alphabetical List Of Documents</h1>
120
121
122 <var class="rightsidebar border2px desktoponly">
123 See Also:
124 <ul>
125 <li><a href="docs.html">Categorical Document List</a>
126 <li><a href="books.html">Books About SQLite</a>
127 <li><a href="sitemap.html">Permuted Title Index</a>
128 <li><a href="keyword_index.html">Website Keyword Index</a>
129 </ul>
130 </var>
131
132 <ol>
133 <li><a href="fasterthanfs.html">35% Faster Than The Filesystem</a></li>
134 <li><a href="shortnames.html">8+3 Filenames</a></li>
135 <li><a href="about.html">About SQLite</a></li>
136 <li><a href="doclist.html">Alphabetical List Of SQLite Documents</a></li>
137 <li><a href="lang_altertable.html">ALTER TABLE</a></li>
138 <li><a href="cintro.html">An Introduction To The SQLite C/C++ Interface</a></li>
139 <li><a href="lang_analyze.html">ANALYZE</a></li>
140 <li><a href="https://sqlite.org/android/">Android Bindings</a></li>
141 <li><a href="appfunc.html">Application-Defined SQL Functions</a></li>
142 <li><a href="whentouse.html">Appropriate Uses For SQLite</a></li>
143 <li><a href="arch.html">Architecture of SQLite</a></li>
144 <li><a href="atomiccommit.html">Atomic Commit In SQLite</a></li>
145 <li><a href="lang_attach.html">ATTACH DATABASE</a></li>
146 <li><a href="undoredo.html">Automatic Undo/Redo With SQLite</a></li>
147 <li><a href="aff_short.html">Benefits of SQLite As A File Format</a></li>
148 <li><a href="books.html">Books About SQLite</a></li>
149 <li><a href="tcljson.html">Bridging Tcl and JSON with the SQLite Extension</a></li>
150 <li><a href="lang_aggfunc.html">Built-in Aggregate Functions</a></li>
151 <li><a href="lang_mathfunc.html">Built-In Mathematical SQL Functions</a></li>
152 <li><a href="lang_corefunc.html">Built-In Scalar SQL Functions</a></li>
153 <li><a href="capi3ref.html">C/C++ Interface For SQLite Version 3</a></li>
154 <li><a href="capi3.html">C/C++ Interface For SQLite Version 3 (old)</a></li>
155 <li><a href="pgszchng2016.html">Change in Default Page Size in SQLite Version 3.12.0</a></li>
156 <li><a href="withoutrowid.html">Clustered Indexes and the WITHOUT ROWID Optimization</a></li>
157 <li><a href="cli.html">Command Line Shell For SQLite</a></li>
158 <li><a href="compile.html">Compile-time Options</a></li>
159 <li><a href="conflict.html">Constraint Conflict Resolution in SQLite</a></li>
160 <li><a href="lang_createindex.html">CREATE INDEX</a></li>
161 <li><a href="lang_createtable.html">CREATE TABLE</a></li>
162 <li><a href="lang_createtrigger.html">CREATE TRIGGER</a></li>
163 <li><a href="lang_createview.html">CREATE VIEW</a></li>
164 <li><a href="lang_createvtab.html">CREATE VIRTUAL TABLE</a></li>
165 <li><a href="custombuild.html">Custom Builds Of SQLite</a></li>
166 <li><a href="fileformat2.html">Database File Format</a></li>
167 <li><a href="lang_naming.html">Database Object Name Resolution</a></li>
168 <li><a href="rsync.html">Database Remote-Copy Tool For SQLite</a></li>
169 <li><a href="datatype3.html">Datatypes In SQLite</a></li>
170 <li><a href="datatypes.html">Datatypes In SQLite version 2</a></li>
171 <li><a href="lang_datefunc.html">Date And Time Functions</a></li>
172 <li><a href="security.html">Defense Against The Dark Arts</a></li>
173 <li><a href="lang_delete.html">DELETE</a></li>
174 <li><a href="lang_detach.html">DETACH</a></li>
175 <li><a href="deterministic.html">Deterministic SQL Functions</a></li>
176 <li><a href="different.html">Distinctive Features Of SQLite</a></li>
177 <li><a href="lang_dropindex.html">DROP INDEX</a></li>
178 <li><a href="lang_droptable.html">DROP TABLE</a></li>
179 <li><a href="lang_droptrigger.html">DROP TRIGGER</a></li>
180 <li><a href="lang_dropview.html">DROP VIEW</a></li>
181 <li><a href="malloc.html">Dynamic Memory Allocation In SQLite</a></li>
182 <li><a href="lang_explain.html">EXPLAIN</a></li>
183 <li><a href="eqp.html">EXPLAIN QUERY PLAN</a></li>
184 <li><a href="features.html">Features Of SQLite</a></li>
185 <li><a href="formatchng.html">File Format Changes in SQLite</a></li>
186 <li><a href="lockingv3.html">File Locking And Concurrency In SQLite Version 3</a></li>
187 <li><a href="floatingpoint.html">Floating Point Numbers</a></li>
188 <li><a href="fullsql.html">Full-Featured SQL</a></li>
189 <li><a href="gencol.html">Generated Columns</a></li>
190 <li><a href="hirely.html">High Reliability</a></li>
191 <li><a href="debugging.html">Hints for Debugging SQLite</a></li>
192 <li><a href="chronology.html">History Of SQLite Releases</a></li>
193 <li><a href="testing.html">How SQLite Is Tested</a></li>
194 <li><a href="howitworks.html">How SQLite Works</a></li>
195 <li><a href="howtocompile.html">How To Compile SQLite</a></li>
196 <li><a href="howtocorrupt.html">How To Corrupt An SQLite Database File</a></li>
197 <li><a href="getthecode.html">How To Download Canonical SQLite Source Code</a></li>
198 <li><a href="limits.html">Implementation Limits For SQLite</a></li>
199 <li><a href="imposter.html">Imposter Tables</a></li>
200 <li><a href="inmemorydb.html">In-Memory Databases</a></li>
201 <li><a href="expridx.html">Indexes On Expressions</a></li>
202 <li><a href="lang_insert.html">INSERT</a></li>
203 <li><a href="intern-v-extern-blob.html">Internal Versus External BLOBs</a></li>
204 <li><a href="invalidutf.html">Invalid UTF Policy</a></li>
205 <li><a href="isolation.html">Isolation In SQLite</a></li>
206 <li><a href="json1.html">JSON Functions And Operators</a></li>
207 <li><a href="syntax.html">List of SQLite Syntax Diagrams</a></li>
208 <li><a href="vtablist.html">List Of Virtual Tables</a></li>
209 <li><a href="locrsf.html">LoC Recommended Storage Format</a></li>
210 <li><a href="lts.html">Long Term Support</a></li>
211 <li><a href="privatebranch.html">Maintaining Private Branches Of SQLite</a></li>
212 <li><a href="np1queryprob.html">Many Small Queries Are Efficient In SQLite</a></li>
213 <li><a href="cpu.html">Measuring and Reducing CPU Usage in SQLite</a></li>
214 <li><a href="mmap.html">Memory-Mapped I/O</a></li>
215 <li><a href="mostdeployed.html">Most Widely Deployed SQL Database Engine</a></li>
216 <li><a href="nulinstr.html">NUL Characters In Strings</a></li>
217 <li><a href="nulls.html">NULL Handling in SQLite</a></li>
218 <li><a href="partialindex.html">Partial Indexes</a></li>
219 <li><a href="bindptr.html">Pointer Passing Interfaces</a></li>
220 <li><a href="psow.html">Powersafe Overwrite</a></li>
221 <li><a href="pragma.html">Pragma statements supported by SQLite</a></li>
222 <li><a href="profile.html">Profiling SQL Queries</a></li>
223 <li><a href="qmplan.html">Quality Management</a></li>
224 <li><a href="lang.html">Query Language Understood by SQLite</a></li>
225 <li><a href="queryplanner.html">Query Planning</a></li>
226 <li><a href="climode.html">Query Result Formatting In The CLI</a></li>
227 <li><a href="quirks.html">Quirks, Caveats, and Gotchas In SQLite</a></li>
228 <li><a href="news.html">Recent SQLite News</a></li>
229 <li><a href="recovery.html">Recovering Data From A Corrupt SQLite Database</a></li>
230 <li><a href="lang_reindex.html">REINDEX</a></li>
231 <li><a href="changes.html">Release History Of SQLite</a></li>
232 <li><a href="lang_replace.html">REPLACE</a></li>
233 <li><a href="rescode.html">Result and Error Codes</a></li>
234 <li><a href="lang_returning.html">RETURNING</a></li>
235 <li><a href="rowvalue.html">Row Values</a></li>
236 <li><a href="rowidtable.html">Rowid Tables</a></li>
237 <li><a href="loadext.html">Run-Time Loadable Extensions</a></li>
238 <li><a href="lang_savepoint.html">Savepoints</a></li>
239 <li><a href="lang_select.html">SELECT</a></li>
240 <li><a href="lang_comment.html">SQL Comment Syntax</a></li>
241 <li><a href="omitted.html">SQL Features That SQLite Does Not Implement</a></li>
242 <li><a href="lang_expr.html">SQL Language Expressions</a></li>
243 <li><a href="sqldiff.html">sqldiff.exe: Database Difference Utility</a></li>
244 <li><a href="sqlar.html">SQLite Archive Files</a></li>
245 <li><a href="https://sqlite.org/sqlar/">SQLite Archiver (sqlar.exe)</a></li>
246 <li><a href="appfileformat.html">SQLite As An Application File Format</a></li>
247 <li><a href="autoinc.html">SQLite Autoincrement</a></li>
248 <li><a href="backup.html">SQLite Backup API</a></li>
249 <li><a href="34to35.html">SQLite Changes From Version 3.4.2 To 3.5.0</a></li>
250 <li><a href="35to36.html">SQLite Changes From Version 3.5.9 To 3.6.0</a></li>
251 <li><a href="consortium.html">SQLite Consortium</a></li>
252 <li><a href="copyright.html">SQLite Copyright</a></li>
253 <li><a href="speed.html">SQLite Database Speed Comparison</a></li>
254 <li><a href="crew.html">SQLite Developers</a></li>
255 <li><a href="docs.html">SQLite Documentation</a></li>
256 <li><a href="download.html">SQLite Download Page</a></li>
257 <li><a href="foreignkeys.html">SQLite Foreign Key Support</a></li>
258 <li><a href="faq.html">SQLite Frequently Asked Questions</a></li>
259 <li><a href="fts3.html">SQLite FTS3 and FTS4 Extensions</a></li>
260 <li><a href="fts5.html">SQLite FTS5 Extension</a></li>
261 <li><a href="index.html">SQLite Home Page</a></li>
262 <li><a href="quickstart.html">SQLite In 5 Minutes Or Less</a></li>
263 <li><a href="selfcontained.html">SQLite is a Self Contained System</a></li>
264 <li><a href="serverless.html">SQLite Is Serverless</a></li>
265 <li><a href="transactional.html">SQLite Is Transactional</a></li>
266 <li><a href="lang_keywords.html">SQLite Keywords</a></li>
267 <li><a href="footprint.html">SQLite Library Footprint</a></li>
268 <li><a href="oldnews.html">SQLite Older News</a></li>
269 <li><a href="useovernet.html">SQLite Over a Network, Caveats and Considerations</a></li>
270 <li><a href="prosupport.html">SQLite Pro Support</a></li>
271 <li><a href="requirements.html">SQLite Requirements</a></li>
272 <li><a href="session.html">SQLite Session Module C/C++ Interface</a></li>
273 <li><a href="sharedcache.html">SQLite Shared-Cache Mode</a></li>
274 <li><a href="sitemap.html">SQLite Site Map</a></li>
275 <li><a href="support.html">SQLite Support Options</a></li>
276 <li><a href="unlock_notify.html">SQLite Unlock-Notify API</a></li>
277 <li><a href="version3.html">SQLite Version 3 Overview</a></li>
278 <li><a href="printf.html">SQLite's Built-in printf()</a></li>
279 <li><a href="onefile.html">SQLite: Single File Database</a></li>
280 <li><a href="staleexpridx.html">Stale Expression Indexes</a></li>
281 <li><a href="stricttables.html">STRICT Tables</a></li>
282 <li><a href="swarmvtab.html">Swarmvtab Virtual Table</a></li>
283 <li><a href="syntaxdiagrams.html">Syntax Diagrams For SQLite</a></li>
284 <li><a href="https://system.data.sqlite.org/">System.Data.SQLite</a></li>
285 <li><a href="tempfiles.html">Temporary Files Used By SQLite</a></li>
286 <li><a href="glossary.html">Terms of Art Glossary</a></li>
287 <li><a href="th3.html">TH3</a></li>
288 <li><a href="flextypegood.html">The Advantages Of Flexible Typing</a></li>
289 <li><a href="amalg-v-canon.html">The Amalgamation Versus Canonical Sources</a></li>
290 <li><a href="base64.html">The Base64() SQL Function</a></li>
291 <li><a href="base85.html">The Base85() SQL Function</a></li>
292 <li><a href="bytecodevtab.html">The Bytecode() And Tables_Used() Table-Valued Functions</a></li>
293 <li><a href="c_interface.html">The C language interface to SQLite Version 2</a></li>
294 <li><a href="carray.html">The Carray() Table-Valued Function</a></li>
295 <li><a href="cksumvfs.html">The Checksum VFS Shim</a></li>
296 <li><a href="completion.html">The COMPLETION() Table-Valued Function</a></li>
297 <li><a href="csv.html">The CSV Virtual Table</a></li>
298 <li><a href="dbhash.html">The dbhash.exe Utility Program</a></li>
299 <li><a href="dbstat.html">The DBSTAT Virtual Table</a></li>
300 <li><a href="errlog.html">The Error And Warning Log</a></li>
301 <li><a href="https://www.fossil-scm.org/">The Fossil Version Control System</a></li>
302 <li><a href="series.html">The generate_series Table-Valued Function</a></li>
303 <li><a href="geopoly.html">The Geopoly Interface To The SQLite R*Tree Module</a></li>
304 <li><a href="lang_indexedby.html">The INDEXED BY Clause</a></li>
305 <li><a href="lemon.html">The Lemon LALR(1) Parser Generator</a></li>
306 <li><a href="queryplanner-ng.html">The Next-Generation Query Planner</a></li>
307 <li><a href="lang_conflict.html">The ON CONFLICT Clause</a></li>
308 <li><a href="percentile.html">The Percentile Extension</a></li>
309 <li><a href="rbu.html">The RBU Extension</a></li>
310 <li><a href="schematab.html">The Schema Table</a></li>
311 <li><a href="sessionintro.html">The Session Extension</a></li>
312 <li><a href="spellfix1.html">The Spellfix1 Virtual Table</a></li>
313 <li><a href="amalgamation.html">The SQLite Amalgamation</a></li>
314 <li><a href="opcode.html">The SQLite Bytecode Engine</a></li>
315 <li><a href="vfs.html">The SQLite OS Interface or "VFS"</a></li>
316 <li><a href="optoverview.html">The SQLite Query Optimizer Overview</a></li>
317 <li><a href="rtree.html">The SQLite R*Tree Module</a></li>
318 <li><a href="zipfile.html">The SQLite Zipfile Module</a></li>
319 <li><a href="sqlanalyze.html">The sqlite3_analyzer.exe Utility Program</a></li>
320 <li><a href="dbpage.html">The SQLITE_DBPAGE Virtual Table</a></li>
321 <li><a href="memstat.html">The SQLITE_MEMSTAT Virtual Table</a></li>
322 <li><a href="stmt.html">The SQLITE_STMT Virtual Table</a></li>
323 <li><a href="tclsqlite.html">The Tcl interface to the SQLite library</a></li>
324 <li><a href="uintcseq.html">The UINT Collating Sequence</a></li>
325 <li><a href="unionvtab.html">The UNION Virtual Table</a></li>
326 <li><a href="assert.html">The Use Of assert() In SQLite</a></li>
327 <li><a href="vdbe.html">The Virtual Database Engine of SQLite</a></li>
328 <li><a href="vtab.html">The Virtual Table Mechanism Of SQLite</a></li>
329 <li><a href="lang_with.html">The WITH Clause</a></li>
330 <li><a href="lang_transaction.html">Transaction</a></li>
331 <li><a href="uri.html">Uniform Resource Identifiers</a></li>
332 <li><a href="lang_update.html">UPDATE</a></li>
333 <li><a href="lang_upsert.html">UPSERT</a></li>
334 <li><a href="threadsafe.html">Using SQLite In Multi-Threaded Applications</a></li>
335 <li><a href="lang_vacuum.html">VACUUM</a></li>
336 <li><a href="versionnumbers.html">Version Numbers in SQLite</a></li>
337 <li><a href="cves.html">Vulnerabilities</a></li>
338 <li><a href="walformat.html">WAL-mode File Format</a></li>
339 <li><a href="keyword_index.html">Website Keyword Index</a></li>
340 <li><a href="famous.html">Well-Known Users Of SQLite</a></li>
341 <li><a href="affcase1.html">What If OpenDocument Used SQLite?</a></li>
342 <li><a href="whyc.html">Why Is SQLite Coded In C</a></li>
343 <li><a href="whynotgit.html">Why SQLite Does Not Use Git</a></li>
344 <li><a href="whybytecode.html">Why SQLite Uses Bytecode</a></li>
345 <li><a href="windowfunctions.html">Window Functions</a></li>
346 <li><a href="wal.html">Write-Ahead Logging</a></li>
347 <li><a href="zeroconf.html">Zero-Configuration</a></li>
348
349 </ol>
350
351