Documentation Source Text

<li>[keyword index | Website Keyword Index]
</ul>
</var>

<ol>
<tcl>
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"
}
</tcl>
</ol>

<li>[keyword index | Website Keyword Index]
</ul>
</var>

<ol>
<tcl>
hd_keywords {alphabetical listing of documents}
db eval {
  CREATE TABLE IF NOT EXISTS expage(url UNIQUE, pagetitle);
  INSERT OR IGNORE INTO expage(url, pagetitle) VALUES
     ('https://sqlite.org/android/','Android Bindings')
  ;
}
db eval {
  SELECT filename, pagetitle
    FROM page
   WHERE pagetitle IS NOT NULL AND pagetitle!='No Title'
  UNION ALL
  SELECT url, pagetitle FROM expage
   ORDER BY pagetitle COLLATE nocase
} {
  hd_puts "<li><a href=\"$filename\">$pagetitle</a></li>\n"
}
</tcl>
</ol>

}
doc {Run-Time Loadable Extensions} {loadext.html} {
  A general overview on how run-time loadable extensions work, how they
  are compiled, and how developers can create their own run-time loadable
  extensions for SQLite.
}




heading {SQLite Features} features {
  Pages describing specific features or extension modules of SQLite.
}
doc {8+3 Filenames} {shortnames.html} {
  How to make SQLite work on filesystems that only support 
  8+3 filenames.
}
................................................................................
}

doc {Compilation Options} {compile.html} {
  This document describes the compile time options that may be set to 
  modify the default behavior of the library or omit optional features
  in order to reduce binary size.
}







heading {Upgrading SQLite, Backwards Compatibility} compat

doc {Moving From SQLite 3.5 to 3.6} {35to36.html} {
  A document describing the differences between SQLite version 3.5.9
  and 3.6.0.
}

}
doc {Run-Time Loadable Extensions} {loadext.html} {
  A general overview on how run-time loadable extensions work, how they
  are compiled, and how developers can create their own run-time loadable
  extensions for SQLite.
}




heading {SQLite Features} features {
  Pages describing specific features or extension modules of SQLite.
}
doc {8+3 Filenames} {shortnames.html} {
  How to make SQLite work on filesystems that only support 
  8+3 filenames.
}
................................................................................
}

doc {Compilation Options} {compile.html} {
  This document describes the compile time options that may be set to 
  modify the default behavior of the library or omit optional features
  in order to reduce binary size.
}

doc {Android Bindings for SQLite} {https://sqlite.org/android/} {
  A description of how to compile your own SQLite for Android
  (bypassing the SQLite that is built into Android) together with
  code and makefiles.
}

heading {Upgrading SQLite, Backwards Compatibility} compat

doc {Moving From SQLite 3.5 to 3.6} {35to36.html} {
  A document describing the differences between SQLite version 3.5.9
  and 3.6.0.
}

<ul class='lessindent'>
<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

<ul class='lessindent'>
<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'
  UNION ALL
  SELECT pagetitle, url FROM expage
} {
  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