Documentation Source Text

Check-in [f45d2bc902]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Lots of little fixes.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: f45d2bc9029a16e49e58e4dd4b1288bb59d3eefe
User & Date: drh 2007-11-15 00:50:26.000
Context
2007-11-16
21:44
Miscellaneous website changes suggested by the community. (check-in: 14ac1dc131 user: drh tags: trunk)
2007-11-15
11:52
(no comment) (check-in: c883828f1b user: anonymous tags: trunk)
00:50
Lots of little fixes. (check-in: f45d2bc902 user: drh tags: trunk)
2007-11-14
15:37
Fix a word here and there. Nothing major. (check-in: 71f4be98f6 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to misc/althttpd.c.
416
417
418
419
420
421
422

423
424
425
426
427
428
429
static struct Suffix {
  int len;
  char *zSuffix;
  char *zContentType;
} suffix[] = {
  {  5,     ".html",    "text/html" },
  {  4,     ".htm",     "text/html" },

  {  4,     ".gif",     "image/gif" },
  {  5,     ".jpeg",    "image/jpeg" },
  {  4,     ".jpg",     "image/jpeg" },
  {  4,     ".png",     "image/png"  },
};

/*







>







416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
static struct Suffix {
  int len;
  char *zSuffix;
  char *zContentType;
} suffix[] = {
  {  5,     ".html",    "text/html" },
  {  4,     ".htm",     "text/html" },
  {  4,     ".css",     "text/css"  },
  {  4,     ".gif",     "image/gif" },
  {  5,     ".jpeg",    "image/jpeg" },
  {  4,     ".jpg",     "image/jpeg" },
  {  4,     ".png",     "image/png"  },
};

/*
Changes to pages/faq.in.
154
155
156
157
158
159
160





161
162
163
164
165
166
167
168
  <a href="c3ref/busy_timeout.html">sqlite3_busy_timeout()</a>
  API functions.</p>
}

faq {
  Is SQLite threadsafe?
} {





  <p>Yes.  Sometimes.  In order to be thread-safe, SQLite must be compiled
  with the SQLITE_THREADSAFE preprocessor macro set to 1.  Both the windows
  and linux precompiled binaries in the distribution are compiled this way.
  If you are unsure if the SQLite library you are linking against is compiled
  to be threadsafe you can call the
  <a href="c3ref/threadsafe.html">sqlite3_threadsafe()</a>
  interface to find out.
  </p>







>
>
>
>
>
|







154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
  <a href="c3ref/busy_timeout.html">sqlite3_busy_timeout()</a>
  API functions.</p>
}

faq {
  Is SQLite threadsafe?
} {
  <p><a href="http://www.eecs.berkeley.edu/Pubs/TechRpts/2006/EECS-2006-1.pdf">
  Threads are evil</a>.  Avoid them.

  <p>SQLite is threadsafe.  We make this concession since many users choose
  to ignore the advice given in the previous paragraph.
  But in order to be thread-safe, SQLite must be compiled
  with the SQLITE_THREADSAFE preprocessor macro set to 1.  Both the windows
  and linux precompiled binaries in the distribution are compiled this way.
  If you are unsure if the SQLite library you are linking against is compiled
  to be threadsafe you can call the
  <a href="c3ref/threadsafe.html">sqlite3_threadsafe()</a>
  interface to find out.
  </p>
Changes to pages/index.in.
10
11
12
13
14
15
16
17
18
19
20
21
22

23
24
25
26
27
28
29
<li><a href="releaselog/3_5_2.html">Version 3.5.2</a>
of SQLite is stable and is recommended for all users.</li>
</ul></p>

<h3>Common Links</h3>

<p><ul>
<li> <a href="about.html">Features</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="lang.html">SQL Syntax</a>. </li>
<li> <a href="c3ref/intro.html">C/C++ Interface Spec</a>. </li>
<li> <a href="http://www.sqlite.org/cvstrac/timeline">Timeline</a>. </li>

</ul></p>

<center>
<a href="http://osdir.com/Article6677.phtml">
<img src="images/2005osaward.gif"></a>
</center>
<p></p>







|
|
|
|
|
|
>







10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
<li><a href="releaselog/3_5_2.html">Version 3.5.2</a>
of SQLite is stable and is recommended for all users.</li>
</ul></p>

<h3>Common Links</h3>

<p><ul>
<li> <a href="about.html">Features</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="lang.html">SQL Syntax</a> </li>
<li> <a href="c3ref/intro.html">C/C++ Interface Spec</a> </li>
<li> <a href="http://www.sqlite.org/cvstrac/timeline">Timeline</a> </li>
<li> <a href="http://www.sqlite.org/cvstrac/wiki">Wiki</a> </li>
</ul></p>

<center>
<a href="http://osdir.com/Article6677.phtml">
<img src="images/2005osaward.gif"></a>
</center>
<p></p>
Added pages/onefile.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
<title>SQLite: Single File Database</title>

<h2>Single-file Cross-platform Database</h2>

<p>
A database in SQLite is a single disk file.
Furthermore, the file format is cross-platform.
A databae that is created on one machine can be
copied and used on a different machine with
a different architecture.  SQLite databases
are portable across 32-bit and 64-bit machines
and between 
<a href="http://en.wikipedia.org/wiki/Endianness">big-endian</a> and 
<a href="http://en.wikipedia.org/wiki/Endianness">little-endian</a>
architectures.
</p>

<p>
The SQLite database file format is also stable.
All releases of of SQLite version 3 can read and write database
files created by the very first SQLite 3 release (version 3.0.0)
going back to 2004-06-18.  This is "backwards compatibility".
The developers promise to maintain backwards compatibility of
the database file format for all future releases of SQLite 3.
"Forwards compatiblity" means that older releases
of SQLite can also read and write databases created by newer
releases.  SQLite is usually, but not completely forwards
compatible. 
</p>

<p>
The stability of the SQLite database file format and the fact
that the file format is cross-platform combine to make SQLite
database files an excellent choice as an 
<a href="whentouse.html#appfileformat">Application File Format</a>.</p>
</p>
Changes to pages/sitemap.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
<title>SQLite Site Map</title>

<h2>Site Map</h2>

<ul>
<li> <a href="index.html">Home Page</a>.
     <ul>
     <li> <a href="about.html">Feature List</a>. </li>
     <li> <a href="famous.html">Well-known Users</a>. </li>
     <li> <a href="crew.html">Developer Vitas</a>. </li>
     </ul></li>
<li> <a href="docs.html">Documentation</a>.
     <ul>
     <li> <a href="faq.html">Frequently Asked Questions</a>.</li>
     <li> <a href="quickstart.html">SQLite In 5 Minutes Or Less</a>.</li>
     <li> <a href="c3ref/intro.html">C/C++ Interface Spec</a>.</li>
     <li> <a href="lang.html">SQL Syntax</a>.</li>
     <li> <a href="whentouse.html">Appropriate Uses For SQLite</a>.</li>
     <li> <a href="different.html">Distinctive Features</a>.</li>
     </ul></li>
<li> <a href="download.html">Download</a>. </li>
<li> <a href="copyright.html">License</a>. </li>
<li> <a href="news.html">News</a>.
     <ul>
     <li> <a href="oldnews.html">Older news</a>. </li>
     </ul></li>
<li> <a href="http://www.sqlite.org/cvstrac/index.html">Developers</a>. </li>
<li> <a href="support.html">Support</a>. </li>
</ul>





|

|
|
|

|

|
|
|
|
|
|

|
|
|

|

|
|

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
<title>SQLite Site Map</title>

<h2>Site Map</h2>

<ul>
<li> <a href="index.html">Home Page</a>
     <ul>
     <li> <a href="about.html">Feature List</a> </li>
     <li> <a href="famous.html">Well-known Users</a> </li>
     <li> <a href="crew.html">Developer Vitas</a> </li>
     </ul></li>
<li> <a href="docs.html">Documentation</a>
     <ul>
     <li> <a href="faq.html">Frequently Asked Questions</a></li>
     <li> <a href="quickstart.html">SQLite In 5 Minutes Or Less</a></li>
     <li> <a href="c3ref/intro.html">C/C++ Interface Spec</a></li>
     <li> <a href="lang.html">SQL Syntax</a></li>
     <li> <a href="whentouse.html">Appropriate Uses For SQLite</a></li>
     <li> <a href="different.html">Distinctive Features</a></li>
     </ul></li>
<li> <a href="download.html">Download</a> </li>
<li> <a href="copyright.html">License</a> </li>
<li> <a href="news.html">News</a>
     <ul>
     <li> <a href="oldnews.html">Older news</a> </li>
     </ul></li>
<li> <a href="http://www.sqlite.org/cvstrac/index.html">Developers</a> </li>
<li> <a href="support.html">Support</a> </li>
</ul>
Added rawpages/cvstrac.css.






















































































































































































































































































































































































































































































































































































































































>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
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
166
167
168
169
170
171
172
173
174
175
176
177
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
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

body {
    margin: auto;
    font-family: "Verdana" "sans-serif";
    padding: 8px;
}

.sqlite_header {
    margin: auto;
}

a { color: #734559 }
a:visited { color: #45735f }

.logo { position:absolute; margin:3px; }
.tagline {
  float:right;
  text-align:right;
  font-style:italic;
  width:240px;
  margin:12px;
  margin-top:58px;
}

.toolbar {
  font-variant: small-caps;
  text-align: center;
  line-height: 1.6em;
  margin: 0;
  padding:1px 8px;
}
.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }
.toolbar a:visited { color: white; }
.toolbar a:hover { color: #80a796; 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; }

/* rounded corners */
.se  { background: url(/images/se.png) 100% 100% no-repeat #80a796}
.sw  { background: url(/images/sw.png) 0% 100% no-repeat }
.ne  { background: url(/images/ne.png) 100% 0% no-repeat }
.nw  { background: url(/images/nw.png) 0% 0% no-repeat }
/* CVSTrac default stylesheet.
** This more or less replicates the "original" CVSTrac style.
*/

/* ********* Standard/default header and footer ************************* */
body {background-color: white}
#footer {font-size: .67em; clear: both;}

hr {clear: both;}

/* ********* Page header ************************************************ */

#header {
          background: #f0ffff;
          padding: 0px;
          border: 2px #80a796 solid;
          margin: 0px;
          display: block;
          position: relative;
        }

#title {font-weight: bold;
        font-size: 1.17em;
        margin: 2px;
        max-width: 30%;
       }

