Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add experimental footer to each page featuring many of the links from docs.html. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | experimental |
Files: | files | file ages | folders |
SHA1: |
8200ba6e9a7f0ff162eb847add506d1e |
User & Date: | dan 2016-08-13 20:02:44.452 |
Context
2016-08-15
| ||
16:02 | Add links to each section at the top of the docs.html page. (check-in: 336ce36b23 user: dan tags: experimental) | |
2016-08-13
| ||
20:02 | Add experimental footer to each page featuring many of the links from docs.html. (check-in: 8200ba6e9a user: dan tags: experimental) | |
2016-08-11
| ||
19:12 | News item for 3.14.1 added. (check-in: 8d42b5de02 user: drh tags: trunk) | |
Changes
Changes to pages/docs.in.
︙ | ︙ | |||
12 13 14 15 16 17 18 | 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>} } | | | < | < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < | 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 | 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>" if {$caption ne ""} { hd_puts {<br />} hd_puts "$caption" } } source [file join $::DOC pages docsdata.tcl] </tcl> </table> |
Added pages/docsdata.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 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 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 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 | heading {Overview Documents} overview doc {About SQLite} {about.html} { A high-level overview of what SQLite is and why you might be interested in using it. } doc {Appropriate Uses For SQLite} {whentouse.html} { This document describes situations where SQLite is an appropriate database engine to use versus situations where a client/server database engine might be a better choice. } doc {Distinctive Features} {different.html} { This document enumerates and describes some of the features of SQLite that make it different from other SQL database engines. } doc {How SQLite Is Tested} {testing.html} { The reliability and robustness of SQLite is achieved in large part by thorough and careful testing. This document identifies the many tests that occur before every release of SQLite. } doc {Copyright} {copyright.html} { SQLite is in the public domain. This document describes what that means and the implications for contributors. } 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. } 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} { Also known as a "keyword in context" or "KWIC" index or as a concordance, this document is a listing of all other documents sorted by keyword. } heading {SQLite Programming Interfaces} programming { Documentation describing the APIs used to program SQLite, and the SQL dialect that it interprets. } doc {SQLite In 5 Minutes Or Less} {quickstart.html} { A very quick introduction to programming with SQLite. } doc {Introduction to the C/C++ API } {cintro.html} { This document introduces the C/C++ API. Users should read this document before the C/C++ API Reference Guide linked below. } doc {How To Compile SQLite} {howtocompile.html} { Instructions and hints for compiling SQLite C code and integrating that code with your own application. } doc {C/C++ API Reference} {c3ref/intro.html} { This document describes each API function separately. } doc {Result Codes} {rescode.html} { A description of the meanings of the numeric result codes returned by various C/C++ interfaces. } doc {Tcl API} {tclsqlite.html} { A description of the TCL interface bindings for SQLite. } doc {SQL Syntax} {lang.html} { This document describes the SQL language that is understood by SQLite. } doc {Pragma commands} {pragma.html} { This document describes SQLite performance tuning options and other special purpose database commands. } doc {Core SQL Functions} {lang_corefunc.html} { General-purpose built-in scalar SQL functions. } doc {Aggregate SQL Functions} {lang_aggfunc.html} { General-purpose built-in aggregate SQL functions. } doc {Date and Time SQL Functions} {lang_datefunc.html} { SQL functions for manipulating dates and times. } doc {JSON SQL Functions} {json1.html} { SQL functions for creating, parsing, and querying JSON content. } doc {DataTypes} {datatype3.html} { SQLite version 3 introduces the concept of manifest typing, where the type of a value is associated with the value itself, not the column that it is stored in. This page describes data typing for SQLite version 3 in further detail. } heading {SQLite Features and Extensions} extensions { 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 {Autoincrement} {autoinc.html} { A description of the AUTOINCREMENT keyword in SQLite, what it does, why it is sometimes useful, and why it should be avoided if not strictly necessary. } doc {Backup API} {backup.html} { The [sqlite3_backup_init | online-backup interface] can be used to copy content from a disk file into an in-memory database or vice versa and it can make a hot backup of a live database. This application note gives examples of how. } doc {Command-Line Shell} {cli.html} { Notes on using the "sqlite3.exe" command-line interface that can be used to create, modify, and query arbitrary SQLite database files. } doc {Error and Warning Log} {errlog.html} { SQLite supports an "error and warning log" design to capture information about suspicious and/or error events during operation. Embedded applications are encouraged to enable the error and warning log to help with debugging application problems that arise in the field. This document explains how to do that. } doc {Foreign Key Support} {foreignkeys.html} { This document describes the support for foreign key constraints introduced in version 3.6.19. } doc {Full Text Search} {fts3.html} { A description of the SQLite Full Text Search (FTS3) extension. } doc {Indexes On Expressions} {expridx.html} { Notes on how to create indexes on expressions instead of just individual columns. } doc {Internal versus External Blob Storage} {intern-v-extern-blob.html} { Should you store large BLOBs directly in the database, or store them in files and just record the filename in the database? This document seeks to shed light on that question. } doc {Limits In SQLite} {limits.html} { This document describes limitations of SQLite (the maximum length of a string or blob, the maximum size of a database, the maximum number of tables in a database, etc.) and how these limits can be altered at compile-time and run-time. } doc {Memory-Mapped I/O} {mmap.html} { SQLite supports memory-mapped I/O. Learn how to enable memory-mapped I/O and about the various advantages and disadvantages to using memory-mapped I/O in this document. } doc {Multi-threaded Programs and SQLite} {threadsafe.html} { SQLite is safe to use in multi-threaded programs. This document provides the details and hints on how to maximize performance. } doc {Null Handling} {nulls.html} { Different SQL database engines handle NULLs in different ways. The SQL standards are ambiguous. This (circa 2003) document describes how SQLite handles NULLs in comparison with other SQL database engines. } doc {Partial Indexes} {partialindex.html} { A partial index is an index that only covers a subset of the rows in a table. Learn how to use partial indexes in SQLite from this document. } doc {R-Trees} {rtree.html} { A description of the SQLite R-Tree extension. An R-Tree is a specialized data structure that supports fast multi-dimensional range queries often used in geospatial systems. } 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. } doc {Shared Cache Mode} {sharedcache.html} { Version 3.3.0 and later supports the ability for two or more database connections to share the same page and schema cache. This feature is useful for certain specialized applications. } doc {Unlock Notify} {unlock_notify.html} { The "unlock notify" feature can be used in conjunction with [shared cache mode] to more efficiently manage resource conflict (database table locks). } doc {URI Filenames} {uri.html} { The names of database files can be specified using either an ordinary filename or a URI. Using URI filenames provides additional capabilities, as this document describes. } doc {WITHOUT ROWID Tables} {withoutrowid.html} { The WITHOUT ROWID optimization is a option that can sometimes result in smaller and faster databases. } doc {Write-Ahead Log (WAL) Mode} {wal.html} { Transaction control using a write-ahead log offers more concurrency and is often faster than the default rollback transactions. This document explains how to use WAL mode for improved performance. } heading {Advocacy} advocacy { Documents that strive to encourage the use of SQLite. } doc {SQLite As An Application File Format} {appfileformat.html} { This article advocates using SQLite as an application file format in place of XML or JSON or a "pile-of-file". } doc {Well Known Users} {famous.html} { This page lists a small subset of the many thousands of devices and application programs that make use of SQLite. } heading {SQLite Technical/Design Documentation} technical { These documents are oriented toward describing the internal implementation details and operation of SQLite. } doc {How Database Corruption Can Occur} {howtocorrupt.html} { SQLite is highly resistant to database corruption. But application, OS, and hardware bugs can still result in corrupt database files. This article describes many of the ways that SQLite database files can go corrupt. } doc {Temporary Files Used By SQLite} {tempfiles.html} { SQLite can potentially use many different temporary files when processing certain SQL statements. This document describes the many kinds of temporary files that SQLite uses and offers suggestions for avoiding them on systems where creating a temporary file is an expensive operation. } doc {In-Memory Databases} {inmemorydb.html} { SQLite normally stores content in a disk file. However, it can also be used as an in-memory database engine. This document explains how. } doc {How SQLite Implements Atomic Commit} {atomiccommit.html} { A description of the logic within SQLite that implements transactions with atomic commit, even in the face of power failures. } doc {Dynamic Memory Allocation in SQLite} {malloc.html} { SQLite has a sophisticated memory allocation subsystem that can be configured and customized to meet memory usage requirements of the application and that is robust against out-of-memory conditions and leak-free. This document provides the details. } doc {Customizing And Porting SQLite} {custombuild.html} { This document explains how to customize the build of SQLite and how to port SQLite to new platforms. } doc {Locking And Concurrency<br>In SQLite Version 3} {lockingv3.html} { A description of how the new locking code in version 3 increases concurrency and decreases the problem of writer starvation. } doc {Isolation In SQLite} {isolation.html} { When we say that SQLite transactions are "serializable" what exactly does that mean? How and when are changes made visible within the same database connection and to other database connections? } doc {Overview Of The Optimizer} {optoverview.html} { A quick overview of the various query optimizations that are attempted by the SQLite code generator. } doc {The Next-Generation Query Planner} {queryplanner-ng.html} { Additional information about the SQLite query planner, and in particular the redesign of the query planner that occurred for version 3.8.0. } doc {Architecture} {arch.html} { An architectural overview of the SQLite library, useful for those who want to hack the code. } doc {VDBE Opcodes} {opcode.html} { This document is an automatically generated description of the various opcodes that the VDBE understands. Programmers can use this document as a reference to better understand the output of EXPLAIN listings from SQLite. } doc {Virtual Filesystem} {vfs.html} { The "VFS" object is the interface between the SQLite core and the underlying operating system. Learn more about how the VFS object works and how to create new VFS objects from this article. } doc {Virtual Tables} {vtab.html} { This article describes the virtual table mechanism and API in SQLite and how it can be used to add new capabilities to the core SQLite library. } doc {SQLite File Format} {fileformat2.html} { A description of the format used for SQLite database and journal files, and other details required to create software to read and write SQLite databases without using SQLite. } 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 {Moving From SQLite 3.4 to 3.5} {34to35.html} { A document describing the differences between SQLite version 3.4.2 and 3.5.0. } doc {Release History} {changes.html} { A chronology of SQLite releases going back to version 1.0.0 } doc {Backwards Compatibility} {formatchng.html} { This document details all of the incompatible changes to the SQLite file format that have occurred since version 1.0.0. } doc {Private Branches} {privatebranch.html} { This document suggests procedures for maintaining a private branch or fork of SQLite and keeping that branch or fork in sync with the public SQLite source tree. } heading {Obsolete Documents} obsolete { The following documents are no longer current and are retained for historical reference only. These documents generally pertain to out-of-date, obsolete, and/or deprecated features and extensions. } doc {Asynchronous IO Mode} {asyncvfs.html} { This page describes the asynchronous IO extension developed alongside SQLite. Using asynchronous IO can cause SQLite to appear more responsive by delegating database writes to a background thread. <i>NB: This extension is deprecated. [WAL mode] is recommended as a replacement.</i> } doc {Version 2 C/C++ API} {c_interface.html} { A description of the C/C++ interface bindings for SQLite through version 2.8 } doc {Version 2 DataTypes } {datatypes.html} { A description of how SQLite version 2 handles SQL datatypes. Short summary: Everything is a string. } doc {VDBE Tutorial} {vdbe.html} { The VDBE is the subsystem within SQLite that does the actual work of executing SQL statements. This page describes the principles of operation for the VDBE in SQLite version 2.7. This is essential reading for anyone who want to modify the SQLite sources. } doc {SQLite Version 3} {version3.html} { A summary of the changes between SQLite version 2.8 and SQLite version 3.0. } doc {Version 3 C/C++ API} {capi3.html} { A summary of the API related changes between SQLite version 2.8 and SQLite version 3.0. } doc {Speed Comparison} {speed.html} { The speed of version 2.7.6 of SQLite is compared against PostgreSQL and MySQL. } |
Added pages/footer.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 | catch { array unset ::footer } set ::footer(current) "" proc heading {text tag {caption {}}} { set ::footer(current) $tag set ::footer(name,$tag) $text } proc doc {name url desc} { set name [string map [list "\n" " " "<br>" " "] $name] lappend ::footer(docs,$::footer(current)) $name $url } source [file join [file dirname [info script]] docsdata.tcl] proc footer_list {tag} { set ret "<div class=doccat>\n" append ret "<h><a href=docs.html#$tag>$::footer(name,$tag)</a>\n</h>" append ret "<ul>\n" foreach {name url} $::footer(docs,$tag) { append ret "<li> <a href=$url>$name</a>\n" } append ret "</ul>\n" append ret "</div>\n" return $ret } hd_puts "<div class=footer>" hd_puts "<table class=footertab align=center><tr><td valign=top>" hd_puts [footer_list overview] hd_puts [footer_list programming] hd_puts "<td valign=top>" hd_puts [footer_list advocacy] hd_puts [footer_list technical] hd_puts "<td valign=top>" hd_puts [footer_list extensions] hd_puts </table> hd_puts </div> |
Changes to pages/index.in.
︙ | ︙ | |||
142 143 144 145 146 147 148 | <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> | > > | 142 143 144 145 146 147 148 149 150 | <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> |
Changes to wrap.tcl.
︙ | ︙ | |||
471 472 473 474 475 476 477 478 479 480 481 482 483 484 | .yyterm { background: #fff; border: 1px solid #000; border-radius: 11px; padding-left: 4px; padding-right: 4px; } </style> } puts $fd {</head>} if {[file exists DRAFT]} { set tagline {<font size="6" color="red">*** DRAFT ***</font>} } else { set tagline {Small. Fast. Reliable.<br>Choose any three.} | > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 | .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 { margin-left: 2ex; margin-right: 2ex; white-space:nowrap; } .doccat li { list-style-type: none; font-size: smaller; } .footer { background-color: #044a64; padding-top: 2px; padding-bottom: 1px; } .footertab { padding-top: 1ex; background-color: white; } </style> } puts $fd {</head>} if {[file exists DRAFT]} { set tagline {<font size="6" color="red">*** DRAFT ***</font>} } else { set tagline {Small. Fast. Reliable.<br>Choose any three.} |
︙ | ︙ | |||
778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 | # Second pass. Process all files again. This time render hyperlinks # according to the keyword information collected on the first pass. # proc hd_keywords {args} {} rename hd_resolve {} rename hd_resolve_2ndpass hd_resolve proc hd_requirement {args} {} foreach infile [lrange $argv 3 end] { cd $HOMEDIR puts "Processing $infile" set fd [open $infile r] set in [read $fd] close $fd if {[regexp {<(fancy_format|table_of_contents)>} $in]} { set in [addtoc $in] } set title {No Title} regexp {<title>([^\n]*)</title>} $in all title regsub {<title>[^\n]*</title>} $in {} in set outfile [file root [file tail $infile]].html hd_open_main $outfile hd_header $title $infile regsub -all {<tcl>} $in "\175; eval \173" in regsub -all {</tcl>} $in "\175; hd_resolve \173" in eval "hd_resolve \173$in\175" cd $::HOMEDIR hd_close_main } # Generate a document showing the hyperlink keywords and their # targets. # | > > | 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 | # Second pass. Process all files again. This time render hyperlinks # according to the keyword information collected on the first pass. # proc hd_keywords {args} {} rename hd_resolve {} rename hd_resolve_2ndpass hd_resolve proc hd_requirement {args} {} set footertcl [file normalize [file join $::DOC pages footer.tcl]] foreach infile [lrange $argv 3 end] { cd $HOMEDIR puts "Processing $infile" set fd [open $infile r] set in [read $fd] close $fd if {[regexp {<(fancy_format|table_of_contents)>} $in]} { set in [addtoc $in] } set title {No Title} regexp {<title>([^\n]*)</title>} $in all title regsub {<title>[^\n]*</title>} $in {} in set outfile [file root [file tail $infile]].html hd_open_main $outfile hd_header $title $infile regsub -all {<tcl>} $in "\175; eval \173" in regsub -all {</tcl>} $in "\175; hd_resolve \173" in eval "hd_resolve \173$in\175" source $footertcl cd $::HOMEDIR hd_close_main } # Generate a document showing the hyperlink keywords and their # targets. # |
︙ | ︙ |