Documentation Source Text

Timeline
Login

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

50 descendants and 50 ancestors of df6145bd4ecdf2b7fcd6a5392800c2f4b1e5e7c4

2014-08-05
20:22
Update the change log for the latest changes. Make it easier to find the "How To Compile" documentation. Remove Nokia from the sponsors list. (check-in: c22649df68 user: drh tags: trunk)
2014-08-01
03:11
Enhance the documentation on PRAGMA integrity_check to match recent implementation enhancements. Add the enhancements to PRAGMA integrity_check to the change log. (check-in: 6b17e6415e user: drh tags: trunk)
2014-07-31
19:04
Add the DISTINCT optimization to the change log for 3.8.6. (check-in: 06696e7778 user: drh tags: trunk)
19:02
Clarification to the "Examples" section on the CREATE TRIGGER documentation page. (check-in: bd0aa2fc3b user: drh tags: trunk)
2014-07-30
14:31
Update the change log to include the CREATE UNIQUE INDEX fix. (check-in: dfe6ec1900 user: drh tags: trunk)
2014-07-29
12:59
Update the change log and the home page for the R-Tree "rowid IN ..." bug. (check-in: e0e37413af user: drh tags: trunk)
2014-07-26
18:03
New image for the Das book. (check-in: 800e621e25 user: drh tags: trunk)
2014-07-25
18:38
Improvements to the "opcode.html" page that documents the VDBE. (check-in: e6972343b0 user: drh tags: trunk)
12:35
Add the book by Sribatsa Das. (check-in: 258b50a4d4 user: drh tags: trunk)
2014-07-24
15:44
Add a change-log not about schema indexes being preferred over transient indexes. (check-in: 3659d1f8cd user: drh tags: trunk)
15:36
Add a change log for version 3.8.6. Update the home page for version 3.8.6. (check-in: 0d81c00b9a user: drh tags: trunk)
14:39
Add documentation for sqlite3_index_info.estimatedRows, part of the virtual table interface. (check-in: 77f80a4186 user: dan tags: trunk)
14:27
Add documentation on the hexadecimal integer notation. (check-in: 4656303de6 user: drh tags: trunk)
13:50
Add documentation about the readfile() and writefile() extension functions in the command-line shell. Additional command-line shell documentation updates. (check-in: d4097ee3bf user: drh tags: trunk)
2014-07-22
12:24
Enhance the file format description to allow unrecognized text tokens at the end of the stat column in sqlite_stat1. (check-in: 3e1aad19c5 user: drh tags: trunk)
2014-07-18
19:06
Clarify that PRAGMA wal_autocheckpoint always causes a PASSIVE checkpoint. Provide clearer definitions for PASSIVE, FULL, and RESET checkpoints. (check-in: 306698cb1d user: drh tags: trunk)
2014-07-07
13:13
Clarification of the automerge documentation in FTS3. (check-in: a8e5cf50a0 user: drh tags: trunk)
10:39
Add documentation for the "^" qualifier to fts3.html. (check-in: 6a74a13c86 user: dan tags: trunk)
2014-07-03
11:15
Fix a typo in vtab.html. (check-in: 34e181958c user: dan tags: trunk)
2014-07-02
16:24
Fix some typos in queryplanner-ng.in. (check-in: 8471968fb0 user: dan tags: trunk)
2014-06-30
17:52
Enhance the description of the sqlite_stat4 format for WITHOUT ROWID tables. (check-in: d7f83670d7 user: drh tags: trunk)
16:26
Fix a couple minor typos in the download page regarding the 64-bit Windows DLL. (check-in: c908300540 user: mistachkin tags: trunk)
2014-06-27
20:49
Clarifications to the FTS4 languageid documentation. (check-in: 0a22af73df user: drh tags: trunk)
2014-06-26
21:05
Fix a typo in datatype3.html and add a new bullet to clarify the affinity for the RHS of an IN or NOT IN operator. (check-in: e89c80cd7d user: drh tags: trunk)
2014-06-16
15:11
Update the ".help" screen capture in the "cli.html" document to show the ".eqp" command. (check-in: c4d6ba9b0c user: drh tags: trunk)
2014-06-04
19:42
Version 3.8.5 (check-in: 0f7dec0517 user: drh tags: trunk, release, version-3.8.5)
19:42
Update the download page to include information about the WinPhone8.1 VSIX file. (check-in: 6d6bc21356 user: drh tags: trunk)
14:17
Add the SQLITE_SOURCE_ID and sha1 sum for version 3.8.5. (check-in: 98333ba617 user: dan tags: trunk)
11:37
Fix typos. (check-in: 909c2b99c5 user: drh tags: trunk)
11:26
Add news for the 3.8.5 release and set the date to today. (check-in: e047b026ae user: drh tags: trunk)
2014-06-02
18:31
Avoid scanning both fileformat.html and fileformat2.html for requirements since one is a copy of the other. (check-in: 51c582171c user: drh tags: trunk)
2014-05-30
18:14
Document the SQLITE_WIN32_HEAP_CREATE and SQLITE_WIN32_MALLOC_VALIDATE compile-time options. (check-in: 9816bbf88c user: mistachkin tags: trunk)
18:01
Add a section describing the Win32 native memory allocator. (check-in: ef8f1ed845 user: mistachkin tags: trunk)
17:01
Enhancements to malloc.html documentation to address concerns arising out of heartbleed. (check-in: 2bc13084bc user: drh tags: trunk)
2014-05-29
15:46
Change the default maximum POST size in althttpd to 20MB. (check-in: 35fcd6cd5b user: drh tags: trunk)
14:08
Update the cli.html document and the change log for the .system and the .once enhancements to the command-line shell. (check-in: a0826e6976 user: drh tags: trunk)
2014-05-28
19:37
Add instructions on building DLLs to the howtocompile.html page. (check-in: cec1821ade user: drh tags: trunk)
11:14
Fix the description of the notindexed problem in the change log. (check-in: 8803444b62 user: drh tags: trunk)
2014-05-27
15:31
Add the "X in (?)" optimization to the change log. (check-in: 487c297731 user: drh tags: trunk)
10:31
Fix documentation typos reported on the mailing list. (check-in: 84efe9e646 user: drh tags: trunk)
2014-05-26
23:18
Fix Win32 to say Win64 for 64-bit DLLs on the download page. (check-in: 3638ded7d1 user: drh tags: trunk)
23:16
Fixes the download of pre-release DLLs. (check-in: 57d62024df user: drh tags: trunk)
22:49
Update the download page to support DLL snapshots. Update the change log for 3.8.5. (check-in: 3eab08af2c user: drh tags: trunk)
21:43
Fix typos and clarify the text on the Partial Sorting Using An Index section of queryplanner.html. (check-in: fee38cf31f user: drh tags: trunk)
15:38
Talk about partial index sorting in the queryplanner.html document. (check-in: f81d69fb6a user: drh tags: trunk)
13:58
Fix typos in the new ALTER TABLE documentation and in the queryplanner.html document. (check-in: be73465c0f user: drh tags: trunk)
13:10
Fix typos and clarify the text in the TH3 document. (check-in: 8e68e11794 user: drh tags: trunk)
13:00
Additional remarks on the use of checklists in the testing.html document. (check-in: 8a2b7d834e user: drh tags: trunk)
12:43
Better support for Windows in the howtocompile.html document. (check-in: 55ab2074b0 user: drh tags: trunk)
11:56
Updates to the ALTER TABLE documentation. Provide a clear warning that RENAME TO does not rewrite referencing triggers and views. Provide two correct procedures for making other kinds of schema changes. (check-in: d4418abf42 user: drh tags: trunk)
2014-05-25
22:11
Make sure fileformat.html stays in sync with fileformat2.html. (check-in: df6145bd4e user: drh tags: trunk)
22:00
Revisions to the arbitrary table schema change text in ALTER TABLE. (check-in: b730943d19 user: drh tags: trunk)
21:54
Add instructions for how to do arbitrary schema changes to the ALTER TABLE documentation. (check-in: 227fb14d50 user: drh tags: trunk)
20:11
Another accidental fork merge. (check-in: b1b9dd90bb user: drh tags: trunk)
20:08
Enhancements to the optoverview.html document: Added discussion of partial sorting and fixed the conditions for query flattening. (check-in: fc0e9baa66 user: drh tags: trunk)
2014-05-24
17:31
Merge accidental fork (check-in: 0f2064446a user: drh tags: trunk)
17:16
Further improvements to the opcodes.html documentation generator. (check-in: 4f034b4e83 user: drh tags: trunk)
17:01
Enhance the "opcodes.html" document to include hyperlinks from to the opcodes. (check-in: 0d929c02e3 user: drh tags: trunk)
16:20
Update the change log for 3.8.5. Fix a typo in the isolation.html document. (check-in: ee616cbbb3 user: drh tags: trunk)
2014-05-22
10:00
Fix a typo in FAQ item 14. (check-in: 1b0ed95a32 user: dan tags: trunk)
2014-05-19
20:00
Clarification in the text of the release notes for 3.8.5. (check-in: c0ce61ad28 user: drh tags: trunk)
19:55
Mention the automerge enhancement in the release notes. (check-in: 5b3b975982 user: drh tags: trunk)
2014-05-16
11:28
Update fts3.html for recent changes to FTS. (check-in: ae994ce63a user: dan tags: trunk)
2014-05-09
22:27
Fix typo in VALUES clause documentation in lang.html. (check-in: fee01c2d5b user: drh tags: trunk)
2014-05-07
16:00
Add notes on the SQLITE_IOCAP_IMMUTABLE and "nolock" and "immutable" query parameter changes. (check-in: 7aa71cbb0c user: drh tags: trunk)
2014-05-01
14:44
Updates to the R*Tree documentation. (check-in: bd0fe1c3e1 user: drh tags: trunk)
2014-04-29
15:08
Added documentation for the sqlite3_rtree_query_callback() enhancement. (check-in: 89557fb903 user: drh tags: trunk)
2014-04-25
20:46
Fix more typos in the foreignkey.html document. (check-in: 2de942054f user: drh tags: trunk)
20:23
Fix a typo in the foreign key documentation. (check-in: 821750714a user: drh tags: trunk)
2014-04-22
01:19
Clarification of one of the 3.8.5 changes lines. (check-in: 72fa86df8d user: drh tags: trunk)
01:06
Update the version number to 3.8.5. Add a change log. (check-in: aabef1a296 user: drh tags: trunk)
00:32
Rename the "sqlite.html" page to "cli.html". Keep an "sqlite.html" page that redirects to "cli.html". (check-in: a6ea023899 user: drh tags: trunk)
2014-04-21
18:20
Update the command-line shell documentation with a discussion of CSV import and export. (check-in: 070bfddab9 user: drh tags: trunk)
13:12
Update the FAQ. (check-in: eb122dda42 user: drh tags: trunk)
2014-04-05
12:04
Fix a typo on the 3.8.4.3 news page. (check-in: 7401266cf0 user: drh tags: trunk)
2014-04-03
17:07
Version 3.8.4.3 (check-in: 2482a30724 user: drh tags: trunk, release, version-3.8.4.3)
2014-04-01
17:19
Tweaks and maintenance on the various documentation pages. Improvements to wording. Updated hyperlinks. (check-in: c08c92bf98 user: drh tags: trunk)
15:02
Strengthen the disclaimers on the "speed.html" page and on the "PRAGMA stats" documentation. (check-in: 0bbad9c76b user: drh tags: trunk)
13:44
Fixes to the application file format document. (check-in: f3db82e049 user: drh tags: trunk)
2014-03-26
18:53
Version 3.8.4.2 (check-in: 2f86548772 user: drh tags: trunk, release, version-3.8.4.2)
18:12
Add notes for the 3.8.4.2 patch release. (check-in: 35bef59b0d user: drh tags: trunk)
2014-03-17
18:30
Add a note about the use of checklists to the "testing.html" page. (check-in: 835c236ee8 user: drh tags: trunk)
18:05
Fix a hyperlink to the "application file format" page. (check-in: 06eecd10f7 user: drh tags: trunk)
2014-03-15
12:25
One more pass, with a few minor corrections, over the application file format document. (check-in: 0dc508ed1b user: drh tags: trunk)
2014-03-14
22:27
More edits to the application-file-format document. (check-in: c0ac5630f2 user: drh tags: trunk)
16:35
Further tuning of the application file format document. (check-in: 1b422ce8de user: drh tags: trunk)
2014-03-13
15:38
Improvements to the application file format document. (check-in: 9e12f0cedd user: drh tags: trunk)
00:43
First complete draft of the new application file format document. Integrate with the rest of the documentation via hyperlinks. (check-in: 6d257b8d92 user: drh tags: trunk)
2014-03-12
18:12
First draft of a document that advocates for using SQLite as an application file format. (check-in: aa63d85794 user: drh tags: trunk)
2014-03-11
15:30
Version 3.8.4.1 (check-in: 103145ba79 user: drh tags: trunk, release, version-3.8.4.1)
14:53
Update change log, index, and news for version 3.8.4.1 (check-in: d1f96df9b2 user: drh tags: trunk)
2014-03-10
12:23
The 3.8.4 release. (check-in: 9ac72e3702 user: drh tags: trunk)
2014-03-08
03:21
Add a news blurb for the 3.8.4 release. (check-in: 02c3db4e28 user: drh tags: trunk)
2014-03-06
02:12
Update the index page and change log in anticipation for 3.8.4. (check-in: 2c81b82587 user: drh tags: trunk)
2014-02-28
12:26
Minor clarifications of recent documentation. (check-in: e139253c4b user: drh tags: trunk)
2014-02-22
13:55
Clarification of what it means for the expression in a DEFAULT clause to be constant. (check-in: 0b36750358 user: drh tags: trunk)
2014-02-21
13:21
Update the all-bnf.html file. (check-in: 424fd15707 user: drh tags: trunk)
2014-02-20
16:09
Make sure bubble diagrams are all shown in the right places. (check-in: a67364e06f user: drh tags: trunk)
2014-02-12
19:36
Fix a mistake in the date/time function documentation. (check-in: 5cb71ea877 user: drh tags: trunk)
2014-02-11
16:36
Add SOURCE_ID and SHA1 hash for the 3.8.3.1 release. (check-in: d882698e7b user: drh tags: trunk)
14:30
Updates for the 3.8.3.1 release. (check-in: f2ce0c9b8e user: drh tags: trunk)