#identity {font-size: .83em;
           font-weight: normal;
           margin: 2px;
           max-width: 30%;
          }

/* The "current" item is traditionally omitted from the navigation bar */
#navigation #current {display: none;}

#navigation li {display: inline; margin: 1px; white-space: nowrap;}
#navigation li :before {content: "["; color: black;}
#navigation li :after {content: "]"; color: black;}
#navigation {text-align: right; list-style-type: none;
             padding: 0;
             margin: 0;
             float: right;
             max-width: 50%;
             position: absolute;
             top: 0em;
             right: 0em;
            }

#action li {display: inline; margin: 1px; white-space: nowrap;}
#action li :before {content: "["; color: black;}
#action li :after {content: "]"; color: black;}
#action {list-style-type: none; text-align: right; background: #f0f0f0;
         margin: 1px;
         padding: 1px;
         padding: 1px;
         clear: both;
         }

#content {clear: both;}

/* File breadcrumb off by default in stock CVSTrac */
#breadcrumb {display: none}

/* ********* Bits and boxes  ******************************************** */

/* wiki history */
#history {
          float: right;
          border: 2px #a0b5f4 solid;
          white-space: nowrap;
          margin: 2px; padding: 0px;
         }
#history h3 { margin: 2px; padding: 0px; background: #d0d9f4;
              font-size: 1em; font-weight: bold;
              text-align: center;
            }
