Documentation Source Text

Check-in [87f524783e]
Login

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

Overview
Comment:Remove all references to the old CVSTrac wiki, which is no longer supported.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:87f524783ee6d7d8023f44821d8d631f057e8f29
User & Date: drh 2011-09-05 11:23:00
Context
2011-09-12
18:29
Remove stray "(" character from the ON CONFLICT documentation. check-in: dd27f660f9 user: drh tags: trunk
2011-09-05
11:23
Remove all references to the old CVSTrac wiki, which is no longer supported. check-in: 87f524783e user: drh tags: trunk
2011-09-01
12:59
Update the "Books About SQLite" page with info about the 2nd edition of Definitive Guide. check-in: e4bb1f4459 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/about.in.

24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
<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">Development Timeline</a> </li>
<li> <a href="http://www.sqlite.org/src/wiki?name=Bug+Reports">Report a Bug</a> </li>
<li> <a href="http://www.sqlite.org/cvstrac/wiki">Wiki</a> </li>
</ul></p>
</table>

<p>SQLite is a in-process library that implements a
<a href="selfcontained.html">self-contained</a>, 
<a href="serverless.html">serverless</a>,
<a href="zeroconf.html">zero-configuration</a>,







<







24
25
26
27
28
29
30

31
32
33
34
35
36
37
<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">Development Timeline</a> </li>
<li> <a href="http://www.sqlite.org/src/wiki?name=Bug+Reports">Report a Bug</a> </li>

</ul></p>
</table>

<p>SQLite is a in-process library that implements a
<a href="selfcontained.html">self-contained</a>, 
<a href="serverless.html">serverless</a>,
<a href="zeroconf.html">zero-configuration</a>,

Changes to pages/dev.in.

1
2
3
4
5
6
7
8
9
10
<title>SQLite Developer Links</title>
<h1 align="center">Developer Resources</h1>

<ul>
<li> <a href="http://www.sqlite.org/src/wiki/name=Bug+Reports">Report A Bug</a>
<li> <a href="http://www.sqlite.org/cvstrac/wiki">Wiki</a>
<li> <a href="http://www.sqlite.org/src/timeline">Timeline</a>
<li> <a href="http://www.sqlite.org/src/dir">Browse Historical Source Files</a>
<li> <a href="http://www.sqlite.org/docsrc">Documentation Source Text</a>
</ul>





<




1
2
3
4
5

6
7
8
9
<title>SQLite Developer Links</title>
<h1 align="center">Developer Resources</h1>

<ul>
<li> <a href="http://www.sqlite.org/src/wiki/name=Bug+Reports">Report A Bug</a>

<li> <a href="http://www.sqlite.org/src/timeline">Timeline</a>
<li> <a href="http://www.sqlite.org/src/dir">Browse Historical Source Files</a>
<li> <a href="http://www.sqlite.org/docsrc">Documentation Source Text</a>
</ul>

Changes to pages/faq.in.

1
2
3
4
5
6
7
8
9
10
11
12
...
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
<title>SQLite Frequently Asked Questions</title>

<p>Also available in <a href="http://pc.de/pages/sqlite-faq-be">
Belorussian</a>.</p>

<tcl>
set cnt 1
proc faq {question answer} {
  set ::faq($::cnt) [list [string trim $question] [string trim $answer]]
  incr ::cnt
}

................................................................................
  application, that might change the ECCN in your particular case.
}

# End of questions and answers.
#############

hd_puts {<h2>Frequently Asked Questions</h2>}
hd_puts {<p>See also <a href="http://www.sqlite.org/cvstrac/wiki?p=SqliteWikiFaq">SqliteWikiFaq</a>.</p>}

    hd_puts {<oL>}
for {set i 1} {$i<$cnt} {incr i} {
  hd_puts "<li><a href=\"#q$i\">[lindex $faq($i) 0]</a></li>"
}
hd_puts {</ol>}



<
<
<







 







<







1
2



3
4
5
6
7
8
9
...
642
643
644
645
646
647
648

649
650
651
652
653
654
655
<title>SQLite Frequently Asked Questions</title>




<tcl>
set cnt 1
proc faq {question answer} {
  set ::faq($::cnt) [list [string trim $question] [string trim $answer]]
  incr ::cnt
}

................................................................................
  application, that might change the ECCN in your particular case.
}

# End of questions and answers.
#############

hd_puts {<h2>Frequently Asked Questions</h2>}


    hd_puts {<oL>}
