Documentation Source Text

Timeline
Login

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

185 check-ins using file matrix.tcl version 787a1c433c

2016-07-28
19:26
Updates to the 3.14 change log. check-in: 6bc4912659 user: drh tags: trunk
17:45
Add linkage macros to the compile-time macro page. check-in: b23ac4e38d user: drh tags: trunk
16:04
Fix a typo in a snippet() example in the FTS3 documentation. check-in: d2cba16a38 user: drh tags: trunk
15:08
When generating C-language API docs, remove the various calling convention macros required for Windows builds (ex: SQLITE_API and SQLITE_CALLBACK) to avoid unnecessary confusion. check-in: 09d99088da user: drh tags: trunk
2016-07-25
13:23
Remove the mention of "Sparc" from the TH3 documentation. check-in: e757c54921 user: drh tags: trunk
2016-07-23
21:45
Tweaks to the JSON extension docs. check-in: d0a0b0987f user: drh tags: trunk
19:42
Add documentation for the json_quote() SQL function. Updates to the change log. check-in: 3506feb7c7 user: drh tags: trunk
14:58
Mention the sqlite3_expanded_sql() and sqlite3_trace_v2() interfaces in the change log. check-in: eecfde6ba8 user: drh tags: trunk
2016-07-22
15:42
Fix another typo in howtocorrupt.html check-in: 2b9db23f51 user: drh tags: trunk
15:23
Update docs for sqlite3_trace_v2(). Leaf check-in: f5fc8bf5d8 user: drh tags: sqlite3_trace_v2
2016-07-20
19:51
Fix typo in the how-to-corrupt document. check-in: d23e6d047a user: mistachkin tags: trunk
2016-07-15
02:59
Fix typo in the when-to-use document. check-in: faf1f46a56 user: drh tags: trunk
2016-07-13
14:17
Convert the RTree documentation to fancy-format. check-in: cb9d13f931 user: drh tags: trunk
13:57
Add documentation on the dbhash.exe utility and an entry in the change-log. check-in: f80207b028 user: drh tags: trunk
11:59
Add a link to vfsstat.c in the change log. check-in: 234e53bfcb user: drh tags: trunk
01:00
Fix formatting on the CVS virtual table documentation. check-in: 60e2c7225d user: drh tags: trunk
00:55
Improvements to the carray() function documentation. check-in: 3f0e846a97 user: drh tags: trunk
2016-07-12
23:52
Add the <fancy_format> markup which works like <table_of_contents> but omits the actual table of contents. Begin writing documentation for the carray() function. Fix typos and adjust wording in the CLI document. check-in: e89a552dc3 user: drh tags: trunk
20:54
Updates to reflect changes in 3.14.0. The "expr" syntax diagram is changed to show the ability to put table-valued functions on the RHS of an IN operator. Related text changes. Update the change log. check-in: 24cd5438cc user: drh tags: trunk
2016-07-09
20:28
Mention the win32-none VFS and the CACHE_USED_SHARED enhancements in the change log. check-in: a5f2c520a7 user: drh tags: trunk
2016-07-01
19:17
Changes to the display format for chronology of releases. check-in: 8e47ab6c5e user: drh tags: trunk
12:54
Further tweaks to the "Common Links" area of the homepage. check-in: 6c1a5a2528 user: drh tags: trunk
2016-06-30
14:08
Minor changes to the homepage. check-in: 1f062a2353 user: drh tags: trunk
2016-06-23
19:04
Added preliminary documentation for the new CSV virtual table. check-in: b0191810a4 user: drh tags: trunk
17:44
Improvements to the DBSTAT and sqlite3_analyzer.exe documentation pages. check-in: 13de82bb23 user: drh tags: trunk
16:59
Enhancements to the WITHOUT ROWID virtual table documentation. check-in: ad981b591f user: drh tags: trunk
2016-06-20
11:12
Additional clarification of the file format. check-in: df46867c0f user: drh tags: trunk
10:51
Enhance the file format document to make it clear that records might contain fewer values than there are columns in the table schema. check-in: 149d28ec0e user: drh tags: trunk
2016-06-04
17:25
Fix an error in fts5.html. check-in: 627d913e58 user: dan tags: trunk
2016-06-03
22:40
Documentation on WITHOUT ROWID virtual tables and the LIKE OR EQUAL optimization for virtual tables. check-in: 01b8f2aa54 user: drh tags: trunk
15:19
Convert the loadext.html page to the pretty-format. check-in: 899d627a5a user: drh tags: trunk
14:25
Added a change log for 3.14.0. Updates for SQLITE_OK_LOAD_PERMANENTLY. check-in: 2c9d634cc9 user: drh tags: trunk
14:21
Remove the disused btreemodule.html document. check-in: 4650ddb4f7 user: drh tags: trunk
2016-06-01
11:18
Fix typo in the description of the blessing. check-in: 8ff18d7976 user: drh tags: trunk
2016-05-26
17:57
Fix a typo on the wal.html page. check-in: e97f045354 user: drh tags: trunk
2016-05-23
18:10
Fix typo. check-in: a88d4c2239 user: mistachkin tags: trunk
2016-05-20
19:21
Add the AAR Android Library to the download page. check-in: 79c52bfb78 user: drh tags: trunk
2016-05-19
12:19
Add the Da Rocha book to the books.html page. check-in: 5b4b8cea40 user: drh tags: trunk
2016-05-18
11:04
Add SOURCE_ID and sha1sum for version 3.13.0. check-in: ee711c5d19 user: dan tags: trunk, version-3.13.0
10:55
Last update to News and Changes prior to release. check-in: c71ec9449d user: drh tags: trunk
2016-05-16
15:41
Clarify wording in cintro.html. check-in: b9557433b1 user: drh tags: trunk
2016-05-09
23:12
Use &gt; instead of > in documentation. check-in: 4607eaf52f user: drh tags: trunk
20:14
Fix a typo in the change log. check-in: 5100e74a66 user: drh tags: trunk
2016-05-06
20:39
Update the change log for the DELETE-WHERE-OR bug. check-in: cfe4d98e00 user: drh tags: trunk
2016-05-05
23:51
Fix a typo in the Error and Warning log page. check-in: cf02ec8132 user: drh tags: trunk
23:40
Add sub-bullets in the description of the b-tree page type flag in fileformat2.html, for improved legibility. check-in: ff214d6ba0 user: drh tags: trunk
13:33
Merge changes from the 3.12 branch. check-in: d545903147 user: drh tags: trunk
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-05-04
11:46
Fix typos in the change log. check-in: 05caaf5dfb user: drh tags: trunk
2016-05-03
17:20
Fix typo in the change log. check-in: ee23402710 user: drh tags: trunk
2016-05-02
12:42
Update the change log with the new DELETE optimization bug fix. check-in: 5b0295da93 user: drh tags: trunk
11:03
Updates to the change log for 3.13.0. check-in: 53e8efc79e user: drh tags: trunk
2016-04-26
19:37
Also add a table of contents to fileformat2.html. check-in: e9007b6030 user: dan tags: trunk
17:59
Add automatically generated tables of contents to rbu.html, cli.html and datatype3.html. check-in: bd775e82aa user: dan tags: trunk
15:37
Add documentation for RBU vacuum to rbu.in. check-in: 2906c27967 user: dan tags: trunk
2016-04-25
21:58
Clarify restrictions on the use of PRAGMA page_size. check-in: 44656180a0 user: drh tags: branch-3.12
2016-04-23
16:24
Add a new hyperlink on the cli.html page. check-in: 03e1bee6c8 user: drh tags: trunk
2016-04-22
12:14
Update the change log for the unix temporary directory search change. check-in: 982ce9adde user: drh tags: trunk
2016-04-21
13:37
Fix a typo in rbu.in: "us" -> "use". check-in: b50372204c user: dan tags: trunk
02:35
Merge the 3.12.2 changes from the 3.12 branch. Add a change log entry for SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION. check-in: 6a5cbbb368 user: drh tags: trunk
2016-04-18
18:37
Add hashes to the 3.12.2 change log. check-in: 7e800725ac user: drh tags: branch-3.12
18:05
Update the change log and news for the 3.12.2 patch release. check-in: cf2965ab99 user: drh tags: branch-3.12
2016-04-15
11:43
Fix typo in partial index documentation. check-in: 544f9ccc33 user: drh tags: branch-3.12
2016-04-08
20:15
Merge changes from the 3.12.0 branch. Improvements to change-log rendering. check-in: 3d991d2d4e user: drh tags: trunk
15:12
Changes for the 3.12.1 release. check-in: 38b637c8ea user: drh tags: branch-3.12
2016-04-04
17:45
Update the change log. check-in: f7f4ae78cc user: drh tags: trunk
12:24
Merge typo fixes from the 3.12.0 branch. check-in: 8370e949b7 user: drh tags: trunk
12:24
Typo fixes from Johannes Laire on unreleased documents. check-in: e3943543c8 user: drh tags: trunk
12:21
Typo fixes from Johannes Laire. check-in: 16f159820b user: drh tags: branch-3.12
2016-04-01
16:08
Create a place-holder for a tutorial on the session extension. check-in: 24e5940ece user: drh tags: trunk
14:57
Merge changes from the 3.12.0 branch. Add the "rowidtable.html" page. Add documentation for SQLITE_ENABLE_PREUPDATE_HOOK. check-in: 74e8dbd8bf user: drh tags: trunk
01:05
Add a change log entry for the query planner enhancement backport to 3.9.3. check-in: cc1675f94a user: drh tags: branch-3.12
2016-03-30
14:26
Start a change log for version 3.13.0 check-in: 6633347c5b user: drh tags: trunk
2016-03-29
22:30
On second thought, remove the information disclosure clean-up policy. check-in: f343e93d94 user: drh tags: trunk
22:27
Add the information disclosure clean-up policy document. check-in: 454218b20d user: drh tags: trunk
17:55
Version 3.12.0 check-in: 8785825a81 user: drh tags: trunk, release, version-3.12.0
17:54
Typo fix and a new anchor in the spellfix documentation. check-in: ab675a0b08 user: drh tags: trunk
17:30
Break out the SHA1 hashes into a separate subheading on the change log. check-in: c5565753d6 user: drh tags: trunk
10:44
Add the SQLITE_SOURCE_ID and sha1sum for version 3.12. check-in: 36f9ae056f user: dan tags: trunk
2016-03-28
15:03
Typo fixes. Add a news entry for 3.12.0. check-in: 1bbb7d8697 user: drh tags: trunk
2016-03-26
23:12
Update TH3 license information. Leaf check-in: 84f9b8afc2 user: drh tags: branch-3.11
22:53
Update TH3 license information. check-in: 150f52f8da user: drh tags: trunk
2016-03-25
13:00
Additional fragments in the cli.html page. check-in: 84a1842726 user: drh tags: trunk
2016-03-24
23:46
Fix typo. check-in: b4cae844cd user: mistachkin tags: trunk
2016-03-23
11:51
Update testing statistics. check-in: ad4c9929f2 user: drh tags: trunk
2016-03-22
17:23
Merge fixes off of the 3.11 branch. check-in: ad0172e592 user: drh tags: trunk
17:23
Fix typos. Add sqlite3_system_errno() to the change log. check-in: d5d9bb664f user: drh tags: trunk
2016-03-21
20:02
Fix the description of the case folding performed by the unicode61 tokenizer in FTS3. check-in: 37a01760c6 user: drh tags: branch-3.11
2016-03-19
19:33
Fix a minor formatting issue in FTS5 documentation. check-in: c959b23a38 user: drh tags: trunk
18:55
Update the change log for 3.12.0 check-in: 7bb88a1e22 user: drh tags: trunk
2016-03-18
15:46
Merge wal.html update from the 3.11.0 branch. check-in: 147aa03544 user: drh tags: trunk
14:56
Update the wal.html document at the bigwal anchor to reflect improvements to large transactions in WAL mode added to version 3.11.0. check-in: e273b7fdae user: drh tags: branch-3.11
2016-03-17
21:10
Fix the date (off by one) on the 3.9.2 release. check-in: 08aa54dd95 user: drh tags: trunk
2016-03-10
18:52
Add extra documentation for fts5 incremental optimize. check-in: b4fa1baa79 user: dan tags: trunk
2016-03-09
20:54
Update the fts5 documentation for the 'usermerge' option and 'merge' command. check-in: 9ed173645f user: dan tags: trunk
16:03
Another bullet on the 3.12.0 change log. check-in: 1b4e717575 user: drh tags: trunk
15:56
Updates to the change log for 3.12.0. check-in: 92353888aa user: drh tags: trunk
2016-03-08
17:23
Correct and clarify the computation of local and overflow payload sizes in the file format documentation. check-in: 9ec8b470d5 user: drh tags: trunk
16:42
Update documentation for SQLITE_DEFAULT_SYNCHRONOUS and related changes. check-in: ab3cf23c74 user: drh tags: trunk
13:15
Clarifications in "PRAGMA synchronous". check-in: 73e31a3096 user: drh tags: trunk
13:11
Add documentation for the SQLITE_STMTJRNL_SPILL compile-time option. check-in: 0449652cda user: drh tags: trunk
2016-03-04
15:33
Application note on the default page size change. Updates to the change log. check-in: 954e5c9945 user: drh tags: trunk
2016-03-03
16:20
Add hashes to the change log. check-in: 2fdaab5ed5 user: drh tags: branch-3.11
16:13
Fix typos and improve the wording of changes for 3.11.1. check-in: 8423b61474 user: drh tags: branch-3.11
16:07
Changes for the 3.11.1 release. check-in: 628be086c5 user: drh tags: branch-3.11
2016-03-02
13:16
Tweaks to the description of the sqlite_stat1 table in the fileformat2 document. check-in: d4c54c7ebe user: drh tags: trunk
2016-02-27
14:20
Include "OR ROLLBACK" among the examples of how to omit statement journals. check-in: 237bf9365d user: drh tags: trunk
2016-02-26
15:54
Updated documentation related to fts3_tokenizer() and the new SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER. check-in: 1483127f32 user: drh tags: trunk
2016-02-23
00:26
New entries in the change log. check-in: 38697e2bb0 user: drh tags: trunk
2016-02-22
14:58
Avoid creating a master journal unless two or more databases in the transaction can actually benefit from the master journal. check-in: 3f48e98ec7 user: drh tags: trunk
2016-02-17
16:14
Fix the PRAGMA synchorous documentation. The default is always FULL even in WAL mode. check-in: 3540d671bc user: drh tags: trunk
04:59
Typo fix. check-in: ab0a116d70 user: drh tags: trunk
2016-02-15
18:26
Separate heading for hashes in the 3.11.0 change log. check-in: b04e9be1a4 user: drh tags: trunk
17:32
Add the sha1sum and SQLITE_SOURCE_ID for version 3.11 to changes.html. check-in: 850ce246dc user: dan tags: trunk
15:45
Add a news item for the 3.11.0 release. Fix a typo in the FTS5 documentation. check-in: 26245406d3 user: drh tags: trunk
2016-02-12
17:29
Fix a typo in the cintro.html document. check-in: 24a90038eb user: drh tags: trunk
05:18
Merge changes from the 3.10 branch. check-in: 09a0fd52d7 user: drh tags: trunk
05:17
Change "Universal App Platform" to "Universal Windows Platform". Leaf check-in: 4802ce4c0a user: drh tags: branch-3.10
2016-02-10
19:16
Update the change log to comment on the NOT NULL and CHECK constraint optimization. check-in: 83657094be user: drh tags: trunk
13:51
Merge download page enhancements from the 3.10 branch. check-in: dd43be4bec user: drh tags: trunk
13:38
Add the snapshot tarball to the list of possible download files. check-in: 6af983fad9 user: drh tags: branch-3.10
03:48
Merge typo fixes from the 3.10 branch. check-in: f26e661484 user: drh tags: trunk
03:47
Fix typos in the fileformat2.html document. check-in: 7ee2137b43 user: drh tags: branch-3.10
2016-02-09
22:53
Updates to talk about the auto-explain changes to the shell. check-in: 5a67b7f178 user: drh tags: trunk
14:46
Merge enhancements from the 3.10.0 branch. check-in: 35017ac57c user: drh tags: trunk
14:43
Update the 3.11.0 change log. check-in: 0dc9452382 user: drh tags: trunk
2016-02-08
19:55
Update fts3 documentation to mention that fts3_tokenzer(x,y) is only available if SQLITE_ENABLE_FTS3_TOKENIZER is defined at compile time. check-in: 27ee6d0233 user: dan tags: trunk
2016-02-03
19:47
Update the documentation for PRAGMA synchronous=EXTRA. check-in: bcf687da9c user: drh tags: trunk
2016-02-02
03:15
Update the change log. check-in: 430d0b230f user: drh tags: trunk
02:05
Enhance the comment on the sqlite3_index_constraint.iColumn field to help bring attention to the fact that it can be negative for a rowid column. check-in: be35c1ae8e user: drh tags: trunk
01:56
Add a mention of sqlite3_column() to the SQLITE_RANGE documentation. check-in: 2111e3600c user: drh tags: branch-3.10
2016-01-26
15:04
Update the file format document to indicate that the number of rows in an index in sqlite_stat1 can be less than the number of table rows in the case of a partial index. check-in: 42f14ae85f user: drh tags: trunk
2016-01-25
13:55
Merge 3.10.2 changes. Add the SQLITE_EXTRA_DURABLE=1 compile-time option. check-in: d39c6c7cfc user: drh tags: trunk
2016-01-21
13:33
Do not suppress links to Windows DLLs on the download page. check-in: 70ec942b27 user: drh tags: branch-3.10
2016-01-20
15:46
Fix the sqlite3.c hash on the change log for 3.10.2. check-in: 65da56b099 user: drh tags: branch-3.10
15:35
Include the minor bug fixes in the 3.10.2 patch release. check-in: 1f9040ed82 user: drh tags: branch-3.10
14:50
Adjust the website for the 3.10.2 patch release. check-in: 19c959312d user: drh tags: branch-3.10
2016-01-19
17:10
Fix to the download.in script to not disable individual shell downloads if the tool bundle is missing. check-in: 2dcd192c8b user: drh tags: branch-3.10
17:07
Add documentation for sqlite3_analyzer.exe and support for the "tools" download bundles. check-in: dd586d2857 user: drh tags: branch-3.10
2016-01-15
08:33
Update fts5.html to node that the unicode61 tokenizer is compatible with the fts3 tokenizer of the same name. check-in: 3cc1ff72a4 user: dan tags: trunk
2016-01-14
18:26
Merge updates from the 3.10 branch. check-in: 885e891911 user: drh tags: trunk
17:58
Fix another typo in the query planner document. check-in: 47810e77ef user: drh tags: branch-3.10
16:10
Fix typos in queryplaner.html check-in: 316be08907 user: drh tags: branch-3.10
15:52
Remove the AWK dependency from the amalgamation page. check-in: fbbbdbca17 user: drh tags: trunk
15:48
Merge the 3.10.1 documentation changes. Update the change log for 3.11.0. check-in: e9bf814a4d user: drh tags: trunk
2016-01-13
21:46
Add the release hashes to the change log for 3.10.1. check-in: 9c12cf4cea user: drh tags: branch-3.10
20:52
Add documentation for the fts5 detail= option. check-in: 08f6990b8a user: dan tags: trunk
18:40
Update docs for the 3.10.1 release. check-in: b01206d6af user: drh tags: branch-3.10
2016-01-12
13:44
Merge changes from 3.10.0. check-in: 7d40b68595 user: drh tags: trunk
13:44
Fix typos in the TCL interface documentation. check-in: 217ea4895f user: drh tags: branch-3.10
2016-01-11
13:00
Begin entering 3.11.0 changes. check-in: 166fc2da3a user: drh tags: trunk
2016-01-06
16:09
Fix an error regarding operator precedence in fts5.html. check-in: a44bb18833 user: dan tags: trunk
12:23
Update download.in to look for products with version numbers starting with "31" instead of "30". check-in: 55ba3b7506 user: dan tags: trunk
11:05
Add the "News" for the 3.10.0 release and fix some typos. Add hashes and correct dates to the change log. check-in: ecbe9a0cbc user: drh tags: trunk, release, version-3.10.0
2016-01-04
00:44
Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option to the changes log. check-in: df761d0907 user: drh tags: trunk
2016-01-02
04:16
Cherrypick changes off of the bubble-generator-tkpath branch that were intended for trunk. Also merge in changes to the 3.9.x branch. check-in: e2ad1111f4 user: drh tags: trunk
04:14
Further tweaks to the website. Leaf check-in: 5619b986d5 user: drh tags: bubble-generator-tkpath
2015-12-31
14:06
Update the change log with the latest enhancements. check-in: 5077172640 user: drh tags: bubble-generator-tkpath
2015-12-30
15:10
Fix a problem in an SQL example in fts3.html. check-in: 4648330f75 user: dan tags: trunk
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-27
14:43
Fix a typo in the file format documentation. check-in: 1cc43dde6c user: drh tags: branch-3.9
2015-12-22
16:03
Modify the bubble-diagram generator script to use the TkPath extension. check-in: 08bf2dfe78 user: chw tags: bubble-generator-tkpath
15:02
Typo fix. check-in: 9b6bab46ee user: drh tags: branch-3.9
2015-12-11
15:50
Improved javascript for randomizing the order of sponsor icons. Remove the document.write() calls. check-in: 4f106d99e8 user: drh tags: trunk
2015-12-09
14:13
Updates to the famous users list. check-in: bf79c7d26b user: drh tags: trunk
11:51
Merge the revised sponsor icon layout into trunk. check-in: 7251ac0674 user: drh tags: trunk
11:50
Omit the blurbs from sponsor icons. Closed-Leaf check-in: f42cb2d82f user: drh tags: new-sponsors-layout
03:53
Further experiments with a new look for the sponsors on the homepage. check-in: 66f30d5788 user: drh tags: new-sponsors-layout
2015-12-08
22:28
Experiment with a new look for the homepage and especially the layout of sponsor links. check-in: f96d1199e7 user: drh tags: new-sponsors-layout
20:11
Add Facebook to the homepage. check-in: e8ddd92958 user: drh tags: branch-3.9
12:03
Fix typo in the amalagmation document. check-in: a77392c96c user: drh tags: branch-3.9
2015-12-03
22:34
Fix requirement mark errors in the cache_spill pragma docs. check-in: ecd3254d36 user: drh tags: trunk
22:05
Merge the AUTOINCREMENT typo fix from the 3.9 branch. check-in: 3dec493cba user: drh tags: trunk
22:03
Fix a typo in the AUTOINCREMENT documentation. check-in: 7c05c71d58 user: drh tags: branch-3.9
2015-12-02
20:59
Update the testing document to indicate that the unix VFS now has 100% branch test coverage. check-in: c345c5933b user: drh tags: trunk
2015-11-30
19:36
Add information about the sqlite3_index_info.colUsed field. check-in: 43d4cb5785 user: drh tags: trunk
2015-11-25
18:42
Update the documentation for the LIKE/GLOB/REGEXP enhancement to virtual tables. check-in: 6b8138c898 user: drh tags: trunk
2015-11-13
18:14
Update the PRAGMA cache_spill documentation to show the new functionality. check-in: 65c5ce0f21 user: drh tags: trunk
18:04
Begin adding changes to the change log for version 3.10.0. check-in: 5591c0216e user: drh tags: trunk
2015-11-11
20:52
Fix a typo in the virtual table documentation. check-in: 04edad8b2f user: drh tags: trunk
00:22
Clarification of the checkpoint algorithm in the file format document. check-in: 4f85463d41 user: drh tags: trunk
2015-11-09
21:21
Clarification of rules regarding SQLITE_OMIT_ compile-time options. Other minor documentation fixes. check-in: ff45f132a6 user: drh tags: trunk
2015-11-03
14:58
Fix closing tag mismatch in fileformat.html. check-in: b4a002ba34 user: dan tags: trunk
2015-11-02
18:42
Add a News entry for the 3.9.2 release. check-in: 9a4e60ca03 user: drh tags: trunk
18:42
Fix typo in matrix.tcl. check-in: 08bd5f6079 user: dan tags: trunk