Documentation Source Text

Timeline
Login

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

311 check-ins using file pages/copyright.in version 43b7e8cdc9

2017-06-02
11:27
Fix a typo in the session documentation. (check-in: acfc24126f user: drh tags: trunk)
11:24
Remove an incorrect statement about sessions and WITHOUT ROWID from the WITHOUT ROWID documentation. (check-in: 65df8fdcfa user: drh tags: trunk)
2017-05-25
16:56
Version 3.19.2 (check-in: 27e87090c9 user: drh tags: trunk, release, version-3.19.2)
00:40
Initial changes for the 3.19.2 release. (check-in: 21ff2eb546 user: drh tags: trunk)
2017-05-24
13:18
Version 3.19.1 (check-in: 522b8714da user: drh tags: trunk, release, version-3.19.1)
2017-05-23
12:49
Start a change log for the 3.19.1 patch release. (check-in: 3abd703937 user: drh tags: trunk)
2017-05-22
20:04
Another typo in the faster than filesystem document. (check-in: de15ebf872 user: drh tags: trunk)
20:01
Fix typo and clarify wording in the new faster-than-filesystem update. (check-in: 2912902889 user: drh tags: trunk)
19:38
Fix another release note typo. (check-in: 4020461a82 user: drh tags: trunk)
19:28
Fix typo in the 3.19.0 release notes. (check-in: 76f5154a37 user: drh tags: trunk)
19:23
Add a chart of raw data to the faster-than-filesystem page. (check-in: 5f95a7df66 user: drh tags: trunk)
14:02
Version 3.19.0 (check-in: 9ae6f97cab user: drh tags: trunk, release, version-3.19.0)
13:49
Fix typos in the opcodes.html document. (check-in: d11890e573 user: drh tags: trunk)
13:36
Update the speed-and-size spreadsheet. (check-in: 5bed01e6bb user: drh tags: trunk)
2017-05-15
17:07
Add the "Why Is SQLite Coded In C" document. (check-in: edc057616f user: drh tags: trunk)
2017-05-12
21:05
Hyperlinks to the faster-than-the-filesystem report from the two application-file-format articles. (check-in: a79b7fc8f1 user: drh tags: trunk)
20:17
Mention the anycollseq.c loadable extension in the release notes. (check-in: c7eb4e0706 user: drh tags: trunk)
02:13
Fix typo in the change log. (check-in: 6aca55b1f8 user: drh tags: trunk)
2017-05-11
18:44
Add the json_extract() enhancement to the change log. (check-in: 48487a9f5c user: drh tags: trunk)
15:55
Mention the FTS5 column filter enhancement in the change log. (check-in: b65a1fd59e user: drh tags: trunk)
13:36
Fix the description of the SQLITE_READ authorizer change in the change log. (check-in: fd8d8bb382 user: drh tags: trunk)
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)
16:38
Minor wording tweaks to the 35%-faster document. (check-in: a1177bfca0 user: drh tags: trunk)
16:34
Add the SQLITE_READ authorizer change to the change log for 3.19.0. (check-in: 84e21ebf22 user: drh tags: trunk)
2017-05-05
16:56
Copy the 35% faster changes from trunk. (check-in: 6fa9ca7f89 user: drh tags: branch-3.18)
16:55
Updates to the 35% faster document. (check-in: ac27ab7f6f user: drh tags: trunk)
12:55
Import the faster-than-filesystem document from trunk. (check-in: 488af3774f user: drh tags: branch-3.18)
2017-05-04
20:23
More tweaks to the 35% faster document. (check-in: 3563b95114 user: drh tags: trunk)
20:14
Fix typos and make improvements to the 35% faster document. (check-in: 4764f16dc0 user: drh tags: trunk)
19:44
Add the "35% Faster Than The Filesystem" document. (check-in: fd906f77ce user: drh tags: trunk)
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)
15:45
Add the fix for the latest ORDER BY LIMIT bug to the change log. (check-in: 3c17612648 user: drh tags: trunk)
2016-10-10
20:55
Fix a typo and slightly expand the "features.html" page. (check-in: 902d14ff5c user: drh tags: trunk)
13:42
Add the index-on-expression NULL handling fix to the bug list for 3.15.0. (check-in: c3d3435f05 user: drh tags: trunk)
10:33
Fix a date typo on the 2.0.0 release entry of the change log. (check-in: 4b0e288692 user: drh tags: trunk)
2016-10-04
19:04
Fix a typo in the new "deterministic function" document. (check-in: 823806a276 user: drh tags: trunk)
15:45
New documentation on deterministic functions. (check-in: 3a07cbb6d5 user: drh tags: trunk)
2016-10-03
18:25
Add the non-deterministic partial index enhancement to the 3.15.0 change log. (check-in: 9ff5e207d7 user: drh tags: trunk)
18:13
Allow deterministic functions in the WHERE clause of a partial index. (check-in: 2aa016e0a8 user: drh tags: trunk)
16:41
Increase the 3.15.0 preformance gain number to 7%. (check-in: 457b37bad2 user: drh tags: trunk)
11:55
Update the change log for new optimizations and the AUTOINCREMENT bug fix. (check-in: 33174a6a8f user: drh tags: trunk)
2016-09-30
22:31
Update the preformance increase on the change log. (check-in: 5f8cc85f5d user: drh tags: trunk)
2016-09-29
14:20
Rework the list of adjectives on the "SQLite is" line of the home page. (check-in: e073115146 user: drh tags: trunk)
14:10
Add the "high-reliability" page. Enhance the home page to reference "self-contained". Rework the self-contained page. (check-in: fd74494a34 user: drh tags: trunk)
2016-09-28
16:04
Fix typos. (check-in: 2a02e13870 user: drh tags: trunk)
14:22
Add "About" and "Download" to the drop-down menu on mobile. (check-in: b20b7983da user: drh tags: trunk)
14:07
Add dateof: macros to a couple of legacy documents. (check-in: eb90986099 user: drh tags: trunk)
13:42
Remove some duplicate chronology entries. Add a total at the bottom of the chronology. Fix a typo in the change-log generator. (check-in: 63090a72fc user: drh tags: trunk)
13:24
Updates to the FAQ (check-in: a68ef4b91a user: drh tags: trunk)
13:07
Add more [dateof:...] markup in the language description pages. (check-in: 6c79d37f0a user: drh tags: trunk)
12:59
New hyperlinks on the Full-Featured SQL page. (check-in: ba6e48411e user: drh tags: trunk)
11:52
Revise the "Full-Featured SQL" page to use just a single bullet-list of features. Add the discription "Clustered Index" to the WITHOUT ROWID page. (check-in: 2e1576a5a9 user: drh tags: trunk)
11:23
Fix a typo in Long-Term Support. (check-in: e6fa42924d user: drh tags: trunk)
11:22
Remove the "sustainable business model" argument from Long-Term Support. (check-in: f019f80a0e user: drh tags: trunk)
04:01
Futher refinement of the Full-featured SQL page. (check-in: d3731ef887 user: drh tags: trunk)
03:53
Add the Full-Featured SQL page. (check-in: 145980fe6f user: drh tags: trunk)
00:54
Fix a typo in the architecture document. (check-in: 27fee8962c user: drh tags: trunk)
00:53
Make the architecture image responsive. (check-in: 639000a718 user: drh tags: trunk)
00:49
Trying to update and improve the "Architecture" document. (check-in: 6316228a33 user: drh tags: trunk)
2016-09-27
23:04
Fix typo in the file format document. (check-in: 6e2e589a04 user: drh tags: trunk)
23:01
New alternative title for the On-Disk Format document. (check-in: 8615868905 user: drh tags: trunk)
22:45
More lts.html refinements. (check-in: 8730ac829e user: drh tags: trunk)
20:09
Tweaks to long-term support. (check-in: 8724e4b982 user: drh tags: trunk)
19:56
Add the "Long-term Support" document. (check-in: db4a43fe7d user: drh tags: trunk)
18:26
On the About page, change the "common links" sidebar into "Executive summary" (check-in: feebb52d8a user: drh tags: trunk)
18:01
Add the "searchdb" target to the "help" output for "make". (check-in: 93e6a53620 user: drh tags: trunk)
16:34
Add the "Many Small Queries Are Efficient In SQLite" page. (check-in: 2ff8c085a7 user: drh tags: trunk)
00:33
Update the makefile to put sqlite.css in the matrix directory. (check-in: 0fd7f82fa7 user: drh tags: trunk)
00:20
Remove the duplicate SQLITE_MAX_EXPR_DEPTH documentation. (check-in: 50e0e6008a user: drh tags: trunk)
2016-09-26
20:35
Add the "Recommended Compile-time Options" section to the compile.html document. (check-in: 67fa7525c1 user: drh tags: trunk)
16:02
New warnings about the possibility of corruption the database when certain pragmas are used. (check-in: bc4e6344c0 user: drh tags: trunk)
13:16
Update the change log to show the 2% performance gain over 3.14.2. (check-in: bf03335759 user: drh tags: trunk)
2016-09-23
14:33
Add an example of using row values in an UPDATE to the row value document. (check-in: 0bc1f4cfc7 user: drh tags: trunk)
11:32
Fix a LHS/RHS mixup in the rowvalue documentation. (check-in: db4e5cec36 user: drh tags: trunk)
2016-09-22
18:03
Provide for alternative document titles using <alt-title>...</alt-title>. Have the document page come up with the first sublist (containing lists of other documents) open automatically. (check-in: 22726478ad user: drh tags: trunk)
17:19
Fix typos in the opcode.html page. (check-in: bfe3dc203f user: drh tags: trunk)
2016-09-21
19:45
Adjust the date on the "current release" so that it read correctly even when the date is "pending". (check-in: 5ceba67384 user: drh tags: trunk)
19:28
Requirements mark fixes. (check-in: 0321b2ac62 user: drh tags: trunk)
15:17
Add the latest changes to the change log. (check-in: ba2eb30c24 user: drh tags: trunk)
13:34
Query planner tutorial updates. (check-in: 79dd9ff1e4 user: drh tags: trunk)
04:21
Remove duplicate disadvantage to WAL mode. (Leaf check-in: aa3809f595 user: drh tags: branch-3.14)
04:17
Remove duplicate disadvantage to WAL mode. (check-in: 4e5ba5873c user: drh tags: trunk)
2016-09-17
17:53
Update the update-stmt-limited syntax diagram and the text of the UPDATE documentation for the addition of row values. (check-in: ea28d5d596 user: drh tags: trunk)
17:39
Improvements to the bytecode engine documentation. (check-in: 20b7232027 user: drh tags: trunk)
17:10
Update the syntax diagram for UPDATE to show the ability to use row values. (check-in: 7f09c9eed4 user: drh tags: trunk)
16:57
Show "(pending)" for the dateof: of unreleased versions. Improvements to wording of recently added or modified documents. (check-in: 30cfddb6c9 user: drh tags: trunk)
15:55
On the current release log, show "(Pending)" instead of a date if the date contains a day of -00. (check-in: 7abf781c1d user: drh tags: trunk)
15:49
Provide a link to the draft changelog on the prerelease snapshot description. (check-in: 90de403f24 user: drh tags: branch-3.14)
15:44
Tweaks to the amalgamation.html and the getthecode.html pages. (check-in: ff6dbcdcf3 user: drh tags: trunk)
2016-09-16
17:02
Fix a missing <p> in the queryplanner document. (check-in: bdc4835c0b user: drh tags: trunk)
2016-09-14
21:12
Fix unescaped > characters in vtab.in. (check-in: aa59a746e9 user: drh tags: trunk)
21:07
Add documentation for the modeof= query parameter. (check-in: 6f85762df5 user: drh tags: trunk)
21:05
Fix a bug in search/hdom.tcl causing it to insert closing tags for elements such as <br>. (check-in: c7aa23108e user: dan tags: trunk)
20:49
Add the "Debugging Hints" document. (check-in: e79705daa6 user: drh tags: trunk)
18:40
Add and use the "[dateof:3.X.Y]" hyperlink target for automatically inserting release dates into the text. (check-in: 858d993381 user: drh tags: trunk)
17:45
Update documentation on VACUUM to describe how attached databases can be vacuumed. (check-in: 6f01723464 user: drh tags: trunk)
17:28
Update syntax diagrams for expr and vacuum. (check-in: 3f00f6192a user: drh tags: trunk)
16:27
Continuing work on the row value documentation. (check-in: ee61092516 user: drh tags: trunk)
04:12
Start a change log for 3.15.0. Begin writing documentation for row values and for the generate_series table-valued function. (check-in: bdbea7dc63 user: drh tags: trunk)
03:45
Add the 3.14.2 release to the chronology. (check-in: 54fe7773db user: drh tags: trunk)
03:39
Add the correct release date for 3.14.2 on the homepage. (check-in: b7faa9d562 user: drh tags: trunk)
2016-09-13
23:54
Add links to android bindings, SDS, and Fossil to the documentation lists. (check-in: e581a20834 user: drh tags: trunk)
22:45
One of the disadvantages of WAL mode is that one cannot change the page_size. (check-in: 006ea9f849 user: drh tags: trunk)
22:40
Version 3.14.2 (check-in: bf7ce59b7b user: drh tags: trunk, release, version-3.14.2)
20:39
Enable a table-of-contents on the WAL documentation. Fix typos in the previous check-in. (check-in: e1960990d2 user: drh tags: trunk)
20:28
Add a section to the WAL documentation that describes some of the scenarios in which a query can get SQLITE_BUSY. (check-in: 9466a94ec8 user: drh tags: trunk)
01:12
Use <codeblock> in more places, instead of <blockquote><pre>. Improved CSS for codeblock and for syntax diagrams. (check-in: 14e4769852 user: drh tags: trunk)
2016-09-12
21:06
Fix formatting problems in vtab.html associated with <yyterm> marks. (check-in: 2262f22f31 user: drh tags: trunk)
21:01
Fix a typo in vtab.in. (check-in: 4df3244e10 user: dan tags: trunk)
20:59
Fix handling of
  • markup in hdom.tcl.
