Documentation Source Text

Branches
Login

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

The initial check-in for each branch:

2024-03-12
10:50
Failed attempt at version 3.45.2 (Closed-Leaf check-in: 45a1292817 user: drh tags: mistake)
2024-01-29
11:00
Typo fixes for the 3.45.0 release. (Leaf check-in: d74c032847 user: drh tags: branch-3.45.0)
2024-01-21
18:05
Fix typos in the JSON documentation. (check-in: 256a6e16f5 user: drh tags: branch-3.45)
2024-01-09
20:02
Typo fixes. (check-in: a808fb2778 user: drh tags: branch-3.44)
2023-10-02
18:51
Initial cut attempt at JSONB documentation. (check-in: 686b8716f9 user: drh tags: jsonb)
2023-09-05
14:39
Improvements to the descriptions of threading modes, in an attempt to avoid confusion. (check-in: c93628caf3 user: drh tags: branch-3.43)
2023-06-19
17:09
Initial draft of support page for System.Data.SQLite. (Leaf check-in: 8d1d330648 user: mistachkin tags: sds)
2023-06-10
17:29
Documentation for SQLITE_DBCONFIG_STRICT_AGGREGATE. (Closed-Leaf check-in: 1d597840ae user: drh tags: newbie-safe-aggregates)
2023-06-07
13:17
Fix problem with example of inserting a symbolic link in zipfile.in. (check-in: 9546f48b09 user: drh tags: branch-3.42)
2023-05-30
12:46
Preliminary documentation for the new timediff() function. (Closed-Leaf check-in: 71097e7496 user: drh tags: timediff)
2023-04-28
22:12
Revise generate_series() extension description to better reflect its behavior with negative step arguments (conforming to like-named PostgreSQL function.) (Closed-Leaf check-in: ab33979fd6 user: larrybr tags: generate_series)
2023-04-15
15:42
Add documentation for 'secure-delete' to fts5.html. (Closed-Leaf check-in: 887ff60b31 user: dan tags: fts5-secure-delete)
2023-03-03
01:19
Complete (nearly) transition to explicit doc build output DEST dir. (check-in: c464faf208 user: larrybr tags: inout-of-tree)
2023-02-24
03:00
WIP: Make doc builds work in-tree and out-of-tree. (check-in: 89771190f9 user: larrybr tags: inout_of_tree)
2022-12-31
12:59
Add a reference to CVE-2022-38627, and in particular point out that this is not a bug in SQLite but rather an ordinary application bug. But put the change on a branch for now in as much as the CVE has not yet been published. (Leaf check-in: 3c86a0cf4e user: drh tags: cve-2022-38627)
2022-12-23
05:53
Minor improvements and nit removal for the docs build. (check-in: 1e14ef5d18 user: larrybr tags: docgen_tweaks)
2022-12-16
18:10
verison/version typo fix reported in [forum:f031a21c33]. (check-in: 0ee60d8811 user: drh tags: branch-3.40)
2022-12-03
17:10
Create incremental doc-gen for developer convience. Instead of scanning and re-rendering all page inputs, do so only for modified ones by maintaining and using a persistent DB for scanned info. A WIP just now. (check-in: a2de0ee407 user: larrybr tags: docgen_speedup)
2022-10-26
20:02
Fix minor typo. Forum post 1af006ebaf. (check-in: ce71f82b22 user: drh tags: branch-3.39)
06:05
Add download section for the wasm build. Tweak a setTimeout() call to avoid having to introduce a global-scope function. (Leaf check-in: 1bd6c2aee6 user: stephan tags: wasm-download)
2022-03-25
18:49
Changes for the 3.38.2 release. (check-in: f12d809ff8 user: drh tags: branch-3.38)
2022-03-08
01:13
Do not use "n=all" on timeline links. (check-in: a3a4ebe3dd user: drh tags: branch-3.38)
2022-02-08
04:36
Create new branch named "new-error-codes" (check-in: 77218bb929 user: larrybr tags: new-error-codes)
2022-01-11
14:09
Update JSON documentation for the addition of the -> and ->> operators and because JSON functions are moved into the core. (Closed-Leaf check-in: f688a6b35c user: drh tags: json-in-core)
2022-01-08
05:02
Update integer encoding details for file format 4 Edit: Move this check-in accidentally sets the execute bit on all files. Moving it to a branch. (check-in: bac82353db user: larrybr tags: mistake)
2021-12-21
00:11
Fix atan2() doc per https://sqlite.org/forum/forumpost/faa3cd2ca1 (check-in: 6910fc8239 user: drh tags: branch-3.37)
2021-08-21
21:04
Fix a typo in the lemon.html documentation page. (check-in: 7d8e36e6eb user: drh tags: branch-3.36)
2021-08-20
00:18
Document new STRICT table option (check-in: e668c1ce28 user: larrybr tags: strict-tables)
2021-07-19
16:45
Improvements to the description of how to get good error messages out of xBestIndex for required table-valued function parameters. (Leaf check-in: f6864997ba user: drh tags: xbestindex-errors)
2021-07-18
01:27
reorg operator precedence/associativity/aryness, and for more of them (check-in: 71f8627b5c user: larrybr tags: operator_traits)
2021-07-14
20:57
Create predecssor of shell extensibility doc. (check-in: a01e599239 user: larrybr tags: cli_extension)
2021-03-23
19:57
Changes associated with 3.35 patches. (check-in: 0e56b31f8c user: drh tags: branch-3.35)
2021-03-01
12:43
Create new branch named "build_de-nit" (check-in: 43b2a0c1fc user: larrybr tags: build_de-nit)
2021-02-22
15:27
Documentation on the materialization hints. (check-in: 01faf091f4 user: drh tags: as-materialized-redux)
2021-02-11
18:12
Create new branch named "build_streamline" (Leaf check-in: 8438309f9a user: larrybr tags: build_streamline)
2021-02-10
11:43
Create new branch named "faster_make" (check-in: aa700e13d1 user: larrybr tags: faster_make)
2021-02-09
15:31
Create new branch named "use_over_network" (check-in: fc8de90ffc user: larrybr tags: use_over_network)
2021-02-08
23:37
Create new branch named "sqldiff_changeset" (check-in: 25a3db0d3c user: larrybr tags: sqldiff_changeset)
2021-02-01
13:50
Add a syntax diagram for the RETURNING clause. (check-in: afce2544ec user: drh tags: returning)
2020-12-08
15:30
Documentation for the proposed generalizations to UPSERT. (Closed-Leaf check-in: d7320caafa user: drh tags: generalized-upsert)
2020-12-07
21:29
Create new branch named "branch-3.34" (check-in: c3fb1b50b1 user: drh tags: branch-3.34)
2020-09-21
14:23
Add infrastructure for porting syntax diagrams to SVG. (check-in: 277011128a user: drh tags: svg-syntax)
2020-08-27
13:32
Clarify the behavior of the "%" operator when presented with non-integer operands. (check-in: 153857859d user: drh tags: branch-3.33)
2020-07-17
17:35
Revise syntax diagrams to include the FROM clause on UPDATE statements. (Closed-Leaf check-in: bd9cdee968 user: drh tags: update-from)
2020-05-26
14:38
Typos in lang_transaction. (check-in: 12ea451a69 user: drh tags: branch-3.32)
2020-02-06
23:40
Clarification the UPSERT documentation. (check-in: 271f686636 user: drh tags: branch-3.31)
2019-11-01
23:58
Fix documentation for the ".explain auto" command. (check-in: c6125c2ae7 user: drh tags: branch-3.30)
2019-08-01
20:50
Initial code for a testing dashboard application. Not yet functional. (check-in: 67d3af93de user: drh tags: test-dashboard)
2019-07-16
13:44
Updates to the testing document. (check-in: 0d69a8d268 user: drh tags: branch-3.29)
2019-06-15
15:24
Documentation on the new SQLITE_DBCONFIG options. (check-in: 4ebc1051c2 user: drh tags: new-dbconfig-options)
2019-06-11
02:51
State that the COLLATE operator does not change affinity. (Leaf check-in: 5395fed295 user: drh tags: mistake)
2019-04-29
15:46
Soften the criticism of Go because of their decision to omit assert() from the language. (check-in: 4a40995c05 user: drh tags: branch-3.28)
2019-03-25
20:49
Update documentation to match the proposed window function changes. (Closed-Leaf check-in: 783032878d user: dan tags: window-functions)
2019-02-27
23:13
Add a note to the printf() documentation to make clear that the built-in SQLite printf() does not implement positional parameters. (check-in: e0c57dd3d0 user: drh tags: branch-3.27)
2019-02-15
20:14
Preliminary support for SCGI in althttpd. (check-in: b3aaed91ba user: drh tags: althttpd-scgi)
2018-12-09
22:31
Omit the sponsor links from the homepage. (check-in: 551ce8e2ad user: drh tags: branch-3.26)
2018-09-24
14:38
Improved linkage to window functions. (check-in: 1c7ab913f0 user: drh tags: branch-3.25)
2018-06-08
13:21
Use https for all internal hyperlinks. (Leaf check-in: 59e5f9e3da user: drh tags: branch-3.24-https)
2018-06-05
23:20
Clarification that the overwrite optimization does not affect the behavior of triggers. (check-in: 27b8057665 user: drh tags: branch-3.24)
2018-04-30
22:39
More detail on synchronous=NORMAL. (check-in: 13c3dff046 user: drh tags: branch-3.23)
2018-04-02
21:24
Fix a typo in the CLI document. (check-in: 7bf84d856a user: drh tags: version-3.23)
2018-02-22
13:42
Add a draft of a quality management plan based on DO178B. But the document seems to prolix, and so it is parked on a branch while I explore simpler alternatives. (Leaf check-in: 6a64bdf866 user: drh tags: do178b-qm-plan)
2018-02-04
21:41
Use Wapp to implement the search function. Search can now be run from the command-line using "./tclsh.docsrc doc/search". (check-in: 33c56bee81 user: drh tags: search-refactor)
2018-01-31
02:52
Typo in the how-to-corrupt document. (check-in: 6ad1abb448 user: drh tags: branch-3.22)
2017-12-19
17:34
Add docs for a proposed addition to the SQLite shell tool. (Closed-Leaf check-in: cd6f445782 user: dan tags: expert-in-shell)
2017-11-02
14:29
Fix typos in the affcase1.html document. (check-in: 7546b88643 user: drh tags: branch-3.21)
2017-08-07
01:43
Fix the hyperlinks to the subsequent pages on the search results page. (check-in: ffe3fc4ac0 user: drh tags: branch-3.20)
2017-08-01
19:24
Add a website option to search the changelog instead of the documentation. Do not add any changelog files to the documentation index. (Closed-Leaf check-in: 368f8fa51f user: dan tags: changelog-search)
2017-07-01
23:24
Attempt to improve the INSERT documentation. (check-in: 6b1a2005d8 user: drh tags: branch-3.19)
2017-05-05
12:55
Import the faster-than-filesystem document from trunk. (check-in: 488af3774f user: drh tags: branch-3.18)
2017-02-22
12:43
Fix typos in the documentation reported by Karol Swietlicki. (check-in: d24b5395d0 user: drh tags: 3.17)
2017-01-14
14:31
Update the download message for prerelease snapshots. Fix a typo in the 2017 dates of the chronology. (Leaf check-in: c22f7ef4b3 user: drh tags: branch-3.16)
2016-10-31
19:02
Fix a broken link to the Lemon documentation. (check-in: 7434eb6397 user: drh tags: branch-3.15)
2016-09-17
15:49
Provide a link to the draft changelog on the prerelease snapshot description. (check-in: 90de403f24 user: drh tags: branch-3.14)
2016-08-31
12:02
Use the experimental mobile-friendly menu. (check-in: b24301fa11 user: drh tags: mobile-friendly)
2016-08-30
20:14
Alternative page header suitable for loading content into Fossil for display. (Leaf check-in: 42802d730e user: drh tags: xdoc)
16:37
Draft chagnes to the VACUUM documentation to describe the ability to VACUUM attached databases. (Leaf check-in: 08b1963db5 user: drh tags: vacuum-enhancement)
2016-08-29
19:59
Run all make scripts using the same tclsh binary - "tclsh.docsrc". (check-in: 28358c49d7 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-07-22
15:23
Update docs for sqlite3_trace_v2(). (Leaf check-in: f5fc8bf5d8 user: drh tags: sqlite3_trace_v2)
2016-04-01
01:05
Add a change log entry for the query planner enhancement backport to 3.9.3. (check-in: cc1675f94a user: drh tags: branch-3.12)
2016-03-03
16:07
Changes for the 3.11.1 release. (check-in: 628be086c5 user: drh tags: branch-3.11)
2016-01-12
13:44
Fix typos in the TCL interface documentation. (check-in: 217ea4895f user: drh tags: branch-3.10)
2015-12-22
16:03
Modify the bubble-diagram generator script to use the TkPath extension. (check-in: 08bf2dfe78 user: chw tags: bubble-generator-tkpath)
2015-12-08
22:28
Experiment with a new look for the homepage and especially the layout of sponsor links. (check-in: f96d1199e7 user: drh tags: new-sponsors-layout)
2015-12-03
22:03
Fix a typo in the AUTOINCREMENT documentation. (check-in: 7c05c71d58 user: drh tags: branch-3.9)
2015-10-08
13:29
Proposed new version numbering scheme. (Closed-Leaf check-in: 82a2560a88 user: drh tags: new-version-numbering)
2015-09-15
12:36
Add the Expensify logo to the front page. (Leaf check-in: 37e5ed4e85 user: drh tags: branch-3.8.11)
2015-05-15
14:53
Link from the ATTACH documentation page to the DETACH page. Increased information about TH3. These are cherry-picks from trunk. (check-in: 643e08dfb8 user: drh tags: branch-3.8.10)
2015-04-21
17:50
Add the UAP VSIX to the prerelease snapshots section of the download page. (Leaf check-in: fe9930b07e user: drh tags: branch-3.8.9)
2015-02-17
19:09
Pull in the whentouse.html updates without waiting for the next release. (check-in: 1dfc552b2a user: drh tags: branch-3.8.8)
2014-10-29
11:15
Update the website for version 3.8.7. (check-in: fc792a76a2 user: drh tags: branch-3.8.7)
2014-09-08
12:11
Add the OpenDocument as SQLite case study. (Cherrypicked from trunk.) (check-in: a39452f2a5 user: drh tags: version-3.8.6)
2014-04-25
20:47
Fix more typos in the foreignkey.html document. (check-in: 25bc66990e user: drh tags: version-3.8.4.3)
2014-02-02
22:43
Enhancements to the bubble diagram generator. (Leaf check-in: 4dc85d1094 user: drh tags: bubble-diagrams)
2013-08-29
14:29
Preparations for the 3.8.0.1 patch release. (check-in: 8d74017a56 user: drh tags: branch-3.8.0)
2013-08-19
21:17
Initial docs for tointeger() and toreal() SQL functions. (check-in: 083cd58817 user: mistachkin tags: toTypeFuncs)
2013-08-01
18:23
Update syntax diagrams (on Mac OS 10.6.8 using Tk 8.5.7) for partial indices. (check-in: 6f7d9ba15e user: drh tags: partial-indices)
2013-06-26
19:13
Add the "Pre-release Snapshot" heading to the download page, with the ability to include winrt81 VSIX snapshots. (check-in: a8228d3c37 user: drh tags: 3.7.17)
2013-04-12
12:07
Changes for the 3.7.16.2 patch release. (check-in: 201b85a7c9 user: drh tags: branch-3.7.16)
2012-10-30
17:13
Tweaks to the download page. (check-in: e30d908c5a user: drh tags: branch-3.7.14)
2012-03-06
13:23
Add Bentley to the front page. (Leaf check-in: 02d2177a90 user: drh tags: version-3.7.10)
2011-05-19
12:59
Preparing for the 3.7.6.3 patch release. (check-in: f3ea1f0a36 user: drh tags: branch-3.7.6)
2011-05-13
16:57
Rather than document goofy behavior, better to make the behavior less goofy. (Was: Clarify in the documentation that last_insert_rowid() does not work for virtual tables.) (Closed-Leaf check-in: f102116e8a user: drh tags: mistake)
2010-08-04
16:19
Update the index, changes, and news pages for the 3.7.0.1 patch release. (Leaf check-in: 25417e1303 user: drh tags: branch-3.7.0)
2007-11-12
03:08
initial empty baseline (check-in: b2e03e19ab user: drh tags: trunk)