#history ul { list-style-type: none; text-align: left;
              margin: 2px; padding: 0px;
            }
#history .current { font-weight: bold; }
#history .off { font-weight: bold; }
#history p { margin: 2px; padding: 0px; }

#wikitoc {border-spacing: 20px 0px;}
#wikitoc th {background: #d0d0d0;}

/* ********* Timeline page ******************************************** */
#timeline {text-align: left;
           margin: .5em 0 0 0;
           padding: 0;
          }

/* date and milestone dividers */
#timeline .dt {background: #f0ffff;
               border: 2px #80a796 solid;
               font-size: 1em; font-weight: normal;
               padding: .25em;
               margin: .2em 0 .2em 0;
               float: left;
               clear: left;
              }
#timeline .dm {background: #f7c0c0;
               border: 2px #ec9898 solid;
               font-size: 1em; font-weight: normal;
               padding: .25em;
               margin: .2em 0 .2em 0;
               float: left;
               clear: left;
              }

#timeline .entries {
                     vertical-align: top;
                     clear: both;
                     margin: 0; padding: 0;
                     margin-left: 1em;
                     }
#timeline .entries dt {
             clear: both;
             float: left;
             margin: 0; padding: 0;
             }
#timeline .entries dd {
             float: left;
             margin: 0; padding: 0;
             }
