Documentation Source Text

Artifact Content
Login

Artifact 307b47fd808bff47764913dae1c96c3456845850:


<title>SQLite Site Map</title>

<h2>Popular Pages:</h2>

<table border=0 width="100%">
<tr><td valign=top><ul>
<li> <a href="features.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="quickstart.html">Getting Started</a> </li>
<li> <a href="whentouse.html">When To Use SQLite</a> </li>
<li> <a href="different.html">Distinctive Features</a> </li>
<li> <a href="doclist.html">Alphabetical list of docs</a> </li>
<li> <a href="books.html">Books About SQLite</a> </li>
<li> <a href="keyword_index.html">Website Keyword Index</a> </li>
</ul><td valign=top><ul>
<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 &amp; time functions</a>
<li> <a href="lang_aggfunc.html">Aggregate functions</a>
</ul>
<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>
</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>

<tcl>hd_fragment pindex {permuted index}</tcl>
<h2>Permuted Index:  
<small><a href="http://en.wikipedia.org/wiki/Key_Word_in_Context">(what is
this?)</a></small></h2>

<table align=right border=1 cellpadding=10>
<tr><td>Other Documentation Indices:
<ul>
<li>[categorical listing of SQLite documents | Categorical Document List]
<li>[books about SQLite | Books About SQLite]
<li>[doclist | Alphabetical List Of Documents]
<li>[keyword index | Website Keyword Index]
</ul>
</table>

<ul>
<tcl>
db eval {
  DROP TABLE IF EXISTS px;
  CREATE TEMP TABLE px(title COLLATE nocase,link);
}
db eval {SELECT pagetitle, filename FROM page WHERE pagetitle!='No Title'} {
  set nword [llength $pagetitle]
  db eval {INSERT INTO px VALUES($pagetitle, $filename)}
  for {set i 1} {$i<$nword} {incr i} {
    set firstpart [lrange $pagetitle 0 [expr {$i-1}]]
    set lastpart [lrange $pagetitle $i end]
    set w [string tolower [lindex $lastpart 0]]
    if {![regexp {^[a-z]} $w]} continue
    if {[string length $w]<3} continue
    if {$w=="sqlite" || $w=="for" || $w=="the"} continue
    set perm "$lastpart &#151; $firstpart"
    db eval {INSERT INTO px VALUES($perm,$filename)}
  }
}
db eval {
  SELECT title, link FROM px ORDER BY title
} {
  hd_puts "<li><a href=\"$link\">$title</a></li>"
} 
</tcl>
</ul>