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