(check-in: dcf4e23f9b user: dan tags: trunk)
20:54
Add links to the Android Bindings repository. (check-in: 7bf5343c19 user: drh tags: trunk)
18:59
Add the 3.14.2 hashes to the change log. (check-in: d2267a9398 user: drh tags: trunk)
18:46
Fix parsehtml so that it recognizes <tcl>...</tcl> as in-line markup. (check-in: 587b9b0128 user: drh tags: trunk)
18:10
Update the news for the 3.14.2 release. (check-in: 3270d5018f user: drh tags: trunk)
18:07
Enhancements to the "cintro.html" document. (check-in: 27bb41c97d user: drh tags: trunk)
17:49
Minor wording improvements in the application file format document. (check-in: 511e39cbb5 user: drh tags: trunk)
17:29
Make the "cintro.html" article more mobile-friendly. (check-in: e540e313e6 user: drh tags: trunk)
16:22
Updates to the "docs.html" page so that it uses the same <ul>-style format on desktop as it does on mobile, except that the detailed document descriptions are shown on desktop while still omitted on mobile. (check-in: 572767e60b user: drh tags: trunk)
15:39
Split out the "Document Lists and Indexes" category at top of the categorical document list. Change the name of "Result Codes" to "Result and Error Codes" to make the document easier to find. (check-in: 8f221f2df8 user: drh tags: trunk)
10:59
Corrections to the statement that defines when the "PRAGMA page_size" macro is not a no-op. (check-in: 1d425258b1 user: drh tags: trunk)
08:34
Fix the search script so that it can search for individual pragmas. Fix a mismatched tag in the document headers causing the search script to index the menubar on every page. (check-in: 4d25c80abf user: dan tags: trunk)
2016-09-09
15:38
Initial change log for the 3.14.2 release. (check-in: 3324b46ab0 user: drh tags: trunk)
2016-09-07
14:45
Fix a typo on compile.html. (check-in: c45332bd5c user: dan tags: trunk)
2016-09-06
00:32
Fix typo on the homepage. (check-in: 3f158f149c user: drh tags: trunk)
2016-09-05
17:18
More mutation testing documentation. (check-in: 34514986f4 user: drh tags: trunk)
16:51
In the testing document, use <codeblock> instead of <pre> and add a section on mutation testing. (check-in: 15b43e7cdb user: drh tags: trunk)
2016-09-03
19:43
Improved hyperlinks in the history of releases. (check-in: a5156889f3 user: drh tags: trunk)
2016-09-02
19:04
Cause the comments within example code in sessionsintro.html to be in blue italic type. (check-in: 59b5461497 user: dan tags: trunk)
18:36
Update the "famous users" page to try to make it more mobile-friendly. (check-in: 709a8a255b user: drh tags: trunk)
18:35
Fix a mismatched tag in sessionintro.in. (check-in: 1abe86b9d2 user: dan tags: trunk)
17:47
Restore the old-style "Documentation" page for desktop while keeping the newer style for mobile. (check-in: 6268aa1b1a user: drh tags: trunk)
17:15
Fix the linkage between sqlite3_backup_xxxxxx() functions and their documentation. (check-in: 78c26d4a46 user: drh tags: trunk)
17:03
Store debugging information in the doc_vardump.txt file after building all documentation. (check-in: cb35d7c443 user: drh tags: trunk)
16:57
Rename the output_list proc to hd_list_of_links and move its implementation from capi3ref.in into wrap.tcl, since it is used as common code. (check-in: c3c40d6711 user: drh tags: trunk)
16:30
Remove unnecessary javascript from the header. Improvements to rendering of C APIs. (check-in: 4180b2cf6f user: drh tags: trunk)
15:25
Remove some unnecessary leading whitespace from generated page content. (check-in: 03b286c8ac user: drh tags: trunk)
14:38
Restructure the website to be more mobile friendly. Put CSS into a separate sqlite.css file. Use responsive layout techniques. This is a work-in-progress. (check-in: 8e1edafe16 user: drh tags: trunk)
12:22
Fix the hyperlink on the logo. (Closed-Leaf check-in: 6fc0f8db82 user: drh tags: mobile-friendly)
12:17
Fix typos and tighten some sentences in the prosupport page. (check-in: ec9d984cb5 user: drh tags: mobile-friendly)
01:33
Typo fix on the obsolete version3.html document. (check-in: a97ba0fa9d user: drh tags: mobile-friendly)
01:23
Less indentation for bullets of the change long on mobile. (check-in: e887482396 user: drh tags: mobile-friendly)
01:19
Fix the font-size of CodeBlock to 1em. (check-in: a12a0dd1b0 user: drh tags: mobile-friendly)
01:04
Improved rendering of CodeBlock in fancy-format. (check-in: a5ef7d9aff user: drh tags: mobile-friendly)
00:30
Improve the cross-platform display of show/hide lists. (check-in: 84b8acdf6c user: drh tags: mobile-friendly)
2016-09-01
21:53
Refinements to the prosupport.html page. (check-in: cc74d20ccd user: drh tags: mobile-friendly)
21:43
Make the prosupport.html page local. (check-in: a65f9087ca user: drh tags: mobile-friendly)
20:58
Hack to get "make searchdb" running again. (check-in: 304b04a18c user: drh tags: mobile-friendly)
19:12
Click-to-view for the table of contents on fancy-format. (check-in: 6d9737f221 user: drh tags: mobile-friendly)
18:38
Fix up the support.html page for mobile. Improved the look of "button" hyperlinks. (check-in: 5e4e985bf0 user: drh tags: mobile-friendly)
18:13
Display improvements for the list-of-documents documents. (check-in: 0ff35a28c6 user: drh tags: mobile-friendly)
16:32
Improved show/hide on the docs.html page. (check-in: 910e5ab927 user: drh tags: mobile-friendly)
15:15
Simplify the JSON documentation for better display on mobile. (check-in: 08908c99e5 user: drh tags: mobile-friendly)
14:36
Reduced indentation for fancy-format in mobile. (check-in: 47dbb59cad user: drh tags: mobile-friendly)
09:14
Change the "docs.in" file so that it shows all categories collapsed, initially. (check-in: b3567c150e user: drh tags: mobile-friendly)
02:08
Fix the syntax.html document so that it uses the output_list proc to generate a variable-column bullet list. (check-in: 028b7208ab user: drh tags: mobile-friendly)
01:54
The "Search" menubar option causes a drop-down search box to appear. (check-in: 61608e2d14 user: drh tags: mobile-friendly)
01:30
Modify the output of the "search" script so that it works better on mobile screens. (check-in: a4e77179b1 user: drh tags: mobile-friendly)
00:54
Update the comment on the output_list proc. Use the output_list proc from capi3ref.in to process session.in. (check-in: 6f74e2171b user: drh tags: mobile-friendly)
00:48
Reformat the core and aggregate function descriptions in a way that works better on mobile. Use the "output_list" proc for the lists of pragma and aggregate and core functions. (check-in: fc4a66aa03 user: drh tags: mobile-friendly)
2016-08-31
21:38
Limit the width of syntax diagram images to the width of the screen. (check-in: 2cbeb114ca user: drh tags: mobile-friendly)
21:18
Adjustments to the CSS for hyperlink buttons. (check-in: c40376b31c user: drh tags: mobile-friendly)
20:59
Close the "Menu" button submenu before leaving the page, in case the user returns to the page using the "Back" button. (check-in: 582eb4ef8a user: drh tags: mobile-friendly)
20:47
Automatically disable the "Search" menu option if the document does not originate from an HTTP server, since there is no chance of running the CGI script in that case. (check-in: 3de5aaebc8 user: drh tags: mobile-friendly)
20:03
Use the variable-number-of-columns routine for the keyword list. (check-in: 9e95bb666d user: drh tags: mobile-friendly)
19:13
Fix the multi-column bullet lists in the c3ref documents so that the number of columns varies with the screen width. (check-in: edc0f779f7 user: drh tags: mobile-friendly)
17:00
Further refinement of the home page. (check-in: 9bab722ac3 user: drh tags: mobile-friendly)