for {set i 1} {$i<$cnt} {incr i} {
  hd_puts "<li><a href=\"#q$i\">[lindex $faq($i) 0]</a></li>"
}
hd_puts {</ol>}

Changes to pages/index.in.

113
114
115
116
117
118
119
120
121
122
123
124
<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">Development Timeline</a> </li>
<li> <a href="http://www.sqlite.org/src/wiki?name=Bug+Reports">Report a Bug</a> </li>
<li> <a href="http://www.sqlite.org/cvstrac/wiki">Wiki</a> </li>
</ul></p>

</td></tr>
</table>







<




113
114
115
116
117
118
119

120
121
122
123
<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">Development Timeline</a> </li>
<li> <a href="http://www.sqlite.org/src/wiki?name=Bug+Reports">Report a Bug</a> </li>

</ul></p>

</td></tr>
</table>

Changes to pages/omitted.in.

53
54
55
56
57
58
59
60
61
62
63
64
65
66
  file access permissions of the underlying operating system.
  The GRANT and REVOKE commands commonly found on client/server
  RDBMSes are not implemented because they would be meaningless
  for an embedded database engine.
}
</tcl>
</table>

<p>
If you find other SQL92 features that SQLite does not support, please
add them to the Wiki page at 
<a href="http://www.sqlite.org/cvstrac/wiki?p=UnsupportedSql">
http://www.sqlite.org/cvstrac/wiki?p=Unsupported</a>
</p>







<
<
<
<
<
<
<
53
54
55
56
57
58
59







  file access permissions of the underlying operating system.
  The GRANT and REVOKE commands commonly found on client/server
  RDBMSes are not implemented because they would be meaningless
  for an embedded database engine.
}
</tcl>
</table>







Changes to pages/sitemap.in.

27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
<li> <a href="c3ref/funclist.html">List of C-language APIs</a>
</ul>
</li>
<li> <a href="tclsqlite.html">The TCL Interface Spec</a>
</ul><td valign=top><ul>
<li> <a href="support.html#mailinglists">Mailing Lists</a> </li>
<li> <a href="http://www.sqlite.org/src/wiki?name=Bug+Reports">Report a Bug</a> </li>
<li> <a href="http://www.sqlite.org/cvstrac/wiki">Wiki</a> </li>
<li> <a href="download.html#cvs">Version control</a>
  <ul>
  <li> <a href="http://www.sqlite.org/src">Source code timeline</a> </li>
  <li> <a href="http://www.sqlite.org/docsrc">Documentation timeline</a> </li>
  </ul>
</ul>
</table>







<







27
28
29
30
31
32
33

34
35
36
37
38
39
40
<li> <a href="c3ref/funclist.html">List of C-language APIs</a>
</ul>
</li>
<li> <a href="tclsqlite.html">The TCL Interface Spec</a>
</ul><td valign=top><ul>
<li> <a href="support.html#mailinglists">Mailing Lists</a> </li>
<li> <a href="http://www.sqlite.org/src/wiki?name=Bug+Reports">Report a Bug</a> </li>

<li> <a href="download.html#cvs">Version control</a>
  <ul>
  <li> <a href="http://www.sqlite.org/src">Source code timeline</a> </li>
  <li> <a href="http://www.sqlite.org/docsrc">Documentation timeline</a> </li>
  </ul>
</ul>
</table>

Changes to pages/speed.in.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<title>SQLite Database Speed Comparison</title>

<h2>Database Speed Comparison</h2>

<font color="red"><b>
Note:  This document is old.  It describes a speed comparison between
an older version of SQLite against archaic versions of MySQL and PostgreSQL.
Readers are invited to contribute more up-to-date speed comparisons
on the <a href="http://www.sqlite.org/cvstrac/wiki">SQLite Wiki</a>.
<p>
The numbers here are old enough to be nearly meaningless.  Until it is
updated, use this document only as proof that SQLite is not a
sluggard.
</b></font>

<h3>Executive Summary</h3>





|
|
<
<







1
2
3
4
5
6
7


8
9
10
11
12
13
14
<title>SQLite Database Speed Comparison</title>

<h2>Database Speed Comparison</h2>

<font color="red"><b>
Note:  This document is very very old.  It describes a speed comparison between
archaic versions of SQLite, MySQL and PostgreSQL.  


<p>
The numbers here are old enough to be nearly meaningless.  Until it is
updated, use this document only as proof that SQLite is not a
sluggard.
</b></font>

<h3>Executive Summary</h3>