Documentation Source Text

Timeline
Login

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

146 check-ins using file pages/docsdata.tcl version f9bb522c3d

2017-05-02
18:46
Update the change log and the speed-and-size graph. (check-in: 03fde5ae27 user: drh tags: trunk)
01:31
Fix typo. (check-in: f230c5ce7d user: mistachkin tags: trunk)
2017-04-29
18:03
Further improvements to the opcode.html document. (check-in: 1f4f0600ef user: drh tags: trunk)
16:55
Improved background information on the bytecode engine. (check-in: 21168dec96 user: drh tags: trunk)
2017-04-18
11:52
Update to the flattening optimization description in the optoverview.html page. Add a new bullet to the change log for 3.19.0. (check-in: d26b238e7e user: drh tags: trunk)
11:40
Add a change log entry for the pending 3.19.0 release. (check-in: 31ead1aade user: drh tags: trunk)
11:07
Update the perfomance and size spreadsheet with the latest figures. (check-in: 7b34966b61 user: drh tags: trunk)
2017-04-17
18:13
Update the documentation on the foreign_key_check pragma to explain that the second output column is NULL for WITHOUT ROWID child tables. (check-in: af6ceab74d user: drh tags: trunk)
2017-04-13
09:59
Update fts5 docs to reflect support for a user column on the LHS of a MATCH operator. (check-in: ab263df2e6 user: dan tags: trunk)
2017-04-12
20:02
Attempt to clarify the operation of the page_size pragma. (check-in: 6d2df6128e user: drh tags: trunk)
20:00
Update fts5 documentation to reflect new column filter capability. (check-in: 27ba2d2d59 user: dan tags: trunk)
2017-04-11
23:14
Fix a typo on the compile.html page. (check-in: 5c613c450a user: drh tags: trunk)
19:19
Fix typos in the howtocorrupt.html document. (check-in: 20b925f012 user: drh tags: trunk)
19:15
Update the JSON1 documentation to state the 2000-level limit on recursion. (check-in: 0bcdcaff9c user: drh tags: trunk)
2017-04-08
11:38
Clarify what it means when it says "JSON1 is not available by default." (check-in: 16bd995f65 user: drh tags: trunk)
2017-03-31
15:40
Fix typos and clarify text in the sessionintro.html document. (check-in: 1bac33959e user: drh tags: trunk)
2017-03-30
16:43
Add documentation for the unlock_notify method of the TCL interface. (check-in: d6dd485d18 user: drh tags: trunk)
15:02
Add a news entry for 3.18.0. (check-in: 8df001ccf7 user: drh tags: trunk)
14:13
Update the date of the 3.18.0 release in changes.in. (check-in: 52e170b093 user: dan tags: trunk, release, version-3.18.0)
11:49
Version 3.18.0 (check-in: b52ffdcfb4 user: drh tags: trunk)
2017-03-28
18:47
Update the size and speed spreadsheet. (check-in: 386e017de4 user: drh tags: trunk)
2017-03-24
19:19
Update the change log so that it shows the OP_Once bug fix. (check-in: 82e4157c6b user: drh tags: trunk)
2017-03-23
23:45
Add documentation for the json_patch() SQL function. (check-in: 3c4519094f user: drh tags: trunk)
2017-03-20
15:36
Report the fix of the sqlite3_trace_v2() output for nested SQL. (check-in: a432575098 user: drh tags: trunk)
14:42
Improved documentation for automatic analyze using PRAGMA optimize. (check-in: 1bbfd06810 user: drh tags: trunk)
13:05
Add the changes to SQLITE_SOURCE_ID to the change log. (check-in: 717afb7f73 user: drh tags: trunk)
12:26
Merge changes from the 3.17.0 release. (check-in: 3ff90dd03b user: drh tags: trunk)
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)
12:10
Refinements to the change log for 3.18.0. (check-in: 967d54a0f6 user: drh tags: trunk)
2017-03-17
23:06
The change log addition of the previous check-in went into the wrong release. This check-in fixes the problem. (check-in: 71622aac82 user: drh tags: trunk)
23:00
Add enforcement of SQLITE_LIMIT_VDBE_OP to the change log. (check-in: 6e5fa8b967 user: drh tags: trunk)
2017-03-16
20:26
Update the speed and size graph. (check-in: fe8607b103 user: drh tags: trunk)
12:55
Merge doc fixes from the 3.17.0 release. (check-in: bb08575574 user: drh tags: trunk)
12:49
Mention the requirement of Fossil 2.0 in getthecode.html. (check-in: 36cbd238b5 user: drh tags: 3.17)
2017-03-15
23:10
An initial top-level README.md file. (check-in: 1b99dd4dc8 user: drh tags: trunk)
20:51
Update the details of when the LIKE optimization is allowed, due to enhancements to the LIKE optimization logic in 3.18.0. (check-in: 7c122e0975 user: drh tags: trunk)
20:32
Further refinement to the loadable extension documentation. (check-in: cecf106465 user: drh tags: trunk)
15:59
Improvements to CLI documentation. Expand the Examples section of the loadable extension document. (check-in: d2d3de4f3f user: drh tags: trunk)
14:08
Fix typos and improve the wording of the .selftest documentation. (check-in: 6aaee6c270 user: drh tags: trunk)
13:56
Preliminary documentation for the .sha3sum and .selftest commands of the CLI. (check-in: a4e4f94863 user: drh tags: trunk)
2017-03-14
23:28
Tighten and formalize the hack in althttpd that allows .well-known path prefixes on URIs. (check-in: adbefa195f user: drh tags: trunk)
02:17
Modify althttpd.c to allow web content in the ".well-known" directory. (check-in: 10a66e4535 user: drh tags: trunk)
2017-03-10
16:37
Add documentation for the SQLITE_MAX_MEMORY compile-time option. (check-in: 268f62bc5a user: drh tags: trunk)
2017-03-09
13:36
Initial work on improving the CLI documentation. Much more needed here. (check-in: fcac2a0e45 user: drh tags: trunk)
12:06
Fix a typo in the date of the 3.16.1 release on news.html. (check-in: 46dd340a24 user: drh tags: 3.17)
2017-03-07
22:25
Fix a typo in the file format document. (check-in: 01b45f38af user: drh tags: trunk)
13:08
Merge the search form fix from the 3.17 branch. (check-in: 4a748fb25c user: drh tags: trunk)
13:05
Fix the action= link for the search form on pages that are not at the top level. (check-in: 564d1318f8 user: drh tags: 3.17)
00:51
Change the defined default mask for PRAGMA optimize to 0xfffe. (check-in: b4f5fcc3c8 user: drh tags: trunk)
2017-03-06
23:14
Fix typo in the pragma optimize documentation. (check-in: f61736804d user: drh tags: trunk)
21:03
More typo fixes and enhancements to the 3.18 change log. (check-in: fc711f28f5 user: drh tags: trunk)
20:54
Fix a typo in the 3.18 change log. (check-in: 82f55fbab0 user: drh tags: trunk)
20:49
Initial documentation changes for 3.18.0. Add documentation for PRAGMA optimize and update documentation for PRAGMA integrity_check and quick_check. (check-in: f7a0591178 user: drh tags: trunk)
19:56
Merge fixes from the 3.17 branch. (check-in: 02cadace0c user: drh tags: trunk)
11:34
Fix typos in the malloc.html document. (check-in: 31b59e00e5 user: drh tags: 3.17)
2017-03-04
20:09
Fix typo reported by Jeffrey Mattox. (check-in: 1a4aa7fa1d user: drh tags: 3.17)
2017-02-22
12:43
Fix typos in the documentation reported by Karol Swietlicki. (check-in: d24b5395d0 user: drh tags: 3.17)
2017-02-15
22:44
Fix a harmless typo in the rollback journal checksum algorithm description. (check-in: ebd7ef38cc user: drh tags: trunk)
22:43
Correct the rollback journal checksum algorithm description. (check-in: b69eaea914 user: drh tags: trunk)
2017-02-14
20:18
Enhanced documentation for the ".separator" and ".mode quote" commands in the CLI. (check-in: 95afd54c2e user: drh tags: trunk)
2017-02-13
16:13
Update dates and tags for the 3.17.0 release. Also fix a hyperlink target in the testing.html document. (check-in: 60bb99911d user: drh tags: trunk, release, version-3.17.0)
11:53
Update sessionintro.in to reflect the support for WITHOUT ROWID tables in the sessions module. (check-in: c6eb84e1aa user: dan tags: trunk)
2017-02-10
17:56
Add news for 3.17.0. Set the dates and check-in hash for 3.17.0. (check-in: 2ca5036003 user: drh tags: trunk)
2017-02-09
19:48
Final adjustments to the change log before starting release tests. (check-in: b6f0b02c8c user: drh tags: trunk)
2017-02-08
18:10
Clarification of a sentence in the R-Tree documentation. (check-in: 96728cbc13 user: drh tags: trunk)
2017-02-04
16:22
Update the preformance spreadsheet (check-in: 49eb6735bf user: drh tags: trunk)
15:16
Updates to the change log for 3.17.0. (check-in: 90822d4b15 user: drh tags: trunk)
14:45
Remove obsolete statements from the EXPLAIN QUERY PLAN documentation. (check-in: 735ffb4d2d user: drh tags: trunk)
2017-02-03
04:10
Clarify wording about PRAGMA synchronous=NORMAL and WAL mode. (check-in: 7660cac647 user: drh tags: trunk)
2017-02-02
23:55
Clarify the behavior of AUTOINCREMENT after an UPDATE. (check-in: f6e2eab4e7 user: drh tags: trunk)
14:48
Update the wording on the description of the WHEN clause on triggers. (check-in: 09d3dc5c51 user: drh tags: trunk)
2017-01-29
11:39
Fix an obsolete example in the FTS3 documentation. (check-in: c90c7a1015 user: drh tags: trunk)
2017-01-28
14:45
Updates to the performance graph spreadsheet. (check-in: 63d1835d75 user: drh tags: trunk)
2017-01-18
02:41
Clarification of affinity, especially in regard to views and subqueries. (check-in: 513684f098 user: drh tags: trunk)
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)
2017-01-12
20:25
Proposed enhancement to the definition of column affinity so that it covers columns belonging to subqueries and VIEWs. (check-in: 524ba450fb user: drh tags: trunk)
20:14
Begin adding changes for the 3.17.0 release. (check-in: 180288b238 user: drh tags: trunk)
19:43
Update the speed and size spreadsheet with the latest measurements from trunk. (check-in: 033eb12bb9 user: drh tags: trunk)
2017-01-06
17:28
Add a note about OSS Fuzz to the testing document. (check-in: f464b0a219 user: drh tags: trunk)
16:49
Second attempt at changing the date in news.html to 2017-01-06. (check-in: 05efe84bdd user: dan tags: trunk)
16:48
Change the date of the news.html entry for 3.16.2 to 2017-01-06. (check-in: 4cd739c3eb user: dan tags: trunk)
16:36
Adjust the change log and hashes for the 3.16.2 release. (check-in: 140541287d user: drh tags: trunk)
2017-01-05
17:53
Changes for the 3.16.2 release. (check-in: dea27852a0 user: drh tags: trunk)
2017-01-03
20:24
Version 3.16.1 (check-in: a9be5c2caa user: drh tags: trunk, release, version-3.16.1)
18:30
Add the final hashes and links for the 3.16.1 release. (check-in: 4d89cd68e7 user: drh tags: trunk)
16:45
Preliminary changes for the 3.16.1 release. (check-in: 9f0236befb user: drh tags: trunk)
15:32
Fix a typo in the change log. (check-in: 81b0ce16e7 user: drh tags: trunk)
2017-01-02
12:02
Add hashes and a chronology entry for the 3.16.0 release. (check-in: b01be9ce27 user: drh tags: trunk, release, version-3.16.0)
11:56
Added news for 3.16.0. Typo fixes and last-minute changes. (check-in: eb70d3b295 user: drh tags: trunk)
2016-12-31
19:55
Remove the not-found.html document. (check-in: 35ec903c39 user: drh tags: trunk)
15:41
Add lookaside change to the change log. Update testing stats. Other minor edits. (check-in: c31ae8096c user: drh tags: trunk)
2016-12-30
16:41
Update the cpu performance stats for Ubuntu 16.04 and GCC 5.4.0. (check-in: 0f60c6b4e4 user: drh tags: trunk)
2016-12-29
20:05
Typos and more updates to documentation. (check-in: 2e6a1f2be8 user: drh tags: trunk)
19:24
Fix a typo in imposter.html. (check-in: 1eb3e3ec71 user: drh tags: trunk)
18:39
Update the cpu-usage graph and the change log. Minor wording improvements in the datatype documentation. (check-in: aa485be4f2 user: drh tags: trunk)
2016-12-22
18:58
Information on PRAGMA table functions. (check-in: 70f4c8ee07 user: drh tags: trunk)
16:09
Updates to the performance graph spreadsheet. (check-in: 34c514f88e user: drh tags: trunk)
2016-12-16
21:26
Adjust the javascript that disables the search button on local browsing so that it works even on ancient browsers. (check-in: ea66b2e252 user: drh tags: trunk)
2016-12-14
11:31
Add the spreadsheet used to compute the performance graph. (check-in: 99240f2102 user: drh tags: trunk)
2016-12-13
19:11
Improve the wording on the change log entry for performance improvement. (check-in: cb109a5dc1 user: drh tags: trunk)
19:06
Update the change log to show a 6% CPU count reduction. Tweaks to the CPU usage measurement page. (check-in: fc30d4babb user: drh tags: trunk)
13:46
Updates to the memory-mapped I/O documentation to reflect that memory maps are always read-only. (check-in: 1b24b6113d user: drh tags: trunk)
00:11
Add in the latest CPU usage graph, showing version numbers along the graph line. (check-in: 3043f6595b user: drh tags: trunk)
2016-12-08
15:05
Add the CPU performance measurement document. (check-in: dd139223c4 user: drh tags: trunk)
2016-12-07
21:40
Boast about using 5% fewer CPU cycles on the change log for 3.16. (check-in: cd4044abac user: drh tags: trunk)
18:30
Improvements to wording and content of the SQLITE_UNTESTABLE docs. (check-in: 7133f9383a user: drh tags: trunk)
16:39
Update the change log to show the SQLITE_UNTESTABLE change. (check-in: dfe8cc2bd8 user: drh tags: trunk)
15:54
Improved documentation for SQLITE_OMIT_BUILTIN_TEST and SQLITE_UNTESTABLE. (check-in: 108398c17f user: drh tags: trunk)
2016-12-03
20:59
Update the change log for recent enhancements and bug fixes. (check-in: 332dab5c56 user: drh tags: trunk)
20:43
Improved sorting of the keyword index by ignoring initial punctuation characters. (check-in: 34fa170684 user: drh tags: trunk)
20:38
Simplified wording in the testing document. (check-in: 58ec3bd0d3 user: drh tags: trunk)
20:38
On the permuted title index, make unpermuted titles bold. (check-in: d0a0a01ce7 user: drh tags: trunk)
2016-11-30
19:07
Refinements to the bare column in aggregate query documentation. (check-in: f84dc83db4 user: drh tags: trunk)
2016-11-29
17:09
Merge more 3.15 changes into trunk. (check-in: a765b8866f user: drh tags: trunk)
2016-11-28
19:35
Clarify the Python entry on the famous users page. (Leaf check-in: b233527c05 user: drh tags: branch-3.15)
19:34
Fix a typo on the 3.15.2 change log, and add a News entry for 3.15.2. (check-in: 343d035585 user: drh tags: branch-3.15)
19:22
Merge changes from the 3.15 branch into trunk. (check-in: 1b36a2d2d4 user: drh tags: trunk)
19:18
Update change logs with the correct date for 3.15.2. (check-in: 0c84be29ea user: drh tags: branch-3.15)
2016-11-25
21:47
Fix typo in the FTS3/4 documentation. (check-in: 71a72a66ff user: drh tags: trunk)
20:10
More tweaks to the 3.15.2 change log. (check-in: 833bcb74d4 user: drh tags: branch-3.15)
13:37
Updates in preparation for the 3.15.2 release. (check-in: 7dce4ba2ff user: drh tags: branch-3.15)
2016-11-23
02:21
In the TCL interface documentation, mention that the busy callback takes a single integer argument which is the number of prior calls for the same locking event. (check-in: 215fcb1b90 user: drh tags: trunk)
2016-11-22
18:59
Further tweaks to language description due to row values. (check-in: 6d7d509612 user: drh tags: trunk)
18:37
SQL language documentation updates due to row values. (check-in: 437288e896 user: drh tags: trunk)
15:24
Discussion of bare columns in aggregate queries. (check-in: 8a4f72ebf1 user: drh tags: trunk)
14:05
Merge 3.15 branch changes into trunk. (check-in: 75391ba907 user: drh tags: trunk)
2016-11-04
13:14
Add a news entry for 3.15.1. (check-in: 953ce31e7e user: drh tags: branch-3.15)
12:12
Add the hashes for version 3.15.1. (check-in: e8b34d5547 user: drh tags: branch-3.15)
2016-11-03
19:02
Prepare for the 3.15.1 release. (check-in: 5b0368d51e user: drh tags: branch-3.15)
14:46
Add documentation on imposter tables. (check-in: 2f88520e33 user: drh tags: trunk)
13:27
Update the change log. (check-in: 06f94a998c user: drh tags: trunk)
2016-11-02
13:46
Start a change log for version 3.16.0. (check-in: c269f2074d user: drh tags: trunk)
13:31
Merge documentation fixes from the release. (check-in: fd68fab5c0 user: drh tags: trunk)
13:29
Further clarification of text in the AUTOINCREMENT documentation. (check-in: 3c7ab13e8b user: drh tags: trunk)
13:14
Add mention of LIKE and GLOB working with NOT NULL partial indexes. (check-in: 936fba6896 user: drh tags: trunk)
12:16
Fix typo in the rowvalue.html document. (check-in: a33b4bf02c user: drh tags: branch-3.15)
2016-10-31
19:02
Fix a broken link to the Lemon documentation. (check-in: 7434eb6397 user: drh tags: branch-3.15)
17:47
Update documentation on AUTOINCREMENT to indicate that it only works for INSERT and not UPDATE. (check-in: 71511a055b user: drh tags: trunk)
13:19
Additional cross-referencing of query planner documents. (check-in: e5277d7908 user: drh tags: trunk)
2016-10-27
15:12
Clarification to the incremental_vacuum documentation. (check-in: 767d991dda user: drh tags: trunk)
2016-10-25
14:50
Enhance the file format document to explain how sqlite_stat1 works for WITHOUT ROWID tables. (check-in: df4011932b user: drh tags: trunk)
2016-10-14
19:35
Fix typo on row value example. (check-in: 2d5915fdd8 user: drh tags: trunk)
10:23
Add hashes for 3.15.0 to the change log. Update the chronology. (check-in: 55f49500f9 user: drh tags: trunk)
10:16
Fix two spelling errors. (check-in: b951d26933 user: drh tags: trunk)
2016-10-13
17:09
Add the release date for 3.15.0. Still need to put in the SHA1 hash for the release check-in. Added a news entry. (check-in: c56346001f user: drh tags: trunk)
2016-10-12
22:22
Fix a typo. "CVS" should be "CSV". (check-in: ff0e70ab45 user: drh tags: trunk)