#timeline .entries .datetime {text-align: right;
                              width: 10%;
                             }
#timeline .entries .time {text-align: center; /* width: 8%; */}
#timeline .entries .hint {text-align: center; width: 5%;}
#timeline .entries .branch {
                          background: #dddddd;
                          width: 85%;
                          }
#timeline .entries .action {
                          width: 85%;
                          }

/* timeline options, down at the bottom */
#timelineopts {
               margin-top: 1em;
               padding: 3px;
               padding-top: 1em;
               clear: both;
               border-top: 1px solid black;
              }
#timelineopts fieldset {
               margin: 1px;
               padding: 3px;
               border: 1px solid black;
              }
#timelineopts #days {}
#timelineopts #checkout {width: 45%; float: left; padding: 3px;}
#timelineopts #ticket {width: 45%; float: left; padding: 3px;}
#timelineopts #timeline {width: 45%; clear: left; float: left; padding: 3px;}
#timelineopts #other {width: 45%; float: left; padding: 3px;}
#timelineopts #show {clear: both;}

/* ********* Setup ******************************************** */
/* setup menu */
#index, #setup {margin: 1em 0; padding: 0;}

#index dt, #setup dt {
                      display: block;
                      width: 30%;
                      float: left;
                      margin: 0 0 0 0;
                      padding: .5em;
                      font-weight: bold;
                      clear: left;
                      white-space: nowrap;
                      }
#index dd, #setup dd {
                      width: 55%;
                      float: left;
                      margin: 0 0 0 0;
                      padding: .5em;
                      }

/* ********* Wiki formatting ******************************************** */
/* ticket markup... various forms of "fixed" are shown as striked. This list
** would need to be updated if the user changes the ticket states
*/
/* .ticket {font-weight: bold} */
.ticket .closed, .ticket .fixed, .ticket .tested, .ticket .defer
   {text-decoration: line-through}

