Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Changes In Branch mobile-friendly
Excluding Merge-Ins
This is equivalent to a diff from
363a0d0503
to 6fc0f8db82
|
2016-09-02
| | |
| 14:38 |
|
(check-in: 8e1edafe16 user: drh tags: trunk)
|
| 12:22 |
|
(Closed-Leaf
check-in: 6fc0f8db82 user: drh tags: mobile-friendly)
|
| 12:17 |
|
(check-in: ec9d984cb5 user: drh tags: mobile-friendly)
|
|
2016-08-31
| | |
| 16:53 |
|
(check-in: 78f2f948fb user: dan tags: trunk)
|
| 12:02 |
|
(check-in: b24301fa11 user: drh tags: mobile-friendly)
|
| 10:07 |
|
(check-in: 363a0d0503 user: drh tags: trunk)
|
| 07:00 |
|
(check-in: 1e433b2be3 user: dan tags: trunk)
|
| | |
Added common_links.tcl.
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
|
proc common_links {} {
hd_puts \
{<ul class=nounderline>
<li> <a href="features.html">Features</a> </li>
<li> <a href="whentouse.html">When to use SQLite</a> </li>
<li> <a href="faq.html">Frequently Asked Questions</a> </li>
<li> <a href="quickstart.html">Getting Started</a> </li>
<li> <a href="chronology.html">Prior Releases</a>
<li> <a href="lang.html">SQL Syntax</a>
<ul>
<li> <a href="pragma.html#toc">Pragmas</a>
<li> <a href="lang_corefunc.html">SQL functions</a>
<li> <a href="lang_datefunc.html">Date & time functions</a>
<li> <a href="lang_aggfunc.html">Aggregate functions</a>
<li> <a href="json1.html">JSON functions</a>
</ul>
</li>
<li> <a href="c3ref/intro.html">C/C++ Interface Spec</a>
<ul>
<li> <a href="cintro.html">Introduction</a>
<li> <a href="c3ref/funclist.html">List of C-language APIs</a>
</ul>
</li>
<li> <a href="tclsqlite.html">The TCL Interface Spec</a>
<li> <a href="http://www.sqlite.org/src/timeline">Commit History</a> </li>
<li> <a href="http://www.sqlite.org/src/wiki?name=Bug+Reports">Report a Bug</a> </li>
<li> <a href="news.html">News</a> </li>
</ul>
}
}
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | |
Changes to document_header.tcl.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
|
+
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
+
-
-
-
-
+
+
+
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
-
|
proc document_header {title path {search {}}} {
set ret [subst -nocommands {
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html><head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<link href="${path}sqlite.css" rel="stylesheet">
<title>$title</title>
<style type="text/css">
body {
margin: auto;
font-family: Verdana, sans-serif;
padding: 8px 1%;
}
.nounderline a { text-decoration: none }
a { color: #044a64 }
a:visited { color: #734559 }
.logo { position:absolute; margin:3px; }
.tagline {
float:right;
text-align:right;
font-style:italic;
width:300px;
margin:12px;
margin-top:58px;
}
.menubar {
clear: both;
border-radius: 8px;
background: #044a64;
padding: 0px;
margin: 0px;
cell-spacing: 0px;
}
.toolbar {
text-align: center;
line-height: 1.6em;
margin: 0;
padding: 0px 8px;
}
.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }
.toolbar a:visited { color: white; }
.toolbar a:hover { color: #044a64; background: white; }
.content { margin: 5%; }
.content dt { font-weight:bold; }
.content dd { margin-bottom: 25px; margin-left:20%; }
.content ul { padding:0px; padding-left: 15px; margin:0px; }
/* Things for "fancyformat" documents start here. */
.fancy img+p {font-style:italic}
.fancy .codeblock i { color: darkblue; }
.fancy h1,.fancy h2,.fancy h3,.fancy h4 {font-weight:normal;color:#044a64}
.fancy h2 { margin-left: 10px }
.fancy h3 { margin-left: 20px }
.fancy h4 { margin-left: 30px }
.fancy th {white-space:xnowrap;text-align:left;border-bottom:solid 1px #444}
.fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top}
.fancy .toct { color: #044a64 ! important }
.fancy #toc a { color: darkblue ; text-decoration: none }
.fancy .todo { color: #AA3333 ; font-style : italic }
.fancy .todo:before { content: 'TODO:' }
.fancy p.todo { border: solid #AA3333 1px; padding: 1ex }
.fancy img { display:block; }
.fancy :link:hover, .fancy :visited:hover { background: wheat }
.fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex }
.fancy li p { margin: 1em 0 }
.fancy blockquote { margin-left : 10ex }
/* End of "fancyformat" specific rules. */
.yyterm {
background: #fff;
border: 1px solid #000;
border-radius: 11px;
padding-left: 4px;
padding-right: 4px;
}
.doccat a {
color: #044a64 ;
text-decoration: none;
}
.doccat h {
font-weight: bold;
}
.doccat h a {
font-size: smaller;
color: black;
}
.doccat {
padding-left: 2ex;
padding-right: 2ex;
white-space:nowrap;
}
.doccat li {
list-style-type: none;
font-size: smaller;
line-height: 150%;
}
.doccat ul {
margin-top: 0.5em;
}
.footer {
padding-top: 2px;
padding-bottom: 1px;
border-top: 2px solid #044a64;
}
</style>
</head>
<div><!-- container div to satisfy validator -->
<img class="logo" src="${path}images/sqlite370_banner.gif" alt="SQLite Logo"
<img class="logo" src="${path}images/sqlite370_banner.gif" alt="SQLite" border="0"></a>
border="0"></a>
<div><!-- IE hack to prevent disappearing logo--></div>
<div class="tagline">${tagline}</div>
<table width=100% class="menubar"><tr>
<td width=100%>
<div class="toolbar">
<a href="${path}about.html">About</a>
<a href="${path}docs.html">Documentation</a>
<a href="${path}download.html">Download</a>
<a href="${path}copyright.html">License</a>
<a href="${path}support.html">Support</a>
<a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
</div>
}]
if {$search==""} {
set initval "Search with FTS5..."
set initstyle {font-style:italic;color:#044a64}
} else {
set initval $search
set initstyle {font-style:normal;color:black}
}
/*
** Set the cookie named "name" to value "value". Expires in "days" days.
*/
|
| ︙ | | |
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
|
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
|
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
+
+
|
/*
** Delete cookie "name".
*/
function eraseCookie(name) {
createCookie(name,"",-1);
}
gMsg = "Search with FTS5..."
function entersearch() {
var q = document.getElementById("q");
if( q.value == gMsg ) { q.value = "" }
q.style.color = "black"
q.style.fontStyle = "normal"
}
function leavesearch() {
var q = document.getElementById("q");
if( q.value == "" ) {
q.value = gMsg
q.style.color = "#044a64"
q.style.fontStyle = "italic"
}
}
<td>
<div style="padding:0 1em 0px 0;white-space:nowrap">
<form name=f method="GET" action="${path}search">
<input id=q name=q type=search
onfocus="entersearch()" onblur="leavesearch()" style="width:24ex;padding:1px 1ex; border:solid white 1px; font-size:0.9em ; $initstyle;" value="$initval">
<input type=submit value="Go" style="border:solid white 1px;background-color:#044a64;color:white;font-size:0.9em;padding:0 1ex">
</form>
</div>
</table>
</div> <!-- matches "div class=nosearch" -->
|
Changes to pages/about.in.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
-
+
-
-
+
-
-
-
-
-
-
-
-
-
-
+
-
-
-
-
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
|
<title>About SQLite</title>
<h1 align=center>About SQLite</h1>
<table align="right" border="1" cellpadding="10" hspace="20" cellspacing="0">
<div class="rightsidebar desktoponly border2px">
<tr><td>
<b>See Also...</b>
<p><ul>
<li> <a href="index.html">Home</a> </li>
<li> <a href="features.html">Features</a> </li>
<li> <a href="whentouse.html">When to use SQLite</a> </li>
<li> <a href="faq.html">Frequently Asked Questions</a> </li>
<li> <a href="famous.html">Well-known Users</a> </li>
<li> <a href="chronology.html">Prior Releases</a>
<li> <a href="quickstart.html">Getting Started</a> </li>
<li> <a href="lang.html">SQL Syntax</a>
<ul>
<li> <a href="pragma.html#toc">Pragmas</a>
<li> <a href="lang_corefunc.html">SQL functions</a>
<li> <a href="lang_datefunc.html">Date & time functions</a>
<li> <a href="lang_aggfunc.html">Aggregate functions</a>
</ul>
</li>
<li> <a href="c3ref/intro.html">C/C++ Interface Spec</a>
<ul>
<li> <a href="cintro.html">Introduction</a>
<li> <a href="c3ref/funclist.html">List of C-language APIs</a>
</ul>
</li>
<li> <a href="tclsqlite.html">The TCL Interface Spec</a>
<li> <a href="http://www.sqlite.org/src/timeline">Commit History</a> </li>
<li> <a href="http://www.sqlite.org/src/wiki?name=Bug+Reports">Report a Bug</a> </li>
<li> <a href="news.html">News</a> </li>
<li> <a href="sitemap.html">Sitemap</a> </li>
</ul></p>
</table>
|
| ︙ | | |
Changes to pages/capi3ref.in.
| ︙ | | |
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
|
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
|
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
+
-
+
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
+
+
+
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
|
set oldname [string tolower $oldname]
regsub {^sqlite_} $oldname {c_} oldname
regsub {^sqlite3_} $oldname {} oldname
regsub { } $oldname _ name
return $name.html
}
# Convert the keyword $kw into an appropriate relative URI
#
proc keyword_to_uri {kw} {
global hd llink glink
if {[string match {*.html} $kw]} {return $kw}
if {$hd(enable-main)} {
set fn $hd(fn-main)
if {[info exists llink($fn:$kw)]} {
return $hd(rootpath-main)$llink($fn:$kw)
}
if {[info exists glink($kw)]} {
return $hd(rootpath-main)$glink($kw)
}
}
if {$hd(enable-aux)} {
if {[info exists glink($kw)]} {
return $hd(rootpath-aux)$glink($kw)
}
}
return ""
}
# Output HTML that displays the list $lx in $N columns
proc output_list {title N lx} {
proc output_list_javascript {lx} {
hd_putsnl {<table width="100%" cellpadding="0"><tr>}
if {$title!=""} {
hd_putsnl "<td colspan=$N>$title</td></tr><tr>"
}
set len [llength $lx]
set n [expr {($len + $N - 1)/$N}]
for {set i 0} {$i<$N} {incr i} {
set start [expr {$i*$n}]
set end [expr {($i+1)*$n}]
hd_puts {<td valign="top"><ul>}
for {set j $start} {$j<$end} {incr j} {
set entry [lindex $lx $j]
if {$entry!=""} {
foreach {link label s} $entry break
if {$s==1} {
hd_resolve "<li>\[$link|$label\] "
hd_resolve "\[experimental | <small><i>(exp)</i></small>\]</li>"
} elseif {$s==2} {
hd_resolve "<li>\[$link|$label\] "
hd_resolve "\[deprecated | <small><i>(obs)</i></small>\]</li>"
} else {
hd_resolve "<li>\[$link|$label\]</li>"
}
hd_puts \n
}
}
hd_putsnl {</ul></td>}
}
hd_putsnl {</tr></table>}
|
| ︙ | | |
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
|
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
|
-
+
|
hd_header {List Of SQLite Objects}
hd_enable_main 0
hd_putsnl {<a href="intro.html"><h2>SQLite C Interface</h2></a>}
hd_enable_main 1
</tcl>
<h2>List Of Objects:</h2>
<tcl>
output_list "" 3 [lsort -nocase $objlist]
output_list "" 280 [lsort -nocase $objlist]
hd_enable_main 0
hd_putsnl {<p>Other lists:
<a href="constlist.html">Constants</a> and
<a href="funclist.html">Functions</a> and
<a href="../rescode.html">Result Codes</a>.}
hd_close_aux
hd_enable_main 1
|
| ︙ | | |
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
|
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
|
-
+
|
hd_putsnl {<a href="intro.html"><h2>SQLite C Interface</h2></a>}
hd_enable_main 1
</tcl>
<h2>List Of Constants:</h2>
<p>Also available: [error codes|list of error codes]</p>
<tcl>
set clist [lsort -index 1 $clist]
output_list "" 2 $clist
output_list "" 400 $clist
hd_enable_main 0
hd_putsnl {<p>Other lists:
<a href="objlist.html">Objects</a> and
<a href="funclist.html">Functions</a> and
<a href="../rescode.html">Result Codes</a>.</p>}
hd_enable_main 1
hd_close_aux
|
| ︙ | | |
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
|
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
|
-
-
-
+
+
+
-
+
|
hd_header {List Of SQLite Functions}
hd_keywords *capi3ref_funclist {C-API function list}
hd_enable_main 0
hd_putsnl {<a href="intro.html"><h2>SQLite C Interface</h2></a>}
hd_enable_main 1
</tcl>
<h2>List Of Functions:</h2>
<p>Note: Functions marked with "[experimental | <small><i>(exp)</i></small>]"
are [experimental] and functions marked with
[deprecated | <small><i>(obs)</i></small>] are [deprecated].</p>
<p>Note: Functions marked with "<small><i>(exp)</i></small>"
are [experimental] and functions whose names are
<s>struck through</s> are [deprecated].</p>
<tcl>
set funclist [lsort -index 1 $funclist]
output_list "" 3 $funclist
output_list "" 315 $funclist
hd_enable_main 0
hd_putsnl {<p>Other lists:
<a href="constlist.html">Constants</a> and
<a href="objlist.html">Objects</a> and
<a href="../rescode.html">Result Codes</a></p>}
hd_enable_main 1
hd_close_aux
|
| ︙ | | |
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
|
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
|
-
+
|
hd_puts "</p>\n"
return
}
set flst {}
foreach x $lx {
lappend flst [list $x $x 0]
}
output_list ${label}s: 3 $flst
output_list ${label}s: 350 $flst
hd_puts "</p>\n"
}
# Output all the records
#
foreach c [lsort $content] {
|
| ︙ | | |
Changes to pages/changes.in.
| ︙ | | |
4230
4231
4232
4233
4234
4235
4236
4237
4238
4239
4240
4241
4242
4243
4244
|
4230
4231
4232
4233
4234
4235
4236
4237
4238
4239
4240
4241
4242
4243
4244
|
-
+
|
foreach {date desc options} $aChng($i) break
if {[regexp {\(([0-9.]+)\)} $date all vers]} {
set label [string map {. _} $vers]
hd_fragment version_$label
}
hd_puts "<h3>$date</h3>"
regsub -all {\yROOT/} $desc {} d2
hd_resolve "<p><ul>$d2\n"
hd_resolve "<p><ul class='lessindent'>$d2\n"
foreach {key value} $options {
if {$key=="backport"} {
if {[info exists xrefChng($value)]} {set value $xrefChng($value)}
set c2 $aChng([expr {$i+$value}])
regexp {([-0-9]+) \((3\.\d+[.0-9]+)[ a-zA-Z]*\)} [lindex $c2 0] all xdate xvers
set d2 [lindex $c2 1]
regsub {(<p>[^\n]*\n)?<li>SQLITE_SOURCE_ID.*$} $d2 {} d2
|
| ︙ | | |
4261
4262
4263
4264
4265
4266
4267
4268
4269
4270
4271
4272
4273
4274
4275
4276
4277
4278
4279
4280
4281
4282
4283
4284
4285
4286
4287
4288
4289
4290
|
4261
4262
4263
4264
4265
4266
4267
4268
4269
4270
4271
4272
4273
4274
4275
4276
4277
4278
4279
4280
4281
4282
4283
4284
4285
4286
4287
4288
4289
4290
|
-
+
-
+
-
+
|
hd_enable_main 0
hd_puts "<h2>SQLite Release $vers On $dateonly</h2>"
regsub -all {<a href="(?!http:)} $desc {<a href="../} desc
foreach {key value} $options {
if {$key=="inadditionto"} {
set d2 [lindex $aChng([expr {$i+$value}]) 1]
regsub {(<p>[^\n]*\n)?<li>SQLITE_SOURCE_ID.*$} $d2 {} d2
hd_resolve "<p><ul>$d2</ul></p>"
hd_resolve "<p><ul class='lessindent'>$d2</ul></p>"
}
}
regsub -all {\yROOT/\y} $desc {../} d2
hd_resolve "<p><ul>$d2\n"
hd_resolve "<p><ul class='lessindent'>$d2\n"
foreach {key value} $options {
if {$key=="patchagainst"} {
if {[info exists xrefChng($value)]} {set value $xrefChng($value)}
set c2 $aChng([expr {$i+$value}])
regexp {([-0-9]+) \((3\.\d+[.0-9]+)[ a-zA-Z]*\)} [lindex $c2 0] all date vers
set d2 [lindex $c2 1]
regsub -all {\yROOT/} $d2 {../} d2
regsub {(<p>[^\n]*\n)?<li>SQLITE_SOURCE_ID.*$} $d2 {} d2
hd_resolve "</ul></p>\n"
hd_resolve "<p><b>Changes carried forward from version $vers ($date):</b></p>\n"
hd_resolve "<p><ul>$d2\n"
hd_resolve "<p><ul class='lessindent'>$d2\n"
}
if {$key=="backport"} {
if {[info exists xrefChng($value)]} {set value $xrefChng($value)}
set c2 $aChng([expr {$i+$value}])
regexp {([-0-9]+) \((3\.\d+\.[.0-9]+)[ a-zA-Z]*\)} [lindex $c2 0] all date vers
set d2 [lindex $c2 1]
regsub {(<p>[^\n]*\n)?<li>SQLITE_SOURCE_ID.*$} $d2 {} d2
|
| ︙ | | |
Changes to pages/copyright.in.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
+
-
-
+
+
-
-
+
+
|
<title>SQLite Copyright</title>
<tcl>hd_keywords {copyright} {public-domain} {license}</tcl>
<h2>SQLite Is Public Domain</h2>
<table align="right" vspace="0" hspace="10" border="1" cellpadding="20">
<tr><td align="center">
<div class="rightsidebar desktoponly">
<center>
<img src="images/nocopy.gif"><br>
SQLite is in the<br>
[http://en.wikipedia.org/wiki/Public_Domain | Public Domain]
</td></tr>
</table>
</center>
</div>
<p>
All of the code and documentation in SQLite has been dedicated to the
[http://en.wikipedia.org/wiki/Public_Domain|public domain]
by the authors.
All code authors, and representatives of the companies they work for,
have signed affidavits dedicating their contributions to
|
| ︙ | | |
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
|
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
|
-
+
-
-
+
-
+
-
+
-
-
+
+
|
No code has been taken from other projects or from the open
internet. Every line of code can be traced back to its original
author, and all of those authors have public domain dedications
on file. So the SQLite code base is clean and is
uncontaminated with licensed code from other projects.
</p>
<table border=0 align='right'>
<div class="rightsidebar">
<tr><td>
</table>
</div>
<h2>Obtaining An License To Use SQLite</h2>
<p>
Even though SQLite is in the public domain and does not require
a license, some users want to obtain a license anyway. Some reasons
for obtaining a license include:
</p>
<ul>
<li> Your company desires warranty of title and
<li> Your company desires warranty of title and/or
indemnity against claims of copyright infringement.
<li> You are using SQLite in a jurisdiction that does not recognize
the public domain. </li>
<li> You are using SQLite in a jurisdiction that does not recognize
the right of an author to dedicate their work to the public
domain. </li>
<li> You want to hold a tangible legal document
as evidence that you have the legal right to use and distribute
SQLite. </li>
<li> Your legal department tells you that you have to purchase a license.
</li>
</ul>
<p>
If you feel like you really need to purchase a license for SQLite,
<a href="http://www.hwaci.com/">Hwaci</a>, the company that employs
the architect and principal developers of SQLite, will
all the developers of SQLite, will
<a href="http://www.hwaci.com/cgi-bin/license-step1">sell you
one</a>.
All proceeds from the sale of SQLite licenses are used to fund further
improvements to SQLite.
All proceeds from the sale of SQLite licenses are used to fund
continuing improvement and support of SQLite.
</p>
<h2>Contributed Code</h2>
<p>
In order to keep SQLite completely free and unencumbered by copyright,
all new contributors to the SQLite code base are asked to dedicate
|
| ︙ | | |
Changes to pages/doclist.in.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
-
+
-
-
+
+
-
+
-
+
|
<title>Alphabetical List Of SQLite Documents</title>
<h1 align=center>Alphabetical List Of SQLite Documents</h1>
<h2 align=center>Alphabetical List Of Documents</h1>
<tcl>hd_keywords {*doclist}</tcl>
<table align=right border=1 cellpadding=10>
<tr><td>See Also:
<var class="rightsidebar border2px desktoponly">
See Also:
<ul>
<li>[categorical listing of SQLite documents | Categorical Document List]
<li>[books about SQLite | Books About SQLite]
<li>[permuted index | Permuted Title Index]
<li>[keyword index | Website Keyword Index]
</ul>
</table>
</var>
<ol>
<tcl>
hd_keywords {alphabetical listing of SQLite documents}
hd_keywords {alphabetical listing of documents}
db eval {
SELECT filename, pagetitle
FROM page
WHERE pagetitle IS NOT NULL AND pagetitle!='No Title'
ORDER BY pagetitle COLLATE nocase
} {
hd_puts "<li><a href=\"$filename\">$pagetitle</a></li>\n"
|
| ︙ | | |
Changes to pages/docs.in.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
|
-
-
-
-
-
+
+
+
+
+
+
+
+
+
-
-
-
-
-
+
+
+
+
+
+
+
+
-
-
+
+
+
-
-
+
-
-
-
+
+
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
+
+
-
-
-
-
-
+
+
+
-
-
-
-
+
+
+
+
+
+
+
-
-
-
+
+
+
+
+
+
-
-
-
-
+
-
+
|
<title>SQLite Documentation</title>
<h1 align="center">Categorical Index Of SQLite Documents</h1>
<table width="100%" cellpadding="5">
<tcl>
<h2 align="center">Documents By Category</h1>
<style>
.showhide {
margin-left: 0;
padding-left: 0;
list-style-type: none;
}
.showhide > li {
clear: both;
hd_keywords {categorical listing of SQLite documents}
set ::lHead [list]
proc doc {name url desc} {
proc heading {text tag {caption {}}} {
lappend ::lHead $text $tag
source [file join $::DOC pages docsdata.tcl]
hd_puts "<table align=center class=nounderline>"
set i 0
set style "\"padding-right:8ex; padding-bottom: 1em\""
foreach {text tag} $::lHead {
if {($i % 2)==0} { hd_puts <tr> }
hd_puts "<th valign=top align=left style=$style> <a href=#$tag>$text</a>"
incr i
hd_puts "</table>"
hd_puts {<tr><td valign="top" align="right" class=nounderline>}
regsub -all { +} $name {\ } name
hd_puts "<a href=\"$url\">$name</a></td>"
hd_puts {<td width="10"></td>}
hd_puts {<td valign="top" align="left">}
hd_resolve $desc
hd_puts {</td></tr>}
proc heading {text tag {caption {}}} {
hd_puts {<tr><td colspan=3 style="padding: 3ex 0 2ex 0">}
hd_puts "<b><a name=$tag></a>$text</b>"
}
proc end_heading {} {
global lDoc cnt prevHead
if {$prevHead==""} return
incr cnt
hd_puts "<li><a onclick='showhide($cnt)'>"
hd_puts "<span class='sh_mark' id='sh_mark_$cnt'>"
if {$caption ne ""} {
hd_puts {<br />}
hd_puts "$caption"
hd_puts "<table width=100% cellpadding=5>"
hd_puts "</table>"
</table>
</ul>
|
Changes to pages/docsdata.tcl.
| ︙ | | |
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
+
+
+
|
}
doc {Frequently Asked Questions} {faq.html} {
The title of the document says all...
}
doc {Books About SQLite} {books.html} {
A list of independently written books about SQLite.
}
heading {Document Lists And Indexes} lists
doc {Alphabetical Listing Of Documents} {doclist.html} {
A list of all titled pages on this website, sorted by title.
}
doc {Website Keyword Index} {keyword_index.html} {
A cross-reference from keywords to various pages within this website.
}
doc {Permuted Title Index} {sitemap.html#pindex} {
|
| ︙ | | |
Changes to pages/fancyformat.tcl.
| ︙ | | |
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
-
+
|
if {$args != ""} {
#puts $args
set ::hd(fragment) $zName
eval hd_keywords $args
}
append ::TOC [subst {
<div style="margin-left:[expr $iLevel*6]ex">
<div class="fancy-toc$iLevel">
<a href="#$zName">${zNumber} $zTitle</a>
</a></div>
}]
return "<h$iLevel id=\"$zName\">$zNumber $zTitle</h$iLevel>\n"
}
proc h1 {args} {uplevel H 1 $args}
|
| ︙ | | |
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
|
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
|
-
+
-
-
+
-
+
-
-
-
-
-
+
+
+
+
+
+
+
+
-
-
+
+
-
-
-
-
-
-
-
+
+
|
append ret "</p>"
}
set ::Requirements [list]
proc CodeBlock {txt} {
set txt [string trim $txt "\n"]
set out {<div class=codeblock style="margin:0 15ex">}
set out {<div class=codeblock><pre>}
append out {<table width=100% style="border:1px solid #80a796;padding:0 1ex;background-color:#EEEEEE"><tr><td><pre style="font-size:1.1em">}
append out "</pre></table></div>"
append out "</pre></div>"
return $out
}
#-------------------------------------------------------------------------
# Return the <script>...</script> block containing the code for persistent
# show/hide on the TOC block. This is inserted into each page immediately
# after the "Table Of Contents" block.
#
proc javascript_toc_toggle {} {
return {
set x {
<script>
function hide_toc(){
var toc = document.getElementById('toc');
var antitoc = document.getElementById('antitoc');
toc.style.display = 'none';
antitoc.style.display = '';
function toggle_toc(){
var sub = document.getElementById("toc_sub")
var mk = document.getElementById("toc_mk")
if( sub.style.display!="block" ){
sub.style.display = "block";
mk.innerHTML = "▼";
} else {
sub.style.display = "none";
eraseCookie('showtoc');
}
function show_toc(){
var toc = document.getElementById('toc');
var antitoc = document.getElementById('antitoc');
toc.style.display = '';
antitoc.style.display = 'none';
createCookie('showtoc', 1, 365);
if( readCookie('showtoc') ) show_toc();
|
| ︙ | | |
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
|
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
|
-
+
|
set D(id) "section_[string map {. _} [string range $HN 0 end-1]]"
} else {
set D(id) "notoc[incr G(notoccounter)]"
}
}
# Append the entry to the table-of-contents.
append G(toc) "<div style=\"margin-left:[expr $level*6]ex\">"
append G(toc) "<div class=\"fancy-toc$level\">"
append G(toc) "<a href=\"#$D(id)\">$HN "
set G(inHeading) 1
}
catch { unset D(nonumber) }
catch { unset D(notoc) }
# If there is a "tags" attribute, then add an [hd_fragment] command
|
| ︙ | | |
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
|
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
|
-
+
|
append G(doc) [formattag $tag [array get D]]
append G(doc) "$HN "
}
/h[1-6] { ;# End of current heading.
if {$::Addtoc(inHeading)} {
append G(toc) "</a></div>"
append G(toc) "</a></div>\n"
}
set G(inHeading) 0
append G(doc) [formattag $tag $details]
}
title {
set G(inTitle) 1
|
| ︙ | | |
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
|
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
|
-
-
-
-
+
+
+
-
-
+
+
-
-
-
-
-
+
-
-
-
-
-
|
# before it. This stops the table of contents from being used for
# snippets on search results pages.
#
set toc [subst {
<div class=fancy>
<div class=nosearch>
<div style="font-size:2em;text-align:center;color:#044a64">
$::Addtoc(title)
</div>
<div id=toc style="display:none">
<div style="margin:1em;color:#044a64">
<span style="font-size:1.5em">Table Of Contents</span>
<a class=toct style="margin-left:4ex" href="#" onclick="hide_toc()">
[hide]
</a>
</div>
$::Addtoc(toc)
</div>
<div id=antitoc>
<a class=toct style="margin-left:4ex" href="#" onclick="show_toc()">
[show table of contents]
</a>
|
| ︙ | | |
Changes to pages/index.in.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
-
-
-
+
+
+
+
+
+
-
-
-
+
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
-
+
+
+
+
+
-
+
+
+
+
+
+
-
-
-
-
+
+
+
+
+
+
+
+
+
|
<title>SQLite Home Page</title>
<table border="0" width="100%">
<tr><td valign="top" width="65%">
<p>SQLite is a software library that implements a
<div class="rightsidebar desktoponly border2px">
<h3 align="center">Common Links</h3>
<tcl>common_links</tcl>
</div>
<p>SQLite is a high-reliablity,
<a href="selfcontained.html">self-contained</a>,
<a href="serverless.html">serverless</a>,
<a href="zeroconf.html">zero-configuration</a>,
<a href="transactional.html">transactional</a>
SQLite is the [most widely deployed]
database engine in the world.
The source code for SQLite is in the
<a href="copyright.html">public domain</a>.
<a href="about.html">More...</a></p>
SQLite is the [most used] database engine in the world.
<a class="button" href="about.html">More Info</a></p>
<hr class="xhr">
<span class="hdrfont">Latest Release: </span>
<a href="releaselog/3_14_1.html">Version 3.14.1</a> on
2016-08-11.
<a class="button" href="download.html">Download</a>
<a class="button" href="chronology.html">Prior Releases</a>
<div class="mobileonly">
<hr style="color: #044a64" height="2">
<hr class="xhr">
<h3>Common Links</h3>
<tcl>common_links</tcl>
</div>
<hr class="xhr">
<h3>Sponsors</h3>
<p>Continuing enhancement and maintenance of SQLite is made possible
<p>Ongoing development and support of SQLite is made possible in part
by <a href="consortium.html">SQLite Consortium</a> members, including:</p>
<a name="consortium_members"></a>
<style>
#sponsors {
margin:auto;
width:80%;
<a name="consortium_members"></a>
<center>
<table border="0" cellpadding="15">
}
.onesponsor a img {
width:200px;
max-width:200px;
padding:1ex;
}
</style>
<div id="sponsors"></div>
<script>
<tcl>
set sponsors {
{name Mozilla
url https://www.mozilla.com/
image mozilla.gif
blurb "Working to preserve choice and innovation on the internet."
}
|
| ︙ | | |
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
|
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
-
-
-
-
-
-
-
-
|
}
{name Facebook
url https://www.facebook.com/
image fb.gif
blurb "Giving people the power to share and make the world more open and connected."
}
}
set nspons [llength $sponsors]
for {set i 0} {$i<$nspons} {incr i} {
if {$i%2==0} {hd_putsnl "<tr>"}
hd_putsnl " <td><a id='a$i'><img id='i$i'></a></td>"
if {$i%2==1 || $i==$nspons-1} {hd_putsnl "</tr>"}
}
hd_putsnl "</table></center>"
hd_putsnl "<script language=\"JavaScript\">"
|
| ︙ | | |
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
|
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
|
+
-
-
+
+
-
-
-
-
+
+
+
-
-
-
+
+
+
-
-
-
+
-
-
-
-
-
+
-
-
-
-
-
-
-
-
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
|
incr nspons
}
unset -nocomplain x
hd_putsnl "\];"
hd_puts {
for(var i=0; i<sponsors.length; i++){sponsors[i].idx = Math.random();}
sponsors.sort(function(a,b){return a.idx-b.idx});
var h = "";
for(var i=0; i<sponsors.length; i++){
var e = document.getElementById("a"+i);
e.href = sponsors[i].href;
var x = document.getElementById("i"+i);
x.src = "images/foreignlogos/"+sponsors[i].src;
if(sponsors[i].wx>0){
x.width = sponsors[i].wx;
x.height = sponsors[i].hx;
}
}
}
hd_putsnl "</script>"
</script>
</td>
<td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td>
<td valign="top">
<h3>Current Status</h3>
<p><ul>
<li><a href="releaselog/3_14_1.html">Version 3.14.1</a>
of SQLite is recommended for all new development.
</li>
</ul></p>
<h3>Common Links</h3>
p><ul class=nounderline>
<li> <a href="features.html">Features</a> </li>
<li> <a href="whentouse.html">When to use SQLite</a> </li>
<li> <a href="faq.html">Frequently Asked Questions</a> </li>
<li> <a href="quickstart.html">Getting Started</a> </li>
<li> <a href="chronology.html">Prior Releases</a>
<li> <a href="lang.html">SQL Syntax</a>
<ul>
<li> <a href="pragma.html#toc">Pragmas</a>
<li> <a href="lang_corefunc.html">SQL functions</a>
<li> <a href="lang_datefunc.html">Date & time functions</a>
<li> <a href="lang_aggfunc.html">Aggregate functions</a>
<li> <a href="json1.html">JSON functions</a>
</ul>
</li>
<li> <a href="c3ref/intro.html">C/C++ Interface Spec</a>
<ul>
<li> <a href="cintro.html">Introduction</a>
<li> <a href="c3ref/funclist.html">List of C-language APIs</a>
</ul>
</li>
<li> <a href="tclsqlite.html">The TCL Interface Spec</a>
<li> <a href="http://www.sqlite.org/src/timeline">Commit History</a> </li>
<li> <a href="http://www.sqlite.org/src/wiki?name=Bug+Reports">Report a Bug</a> </li>
<li> <a href="news.html">News</a> </li>
</ul></p>
</td></tr>
</table>
<tcl>
source [file normalize [file join $::DOC pages footer.tcl]]
</tcl>
|
Changes to pages/json1.in.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
-
+
-
+
-
+
-
-
-
+
-
+
-
-
-
+
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
|
<title>The JSON1 Extension</title>
<tcl>hd_keywords json1 {the json1 extension} {JSON SQL functions}</tcl>
<table_of_contents>
<h1>Overview</h1>
<p>
The <b>json1</b> extension is a [loadable extension] that
implements thirteen [application-defined SQL functions] and
implements fourteen [application-defined SQL functions] and
two [table-valued functions] that are useful for
managing [http://json.org/ | JSON] content stored in an SQLite database.
These are the scalar SQL functions implemented by json1:
Twelve of the fourteen SQL functions are scalar functions:
<blockquote>
<ol>
<center><table border=0 cellpadding=5>
hd_puts "<tr><td width=30 valign='top'>$tabcnt.</td>"
hd_puts "<td valign='top' width='30%'>\n"
hd_puts $fx\n
hd_puts "$fx\n"
hd_puts "</td><td valign='top'>\n"
hd_puts [string trim $desc]\n
hd_puts "</td></tr>\n\n"
proc jexample {args} {
hd_puts "<blockquote><table border=0 cellpadding=0>\n"
foreach {sql res} $args {
### uncomment to generate test cases from the examples
# global tsctr
# puts "do_execsql_test json102-$tsctr \173"
# incr tsctr 10
# puts " SELECT [string trim $sql];"
# set x \173[string trim $res ']\175
# puts "\175 \173$x\175"
hd_puts "<tr><td>[string trim $sql]</td>\n"
hd_puts "<td width='50' align='center'><b>→</b></td>\n"
hd_puts "<td>[string trim $res]</td></tr>\n"
}
hd_puts "</table></blockquote>\n"
}
|
| ︙ | | |
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
|
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
|
-
+
-
+
-
+
-
+
-
+
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
|
} jvalid
tabentry {json_quote(value)} {
Convert an SQL value (a number or a string) into its corresponding JSON
representation.
} jvalid
</tcl>
</table></center></blockquote>
</ol>
<p>There are two aggregate SQL functions:
<blockquote><center><table border=0 cellpadding=5>
<ol>
<tcl>
tabentry {json_group_array(value)} {
Return a JSON array composed of all <i>value</i> elements
in the aggregation.
} jgrouparray
tabentry {json_group_object(name,value)} {
Return a JSON object composed of all <i>name</i> and <i>value</i> pairs
in the aggregation.
} jgroupobject
</tcl>
</table></center></blockquote>
</ol>
<p>The [table-valued functions] implemented by this routine are:
<p>The two [table-valued functions] are:
<blockquote><center><table border=0 cellpadding=5>
<ol>
<tcl>
tabentry {json_each(json)<br>json_each(json,path)} {
Return one row describing each element in an array or object
at the top-level or at "path" within the input JSON.
} jeach
tabentry {json_tree(json)<br>json_tree(json,path)} {
Walk the JSON recursively starting at the top-level or at the
specified "path" and return one row for each element.
} jtree
</tcl>
</ol>
</table></center></blockquote>
|
| ︙ | | |
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
|
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
|
+
-
+
|
come directly from another json1 function.
<h2>Compatibility</h2>
<p>
The json1 extension uses the [sqlite3_value_subtype()] and
[sqlite3_result_subtype()] interfaces that were introduced with
SQLite version 3.9.0 (circa 2015-10-14).
SQLite version 3.9.0. Therefore the json1 extension will not work
|
| ︙ | | |
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
|
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
|
-
+
|
a single JSON value as their first argument followed by zero or more
pairs of path and value arguments, and return a new JSON string formed
by updating the input JSON by the path/value pairs. The functions
differ only in how they deal with creating new values and overwriting
preexisting values.
<center>
<table border=1 cellpadding=3>
<table border=1 cellpadding=3 cellspacing=0>
<tr>
<th>Function<th>Overwrite if already exists?<th>Create if does not exist?
<tr>
<td>json_insert()<td align='center'>No<td align='center'>Yes
<tr>
<td>json_replace()<td align='center'>Yes<td align='center'>No
<tr>
|
| ︙ | | |
Changes to pages/keyword_index.in.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
-
+
-
-
+
+
-
+
-
+
|
<title>Website Keyword Index</title>
<h1 align=center>Website Keyword Index</h1>
<h2 align=center>Keyword Index</h1>
<table align=right border=1 cellpadding=10>
<tr><td>Other Documentation Indices:
<var class="rightsidebar border2px desktoponly">
Other Documentation Indexes:
<ul>
<li>[categorical listing of SQLite documents | Categorical Document List]
<li>[books about SQLite | Books About SQLite]
<li>[doclist | Alphabetical List Of Documents]
<li>[permuted index | Permuted Document Title Index]
</ul>
</table>
</var>
<ul>
<ul class='lessindent'>
<tcl>
hd_keywords {keyword index}
db eval {
UPDATE keyword SET indexKw=0
WHERE kw GLOB '*s' AND indexKw
AND EXISTS(SELECT 1 FROM keyword AS x
WHERE x.kw = substr(keyword.kw,1,length(keyword.kw)-1));
|
| ︙ | | |
Changes to pages/lang.in.
| ︙ | | |
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
|
-
+
-
-
-
-
+
+
+
+
-
-
+
-
-
-
-
-
-
-
-
+
+
|
{{ANALYZE} analyze}
{{INDEXED BY} indexedby}
{{aggregate functions} aggfunc aggfunc}
{{core functions} corefunc corefunc}
{{date and time functions} datefunc datefunc}
{keywords keywords {SQL keywords}}
}
set lang_section_break [expr {([llength $lang_section_list]+2)/3}]
set lx {}
foreach {section} [lsort -index 0 -dictionary $lang_section_list] {
foreach {s_title s_tag s_kw} $section {}
if {$s_kw == ""} {
set s_kw $s_title
}
foreach {s_title s_tag s_kw} $section {}
if {$s_kw == ""} {
set s_kw $s_title
}
if {$s_tag=="pragma.html"} {
set url $s_tag
} else {
set url lang_$s_tag.html
hd_resolve "<li>\[$s_kw|$s_title\]</li>"
incr i
if {$i==$lang_section_break || $i==2*$lang_section_break} {
hd_puts "</ul></td><td valign=\"top\"><ul>"
}
}
|
| ︙ | | |
2325
2326
2327
2328
2329
2330
2331
2332
2333
2334
2335
2336
2337
2338
2339
2340
2341
2342
2343
2344
2345
2346
2347
2348
2349
2350
2351
2352
2353
2354
2355
2356
2357
2358
2359
2360
2361
2362
2363
2364
2365
2366
2367
2368
2369
2370
2371
|
2318
2319
2320
2321
2322
2323
2324
2325
2326
2327
2328
2329
2330
2331
2332
2333
2334
2335
2336
2337
|
+
-
-
+
-
-
-
-
-
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
-
-
-
-
-
+
-
-
|
function are different. ^For example, the [agg_max|max()] function with a
single argument is an aggregate and the [max()] function with two or more
arguments is a simple function.
<tcl>
##############################################################################
Section {Core Functions} corefunc {*corefunc}
unset -nocomplain corefuncset
proc funcdef {syntax keywords desc} {
hd_puts {<tr>}
regsub -all {\s+} [string trim $syntax] {<br />} syntax
regsub -all {\(([^*)]+)\)} $syntax {(<i>\1</i>)} syntax
regsub -all {,} $syntax {</i>,<i>} syntax
regsub -all {<i>\.\.\.</i>} $syntax {...} syntax
hd_puts "<td valign=\"top\" align=\"right\" width=\"120\">"
if {[llength $keywords]==0} {
regexp {[a-z_]+} $syntax name
hd_fragment $name *$name "${name}() SQL function"
} else {
set fragname [lindex $keywords 0]
regsub -all {[^a-z]} $fragname {} fragname
hd_fragment $fragname
eval hd_keywords [string map {\n { }} $keywords]
}
hd_puts "$syntax</td>"
hd_puts {<td valign="top">}
hd_resolve $desc
hd_puts {</td></tr>}
}
</tcl>
<p>The core functions shown below are available by default.
[datefunc | Date & Time functions],
[aggfunc | aggregate functions], and
[json1 | JSON functions] are documented separately. An
application may define additional
functions written in C and added to the database engine using
the [sqlite3_create_function()] API.</p>
<table border=0 cellpadding=10>
<tcl>
|
| ︙ | | |
2716
2717
2718
2719
2720
2721
2722
2723
2724
2725
2726
2727
2728
2729
2730
2731
2732
|
2682
2683
2684
2685
2686
2687
2688
2689
2690
2691
2692
2693
2694
2695
2696
2697
2698
2699
2700
2701
2702
2703
2704
2705
2706
2707
2708
2709
2710
2711
2712
2713
2714
2715
2716
2717
2718
2719
2720
2721
2722
2723
2724
2725
2726
2727
2728
2729
2730
2731
2732
2733
2734
2735
2736
2737
2738
|
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
|
SQLite manages these zeroblobs very efficiently. Zeroblobs can be used to
reserve space for a BLOB that is later written using
[sqlite3_blob_open() | incremental BLOB I/O].
^This SQL function is implemented using the [sqlite3_result_zeroblob()]
routine from the C/C++ interface.
}
</tcl>
</table>
|
| ︙ | | |
3026
3027
3028
3029
3030
3031
3032
3033
3034
3035
3036
3037
3038
3039
3040
3041
3042
3043
3044
3045
3046
3047
3048
3049
3050
3051
3052
3053
3054
3055
3056
3057
3058
|
3032
3033
3034
3035
3036
3037
3038
3039
3040
3041
3042
3043
3044
3045
3046
3047
|
-
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
|
[http://en.wikipedia.org/wiki/Gregorian_calendar | Gregorian calendar]
system. It is also assumed that every
day is exactly 86400 seconds in duration.</p>
<tcl>
##############################################################################
Section {Aggregate Functions} aggfunc {*aggfunc}
</tcl>
<p>
The aggregate functions shown below are available by default. Additional
aggregate functions written in C may be added using the
[sqlite3_create_function()]</a>
API.</p>
<p>
^In any aggregate function that takes a single argument, that argument
can be preceded by the keyword DISTINCT. ^In such cases, duplicate
elements are filtered before being passed into the aggregate function.
^For example, the function "count(distinct X)" will return the number
of distinct values of column X instead of the total number of non-null
values in column X.
</p>
<table border=0 cellpadding=10>
<tcl>
|
| ︙ | | |
3120
3121
3122
3123
3124
3125
3126
3127
3128
3129
3130
3131
3132
3133
3134
3135
3136
|
3109
3110
3111
3112
3113
3114
3115
3116
3117
3118
3119
3120
3121
3122
3123
3124
3125
3126
3127
3128
3129
3130
3131
3132
3133
3134
3135
3136
3137
3138
3139
3140
3141
3142
3143
3144
3145
3146
3147
3148
3149
3150
3151
3152
3153
3154
3155
3156
3157
3158
3159
3160
3161
3162
3163
3164
3165
3166
3167
3168
3169
3170
3171
3172
3173
|
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
|
<p>^Sum() will throw an "integer overflow" exception if all inputs
are integers or NULL
and an integer overflow occurs at any point during the computation.
^Total() never throws an integer overflow.
}
</tcl>
</table>
|
| ︙ | | |
4850
4851
4852
4853
4854
4855
4856
4857
4858
4859
4860
4861
4862
4863
4864
4865
4866
4867
4868
4869
4870
4871
4872
4873
4874
4875
|
4887
4888
4889
4890
4891
4892
4893
4894
4895
4896
4897
4898
4899
4900
4901
4902
4903
4904
|
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
|
but some keywords may be omitted when SQL language features are
disabled.
^(Regardless of the compile-time configuration, any identifier that is not on
the following <tcl>hd_puts [llength $keyword_list]</tcl> element
list is not a keyword to the SQL parser in SQLite:
</p>
<tcl>
set lx {}
foreach word $keyword_list {
lappend lx [list {} $word 0]
}
output_list {} 200 $lx
</tcl>
<blockquote>
<table width="100%"><tr>
<td align="left" valign="top" width="20%">
<tcl>
set n [llength $keyword_list]
set nCol 5
set nRow [expr {($n+$nCol-1)/$nCol}]
set i 0
foreach word $keyword_list {
if {$i==$nRow} {
hd_puts "</td><td valign=\"top\" align=\"left\" width=\"20%\">"
set i 1
} else {
incr i
}
hd_puts "$word<br>\n"
}
</tcl>
</td></tr></table></blockquote>)^
|
Changes to pages/mostdeployed.in.
1
2
3
4
5
6
7
8
9
|
1
2
3
4
5
6
7
8
9
|
-
+
|
<title>Most Widely Deployed SQL Database Engine</title>
<tcl>hd_keywords {most widely deployed}</tcl>
<tcl>hd_keywords {most widely deployed} {most used} {most widely used}</tcl>
<h2>Most Widely Deployed and Used Database Engine</h2>
<p>SQLite is likely used more than all other database engines
combined. Billions and billions of copies
of SQLite exist in the wild. SQLite is found in:
|
| ︙ | | |
Changes to pages/pragma.in.
| ︙ | | |
1542
1543
1544
1545
1546
1547
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
1566
1567
1568
1569
1570
1571
1572
1573
1574
1575
1576
1577
1578
1579
1580
1581
1582
1583
1584
1585
1586
1587
1588
|
1542
1543
1544
1545
1546
1547
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
1566
1567
1568
1569
1570
1571
1572
1573
1574
1575
|
-
+
-
-
-
-
+
-
-
-
-
-
+
-
+
-
+
-
+
-
-
-
+
-
+
-
-
-
-
+
+
+
-
-
-
|
<p>When this pragma is on, the SQLITE_MASTER tables in which database
can be changed using ordinary [UPDATE], [INSERT], and [DELETE]
statements.)^ ^Warning: misuse of this pragma can easily result in
a corrupt database file.</p>
}
Section {List Of PRAGMAs} {toc} {{pragma list}}
</tcl>
<table border=0 width="100%" cellpadding=10>
<tr><td valign="top" align="left"><ul>
<tcl>
set allprag [lsort [array names PragmaRef]]
set nprag [llength $allprag]
set nrow [expr {($nprag+2)/3}]
for {set i 0} {$i<$nprag} {incr i} {
set prag [lindex $allprag $i]
hd_puts "<li><a href=\"#pragma_$ref\"><s>$prag</s></a>¹\n"
hd_puts "<li><a href=\"#pragma_$ref\"><i>$prag</i></a>²\n"
hd_puts "<li><a href=\"#pragma_$ref\"><i>$prag</i></a>³\n"
hd_puts "<li><a href=\"#pragma_$ref\">$prag</a>\n"
if {$i%$nrow==($nrow-1) && $i+1<$nprag} {
hd_puts "</ul></td><td valign=\"top\" align=\"left\"><ul>\n"
}
}
</ul></td></tr></table>
<li>Pragmas whose names are marked through in the list above
are deprecated. They are not maintained. They continue to exist
for historical compatibility only.
<li>Pragmas whose names are <s>struck through</s>
are deprecated. Do not use them. They exist
for historical compatibility.
Do not use the deprecated pragmas in new applications.
Remove deprecated pragmas
from existing applications at your earliest opportunity.</blockquote>
|
| ︙ | | |
Added pages/prosupport.in.