Documentation Source Text

Leaves
Login

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

All leaves, both open and closed:

2024-03-28
14:56
Improved wording in the change log for the VALUES-as-coroutine optimization. (Leaf check-in: 33ef696a6a user: drh tags: trunk)
2024-03-18
18:59
Adjust download parameters to the assumption that the next release will be version 3.46.0. (Leaf check-in: 993b056b97 user: drh tags: branch-3.45)
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-13
19:04
Fix typos. Add a new CVE. (Leaf check-in: 0b88a38dfd user: drh tags: branch-3.44)
2023-12-05
16:07
Further tweaks for the JSONB documentation. (Closed-Leaf check-in: f6fad8006b user: drh tags: jsonb)
2023-10-24
11:39
Adjust the download page generator so that it can accept snapshot builds of the windows utility problems. (Leaf check-in: eeb54d184d user: drh tags: branch-3.43)
2023-08-14
10:54
Fix indentation of the menu on the docs page. Forum post b44b6e3547. (Leaf check-in: 5836f51eb9 user: drh tags: branch-3.42)
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-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-31
19:57
Get interdependent pages/.in files to be separately processable (for make faster.) (Leaf check-in: 7d59751a5e user: larrybr tags: inout-of-tree)
2023-02-27
03:04
Make spell target work out-of-tree too. (Closed-Leaf check-in: 6bc167df1c user: larrybr tags: inout_of_tree)
2023-02-19
23:57
Updates to the text describing when RTree and Geopoly are available in amalgamation builds. (Leaf check-in: 58bfae254b user: drh tags: branch-3.40)
2023-01-02
13:47
Cherry-pick branch-3.40 changes (and fix internal links therein.) (Leaf check-in: 139fb64868 user: larrybr tags: docgen_tweaks)
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-22
09:11
Final polishing of code changes associated with incremental docs build. (Ready to be relearned years later!) Fix "last modified on ... footer", broken sometime this fall. (Closed-Leaf check-in: fc97ab336e user: larrybr tags: docgen_speedup)
2022-12-14
16:04
Add a link from the "whentouse.html" page to the HN discussion from yesterday about using SQLite for websites. (Leaf check-in: 5ee6756831 user: drh tags: branch-3.39)
2022-10-26
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-06-18
09:43
Remove references to Flame malware (Leaf check-in: 6e88ae990e user: drh tags: branch-3.38)
2022-04-24
19:48
Document CLI enhancements and extensibility (Leaf check-in: 0131658331 user: larrybr tags: cli_extension)
2022-03-08
09:51
Update the Bloomberg logo and hyperlink, by request. (Closed-Leaf check-in: d8b8a493e3 user: drh tags: branch-3.38)
2022-02-17
20:45
Fix type on the Operators table of lang_expr.html. (Leaf check-in: b9e687671b user: drh tags: branch-3.37)
2022-02-08
12:34
Remove an internal-only result code from API docs (Closed-Leaf check-in: 6e9f29aa01 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:17
In storage class/datatype explication, link the record format as available further detail. (Leaf check-in: fb1f0bd41b user: larrybr tags: mistake)
2021-10-22
19:22
Add a note about CVE-2021-42169. (Leaf check-in: 9c2a89cd40 user: drh tags: branch-3.36)
2021-08-20
15:27
First bits of documentation about STRICT tables. (Closed-Leaf check-in: 0b842e6e48 user: drh 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)
16:36
Minor formatting enhancements to the new precedence description in the Expression documentation. (Closed-Leaf check-in: 43247e25e1 user: drh tags: operator_traits)
2021-06-18
13:43
Update the built-in copies of wapp.tcl to the latest version that fixes the backslash problem reported by SQLite forum post 8fb639b5ad. (Leaf check-in: a92de28e5e user: drh tags: branch-3.35)
2021-03-04
18:38
Temporary work-around for sqlite3 shell bug. (.ar -c with sqlite3 -append fails.) (Closed-Leaf check-in: 9fb7386101 user: larrybr tags: build_de-nit)
2021-02-25
14:48
Clarify: [NOT] MATERIALIZE is a hint, not a dictate. (Closed-Leaf check-in: a0fb8ec14b user: larrybr tags: as-materialized-redux)
2021-02-17
13:13
Typo fix and clarification on the description of the ".width" argument in the CLI. (Leaf check-in: fdb416d609 user: drh tags: branch-3.34)
2021-02-12
19:05
Mention NFS fsync() issues in How To Corrupt ... section. (Closed-Leaf check-in: 518e2ac357 user: larrybr tags: use_over_network)
2021-02-11
18:21
New target, doc/<whatever>.html , for speedy, single docpage development. (Leaves red links now.) (Leaf check-in: 45149b39ce user: larrybr tags: faster_make)
18:12
Create new branch named "build_streamline" (Leaf check-in: 8438309f9a user: larrybr tags: build_streamline)
2021-02-09
00:10
Modify sqldiff docs to mention empty --changeset output for certain rowid-hidden and PK-less tables. (Closed-Leaf check-in: 1b2ddbe529 user: larrybr tags: sqldiff_changeset)
2021-02-03
01:12
Add the SQLITE_DBCONFIG_ENABLE_TRIGGER change to the change log. Updates to the RETURNING documentation. (Closed-Leaf check-in: e95fde2606 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-10-20
19:05
Enhance the "timeline" link on the prerelease snapshot to use the p= and bt= query parameters in order to see all branches that have contributed to the build product. (Leaf check-in: 6346afca54 user: drh tags: branch-3.33)
2020-09-26
22:29
Create a TCL script that converts all *.pikchr files into *.svg files and constructs syntax_linkage and syntax_order. Clean up legacy. (Closed-Leaf check-in: c877e0ff4a user: drh tags: svg-syntax)
2020-08-06
11:12
In the search script, remove all punctuation from the search string before injecting it into TCL. (Leaf check-in: 382a046780 user: drh tags: branch-3.32)
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-21
19:16
Fix typo in the query planner documentation. (Leaf check-in: c3875b77fa user: drh tags: branch-3.31)
2020-01-08
11:12
Further clarification that collating functions only work on string values. (Leaf check-in: ba755cbcaa user: drh tags: branch-3.30)
2019-10-02
11:36
Add the ability to put an ad unit at the top of the index page and the download page. If the file "adunit.txt" exists in the build directory, then the content of that file is copied into the appropriate spot on those two pages. (Leaf check-in: ea232463fc user: drh tags: branch-3.29)
2019-08-12
10:27
Minor improvements to dashboard. (Closed-Leaf check-in: 44eb5d574e user: drh tags: test-dashboard)
2019-07-09
09:48
Fix documentation typo. (Leaf check-in: ee5e3f5b43 user: drh tags: branch-3.28)
2019-06-17
13:56
Track the revised DQS interface. (Closed-Leaf check-in: 09cea3924b 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-08
18:08
Fix a minor error in the datatype documentation. (Leaf check-in: 87bef3d123 user: drh tags: branch-3.27)
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-15
20:31
Mention the use of SCGI in the althttpd.md file. (Closed-Leaf check-in: d2ad0c8ca6 user: drh tags: althttpd-scgi)
2019-01-29
18:59
Fix a typo in the date-time function documentation. (Leaf check-in: 0866c95aaf user: drh tags: branch-3.26)
2018-11-26
12:01
Fix typo in the wal.html document. (Leaf check-in: 4182b1655e user: drh tags: branch-3.25)
2018-09-02
10:12
Fix a duplicate anchor in the lang.in page. (Leaf check-in: 718909cfaf user: drh tags: branch-3.24)
2018-06-08
13:21
Use https for all internal hyperlinks. (Leaf check-in: 59e5f9e3da user: drh tags: branch-3.24-https)
2018-05-17
10:02
New advantage of SQLite Archives: Bypass firewall censorship. (Leaf check-in: ef0b96b340 user: drh tags: branch-3.23)
2018-04-10
00:29
Fix a typo in the whynotgit.html document. (Leaf check-in: 737022637a user: drh tags: version-3.23)
2018-03-23
23:09
Typos and minor wording changes to the CoC intro to bring it into alignment with the trunk. (Leaf check-in: 29d1943774 user: drh tags: branch-3.22)
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-05
01:15
Update the built-in wapp.tcl to the latest from wapp.tcl.tk. (Closed-Leaf check-in: 9c03c81fbb user: drh tags: search-refactor)
2018-01-13
20:39
Fix typo in the how-to-corrupt document. (Cherrypick from trunk) (Leaf check-in: 97e70fb787 user: drh tags: branch-3.21)
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-09-29
12:50
Consistent name for the "SQLite In 5 Minutes Or Less" document. (Leaf check-in: 14bfb3bcf4 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-23
17:07
Fix the hyperlinks to the mailing lists. (Leaf check-in: 2785e9dd6c user: drh tags: branch-3.19)
2017-05-10
16:38
Update the 35%-faster document to the latest from trunk. (Leaf check-in: 7e41434c2b user: drh tags: branch-3.18)
2017-03-20
12:25
Include a link to the draft change log on Pre-Release Snapshots on the download page. (Leaf check-in: 1b710ef1fc 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-11-28
19:35
Clarify the Python entry on the famous users page. (Leaf check-in: b233527c05 user: drh tags: branch-3.15)
2016-09-21
04:21
Remove duplicate disadvantage to WAL mode. (Leaf check-in: aa3809f595 user: drh tags: branch-3.14)
2016-09-02
12:22
Fix the hyperlink on the logo. (Closed-Leaf check-in: 6fc0f8db82 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
20:18
Add the $(TCLINC) to the arguments to build tclsh.docsrc (Closed-Leaf check-in: 8d6ba1bfab user: drh tags: experimental)
15:41
Change the "show table-of-contents" setting so that it is off by default. Setting is still persistent. (Closed-Leaf check-in: a0e88fec0c 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-05-05
13:28
Clarify that using an database file with a link count different from 1 results in undefined behavior. (Leaf check-in: 7c96132d65 user: drh tags: branch-3.12)
2016-03-26
23:12
Update TH3 license information. (Leaf check-in: 84f9b8afc2 user: drh tags: branch-3.11)
2016-02-12
05:17
Change "Universal App Platform" to "Universal Windows Platform". (Leaf check-in: 4802ce4c0a user: drh tags: branch-3.10)
2016-01-02
04:14
Further tweaks to the website. (Leaf check-in: 5619b986d5 user: drh tags: bubble-generator-tkpath)
2015-12-28
16:20
Add links to the built-in SQL function documentation to the docs.html page. (Leaf check-in: 51cd2291e6 user: drh tags: branch-3.9)
2015-12-09
11:50
Omit the blurbs from sponsor icons. (Closed-Leaf check-in: f42cb2d82f user: drh tags: new-sponsors-layout)
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-07-01
17:34
Fix a typo in the zero-malloc memory allocator documentation. (Leaf check-in: a3a3160989 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-03-16
22:22
Fix typos in the FAQ. (Leaf check-in: 973dd7c44b user: drh tags: branch-3.8.8)
2015-01-12
12:37
Fix typos in the whentouse.html document. (Leaf check-in: 6ee4cecc7e user: drh tags: branch-3.8.7)
2014-09-24
13:26
Clarify that bound parameters may not appear in the DEFAULT clause of a CREATE TABLE statement. (Leaf check-in: c914be12fe user: drh tags: version-3.8.6)
2014-05-26
23:18
Fix Win32 to say Win64 for 64-bit DLLs on the download page. (Leaf check-in: e56e2046b0 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-10-01
01:01
Fix a typo on the release date for 3.8.0.2. (Closed-Leaf check-in: 46516308c7 user: drh tags: branch-3.8.0)
2013-08-22
20:28
Clearly label the source code snapshots on the download page as source code. (Leaf check-in: 0e1cfbafc8 user: drh tags: 3.7.17)
2013-08-20
03:06
Revised and amplified definition of the tointeger() and toreal() functions. (Leaf check-in: 85757c1492 user: drh tags: toTypeFuncs)
2013-08-02
18:27
Corrections to partial index documentation. (Closed-Leaf check-in: 3e022afe53 user: drh tags: partial-indices)
2013-04-12
12:17
Add sha1sum and source id for version 3.7.16.2 (Leaf check-in: 278390b656 user: dan tags: branch-3.7.16)
2012-10-30
18:12
Further tweaks to the download page. (Leaf check-in: 87c65ed934 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
14:45
News updates for the 3.7.6.3 release. (Leaf check-in: ef14f9a3d4 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-12-12
11:14
Experimental: Attempt yet another method for implementing cross-browser pulldown menus. (Closed-Leaf check-in: 81ab7ec21a user: dan tags: trunk)
2007-11-15
12:44
Change the motto on the upper right. (Closed-Leaf check-in: bac03a29c9 user: drh tags: trunk)