/* chng markup. Check-ins and milestones. */
/* .chng {font-weight: bold} */
/* .chng .event {color: orange} */
/* .chng .release {color: orange} */
/* .chng .checkin {color: red} */
.chng .branch {background: #dddddd;}

/* links to Wiki pages */
/* .wiki {font-weight: bold} */
.wiki .missing {color: gray; font-style: italic; font-weight: normal;}

/* .diff {background: #e0e0e0} */
/* hr.diff {visibility: hidden} */
div.difftop {float: right}

/* raw HTML in wiki */
/* div.restricted {background-color: #e0e0e0} */

/* URL's in wiki markup. This puts a special character in front, but
** you could also use a link to an image or something...
*/
a.external:before {content: "\0000a4"; color: #a0a0a0;}

/* Path's to code mentioned in wiki markup. */
a.file {font-family: monospace;}

/* two and three asterisks... The class names are a bit lame, but
** I'm not sure what else to call 'em
*/
.two {font-size: 1.17em}
.three {font-size: 1.33em}

/* user id */
/* .user {font-weight: bold;} */

/* revision */
/* .vers {font-style: italic;} */

/* ********* Icons ****************************************************** */
.icon:before {content: "\002022"; color: black;}

.icon.milestone:before {content: "\0000a4"; color: #007878;}
.icon.del:before {content: "\0000d7"; color: red;}
.icon.file:before {content: "\002022"; color: black;}
.icon.dir:before {content: "\0000bb"; color: green;}
.icon.backup:before {content: "\0000ab"; color: black;}
.icon.checkin:before {content: "\002022"; color: blue;}
.icon.ticket:before {content: "\00203a"; color: blue;}
.icon.edit:before {content: "\00002a"; color: #8C80A3;}
.icon.attach:before {content: "\0000bb"; color: blue;}
.icon.inspect:before {content: "\002022"; color: blue;}

/* each ticket type can have a timeline icon. This is usually
** used for the ticket creation.
*/
.icon.type:before {content: "\0000bb"; color: purple;}
.icon.type.code:before {content: "\0000d7"; color: red;}

/* each ticket state can also have a timeline icon */
.icon.state:before {content: "\002666"; color: #ffa000;}
.icon.state.new:before {content: "\0000d7"; color: red;}
.icon.state.active:before {content: "\0000d7"; color: red;}
.icon.state.fixed:before {content: "\00221a"; color: green;}
.icon.state.closed:before {content: "\00221a"; color: green;}
.icon.state.defer:before {content: "\00221a"; color: green;}

/* deprecated icons... they'll disappear shortly, hopefully */
.icon.dot:before {content: "\002022"; color: blue;}
.icon.ptr1:before {content: "\0000bb"; color: purple;}

/* ********* Other ****************************************************** */

.rlog {padding: 0; margin: 0; border-width: 0;}
.rlog td, .rlog th {text-align: left;}
.rlog .version {width: 80px; text-align: center;}
.rlog .date {white-space: nowrap; text-align: left;}

/* Zebra stripe background effect */
.rlog .odd  {background: #efefff;}
.rlog .milestone  {background: #f7c0c0;}

.rlog .branch  {background: #dddddd;}
Changes to wrap.tcl.
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
#
proc PutsHeader {title {path {}}} {
  puts {<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">}
  puts {<html><head>}
  puts "<title>$title</title>"
  putsin4 {<style type="text/css">
    body {
        max-width: 800px; /* not supported in IE 6 */
        margin: auto;
        font-family: "Verdana" "sans-serif";
        padding: 8px 1%;
    }
    
    a { color: #40534b }
    a:visited { color: #587367 }
    
    .logo { position:absolute; margin:3px; }
    .tagline {
      float:right;
      text-align:right;
      font-style:italic;
      width:240px;







<





|
|







49
50
51
52
53
54
55

56
57
58
59
60
61
62
63
64
65
66
67
68
69
#
proc PutsHeader {title {path {}}} {
  puts {<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">}
  puts {<html><head>}
  puts "<title>$title</title>"
  putsin4 {<style type="text/css">
    body {

        margin: auto;
        font-family: "Verdana" "sans-serif";
        padding: 8px 1%;
    }
    
    a { color: #734559 }
    a:visited { color: #45735f }
    
    .logo { position:absolute; margin:3px; }
    .tagline {
      float:right;
      text-align:right;
      font-style:italic;
      width:240px;