Documentation Source Text

Timeline
Login

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

689 check-ins using file art/syntax/all-bnf.html version 873cf35adf

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)
2014-02-10
17:49
Fix a typo in the WITH documentation. (check-in: 4cd3bb5ab2 user: drh tags: trunk)
2014-02-06
16:52
Further clarification on the difference between recursive and ordinary CTEs. (check-in: ecdd0d43d0 user: drh tags: trunk)
13:25
Fix an example code error in the WITH documentation. (check-in: a6ce882b01 user: drh tags: trunk)
2014-02-05
00:16
Fix a hyperlink in the SELECT documentation. (check-in: 1c86b01b95 user: drh tags: trunk)
2014-02-03
14:00
Add the sha1sum and SQLITE_SOURCE_ID for version 3.8.3 to the changelog. (check-in: c161234538 user: dan tags: trunk)
2014-02-02
22:43
Enhancements to the bubble diagram generator. (Leaf check-in: 4dc85d1094 user: drh tags: bubble-diagrams)
2014-01-30
20:55
Fix an error in the table-or-subquery syntax diagram. (check-in: a467d7a4b8 user: drh tags: trunk)
20:51
Add the "factored-select-stmt" syntax diagram. Improve the way diagrams are hidden and shown. (check-in: fac98d12ae user: drh tags: trunk)
19:39
Make the "select-stmt" syntax diagram a closer fit to reality. (check-in: 0c43e7efb4 user: drh tags: trunk)
17:41
Fix FROM clause in the SELECT syntax diagrams. Also fix typos in the text. (check-in: a115a033da user: drh tags: trunk)
15:56
Update the mmap documentation to describe the problem of Windows not truncating memory mapped files. (check-in: fa77748670 user: drh tags: trunk)
15:32
Additional clarification on syntax restrictions in SELECT statements. (check-in: 4c5d78209a user: drh tags: trunk)
15:03
Further enhancements to the SELECT documentation. (check-in: 979599b0b6 user: drh tags: trunk)
14:11
Add the extended-simple-select-stmt syntax diagram. Update the documentation on SELECT statements to better explain limitations on the use of ORDER BY and LIMIT in compound SELECTs. (check-in: c14dc7c23b user: drh tags: trunk)
11:15
Additional hyperlinks to "compound SELECT", "ORDER BY" and "LIMIT". (check-in: 1c8ccd6d21 user: drh tags: trunk)
11:08
Clarification of the role of ORDER BY and LIMIT in compound SELECT statements. (check-in: 7b8d43a8ef user: drh tags: trunk)
2014-01-29
17:47
Update News and the change log. Bring the release date forward to 2014-02-03. Fix typos. Move older news entries out to oldnews.in. (check-in: ea6e1d11de user: drh tags: trunk)
17:10
Add new elements to the 3.8.3 change log. (check-in: 7ab25ac60e user: drh tags: trunk)
13:52
Typo fix. CAST(...TO...) should be CAST(...AS...). (check-in: 64427669a7 user: drh tags: trunk)
2014-01-24
23:43
Fix typos in the WITH clause documentation reported on the mailing list. (check-in: 5415be54c0 user: drh tags: trunk)
13:20
Add examples to WITH documentation showing how to control depth-first versus breath-first search of a tree using an ORDER BY clause on the recursive query. (check-in: fb11eda20b user: drh tags: trunk)
04:05
Further refinement and cleanup of the WITH and SELECT documentation. (check-in: 2941cf658c user: drh tags: trunk)
01:20
First cut at WITH documentation. (check-in: 2636279279 user: drh tags: trunk)
2014-01-23
22:25
Incremental checkin of work on the common-table-expression documentation. (check-in: 52484ca596 user: drh tags: trunk)
18:37
Refactoring many of the bubble syntax diagrams, especially related to SELECT. Attempting to make the bubble diagrams easier to follow. (check-in: 9aa1b8df9b user: drh tags: trunk)
15:29
Fix a link in the with-clause syntax diagram. (check-in: 3598251c1c user: drh tags: trunk)
15:25
Recursive syntax diagram display. (check-in: 87e7eb3d0d user: drh tags: trunk)
2014-01-17
23:50
Update the syntax bubble diagrams to show that the WITH clause is allowed. (check-in: 3f48c6857f user: drh tags: trunk)
2014-01-15
03:02
Clarify some sentences in the documentation on ANALYZE. (check-in: 5fc1073e06 user: drh tags: trunk)
2013-12-17
16:33
Documentation for the printf() SQL function. (check-in: 9cbe2e4d08 user: drh tags: trunk)
2013-12-16
21:42
When the request URI for static content contains extra path elements, report the error as 404 instead of 301. (check-in: 155df5701c user: drh tags: trunk)
21:30
In althttpd, keep track of wall-clock time in milliseconds, not seconds. And for the user and system times, be sure to subtract out the user and system times for prior requests on the same connection. (check-in: 333c090d36 user: drh tags: trunk)
20:13
Add an extra column to the logfile output from althttpd. The 16th column gives the number of characters in the request URI that contribute to the script name. This is useful with substr() in doing queries against specific CGI scripts. (check-in: faec8e5df4 user: drh tags: trunk)
17:01
Improvements to the althttpd logic that redirects to the base document when there are surplus pathname elements in the request URI. (check-in: 452b6e3c75 user: drh tags: trunk)
14:39
When serving static content that has extra elements on the end of the URI, return a 301 to redirect to the base document, so that relative hyperlinks in the document will be correct. (check-in: 1682f2225f user: drh tags: trunk)
2013-12-14
14:42
Update the change log with SQLITE_DETERMINISTIC. (check-in: 5bc4dbf151 user: drh tags: trunk)
12:40
Add a change log for version 3.8.3. Fix a typo in the FAQ. (check-in: 0aa5202f33 user: drh tags: trunk)
2013-12-12
14:10
Fix missing "is" in the query planner document. (check-in: 200941601a user: drh tags: trunk)
13:23
Corrections to the spellfix1 documentation. (check-in: aa19d1fdb5 user: drh tags: trunk)
2013-12-06
15:50
Version 3.8.2 (check-in: e795bba129 user: drh tags: trunk, release, version-3.8.2)
14:57
Update the changelog with the source-id and sha1 sums for version 3.8.2. (check-in: e22d41d36f user: dan tags: trunk)
2013-12-02
21:45
Fix a typo in the News. (check-in: c6e5d60723 user: drh tags: trunk)
2013-11-27
19:20
Add a tentative news item for the 3.8.2 release. Updates to CAST documentation. Fix typos. (check-in: 825b2c6448 user: drh tags: trunk)
04:26
Update the skip-scan documentation to mention the magic 18 number for when skip-scan becomes profitable. (check-in: 3eaa7f572e user: drh tags: trunk)
01:26
Add documentation for the SQLITE_WIN32_HEAP compile-time option. Fix typos in the change log. (check-in: 907e8cfb73 user: drh tags: trunk)
2013-11-26
21:07
Change the documented behavior of casting a large real into an integer. (check-in: f9d830d206 user: drh tags: trunk)
17:47
Add the double-to-int casting change to the change log. Set the release date (tenatively) to 2013-12-10. (check-in: 45cab1f685 user: drh tags: trunk)
2013-11-25
13:23
Fix typo in malloc.html. (check-in: bf0de31094 user: drh tags: trunk)
2013-11-21
23:43
Update the change log to mention recent VDBE performance enhancements. (check-in: 7113f9f169 user: drh tags: trunk)
2013-11-19
00:20
Update the list of keywords to include COVERING, WITH, and WITHOUT. COVERING and WITH are currently unused. (check-in: 74e28675d4 user: drh tags: trunk)
2013-11-18
23:39
Updates to the "opcode.html" and "sqlite.html" documents. (check-in: 45a6eaaaa7 user: drh tags: trunk)
20:57
Correct minor typo. (check-in: 9589b9982b user: mistachkin tags: trunk)
18:48
Fix documentation typos pointed out on the mailing list by Philip Newton. (check-in: b8e6ac4ce4 user: drh tags: trunk)
2013-11-15
16:22
Fix a typo in the WITHOUT ROWID documentation. (check-in: 5725d732c9 user: drh tags: trunk)
2013-11-13
22:39
Update the change log to show the skip-scan optimization and other recent changes. Add documentation on skip-scan. (check-in: 9b1dc53b75 user: drh tags: trunk)
2013-11-11
23:27
Documentation updates associated with WITHOUT ROWID and the extension of the sqlite3_index_info object. (check-in: 21034f356e user: drh tags: trunk)
2013-11-09
17:27
Tweaks to WITHOUT ROWID documentation. (check-in: 478a586d67 user: drh tags: trunk)
17:17
Fix a broken fragment specification in the fileformat page. (check-in: ea35f76f95 user: drh tags: trunk)
17:14
Add the WITHOUT ROWID document. Enhance the file-format, CREATE TABLE, and AUTOINCREMENT documents to reflect changes due to WITHOUT ROWID. (check-in: ffe4c464ea user: drh tags: trunk)
2013-11-08
20:06
First attempt at documenting WITHOUT ROWID. (check-in: 3819df0c0d user: drh tags: trunk)
2013-10-27
03:44
Fix a typo in the documentation for the ABS() function. (check-in: 9e1d78e903 user: drh tags: trunk)
2013-10-19
16:21
Updates to documentation for recent changes, especially the unlikely() function and STAT4. Also fix some typos. (check-in: 0998ee24a4 user: drh tags: trunk)
15:21
Add documentation on the new SQLITE_USE_FCNTL_TRACE compile-time option. (check-in: 67d47ef62f user: drh tags: trunk)
15:17
Add discussion and cautions on the use of TEMP triggers on non-TEMP tables. (check-in: 59201e1cfb user: drh tags: trunk)
13:51
Merge the changes from the 3.8.0.x branch into trunk. (check-in: 2faf39e6c4 user: drh tags: trunk)
2013-10-17
13:52
Add the SQLITE_SOURCE_ID and sha1sum of sqlite3.c for 3.8.1 to changes.in. (check-in: 7532f00f57 user: dan tags: trunk)
12:54
Add news for the 3.8.1 release. Other final documentation tweaks prior to release. (check-in: ca4b03a1f2 user: drh tags: trunk)
2013-10-16
23:58
Fix typos in documentation. (check-in: df95e4e1ec user: drh tags: trunk)
2013-10-15
19:08
Added the fts4aux languageid column. Fix typos in famous.html (check-in: cd0e9d17ed user: drh tags: trunk)
2013-10-14
21:20
Move the tointeger() and toreal() functions into an extension. (check-in: 6218782fda user: drh tags: trunk)
19:36
Add documentation for toInteger() and toReal(). (check-in: 782c63b8f0 user: drh tags: trunk)
17:31
Add a mention of the SQLITE_TMPDIR environment variable in the change log. (check-in: b5aece674f user: drh tags: trunk)
13:15
Tweaks to the change log. Set an estimated release date for 3.8.1 of 2013-10-18. (check-in: c00394dd14 user: drh tags: trunk)
2013-10-12
20:43
Update the change log and the pragma documentation to reflect restoring PRAGMA index_list to its old behavior. (check-in: d585c58e71 user: drh tags: trunk)
13:10
Fix the PRAGMA defer_foreign_keys documentation to explain that deferral is disabled whenever a transaction completes. (check-in: 651b3720a7 user: drh tags: trunk)
2013-10-11
23:33
Improved documentation for DETACH - explain how behavior changes in shared cache mode. Update the makefile to scan the th3/core/*.c files for requirements marks. (check-in: 949c314919 user: drh tags: trunk)
20:16
Improve the text (rephrasing, not changing the meaning) of some requirements related to functions and pragmas. Improve or correct requirements marks. (check-in: 77dee5dcd0 user: drh tags: trunk)
14:18
Edits to the change log. (check-in: c508b3c51a user: drh tags: trunk)
2013-10-08
15:07
Revise the description of the Tcler's wiki database corruption event. (check-in: 63ad7e56b1 user: drh tags: trunk)
2013-10-07
08:27
Add documentation on the optional timezone suffixes to timestrings in the date and time functions. (check-in: d4924d1139 user: drh tags: trunk)
2013-10-04
17:27
Add new bullets to the change log for 3.8.1. (check-in: dc132e270c user: drh tags: trunk)
2013-10-02
13:34
Additional notes on how to corrupt an SQLite database file. (check-in: 7c6ef04be8 user: drh tags: trunk)
2013-10-01
01:01
Fix a typo on the release date for 3.8.0.2. (Closed-Leaf check-in: 46516308c7 user: drh tags: branch-3.8.0)
2013-09-30
12:14
Update the timeline link on the snapshot downloads so that it works if the previous release was on a branch. (check-in: aa3aec51de user: drh tags: branch-3.8.0)
12:10
Fix to the releaselog/current.html generator. (check-in: e7d9c2101a user: drh tags: trunk)
2013-09-19
14:30
Clarification of the meaning of the stat column in sqlite_stat1. (check-in: 83b2bf0c4d user: drh tags: trunk)
14:24
Leave unspecified what it means for the sqlite_stat3 and sqlite_stat4 tables to have idx columns equal to their tbl column. (check-in: c538b41b91 user: drh tags: trunk)
14:14
Fix typos and enhance the text of documentation for 3.8.1 changes. (check-in: 1d0df412df user: drh tags: trunk)
13:22
Updates to the TH3 description. (check-in: ecd17d4f41 user: drh tags: trunk)
2013-09-18
11:31
Add examples of creating fts3tokenize tables that use tokenizers declared with multiple arguments to fts3.in. (check-in: 23c364befb user: dan tags: trunk)
2013-09-16
13:32
Update the date and time function documentation to guarantee that 'now' is stable within a single sqlite3_step() call. (check-in: a2842a55e9 user: drh tags: trunk)
2013-09-14
16:09
Merge the 3.8.0 branch changes into trunk. (check-in: 18c0f01b0c user: drh tags: trunk)
2013-09-13
22:03
Add documentation for unlikely(), likelihood() and the soft_heap_limit pragma. (check-in: dc4eae98aa user: drh tags: trunk)
19:44
Add separate VSIX files for WinRT80 and WinRT81. Fix a typo on the home page. (check-in: 474bc9f7f5 user: drh tags: branch-3.8.0)
14:52
Add documentation for the fts4 unicode61 "tokenchars" and "separators" options. (check-in: 00c7833d65 user: dan tags: trunk)
2013-09-03
17:22
Add the sha1sum and SQLITE_SOURCE_ID for 3.8.0.2. (check-in: 4069a1b264 user: dan tags: branch-3.8.0)
17:20
Add documentation for the fts4 unicode61 tokenizer option "remove_diacritics=0". (check-in: bc38355689 user: dan tags: branch-3.8.0)
16:06
Changes for the 3.8.0.2 release. (check-in: d705052eb2 user: drh tags: branch-3.8.0)
2013-09-02
14:24
Merge change-log enhancements from the 3.8.0 branch into trunk. (check-in: 265fde6eac user: drh tags: trunk)
14:20
In the change log for patch releases, repeat the changes of the main release for the page containing changes of the just the patch release, but do not repeat the main release changes in the overall change log. (check-in: affc1a3589 user: drh tags: branch-3.8.0)
2013-08-31
14:32
Add documentation for the fts4 unicode61 tokenizer option "remove_diacritics=0". (check-in: f5d1d7106f user: dan tags: trunk)
2013-08-30
14:28
Added a 3.8.1 change log. Added documentation on SQLITE_MINIMUM_FILE_DESCRIPTOR. (check-in: 4e286cee85 user: drh tags: trunk)
14:03
Include all changes since 3.7.17 in the 3.8.0.1 change log. Typos fixed in the NGQP document. (check-in: 3f23dd6ba9 user: drh tags: branch-3.8.0)
2013-08-29
17:44
Add the source-id and sha1sum for 3.8.0.1 to changes.in. (check-in: d22f4d2e9a user: dan tags: branch-3.8.0)
16:51
If the user tries a download hyperlink without javascript, send them to an explanation page. (check-in: 32aeca2648 user: drh tags: trunk)
16:19
If the user tries a download hyperlink without javascript, send them to an explanation page. (check-in: 80f0aef2d3 user: drh tags: branch-3.8.0)
14:29
Preparations for the 3.8.0.1 patch release. (check-in: 8d74017a56 user: drh tags: branch-3.8.0)
2013-08-28
14:13
Add documentation for STAT4. (check-in: 04ab4fa5ec user: drh tags: trunk)
2013-08-27
13:34
Fix typos in the queryplanner-ng document. (check-in: 9747293881 user: drh tags: trunk)
2013-08-26
12:54
Version-3.8.0 (check-in: e672a5f4d8 user: drh tags: trunk, release, version-3.8.0)
12:20
Merge in the download pages updates that were made on the 3.7.17 branch. (check-in: 71f4e91277 user: drh tags: trunk)
10:07
Add the sha1 and source-id for 3.8.0 to changes.in. (check-in: cb43f0154e user: dan tags: trunk)
2013-08-25
23:48
Change the 3.8.0 release date to 2013-08-26. (check-in: 105ed6eed2 user: drh tags: trunk)
2013-08-23
16:37
Clarification and typo fixes in the NGQP document. (check-in: a5a0ee107d user: drh tags: trunk)
16:16
Fix documentation typos. (check-in: ce2a4ec1e7 user: drh tags: trunk)
01:57
Add documentation for the query_only and defer_foreign_keys pragmas. Update the change log for the 3.8.0 release. (check-in: 8e16497ef1 user: drh tags: trunk)
2013-08-22
20:28
Clearly label the source code snapshots on the download page as source code. (Leaf check-in: 0e1cfbafc8 user: drh tags: 3.7.17)
2013-08-20
17:06
Fix typos in the cache_spill pragma documentation. (check-in: 4bfef7edb7 user: drh tags: trunk)
03:06
Revised and amplified definition of the tointeger() and toreal() functions. (Leaf check-in: 85757c1492 user: drh tags: toTypeFuncs)
2013-08-19
21:17
Initial docs for tointeger() and toreal() SQL functions. (check-in: 083cd58817 user: mistachkin tags: toTypeFuncs)
14:26
Fix a typo in the RTREE documentation. (check-in: 9ceaba9f7f user: drh tags: trunk)
2013-08-17
17:56
Add documentation for the cache_spill pragma. (check-in: 74740a2d9e user: drh tags: trunk)
2013-08-08
17:58
Fix typos in the "vfs.html" document. (check-in: 37c89b86f8 user: drh tags: trunk)
02:54
Fix typos in the partial index document. (check-in: 8bf9d71fd6 user: drh tags: trunk)
2013-08-07
23:38
Add documentation for SQLITE_ALLOW_URI_AUTHORITY. (check-in: cadb86b398 user: drh tags: trunk)
15:39
Merge the changes from the 3.7.17 branch into trunk. (check-in: 69c4153640 user: drh tags: trunk)
15:02
Use javascript to delay setting href on anchors for deliverables on the download page. This is designed to prevent robots from downloading the deliverables. (check-in: ea86d36c1c user: drh tags: 3.7.17)
00:21
Clarifications and typo-fixes in the NGQP document. (check-in: 5cbddcc945 user: drh tags: trunk)
2013-08-03
18:42
Change pre-release snapshot descriptions to include links to change logs. (check-in: e847b39547 user: drh tags: 3.7.17)
18:42
Always publish the most recent changes in releaselog/current.html. (check-in: 27f4c1dbbc user: drh tags: trunk)
2013-08-02
23:41
Updates to requirements marks. (check-in: 498cd0709e user: drh tags: trunk)
18:27
Enable partial indices. (check-in: f990657458 user: drh tags: trunk)
18:27
Corrections to partial index documentation. (Closed-Leaf check-in: 3e022afe53 user: drh tags: partial-indices)
03:43
Add documentation on the partial index implementation. (check-in: 5723efb011 user: drh tags: partial-indices)
2013-08-01
18:23
Update syntax diagrams (on Mac OS 10.6.8 using Tk 8.5.7) for partial indices. (check-in: 6f7d9ba15e user: drh tags: partial-indices)
17:48
Fix the description of COLLATE operator precedence so that it is aligned with the implementation. (check-in: 52366f9588 user: drh tags: trunk)
2013-07-23
13:48
Merge the download page improvements that have been taking place over on the 3.7.17 branch. (check-in: 0dc4a0b22a user: drh tags: trunk)
13:45
Add a missing "not" to the text in the download page. (check-in: 53bc857d09 user: drh tags: 3.7.17)
2013-07-19
20:41
Further tweaks to the look of the Download page. (check-in: c90897b38c user: drh tags: 3.7.17)
20:22
Put a yellow background on the prerelease snapshots on the download page. (check-in: c032a10b8b user: drh tags: 3.7.17)
2013-07-17
15:39
Omit the newline from the default root name in standalone mode in althttpd. (check-in: 6df9c92bc9 user: drh tags: trunk)
00:17
Tweaks to the text describing the hazards of upgrading to the NGQP. (check-in: 232b584bda user: drh tags: trunk)
2013-07-16
22:15
Improvements to standalone mode in althttpd.c. (check-in: a970d449c6 user: drh tags: trunk)
2013-07-15
17:11
The log file for althttpd is now RFC-4180 CSV. Cherry-pick merge from check-in [52bfa21f48e14a29]. (check-in: 93ba1a8d9d user: drh tags: trunk)
17:10
Add the sqlite3_cancel_auto_extension() interface. (check-in: 28716e6fd2 user: drh tags: trunk)
11:17
The log file for althttpd is now RFC-4180 CSV. (check-in: 52bfa21f48 user: drh tags: 3.7.17)
2013-07-12
20:39
Fix typos in the isolation document. (check-in: f64ef462b2 user: drh tags: trunk)
20:03
Add the isolation.in document. Other changes for 3.8.0. (check-in: 2eb277d7fc user: drh tags: trunk)
2013-07-09
21:49
Fix typo in version number for sqlite_stat3. (check-in: a583de40a1 user: mistachkin tags: trunk)
2013-07-01
20:52
Fix a typo in an example in the fts4aux virtual table documentation. (check-in: 6743aed594 user: drh tags: trunk)
16:07
Lots of tweaking and enhancements to the documentation, especially regarding the query planner and ways of controlling the query planner. (check-in: 641e107a66 user: drh tags: trunk)
2013-06-26
19:13
Add the "Pre-release Snapshot" heading to the download page, with the ability to include winrt81 VSIX snapshots. (check-in: a8228d3c37 user: drh tags: 3.7.17)
14:35
Updates to the changes.html page. Fix typos on the NGQP documentation. (check-in: e0c107dec3 user: drh tags: trunk)
2013-06-25
16:31
Further improvement and expansion of the NGQP documentation, including adding a checklist for preventing and dealing with bad choices by the query planner. (check-in: 828ca81aae user: drh tags: trunk)
01:44
Second draft of the NGQP document. (check-in: e09abae6c3 user: drh tags: trunk)
2013-06-24
19:23
Work toward documenting the NGQP changes. (check-in: e1646aea15 user: drh tags: trunk)
2013-06-21
19:06
Add documentation for the fts4 notindexed option. (check-in: 968222aa1c user: dan tags: trunk)
08:00
Fix another minor typo in the vtable docs. (check-in: a93d66e412 user: mistachkin tags: trunk)
2013-05-29
06:57
Fix minor typo in the virtual table documentation for xCreate and xConnect. (check-in: 44d1e198ca user: mistachkin tags: trunk)
2013-05-28
13:23
Clarify the license for SQLite documentation. (check-in: 419389e585 user: drh tags: trunk)
2013-05-23
22:56
Fix a typo in mmap.html. (check-in: 04448addda user: drh tags: trunk)
11:48
Update the documentation for PRAGMA mmap_size to explain that it can sometimes be a no-op. (check-in: a577a4e618 user: drh tags: trunk)
2013-05-20
05:41
Add the sha1 hash and SQLITE_SOURCE_ID for 3071700 to changes.html. (check-in: e87984f1c8 user: dan tags: trunk)
2013-05-19
21:21
Tweaks to the "application file format" use case description. (check-in: 89971860f6 user: drh tags: trunk)
2013-05-18
17:45
Documentation updates for version 3.7.17. (check-in: 67d025e82c user: drh tags: trunk)
2013-05-15
18:58
Add recent bug fixes to the 3.7.17 change log. (check-in: 2b8ea61f51 user: drh tags: trunk)
2013-05-14
11:14
Fix another typo in queryplanner.in. (check-in: d1d2571bce user: drh tags: trunk)
11:12
Fix a typo in queryplanner.html. (check-in: d52ed00775 user: drh tags: trunk)
02:37
Improved hyperlinks on various documents. (check-in: af7d790e13 user: drh tags: trunk)
2013-05-08
18:04
Update the change log. (check-in: f88ad9fa6a user: drh tags: trunk)
2013-05-06
12:14
Fix a typo and clarify wording on the loadext.html page. (check-in: f35f69d86e user: drh tags: trunk)
2013-05-03
17:55
Typo correction and enhancement to the change log. (check-in: a9cecdf9e8 user: drh tags: trunk)
17:51
Still more edits to the application file format text. (check-in: 6ef8771745 user: drh tags: trunk)
17:42
Updates to the application-file-format text. (check-in: 9811172daa user: drh tags: trunk)
15:43
Add documentation for the Application ID. Add a proposed release date for 3.7.17. (check-in: 0d800b73f2 user: drh tags: trunk)
2013-05-01
11:51
Fix a broken hyperlink in the pragma.html page. (check-in: 76230867ab user: drh tags: trunk)
11:02
Fix typos in queryplanner-ng.html. (check-in: c9e2b500a2 user: drh tags: trunk)
00:14
Fix a typo in intern-v-extern-blob.html (check-in: c8b280b8eb user: drh tags: trunk)
2013-04-30
22:20
Updates to the next-generation-query-planner document. (check-in: 28554e7596 user: drh tags: trunk)
16:49
Add the Next Generation Query Planner document. (check-in: 74fbc7b392 user: drh tags: trunk)
11:51
Fix typos in the compile.html document. (check-in: 32b04c8243 user: drh tags: trunk)
2013-04-27
18:31
More documentation tweaks. Add two new entries to the "limits" page. (check-in: 8da1a575d7 user: drh tags: trunk)
12:01
Updates to documentation, especially the C API introduction. (check-in: f0275a9b47 user: drh tags: trunk)
2013-04-26
19:35
Update the change log for 3.7.17. Fix typos in the memory-mapped I/O documentation. (check-in: c8b24bb8c6 user: drh tags: trunk)
15:21
Update the change log for 3.7.17 after reviewing the timeline. (check-in: 7e7024c429 user: drh tags: trunk)
14:47
Fix typos and add clarification in the fts3tokenize documentation. (check-in: aee1b746ba user: drh tags: trunk)
14:38
Add documentation for the fts3tokenize table. (check-in: a6e655aa62 user: drh tags: trunk)
2013-04-25
11:35
Update the FTS3 documentation to make it clearer that external content tables must be in the same database as the FTS virtual table. (check-in: 35441559aa user: drh tags: trunk)
2013-04-24
22:09
If the website keyword search fails, try again after lowercasing the input text. This avoids problems when users enter "OR" and "NEAR" as search terms rather than operators. (check-in: 78cbbe549b user: drh tags: trunk)
2013-04-22
15:35
Ignore the error if two hyperlink keywords differ only in case. (check-in: 55000f1b07 user: drh tags: trunk)
13:52
Add documentation for the SQLITE_ENABLE_SQLLOG compile-time option. (check-in: d81b3b01bf user: drh tags: trunk)
2013-04-19
14:32
Replace some instances of < and > in the text of fts3.html with < and >. (check-in: 2966921d57 user: dan tags: trunk)
02:30
Enhancements to the run-time loadable extensions documentation. (check-in: 9d4141b91f user: drh tags: trunk)
2013-04-17
13:35
Fix a coordinate error in the RTree documentation. (check-in: 600d427573 user: drh tags: trunk)
12:58
Add a documentation page describing how to write run-time loadable extensions. (check-in: 6da9f893bc user: drh tags: trunk)
2013-04-16
13:57
Fix typos in new documents. (check-in: 224d684b8b user: drh tags: trunk)
13:09
Added the mmap.html and errlog.html documents. Updates to the "How to Corrupt" document. Update the change log for 3.7.17. (check-in: ccb921fd36 user: drh tags: trunk)
2013-04-15
17:13
Merge in the changes for 3.7.16.2. Update documentation for the mmap_size refactoring. (check-in: 1e3f82a26e user: drh tags: trunk)
13:16
Update the FTS4 document to describe the two-argument form of fts4aux. (check-in: ba14e1152f user: drh tags: trunk)
2013-04-14
20:55
Fix a typo in the ON CONFLICT clause documentation. (check-in: 0042260937 user: drh tags: trunk)
2013-04-12
12:17
Add sha1sum and source id for version 3.7.16.2 (Leaf check-in: 278390b656 user: dan tags: branch-3.7.16)
12:07
Changes for the 3.7.16.2 patch release. (check-in: 201b85a7c9 user: drh tags: branch-3.7.16)
2013-04-10
15:02
Do not include sessions APIs in the main API documentation. (check-in: db41739574 user: drh tags: trunk)
2013-04-08
02:12
Initial documentation updates for mmap_limit. (check-in: 4dd308afff user: drh tags: trunk)
2013-04-04
01:18
Change the version number to 3.7.17 and begin the change log. (check-in: e78c01d305 user: drh tags: trunk)
2013-03-29
14:02
Add source-id and sha1sum for version 3.7.16.1 (check-in: b6742f225c user: dan tags: trunk, version-3.7.16.1)
13:47
Redate the 3.7.16.1 release to 2013-03-29. (check-in: 5d46117c19 user: drh tags: trunk)
12:17
Fix a broken hyperlink in the different.html document. (check-in: e518038151 user: drh tags: trunk)
2013-03-28
17:51
Update the compile-time options page. Change all dates on the release history to ISO8601 format. (check-in: ce11667ff6 user: drh tags: trunk)
2013-03-27
20:24
Website updates in preparation for the 3.7.16.1 patch release. (check-in: 8e7e750269 user: drh tags: trunk)
19:06
Update the omitted.html page. (check-in: d4dfc5ce44 user: drh tags: trunk)
2013-03-22
23:39
Fix a typo. (check-in: 349d556c0a user: drh tags: trunk)
2013-03-19
20:00
Improved documentation for PRAGMA foreign_key_check and foreign_key_list. (check-in: 72af2c4df1 user: drh tags: trunk)
2013-03-18
21:54
Add a mention of the ZIPVFS extension to the Support page. (check-in: c6ec519b53 user: drh tags: trunk)
21:37
Update the documentation on the SQLite TCL interface to talk about options to the "sqlite3" command and the "wal_hook" method. (check-in: c00d5a996d user: drh tags: trunk)
21:05
Use "package require" rather than "load" on the quick-start guide to using SQLite from TCL. (check-in: 12ac1ca27f user: drh tags: trunk)
19:47
Add Tcl/Tk to the set of well-known-users of SQLite. (check-in: 6ab45fc348 user: drh tags: trunk)
13:38
Store the "legacy source code" packages in the same directory as other products. (check-in: c735c53f75 user: dan tags: trunk, release, version-3.7.16)
13:14
Add source-id and sha1sum for 3.7.16 to changes.in. (check-in: 44bc5edf57 user: dan tags: trunk)
2013-03-13
17:11
Documentation updates and typo fixes in preparation for the next release. (check-in: d29bab5808 user: drh tags: trunk)
2013-03-11
20:22
Fix typos in the atomiccommit.html document. Update the proposed release date for 3.7.16. (check-in: b17469386d user: drh tags: trunk)
2013-03-09
15:12
Fix various documentation typos. (check-in: 8a8b9f4250 user: drh tags: trunk)
15:02
Update change log and index for the 3-way join/affinity bug. (check-in: b7385b0ef3 user: drh tags: trunk)
2013-03-03
00:19
Fix a typo on the pragma documentation. (check-in: 556fe1bb34 user: drh tags: trunk)
2013-03-02
17:37
Add a backwards compatibility note on the documentation of cache_size and its behavior when N is negative. (check-in: 92f6694092 user: drh tags: trunk)
16:44
Fix a typo in the change log for 3.7.16. Remove forgotten debugging puts in the download.in script. (check-in: bf5c2c74b2 user: drh tags: trunk)
16:20
Move future downloads into subdirectories to try to stem the growth in the number of files in the root directory of the website. (check-in: 4d9a64a055 user: drh tags: trunk)
2013-02-25
15:48
Record the incremental vacuum enhancements in the change-log for 3.7.16. (check-in: 638d9567ad user: drh tags: trunk)
14:52
Add documentation for the unicode() and char() functions. (check-in: 0b81bc6851 user: drh tags: trunk)
2013-02-15
15:18
Update the change log and pragma documentation for 3.7.16. (check-in: ba9b0b1040 user: drh tags: trunk)
00:48
Begin making documentation changes for the 3.7.16 release. (check-in: 685a544f00 user: drh tags: trunk)
2013-02-12
13:49
Nokia back on the Sponsors section of the homepage. (check-in: 8197ce8dbb user: drh tags: trunk)
13:45
Updates to the temporary disk file document. (check-in: 9b3d9280b7 user: drh tags: trunk)
2013-01-25
15:06
Correction to the description of the WAL file checksum computation. (check-in: 0a8b8c3b49 user: drh tags: trunk)
2013-01-14
19:22
Add scripts allowing src4 to be used as the search engine for sqlite.org. (check-in: db6671c0ab user: dan tags: trunk)
2013-01-09
13:33
Version 3.7.15.2. (check-in: fb8892f57e user: drh tags: trunk, release, version-3.7.15.2)
2013-01-05
18:22
Fix one of the hyperlinks to mailing list archives on the support page. (check-in: 23c74f1ea7 user: drh tags: trunk)
17:56
Fix typo in comment. (check-in: 85008dde3d user: mistachkin tags: trunk)
2013-01-04
14:05
Fix the order of parameters in the documentation of the INSTR() function. (check-in: ffc982706c user: drh tags: trunk)
2012-12-20
00:37
Version 3.7.15.1 (check-in: 4506c08a63 user: drh tags: trunk, release, version-3.7.15.1)
2012-12-19
20:37
Prepare for the 3.7.15.1 patch release. (check-in: 1e48c52c16 user: drh tags: trunk)
2012-12-12
19:37
Version 3.7.15 (check-in: db9e3b37cc user: drh tags: trunk, release, version-3.7.15)
18:18
Use CSS rather than GIFs to implement rounded corners on the menu bar of the "Search" page. (check-in: 60d478d5bb user: drh tags: trunk)
15:33
Remove references to GIFs used for rounded corners. Rounded corners have not used those GIFs since check-in [2912fc93f779] on 2012-09-04. (check-in: 708a9a33a8 user: drh tags: trunk)
14:45
Fix mistaken latitude values in the examples in the RTree documentation. (check-in: 3af544a1b7 user: drh tags: trunk)
14:44
Update the changelog with the sha1 and source-id for 3715. (check-in: acbd6231fa user: dan tags: trunk)
2012-12-11
19:43
Fix a typo in the requirements marks for "PRAGMA busy_timeout". (check-in: 5081393990 user: drh tags: trunk)
19:11
Documentation typos fixed. (check-in: 5d8312cd94 user: drh tags: trunk)
18:46
Update change logs and news for the 3.7.15 release. Update the "footprint" according to the larger executables generated by recent GCCs. (check-in: 13a0452762 user: drh tags: trunk)
2012-12-07
03:18
Maximum database size is about 140 terabytes. Correct text that formerly reported 14 TB. (check-in: 9c49481d93 user: drh tags: trunk)
2012-12-04
01:34
Fix typo on the "about.html" page. (check-in: e8e08658af user: drh tags: trunk)
2012-12-03
20:10
Tweaks to the change log in preparation for 3.7.15. (check-in: 50fc706041 user: drh tags: trunk)
2012-11-26
15:25
First draft of documentation for the spellfix1 virtual table. (check-in: 3a79eaa3ec user: drh tags: trunk)
2012-11-14
12:46
Fix typo in documentation on EXCLUSIVE locking mode for WAL. (check-in: 64593a771c user: drh tags: trunk)
2012-11-10
14:43
althttpd.c changes: Send a 403 response to unauthorized agents. Add Ezoom to the list of unauthorized agents. Do not log timeouts if the first line of the HTTP request was never received. (check-in: d61bcab9f4 user: drh tags: trunk)
12:38
Change the way that user-agent restrictions are handled in althttpd.c. (check-in: 8d5d89e6db user: drh tags: trunk)
12:23
Disallow the "Download Master" user agent in althttpd.c. (check-in: e6b47e0290 user: drh tags: trunk)
2012-10-30
21:12
Updates to the change log. (check-in: 90a87f71d6 user: drh tags: trunk)
18:15
Import the download page changes from the 3.7.14 branch. (check-in: 1bbb35f908 user: drh tags: trunk)
18:12
Further tweaks to the download page. (Leaf check-in: 87c65ed934 user: drh tags: branch-3.7.14)
17:13
Tweaks to the download page. (check-in: e30d908c5a user: drh tags: branch-3.7.14)
2012-10-29
19:14
Fix typos in the documentation of xDisconnect and xDestroy methods of virtual tables. (check-in: 1974081af3 user: drh tags: trunk)
13:15
Fix the name of the command-line tool in the whentouse.html page. (check-in: bb4847adbb user: drh tags: trunk)
2012-10-26
14:21
Update althttpd.c to use getrusage() for finding run-time information for the log. Always wait for children prior to reporting child runtimes. (check-in: 357e7b7813 user: drh tags: trunk)
2012-10-23
13:29
Added "charset=utf-8" marks to the content type in althttpd.c. (check-in: de32cdc42a user: drh tags: trunk)
2012-10-19
22:24
Add a script for pushing builds of the website out to all three servers. Take care that draft builds are pushed only in the draft directory. (check-in: ac603d6340 user: drh tags: trunk)
2012-10-15
20:39
Fix the INSERT documentation to describe the fact that the VALUES form of an INSERT can insert multiple rows. (check-in: ee9ff30ec6 user: drh tags: trunk)
06:10
Fix typo in the description of PRAGMA journal_mode. (check-in: 4eade435df user: mistachkin tags: trunk)
2012-10-09
16:18
Add documentation of recent changes. (check-in: 7417675f15 user: drh tags: trunk)
2012-10-04
20:37
Add the source_id and sha1sum for the 3.7.14.1 release. (check-in: d8c6fa507b user: drh tags: trunk)
19:54
Website updates for the 3.7.14.1 release. (check-in: ab93c4c755 user: drh tags: trunk)
2012-09-24
11:40
Documentation update for shared-cache. (check-in: 8cf29db0b8 user: drh tags: trunk)
2012-09-21
23:27
Add an apple-touch-icon.png. (check-in: f316f03b40 user: drh tags: trunk)
2012-09-11
11:04
Add information on the values returned by the wal_checkpoint pragma. (check-in: 58cdffdea5 user: drh tags: trunk)
2012-09-04
14:27
Fix a typo in the 3.7.14 change summary. (check-in: 344a45bf94 user: drh tags: trunk)
14:16
Use CSS instead of GIFs to make the rounded corners on the menu bar. (check-in: 2912fc93f7 user: drh tags: trunk)
2012-09-03
21:41
Relabel the System.Data.SQLite download link. (check-in: 24408e4406 user: drh tags: trunk)
18:50
Merge together the accidental trunk fork. (check-in: af94b16ada user: drh tags: trunk)
18:49
Version 3.7.14 (check-in: 55043e391c user: drh tags: trunk, release, version-3.7.14)
15:57
Add the SQLITE_SOURCE_ID and sha1 for 3071400 to changes.in. (check-in: 23ef7483d7 user: dan tags: trunk)
15:46
Push the 3.7.14 release date forward by two days. (check-in: 036b419808 user: drh tags: trunk)
2012-08-31
17:28
Use "&amp;" instead of raw "&" inside the malloc.html document. (check-in: 8d2b596b5e user: drh tags: trunk)
2012-08-29
18:17
Fix a few minor typos. (check-in: ac94eb8835 user: drh tags: trunk)
2012-08-27
16:37
Miscellaneous documentation updates, including updates to the testing document and updates to the changes for version 3.7.14. (check-in: 8fa9629e00 user: drh tags: trunk)
2012-08-25
01:56
Update the change log for 3.7.14 to reflect the latest additions. (check-in: c98f1a5ff9 user: drh tags: trunk)
2012-08-22
22:50
Improved names for triggers in the FTS documentation. (check-in: 851c7d53b7 user: drh tags: trunk)
2012-08-21
21:14
Mention the SQLITE_DISABLE_FTS4_DEFERRED compile-time option in the release notes for 3.7.14. (check-in: 9bb0a29008 user: drh tags: trunk)
2012-08-14
17:10
First attempt at the website alterations for version 3.7.14. (check-in: 1740b434f3 user: drh tags: trunk)
2012-08-11
14:35
Fix typos on page onconflict.html: SQLITE_CONSTAIT -> SQLITE_CONSTRAINT and "proscribed" -> "specified by". (check-in: 81daf9c340 user: dan tags: trunk)
2012-08-07
22:34
Use the full name of WinRT for the header and change instances of 'for' to have the same case. (check-in: 1626e732e1 user: mistachkin tags: trunk)
00:39
Change "win32" to "Win32" on the download page. (check-in: 820bf7a014 user: drh tags: trunk)
00:38
Update the download page to separate WinRT binaries into a separate head and to add the VSIX download. (check-in: 1daba99c3e user: drh tags: trunk)
2012-07-17
12:20
Updates to the static analysis section of the testing.html document. (check-in: f65ab3a743 user: drh tags: trunk)
12:13
Fix the download page to use absolute rather than relative pathnames in order to work around a bug in the Google search engine. (check-in: 90cc4b660f user: drh tags: trunk)
2012-07-09
17:55
Get althttpd to compile and run on linux by adding #include <errno.h&gt. (check-in: ac91a2d606 user: drh tags: trunk)
2012-07-07
10:45
Add "-family ipv6" and "-family ipv4" options to althttpd.c to force it to use one or the other internet protocol version. (check-in: 734d42b432 user: drh tags: trunk)
05:47
In althttpd.c add process tracing, commented out. (check-in: 2a6b5e40c5 user: drh tags: trunk)
2012-07-06
05:22
Fix a bug in checking for the existance of the "default.website" folder. (check-in: 67fc7ffb67 user: drh tags: trunk)
2012-07-05
20:01
Add support for IPv6 to the CGI handler. (check-in: 46c838972f user: drh tags: trunk)
19:35
Add support for IPv6 to the althttpd.c standalone server. (check-in: 74563a081e user: drh tags: trunk)
2012-06-27
19:57
Clarification of the input time string formats for date/time functions. (check-in: 738f9af9ca user: drh tags: trunk)
2012-06-20
08:42
Add "Flame" as a notorious user of SQLite. (check-in: 8c4c1ef51e user: drh tags: trunk)
2012-06-19
15:00
Althttpd changes: Make Redirect() much faster by avoiding timeouts. When a document it not found, search the either path for a not-found.html file to display and redirect to that file. (check-in: 8ad926dff3 user: drh tags: trunk)
14:08
In althttpd, if the requested file is not found, look for the "not-found.html" file in the same directory and use it instead. (check-in: e4391f7f58 user: drh tags: trunk)
2012-06-17
23:53
Fix an issue with the chroot jail. At the ability to 404 certain Referer values. (check-in: cf0aea0254 user: drh tags: trunk)
2012-06-14
17:04
Minor correction to the 3.7.13 news. (check-in: 78b3be0bd9 user: drh tags: trunk)
12:44
Add WinRT and 64-bit binaries to the download page. (check-in: 7dda75edf9 user: drh tags: trunk)
2012-06-11
09:50
Update the changes.html page with the sha1 and source-id for 3.7.13. (check-in: 975182c8e8 user: dan tags: trunk)
2012-06-10
22:19
Updates to documentation for the 3.7.13 release. (check-in: 8ab5a61958 user: drh tags: trunk)
2012-06-09
02:24
Fixes to the --port option of althttpd. (check-in: 7b4eed2b49 user: drh tags: trunk)
01:22
Enhance althttpd with new options --nojail, --port N, and --debug. If the --port N flag is used, then run as a server. --nojail avoids setting the chroot jail. --debug disables the timeout alarms. (check-in: f23fa402b1 user: drh tags: trunk)
2012-06-07
16:30
Updates in preparation for 3.7.13. (check-in: 45f3811cfd user: drh tags: trunk)
2012-06-02
18:50
Bug fix in althttpd.c: Include the port number on the HTTP_HOST cgi environment variable. (check-in: c22354d66a user: drh tags: trunk)
2012-05-31
08:10
Add the COMBINED_LOG_FORMAT compile-time option to althttpd.c. Also catch errors opening a /tmp file and report them. (check-in: f5c16dc36c user: drh tags: trunk)
08:00
Adjust the search script to change an empty title into "No Title". (check-in: d53c90f145 user: drh tags: trunk)
2012-05-30
14:25
Fix the "search" box so that it accepts upper and lower case search terms (with case folding) and OR and NEAR search and phrase searches. Exclude some of the aggregate documents from indexing. (check-in: 26dedb8a9a user: drh tags: trunk)
00:46
Clarification of what counts as using a database connection for restrictions on SQLITE_THREADSAFE=2. (check-in: 84df66d24b user: drh tags: trunk)
2012-05-29
01:06
Add a brief note to the R-Tree documentation to encourage applications to round contained-within query boxes outward slightly to account for round-off error in 64-to-32-bit floating point conversions. (check-in: 1f473ab6ac user: drh tags: trunk)
2012-05-28
17:52
Improvements to shared cache hyperlinking and fixes to the URI parameter documentation. (check-in: 918202f13d user: drh tags: trunk)
17:30
Further enhancements to the in-memory shared-cache documentation. (check-in: bc46aa4246 user: drh tags: trunk)
17:05
Documentation on the unicode61 tokenizer and the ability to use shared-cache with in-memory databases. (check-in: 2ed85cc08c user: drh tags: trunk)
2012-05-22
02:49
Update SHA1 sums for version 3.7.12.1. (check-in: dbe5954269 user: drh tags: trunk)
02:38
Updates to the website for the 3.7.12.1 patch release. (check-in: 80976ba114 user: drh tags: trunk)
2012-05-15
16:46
Fix typos in FTS3 documentation. (check-in: 89c68b1e44 user: drh tags: trunk)
16:41
Typo fix on the homepage. (check-in: 743b78dca8 user: drh tags: trunk)
2012-05-14
15:15
Version 3.7.12 (check-in: 390fbb89ce user: drh tags: trunk, release, version-3.7.12)
09:54
Add the sha1 and SQLITE_SOURCE_ID for sqlite 3.7.12 (8654aa9540). (check-in: 0c4f615237 user: dan tags: trunk)
2012-05-12
22:37
Fix a single spelling error. (check-in: 2cb9dc6d21 user: drh tags: trunk)
20:24
Add a line to the change log to describe an optimization that was added, forgotten, then remembered during the pre-release code inspection. (check-in: 70f4da8259 user: drh tags: trunk)
01:50
Fix a typo in the file format documentation. (check-in: c1bf8efee7 user: drh tags: trunk)
2012-05-11
17:01
Update the change history and news. And make some minor fixes to requirements text. (check-in: 9778992724 user: drh tags: trunk)
2012-04-20
12:52
Many small updates and tweaks to the site in an effort to keep all information current. (check-in: d433035324 user: drh tags: trunk)
12:16
Update the makefile so that it no longer tries to import the GIFs from the source repository. (check-in: 4da3e1833a user: drh tags: trunk)
11:54
Transfer older GIFs from the source repository. (check-in: de32446cf3 user: drh tags: trunk)
2012-04-19
15:19
Fix a typo on the download page. (check-in: 9b450ad866 user: drh tags: trunk)
2012-04-03
02:04
Documentation on how to configure R*Tree for integer-only operation. (check-in: 7404688990 user: drh tags: trunk)
2012-04-02
15:49
Updates to the atomic commit document in order to reference WAL and PSOW and to improve clarity of presentation. (check-in: aaf3ea1155 user: drh tags: trunk)
15:00
Enforce the 80-character line limit on the new documentation source text for FTS4 commands. (check-in: f1d54965d0 user: drh tags: trunk)
14:47
Updates to the FTS4 document to describe recent merge=X,Y, automerge=B, and integrity-check commands. Updates to the change log for the same and for other recent changes. (check-in: 2c33993bdc user: drh tags: trunk)
2012-03-31
12:10
Fix typo in the fileformat2 document. (check-in: 912e06a446 user: drh tags: trunk)
2012-03-29
14:14
Enhance the file format documentation with additional information about internal schema objects. (check-in: 68d2666398 user: drh tags: trunk)
2012-03-28
17:00
Add the typeof()/length() optimization to the change log. (check-in: a2d5d784a5 user: drh tags: trunk)
2012-03-25
17:32
Change the next release number to 3.7.12. Add a comment about the addition of SQLITE_DBSTATUS_CACHE_WRITE. (check-in: 6f0804521d user: drh tags: trunk)
2012-03-20
14:14
Version 3.7.11 (check-in: 6c493d22af user: dan tags: trunk, version-3.7.11)
01:13
News updates in preparation for 3.7.11. (check-in: e231785185 user: drh tags: trunk)
2012-03-06
13:24
Reduce the size of the Bentley logo from 600KB to about 8KB. (check-in: 36e8f98b78 user: drh tags: trunk)
13:23
Add Bentley to the front page. (Leaf check-in: 02d2177a90 user: drh tags: version-3.7.10)
13:11
Tweaks to the FTS4 documentation. Add Bentley to the sponsor list on the front page. (check-in: 39b1d19256 user: drh tags: trunk)
2012-03-05
19:40
Fix typos in the FTS4 languageid option documentation. Add entries to the 3.7.11 change log. (check-in: eb26f05574 user: drh tags: trunk)
19:14
Documentation for the content= and langaugeid= options for FTS4. (check-in: 16b58c9eb4 user: drh tags: trunk)
2012-02-27
07:06
Fix a bug in the description of the 'simple' FTS tokenizer. Underscores (codepoint 95) are divider characters not token characters. (check-in: 73a0dac584 user: dan tags: trunk)
2012-02-23
14:40
Documentation of the SQLITE_FCNTL_PRAGMA file-control. Point out that disabling compound SELECT statements also disables multi-value INSERT. (check-in: cf86dcee73 user: drh tags: trunk)
12:32
Fix a typo in the lang_keywords.html page. (check-in: f8a77cd24f user: drh tags: trunk)
2012-02-05
05:19
Fix an error in the FTS matchinfo documentation. (check-in: 4a7f0dacc7 user: dan tags: trunk)
2012-01-28
19:47
Update the changelog to mention IF NOT EXISTS on virtual tables. (check-in: b0db418b5a user: drh tags: trunk)
19:42
Update the syntax diagram for CREATE VIRTUAL TABLE to show the optional IF NOT EXISTS clause. (check-in: d170aa6e3f user: drh tags: trunk)
18:37
Create the version 3.7.11 change log. (check-in: eb1a6182af user: drh tags: trunk)
15:23
Update the INSERT statement syntax diagram to show the support for multiple rows in the VALUES clause of an INSERT. (check-in: 55bd8303d7 user: drh tags: trunk)
2012-01-27
16:06
Add a fragment for the posix close bug in the howtocorrupt.html document. (check-in: bc266720f3 user: drh tags: trunk)
2012-01-16
13:55
Add the source-id and sha1 sum of sqlite3.c for 3.7.10. (check-in: 7243ea8540 user: dan tags: trunk)
2012-01-13
18:28
Update webpage in preparation for the 3.7.10 release. (check-in: fd5efdc2c1 user: drh tags: trunk)
2012-01-11
21:16
Describe fake-capacity USB sticks on the How-To-Corrupt page. (check-in: 0a50332c30 user: drh tags: trunk)
16:56
Fix typos in the psow.html document. (check-in: e771d11d93 user: drh tags: trunk)
2012-01-09
13:40
Add a note about data types and the compress/uncompress functions to the FTS documentation. (check-in: 8fadbd41ce user: dan tags: trunk)
2012-01-05
12:36
Add mention of torn pages to the PSOW document. (check-in: 776ba1e766 user: drh tags: trunk)
2012-01-03
15:14
Updates to the psow and testing documents. (check-in: d30b4960c1 user: drh tags: trunk)
2012-01-02
15:48
Document the change to PRAGMA cache_size in which a negative argument can be used to set the cache size in kibibytes. (check-in: 47c781b488 user: drh tags: trunk)
2011-12-31
00:20
Add hyperlinks to source documetns on the requirements.html page. Add mention of the psow query parameter to the uri.html page. (check-in: b69af062e6 user: drh tags: trunk)
2011-12-30
20:41
Update the change log for 3.7.10. Added information on test modules associated with each requirement. (check-in: d62d2f8ee3 user: drh tags: trunk)
15:04
Additional "help" printout from the Makefile. (check-in: e044ff8645 user: drh tags: trunk)
14:57
Major speed improvement on the script that translates requirements. Fix requirements markup in optoverview.html and in fileformat2.html. Fixes to requirements.html. (check-in: 986229bc47 user: drh tags: trunk)
13:35
Update the requirements.html document to actually show a list of requirements. (check-in: 03b2db4bd8 user: drh tags: trunk)
2011-12-25
23:06
Move the content-type meta-tag to right after the head tag. It is reported that this helps browsers to load faster. (check-in: 17f12988a0 user: drh tags: trunk)
2011-12-23
20:32
Add the psow.html document describing powersafe overwrite. (check-in: 38fb9e5380 user: drh tags: trunk)
2011-12-19
22:08
Use &#94; instead of ^ in news articles since the rendering software strips out all ^ characters. (check-in: 0fb2011c18 user: drh tags: trunk)
22:02
Fix another typo on the news page. (check-in: 04b4ed6a0d user: drh tags: trunk)
21:08
Fix a typo. "no" becomes "now". (check-in: 2286e5b9c1 user: drh tags: trunk)
2011-12-01
02:30
Changes to make capi3ref processing more robust. (check-in: ababf67f17 user: drh tags: trunk)
2011-11-30
18:46
Improvements to journal_size_limit documentation. (check-in: be40d822e3 user: drh tags: trunk)
2011-11-25
17:51
Update the changes log for sqlite3_stmt_busy(). (check-in: 8092164ae8 user: drh tags: trunk)
2011-11-24
19:40
Fix typos and a mixup over BLOB and text serial types in the file format document. (check-in: 3b3c197a19 user: drh tags: trunk)
2011-11-17
18:03
Update the "changes" log for the next release. Fix all hyperlinks. (check-in: 4643d06dfe user: drh tags: trunk)
14:59
Fix a documentation error pointed out by Richard Godbee on the mailing list. (check-in: 2112591627 user: drh tags: trunk)
2011-11-11
13:37
Rerender all bubble-diagram gifs using xvnc on "elly". The choice of X-server makes a huge difference in the final output, unfortunately. (check-in: d8b1c2a562 user: drh tags: trunk)
13:24
Update the bubble diagram for select-core so that GROUP BY does not allow ASC or DESC keywords. This brings the documentation into compliance with the implementation. (check-in: 40ef9e8de8 user: drh tags: trunk)
2011-11-07
14:45
Start documentation for 3.7.10 by noting the change in DEFAULT_FILE_FORMAT. (check-in: 50947bf51f user: drh tags: trunk)
2011-11-01
13:14
Add SHA1 hashes to the change-log for 3.7.9. (check-in: b2eb449d5e user: drh tags: trunk)
2011-10-31
17:20
Update changes and news in preparation for the 3.7.9 release. (check-in: b78d9767b2 user: drh tags: trunk)
2011-10-21
18:36
Add documentation for the SQLITE_DIRECT_OVERFLOW_READ compile-time option. (check-in: 02ece32458 user: drh tags: trunk)
16:42
Documentation updates for the round() function. (check-in: 81fe64736e user: drh tags: trunk)
2011-10-20
16:34
Update the link to Intuit on the famous.html page. (check-in: 1c732d7d88 user: drh tags: trunk)
2011-10-19
22:32
Add reports on the effect of compile-time options on library footprint. (check-in: 4cf26f3811 user: drh tags: trunk)
19:51
Tweaks to the changes.html page. (check-in: 7e0c741ddc user: drh tags: trunk)
17:14
Add tentative release notes for 3.7.9. Update the documentation on the length() and upper() SQL functions. (check-in: bb404327e3 user: drh tags: trunk)
2011-10-13
15:55
Change exit(1) to return(1) in the quick-start demo programs to avoid having to #include stdlib.h. (check-in: 4a03d52003 user: drh tags: trunk)
2011-10-11
12:36
Fix requirements marks on ANALYZE documentation. (check-in: 5eb8cc7380 user: drh tags: trunk)
2011-10-07
23:26
Update documentation for SQLITE_ENABLE_STAT3. (check-in: 4b78e06344 user: drh tags: trunk)
2011-09-30
14:43
Fix the maximum database size in the limits.html document. (check-in: 1579da9239 user: drh tags: trunk)
2011-09-21
00:53
Add the intern-v-extern-blob document. (check-in: 7f16b8574c user: drh tags: trunk)
2011-09-19
18:22
Add sha1 and SQLITE_SOURCE_ID checksums for 3.7.8 to the change log. (check-in: af2e9e04ed user: dan tags: trunk)
17:44
Updates to the 3.7.8 change list. Release date moved to 2011-09-19. (check-in: 837d3a3411 user: drh tags: trunk)
17:31
Changes prior to release. (check-in: 7cd488eca0 user: drh tags: trunk)
16:41
Update compile.html with SQLITE_MAX_SCHEMA_RETRY and SQLITE_OMIT_MERGE_SORT. (check-in: 5557403d9c user: drh tags: trunk)
15:42
Add the new database footprint page and populate it with statistics for SQLite version 3.7.8. (check-in: c3a816983f user: drh tags: trunk)
2011-09-17
22:45
Update the testing statistics. (check-in: 81fd8fc44f user: drh tags: trunk)
2011-09-16
21:41
Updates to the change log. (check-in: 00154767d3 user: drh tags: trunk)
2011-09-15
12:43
Update the code footprint numbers in the documentation (now 350KiB fully configured and 200KiB minimum). (check-in: 29d8f8e7c5 user: drh tags: trunk)
2011-09-12
18:29
Remove stray "(" character from the ON CONFLICT documentation. (check-in: dd27f660f9 user: drh tags: trunk)
2011-09-05
11:23
Remove all references to the old CVSTrac wiki, which is no longer supported. (check-in: 87f524783e user: drh tags: trunk)
2011-09-01
12:59
Update the "Books About SQLite" page with info about the 2nd edition of Definitive Guide. (check-in: e4bb1f4459 user: drh tags: trunk)
2011-08-31
16:54
Drop the STAT3 enhancement from the 3.7.8 release. (check-in: e64468c842 user: drh tags: trunk)
2011-08-22
19:47
Always specify -fPIC when building the parsehtml.so shared library. (check-in: 01468d451c user: drh tags: trunk)
2011-08-15
23:00
Updates to the short-filename documentation to describe SQLITE_ENABLE_8_3_NAMES=2. (check-in: f0ae7d9c09 user: drh tags: trunk)
16:44
Preliminary release date and change list for 3.7.8. (check-in: 4b85a41d69 user: drh tags: trunk)
2011-08-09
19:22
Update the "crew.html" page to show Joe's picture and bio. (check-in: 127b4cc937 user: drh tags: trunk)
2011-08-04
21:57
Clarify the language in the opening paragraphs of the file format document. (check-in: e7ebad87a6 user: drh tags: trunk)
2011-07-20
13:49
Fix typos in the file format document. (check-in: 81951052dc user: drh tags: trunk)
2011-06-30
16:26
Fix issues with the c3ref documentation generator script. (check-in: 50d18aeabf user: drh tags: trunk)
2011-06-28
18:01
Add the SQLITE_SOURCE_ID and SHA1 checksum for 3.7.7.1 to the changelog. (check-in: f84b6b4880 user: dan tags: trunk)
17:57
Changes for version 3.7.7.1. (check-in: 7c476ae1be user: dan tags: trunk)
2011-06-24
11:03
Fix a date on the news.html page. (check-in: 5ad1fee55e user: dan tags: trunk)
06:41
Update the changelog with the sha1 and SQLITE_SOURCE_ID values for 3.7.7. Change the 3.7.7 release date to the 24th. (check-in: 13b40c2c08 user: dan tags: trunk)
2011-06-21
00:17
Add a news item for the 3.7.7 release. (check-in: 4bfe2f0bdf user: drh tags: trunk)
2011-06-20
23:51
More typo fixes. (check-in: 8f9d1225b6 user: drh tags: trunk)
21:48
Documentation typos. (check-in: b503d1f516 user: drh tags: trunk)
20:27
Update the compile-time options. (check-in: 46855636fa user: drh tags: trunk)
19:49
Updates in preparation for the 3.7.7 release. (check-in: be9ae0b604 user: drh tags: trunk)
19:49
Fix the ON CONFLICT documentation to avoid the erroneous implication that you can put an ON CONFLICT clause on a CHECK constraint. (check-in: 11f4999021 user: drh tags: trunk)
2011-06-15
17:17
Fix typos found and reported by aku. (check-in: f6062d7175 user: drh tags: trunk)
12:23
Update the limits.html document for the new upper bound on SQLITE_MAX_ATTACHED and to describe the maximum database size and the maximum number of rows in a table. (check-in: b91558ccbf user: drh tags: trunk)
2011-06-14
19:38
Update fts3.html with the new "order" and "prefix" options. (check-in: 074255f9eb user: dan tags: trunk)
2011-06-08
15:11
Fix a typo in the how-to-corrupt document. (check-in: a1408d26c6 user: drh tags: trunk)
2011-06-04
23:20
Fix a missing end-requirement mark in the expression documentation. (check-in: 957ac800cf user: drh tags: trunk)
2011-05-31
11:56
Update the documentation to state that the LIMIT of a scalar subquery is always 1. (check-in: 8d37b80354 user: drh tags: trunk)
2011-05-25
14:51
A tweak to the 8+3 filename documentation. Update to the change log. (check-in: 6f298c3ff3 user: drh tags: trunk)
2011-05-24
00:52
Added preliminary documentation for the SAVEPOINT methods in virtual tables. (check-in: 3dded2adf9 user: drh tags: trunk)
00:44
Restrict website search text to omit non-alphanumeric characters. (check-in: 2528553d5a user: drh tags: trunk)
2011-05-23
19:04
Edits to the VFS documentation. Better cross-referencing to VFS. (check-in: e63c0ce4fb user: drh tags: trunk)
2011-05-20
23:21
Further tightening of the validity rules for valid HTTP requests in althttpd.c. (check-in: 73bc374298 user: drh tags: trunk)
20:41
Initial work on documentation of the VFS. (check-in: 5654d9aebd user: drh tags: trunk)
2011-05-19
17:14
Merge the 3.7.6.3 changes into trunk. (check-in: 6800ff0968 user: drh tags: trunk)
14:45
News updates for the 3.7.6.3 release. (Leaf check-in: ef14f9a3d4 user: drh tags: branch-3.7.6)
12:59
Preparing for the 3.7.6.3 patch release. (check-in: f3ea1f0a36 user: drh tags: branch-3.7.6)
2011-05-18
13:31
Refinements to the 8+3 filename documentation. (check-in: 4e0a472c30 user: drh tags: trunk)
13:14
Add documentation for 8+3 filenames. (check-in: 4e973ec4bf user: drh tags: trunk)
2011-05-13
16:57
Rather than document goofy behavior, better to make the behavior less goofy. (Was: Clarify in the documentation that last_insert_rowid() does not work for virtual tables.) (Closed-Leaf check-in: f102116e8a user: drh tags: mistake)
16:47
Add a requirement that CHECK constraints cannot contain subqueries. (check-in: 1f3d321253 user: drh tags: trunk)
2011-05-11
20:53
Improvements to capi3ref hyperlinking. (check-in: b12665db54 user: drh tags: trunk)
19:01
Add documentation for URI filenames. Update capi3ref.in so that it is able to have [[label]] style anchors in the middle of a single documentation unit. (check-in: 66c5bcbaf8 user: drh tags: trunk)
2011-05-02
12:23
Fix a typo in the FAQ reported on the mailing list. (check-in: a8df0f43ab user: drh tags: trunk)
2011-04-22
20:49
Clarification and corrections to the computation of how much content spills into overflow pages in the b-tree. (check-in: e64e27e335 user: drh tags: trunk)
2011-04-20
11:01
Add the "make fast" target on the makefile - for constructing documentation without the requirements matrix. Added notation to the windows DLL on the download page to mention that it is suitable for use with Ruby on Rails. (check-in: e84c9353ca user: drh tags: trunk)
10:46
Change CURRENT_DATETIME to CURRENT_TIMESTAMP in the documentation. Clarify the 32K-amalgamation description. (check-in: 372f970213 user: drh tags: trunk)
2011-04-17
18:03
Update the website for version 3.7.6.2. (check-in: 773de3a641 user: drh tags: trunk)
2011-04-13
18:37
Update documentation for the 3.7.6.1 patch release. Fix a typos in the FTS4 documentation. (check-in: 0a742ee49a user: drh tags: trunk)
2011-04-12
19:40
Another typo in howtocorrupt.html (check-in: 0a0f9e093b user: drh tags: trunk)
19:31
Fix typos in the howtocorrupt.html document. (check-in: ee071c325f user: drh tags: trunk)
18:46
Add a new failure scenario to the howtocorrupt.html document. (check-in: 115b99a5d1 user: drh tags: trunk)
18:17
Add the "How To Corrupt And SQLite Database" document. (check-in: bc040b36db user: drh tags: trunk)
13:28
Add a link from the download page to System.Data.SQLite.org. Also change the name of precompiled Mac binaries from *-mac-* to *-osx-*. (check-in: 5235a1ff91 user: drh tags: trunk)
13:27
Fix a typo in the news for version 3.7.6. (check-in: 79c9cada16 user: drh tags: trunk)
12:06
Update the description of the "sqlite-autoconf-*.tar.gz" tarball to explain that it now also incorporates the TCL bindings using TEA. (check-in: aa9c46b205 user: drh tags: trunk)
02:34
Add the SQLITE_SOURCE_ID to the "changes" page. (check-in: f0fe4bfd5d user: drh tags: trunk)
02:13
Tag the 3.7.6 release. (check-in: 2e59fe9667 user: drh tags: trunk, release)
2011-04-11
23:23
Add a news entry for the release. Update the homepage. (check-in: 9f0051f622 user: drh tags: trunk)
2011-04-09
03:04
Back out the SQLITE_OMIT_UNIQUE_ENFORCEMENT compile-time option. (check-in: 4e49b51557 user: drh tags: trunk)
2011-04-07
18:17
Fix a typo in SQLITE_OMIT_UNIQUE_ENFORCEMENT. (check-in: 8870b75865 user: drh tags: trunk)
11:14
Fix a typo in pragma.html. "RESTART" is a valid parameter to use with "PRAGMA wal_checkpoint", not "RESET". (check-in: 486f3e085d user: dan tags: trunk)
2011-04-06
19:40
Fix a typo in the change log for 3.7.6. (check-in: 055d224c39 user: drh tags: trunk)
15:26
Fix the build-product name recipe at the bottom of the download page. (check-in: e538d8674b user: drh tags: trunk)
2011-04-05
22:22
Change the target release date for 3.7.6 to April 12. (check-in: 76d31b952b user: drh tags: trunk)
14:31
Updates to the ANALYZE and FTS4 documentation to describe the latest changes. Updates to the changes.html file as we move closer to the 3.7.6 release. Added amalgamation32k to the download.html page. (check-in: 4fb953fec0 user: drh tags: trunk)
2011-03-30
19:11
Fix an broken link in the compile.in document. (check-in: 21e4585531 user: drh tags: trunk)
2011-03-29
16:02
Fix a typo in an error message for althttpd.c. (check-in: 67ea9276f4 user: drh tags: trunk)
2011-03-28
16:44
Add basic authentication capabilities to althttpd.c (check-in: 458e5b55bf user: drh tags: trunk)
2011-03-23
18:24
Add a line about the SQLITE_MAX_ATTACHED increase to the change log. (check-in: 15a9eb4640 user: drh tags: trunk)
2011-03-21
07:25
Remove some sqlite API related text that was accidentally copied from c3ref.in into session.in. (check-in: 2027dee073 user: dan tags: trunk)
02:19
Automatically create the "session" subdirectory if it does not previously exist. (check-in: ddc0a3baa3 user: drh tags: trunk)
2011-03-20
11:13
Add new page session.in to document the session module. (check-in: fd135b2345 user: dan tags: trunk)
2011-03-17
14:13
Add Nokia back to the list of sponsors. (check-in: 1fe83b7e46 user: drh tags: trunk)
14:13
Update the changes log for recent addition to 3.7.6. (check-in: ef63e519c2 user: drh tags: trunk)
2011-03-16
07:03
Fix a typo in fts3.in. (check-in: c605c75c11 user: dan tags: trunk)
2011-03-12
05:03
Fixed typo. (check-in: 12e0a9369a user: shaneh tags: trunk)
05:01
Added comments for SQLITE_OMIT_UNIQUE_ENFORCEMENT. (check-in: 21beb4719d user: shaneh tags: trunk)
2011-03-07
13:40
Fix typos in Appendix A of fts3.html. (check-in: b3c69199b5 user: dan tags: trunk)
2011-03-06
03:32
Updates to the testing page: talk of signed-integer overflow and verifying that it is not used. (check-in: 3793e03ba1 user: drh tags: trunk)
2011-02-23
21:27
Make the opcode formatter resistent to comment text that looks like hyperlinks but is really an array index. (check-in: 479052b445 user: drh tags: trunk)
21:21
Add Intuit to the list of famous users. (check-in: d45b5ab320 user: drh tags: trunk)
2011-02-21
14:46
Add a FAQ to for the ECCN for SQLite. (check-in: 4787eddcd9 user: drh tags: trunk)
2011-02-19
15:54
Fix a typo on the change list for version 3.7.6. (check-in: b51db44405 user: drh tags: trunk)
15:53
Update the working on the "warning message" FAQ in response to complaints on the mailing list. (check-in: cea598a713 user: drh tags: trunk)
2011-02-10
20:30
Update the index page and the change log for 3.7.6. (check-in: a7fc545076 user: drh tags: trunk)
20:25
Update pragma documentation to describe the parameters to the wal_checkpoint pragma that follow from the addition of sqlite3_wal_checkpoint_v2(). (check-in: aefb07aa90 user: drh tags: trunk)
2011-02-05
17:00
Update the description of fts4aux in fts3.in to account for recent changes. (check-in: 8e18201f14 user: dan tags: trunk)
2011-02-04
00:52
Update the ATTACH documentation to allow an expression as the filename parameter. Core ticket http://www.sqlite.org/src/info/9013e13dba. (check-in: be0c879c12 user: drh tags: trunk)
2011-02-03
19:06
Update fts3.html to describe the fts4aux module and the fts4 compress/uncompress options. (check-in: ead2cc60ef user: dan tags: trunk)
2011-01-31
14:41
Change the date on version 3.7.5 to February 1. (check-in: ee5bc9089c user: drh tags: trunk)
2011-01-28
21:39
Mention system.data.sqlite in the News for the 3.7.5 release. (check-in: b6c1243fbc user: drh tags: trunk)
2011-01-27
14:39
Documentation updates in preparation for the 3.7.5 release. (check-in: c28584352a user: drh tags: trunk)
2011-01-24
17:56
Update the feature list for 3.7.5. (check-in: 9bc76da550 user: drh tags: trunk)
2011-01-20
15:16
Fixed eight documentation typos reported on the mailing list. (check-in: 9101dd1c25 user: drh tags: trunk)
2011-01-17
18:29
Begin recording changes in preparation for the 3.7.5 release. (check-in: d098a0558d user: drh tags: trunk)
2011-01-13
16:09
Fix typo in the pragma documentation: dartbase to database. (check-in: bd64b1f2ab user: drh tags: trunk)
12:28
Update the names of the Fossil repositories for source code and documentation. (check-in: aae700de31 user: drh tags: trunk)
2011-01-12
22:22
Fix documentation typo pointed out on the mailing list. (check-in: 1927e7c245 user: drh tags: trunk)
2011-01-05
21:46
Fix a serious bug in the specification of the file format: the serial types for BLOB and TEXT where reversed. (check-in: 83a0bc6bb9 user: drh tags: trunk)
2010-12-29
04:52
Fix the order of the LIMIT and OFFSET clauses in some examples on fts3.html (LIMIT comes before OFFSET). (check-in: d3fc079ba8 user: dan tags: trunk)
2010-12-17
17:49
Add entries to the download.in page for snapshot shells for windows. (check-in: 02ac129c98 user: drh tags: trunk)
2010-12-16
17:20
Add documentation of the SQLITE_DEFAULT_FOREIGN_KEY compile-time parameter. (check-in: d606802b48 user: drh tags: trunk)
17:19
Fix a detail of the case_sensitive_like pragma documentation to more accurately describe what really happens. (check-in: 78d484e889 user: drh tags: trunk)
2010-12-09
18:56
Add documentation for the SQLITE_DEFAULT_WAL_AUTOCHECKPOINT compile-time option. Other updates to PRAGMA documentation. (check-in: 140df585c3 user: drh tags: trunk)
2010-12-08
21:13
Remove an obolete requirement from the cache_size pragma. Un-deprecate the foreign_key_list pragma, since people seem to use it far more than we suspected. (check-in: d399230aae user: drh tags: trunk)
12:58
Add a description of the file naming conventions to the download page. (check-in: 5610cee39b user: drh tags: trunk)
2010-12-07
20:07
Update release notes; fix some typos. (check-in: 9cd115e7d2 user: shaneh tags: trunk)
19:32
Fix a typo in the News page. (check-in: 031858612b user: drh tags: trunk)
16:40
Updates to the change-log and news prior to the 3.7.4 release. (check-in: 9ccdbef023 user: drh tags: trunk)
2010-12-01
12:57
Fix a requirement mark in the pragma documentation. (check-in: 517974ad50 user: drh tags: trunk)
11:23
Change a testable statement mark in lang.in. (check-in: 05fc2c982b user: dan tags: trunk)
2010-11-30
18:13
Fix typos in queryplanner.in (check-in: 78db9f1266 user: drh tags: trunk)
12:11
Minor changes to lang_dropview.html. Add section to lang.in describing resolution of object names. (check-in: 6ec0e9720c user: dan tags: trunk)
2010-11-29
21:50
Explanation of the use of :-prefix host parameters for substitution in the TCL interface. (check-in: af551e7e6d user: drh tags: trunk)
12:05
Change a sentence in lang_droptable.html. (check-in: 8c82296b21 user: dan tags: trunk)
2010-11-27
15:55
Add some extra details to fts3.in. (check-in: 5ab479563e user: dan tags: trunk)
11:46
Fix typos in fts3.in. (check-in: bead827e51 user: dan tags: trunk)
2010-11-26
22:46
Update the download page to use a new, consistent file naming scheme. Download files end with a version number of the form WXXYYZZ where W is 3, XX is the major version, YY is the minor version, and ZZ is the patch number. (check-in: 8b77a71a8c user: drh tags: trunk)
21:06
Updates to the FTS3 documentation to include additional discussion and links to FTS4 concepts. (check-in: b8865a0011 user: drh tags: trunk)
18:23
Update documentation for fts3 matchinfo function. (check-in: 4deb70dd76 user: dan tags: trunk)
15:18
Further updates to pragma documentation. Mark deprecated pragmas as such. Tag pragmas used for debugging only. (check-in: e3dca045a2 user: drh tags: trunk)
2010-11-23
15:57
Updates to the PRAGMA documentation. (check-in: b5201ace8f user: drh tags: trunk)
2010-11-21
01:36
Updates to documentation on date/time functions and pragmas. (check-in: 2d231c8139 user: drh tags: trunk)
2010-11-20
01:45
Improved sync pragma documentation. (check-in: 3ae5d72cbd user: drh tags: trunk)
2010-11-18
20:42
Fix a typo in the PRAGMA auto_vacuum documentation. (check-in: 8c4c6ab123 user: drh tags: trunk)
16:21
Update the documentation to be explicit that a parent key must not be a rowid. (check-in: d1edb27943 user: drh tags: trunk)
01:11
Another minor change to the EQP documentation. (check-in: 1aff231013 user: drh tags: trunk)
2010-11-17
22:30
Tweak to the text of the EQP documentation. (check-in: 5f2171a4cb user: drh tags: trunk)
01:32
Add the sqlite3_stmt_readonly() function to the change log. (check-in: c591c1b79d user: drh tags: trunk)
2010-11-15
18:43
Add additional requirements marks and reword a few sentences in eqp.html. (check-in: 09966391b1 user: drh tags: trunk)
17:35
Minor fixes for sample code in eqp.in. (check-in: 897bd4f88e user: dan tags: trunk)
14:32
Add the Airbus logo to the "famous.html" page. Update the changes for 3.7.4. (check-in: c0a45dd7fa user: drh tags: trunk)
13:15
Fix a typo from the fts3.html document. (check-in: c547f4b6c1 user: drh tags: trunk)
2010-11-13
19:00
Move the examples on lang_explain.html to new document eqp.html. (check-in: 0c8678b577 user: dan tags: trunk)
17:10
Update EXPLAIN QUERY PLAN examples to match changes to sqlite. (check-in: 3f8c0a0c1f user: dan tags: trunk)
2010-11-12
17:40
Add evidence marks to examples on lang_explain.html. (check-in: 360fe45245 user: dan tags: trunk)
2010-11-11
17:47
Add extra documentation for EXPLAIN QUERY PLAN. (check-in: 759dfb93a1 user: dan tags: trunk)
2010-11-10
18:43
Add some more documentation for EXPLAIN QUERY PLAN. (check-in: 37f6e9f261 user: dan tags: trunk)
2010-11-03
01:22
Updates to PRAGMA locking_mode and WAL documentation. (check-in: 8ff1145035 user: drh tags: trunk)
2010-11-02
14:46
Documentation of the WAL in EXCLUSIVE locking-mode changes. (check-in: 0aa0be4de5 user: drh tags: trunk)
2010-10-14
17:27
Fix the join-op syntax diagram so that it allows LEFT JOIN in addition to LEFT OUTER JOIN. (check-in: 1a0decefd2 user: drh tags: trunk)
2010-10-08
16:09
Changes to lang_createtable.html. (check-in: dcfeca529f user: dan tags: trunk)
02:37
Changes to the website for version 3.7.3. (check-in: c800d719f4 user: drh tags: trunk)
2010-10-06
13:47
Updates to the file format documentation. (check-in: 8f5cfd48d2 user: drh tags: trunk)
12:23
Update the change documentation for the 3.7.3 release. Fixes to the description of the index_info pragma. (check-in: d009514359 user: drh tags: trunk)
2010-10-01
19:03
Clarify that if a CHECK expression evaluates to NULL, it is not a constraint violation. (check-in: 217545f050 user: dan tags: trunk)
2010-09-30
18:23
Fix a typo on lang_createtable.html. (check-in: 2d50d47170 user: dan tags: trunk)
16:31
Add missing image: numeric-literal.gif. (check-in: d1c65c4e95 user: drh tags: trunk)
16:15
Added a syntax diagram for numeric literals, especially floating point literals. (check-in: 598ff451ef user: drh tags: trunk)
2010-09-29
18:22
Fix a problem with the definition of the DEFAULT clause on lang_conflict.html. (check-in: 73b4c1e498 user: dan tags: trunk)
11:10
Change "'CREATE TABLE AS' statements" to "'CREATE TABLE ... AS SELECT ...' statements" on lang_createtable.html. (check-in: 4534ea5789 user: dan tags: trunk)
04:20
Fix documentation typos in testing.html and in fileformat2.html. (check-in: ac93c65159 user: drh tags: trunk)
01:38
Various documentation typo fixes and updates. (check-in: 161f14d929 user: drh tags: trunk)
2010-09-28
17:38
Changes to the CREATE TABLE documentation. (check-in: 2092d92251 user: dan tags: trunk)
2010-09-24
19:00
Update the REINDEX syntax diagram to allow for no arguments. (check-in: f55ccb05aa user: drh tags: trunk)
18:59
Document the effect of the "REINDEX;" statement. (check-in: 6405a81c7b user: dan tags: trunk)
17:58
Fixes and testability improvements to lang_vacuum.html. (check-in: 91efaa0fc0 user: dan tags: trunk)
07:59
Add a definition for interpreting the result of an expression as a boolean value (e.g. for WHERE or HAVING clauses) to lang_expr.html. Link to this from lang_update.html, lang_delete.html and lang_select.html instead of repeating the definition on each page. (check-in: 36c1765653 user: dan tags: trunk)
2010-09-23
18:46
Changes to lang_update.html. (check-in: 32506c4e82 user: dan tags: trunk)
2010-09-21
16:58
Further changes to lang_update.html. (check-in: e7259b8c39 user: dan tags: trunk)
2010-09-20
19:09
Changes to lang_update.html to make it more testable. (check-in: 5df6adc2a9 user: dan tags: trunk)
2010-09-18
18:52
Tweaks to lang_insert.html. (check-in: 15cc2204a5 user: dan tags: trunk)
15:03
Remove the tags from a couple of untestable statements in lang_select.html. (check-in: 0df9f2d381 user: dan tags: trunk)
2010-09-17
19:52
Update the syntax diagram GIF files. (check-in: 2adf0c0cca user: drh tags: trunk)
17:08
Modify syntax diagrams to show that LIMIT and OFFSET clauses are now expressions, not constant integers. And to make it clear that "OUTER" and "NATURAL OUTER" joins are not supported. (check-in: 5db62da333 user: dan tags: trunk)
00:50
Add coverage percentages to the bottom of the requirements matrix. (check-in: 0f0f4c2b6f user: drh tags: trunk)
2010-09-16
18:50
Change the documentation for LIMIT and OFFSET clauses to be more testable. (check-in: 1cb27a268e user: dan tags: trunk)
2010-09-15
22:17
Updates to the documentation for the new sqlite3_soft_heap_limit64() interface. (check-in: 5d170249d2 user: drh tags: trunk)
18:54
Changes to make the documentation for ORDER BY more testable. (check-in: 095cad2463 user: dan tags: trunk)
2010-09-14
19:10
Adding additional comparison operators to the list in datatype3.html. (check-in: a43ee1e871 user: drh tags: trunk)
18:57
Fix a recently introduced error regarding collation sequences and compounds SELECT statements. (check-in: 8d9fe20890 user: dan tags: trunk)
13:25
Add <> to the list of comparison operators in datatype3.html. (check-in: 838bd2b455 user: drh tags: trunk)
2010-09-13
18:56
Changes to SELECT documentation related to compound SELECT operators. (check-in: 182ba19363 user: dan tags: trunk)
12:06
Added documentation on the SQLITE_4_BYTE_ALIGNED_MALLOC compile-time option. (check-in: dc93bef322 user: drh tags: trunk)
2010-09-11
17:46
Change to requirement marks in lang.in. (check-in: b5882b3f8f user: dan tags: trunk)
2010-09-10
19:11
Minor changes to lang.in. (check-in: 8efac9af2b user: dan tags: trunk)
2010-09-09
19:08
Bug in "fossil rename" prevented the removal of fileformat.in from working. This checkin deletes it, which we know works. (check-in: 95550b75ee user: drh tags: trunk)
18:48
Change some testable statement formatting marks in lang.in. (check-in: a4b6b57093 user: dan tags: trunk)
12:31
Disable the older fileformat document. This makes documentation builds run much faster. Also fix some typos. (check-in: 7cab8e90e4 user: drh tags: trunk)
11:32
Combine two requirements into one in lang_select.html. (check-in: 85d1540336 user: dan tags: trunk)
09:51
Fix a broken link in lang_select.html. (check-in: 53081e3979 user: dan tags: trunk)
2010-09-08
19:01
Clarifications to lang_select.html (check-in: 49e2c0eae6 user: dan tags: trunk)
2010-09-07
14:58
Added link to the Belorussion translation of the FAQ. Added links from parameter binding to SQLITE_LIMIT_VARIABLE_NUMBER. Added section to the "How SQLite Is Tested" document describing disabled optimization tests. (check-in: 71ae536af0 user: drh tags: trunk)
2010-09-06
19:12
Fix some mistakes in lang_select.html. (check-in: 55e829f468 user: dan tags: trunk)
2010-09-04
18:36
Fix a couple of errors in the recent changes to lang_select.html. (check-in: b47f9e77a6 user: dan tags: trunk)
2010-09-03
19:07
Changes to lang_select.html to make it more testable. (check-in: 2441ba87c8 user: dan tags: trunk)
2010-09-02
23:37
Tweaks to the formatting of the requirements traceability matrix. (check-in: e4a472e7f6 user: drh tags: trunk)
19:21
Reword some testable statements related to scalar subqueries in lang_expr.html. (check-in: 573431382a user: dan tags: trunk)
11:52
Add section to lang_expr.html for the EXISTS operator. (check-in: c8e9d99b1d user: dan tags: trunk)
04:20
More typo fixes. (check-in: db66d3a1d4 user: shaneh tags: trunk)
04:20
Add a couple of other typo checking heuristics. (check-in: effb349be5 user: shaneh tags: trunk)
2010-09-01
11:49
New hyperlinks to FTS and RTree. New requirement that automatically generated rowids must be positive. (check-in: ddcf89bab0 user: drh tags: trunk)
2010-08-31
16:49
Fix typo in fts3.html pointed out on the mailing list. (check-in: 8873618014 user: dan tags: trunk)
16:14
Add a fragment for the custom r-tree query section of the r-tree docs. Add the addition of custom r-tree query to the "changes" page. (check-in: c96a663926 user: drh tags: trunk)
15:53
Expand the description of the large-transaction limitatioo for WAL mode. Identify additional requirements in the second file format document. (check-in: 400de5a3af user: drh tags: trunk)
15:03
Add a link to example geometry callback code to rtree.in. (check-in: ed402895f8 user: dan tags: trunk)
11:01
Add documentation for custom r-tree geometry callbacks to rtree.in (check-in: 7e421e2c51 user: dan tags: trunk)
2010-08-30
15:10
More typo and spelling fixes. (check-in: d7a2085524 user: shaneh tags: trunk)
15:09
More updates to custom word list. (check-in: 2bbdfeeb37 user: shaneh tags: trunk)
15:09
Simplified interface to aspell. (check-in: d06b98415b user: shaneh tags: trunk)
13:36
Fix more spelling mistakes and typos. Additional changes for consistency in word usage. (check-in: 9425bd7118 user: shaneh tags: trunk)
13:33
Updated custom word list. (check-in: 46ad923cc2 user: shaneh tags: trunk)
13:32
Pass location of custom word list to spell_chk.sh as an arg. (check-in: a75f0b1a75 user: shaneh tags: trunk)
00:42
Copy the spell-check exception list into the buid directory. Add "SQLite" to the spell-check exception list. (check-in: 99a59a73ff user: drh tags: trunk)
00:13
Updates to the queryplanner.html document. (check-in: 33d6d684cb user: drh tags: trunk)
2010-08-28
05:48
Fix documentation typos. (check-in: 78fe166463 user: shaneh tags: trunk)
05:33
Tweaks to the custom dictionary used for spell checking. (check-in: b5e80cf302 user: shaneh tags: trunk)
2010-08-27
21:09
Add spell check for generated docs using aspell (make spell). (check-in: 047dfe3550 user: shaneh tags: trunk)
11:20
Minor fixes to CAST documentation. (check-in: 302d0bb876 user: dan tags: trunk)
2010-08-26
19:07
Changes to CAST expression documentation to make for more testable statements. (check-in: 6c20f79cbc user: dan tags: trunk)
2010-08-24
13:11
Modifications to documentation for CASE expressions. (check-in: 6c47d70dc0 user: dan tags: trunk)
2010-08-23
22:51
Preparation for the 3.7.2 release. (check-in: 7bf266483d user: drh tags: trunk)
2010-08-21
19:11
Preparations for the 3.7.1 release. (check-in: fb2b8b097b user: drh tags: trunk)
2010-08-14
12:25
Break a big testable statement in lang_expr.html into several smaller blocks. (check-in: 61d45eaf94 user: dan tags: trunk)
2010-08-13
17:44
Enhancements to the description of how the COLLATE operator works. (check-in: 17093bc7d6 user: drh tags: trunk)
2010-08-12
17:55
Initial identification of requirements in the fileformat2.html document. (check-in: 8925c8c2e1 user: drh tags: trunk)
16:26
Work on the queryplanner.html document. (check-in: e8152063fb user: drh tags: trunk)
14:38
Update the file format documentation for the new 64K page size. Add a caution to the WAL document. Omit annoying echos in the script that removes requirement marks from the documentation. (check-in: 0ec9f2cb8f user: drh tags: trunk)
2010-08-10
05:58
Fix typos reported on the mailing list. (check-in: a85aaa0b62 user: drh tags: trunk)
2010-08-09
15:45
Fix a bunch of documentation typos reported on the mailing list. (check-in: d9e242f92a user: drh tags: trunk)
14:30
Fix a typo in the datatype3.html document. (check-in: 9fec2f9dda user: drh tags: trunk)
2010-08-06
17:49
First draft of the queryplanner.html document. (check-in: 1da52815fa user: drh tags: trunk)
2010-08-04
16:19
Update the index, changes, and news pages for the 3.7.0.1 patch release. (Leaf check-in: 25417e1303 user: drh tags: branch-3.7.0)
12:03
Fix a broken hyperlink from lang_conflict.html to foreignkeys.html. (check-in: 5b960cc498 user: drh tags: trunk)
2010-08-03
13:14
ON CONFLICT does in fact work with CHECK constraints. Fix the documentation to show this. The docs used to be right, but were broken by the prior check-in. (check-in: 5395a69f2f user: drh tags: trunk)
02:26
Updates to language documentation. (check-in: c412626afe user: drh tags: trunk)
2010-08-02
18:03
Updates to documentation for ATTACH. (check-in: 213b37eef1 user: drh tags: trunk)
13:05
Always generate the SEARCH box on the website. (check-in: 09c7a61e1a user: drh tags: trunk)
2010-07-28
15:04
Add sqlite3_prepare16_v2() to the list of routines that accept SQL. (check-in: 83cbf2ca08 user: drh tags: trunk)
13:42
Add a blue tint to requirements matrix summary entries that are partially completed, with darker colors indicating more completion. (check-in: 4eb9d03d43 user: drh tags: trunk)
2010-07-27
15:25
Add support for gathering evidence from SLT. (check-in: 0b915cf1f8 user: drh tags: trunk)
13:22
Update the documentation for SQLITE_DEFAULT_AUTOVACUUM to cover the incremental vacuum option. (check-in: 39f2677bb7 user: drh tags: trunk)
08:10
Fix race condition in search box javascript that could occur if the user started to enter text before the page was completely loaded. (check-in: 902e250d41 user: dan tags: trunk)
2010-07-26
16:57
Initial documentation changes for the 3.7.1 release. (check-in: f02b06bd3c user: drh tags: trunk)
11:58
Remove <dl> marks from requirements text prior to insertion into the matrix. (check-in: 9b8e4462b6 user: drh tags: trunk)
2010-07-23
01:13
Updates to the optimizer documentation. (check-in: 06b1be36db user: drh tags: trunk)
2010-07-22
01:47
Fix a typo (reported on the sqlite-users mailing list) in the history for release 3.6.18. (check-in: e0993fbf96 user: drh tags: trunk)
2010-07-21
22:59
Updates to the download.html page. (check-in: 82a31b0b29 user: drh tags: trunk)
16:11
Update news, change log, and testing statistics prior to the release. (check-in: cc4bcb6790 user: drh tags: trunk)
2010-07-17
18:42
Minor changes to the 'Expressions' section of lang.in. (check-in: 8ddf5c33ed user: dan tags: trunk)
15:42
Note in the docs that "+ NULL" is NULL. (check-in: 29da1fe525 user: dan tags: trunk)
2010-07-15
18:41
Fix typos in the wal.html document. (check-in: ad5454b5e0 user: drh tags: trunk)
2010-07-14
22:40
Fix a bug in the back-links of the evidence display generator. (check-in: 96334c601b user: drh tags: trunk)
18:39
Improved documentation of the IN and NOT IN operators. Push back the 3.7.0 release date to 2010-07-22. (check-in: 07096801a3 user: drh tags: trunk)
2010-07-13
23:51
Updates to the WAL documentation. (check-in: 8cdaccbb90 user: drh tags: trunk)
16:51
Enhancements to the ext3 barrier problem description in lockingv3.html. (check-in: a1de10679b user: drh tags: trunk)
14:50
Fix a typo on the temp_store_directory pragma documentation. (check-in: 40fa307f4e user: drh tags: trunk)
13:57
Updates to the lockingv3.html document. (check-in: c354e08449 user: drh tags: trunk)
2010-07-08
18:12
Update PRAGMA journal_mode documentation. Fix typos in the wal.html document. (check-in: b1e171c029 user: drh tags: trunk)
2010-07-07
02:03
Update the compile-time options document and footprint size bounds. Updates to the file format document. (check-in: 0992cf9ad0 user: drh tags: trunk)
2010-07-06
01:27
Adding first draft of WAL file format. (check-in: 05824b6e6a user: drh tags: trunk)
2010-07-05
15:06
Updates to the file format documentation. (check-in: 2d2c9fd38a user: drh tags: trunk)
2010-06-29
16:05
Fix a typo in the date/time function documentation. (check-in: cf14a52e82 user: drh tags: trunk)
2010-06-26
19:53
Move the target 3.7.0 release day to 2010-07-15. (check-in: bf7e93c8b5 user: drh tags: trunk)
2010-06-25
14:52
Add the ability to include TEA snapshots on the download page. (check-in: 2415d6de49 user: drh tags: trunk)
13:45
Fix typos on the wal.html page. (check-in: 3bf3e14239 user: drh tags: trunk)
2010-06-24
17:51
Improve explanation of page_size limitations in WAL mode. Fix a broken link in fileformat2.in. (check-in: c079123bb9 user: drh tags: trunk)
11:49
Add the ability to include development snapshot amalgamations on the download page. (check-in: 3a3f77dd1d user: drh tags: trunk)
2010-06-21
19:17
Clarify the sqlite3_unlock_notify() documentation. (check-in: 5345d71214 user: drh tags: trunk)
2010-06-19
10:40
Add the oracle logo. (check-in: cddbaba37a user: drh tags: trunk)
10:39
Updates to the fileformat2 document. (check-in: 2a5bc288a1 user: drh tags: trunk)
2010-06-17
15:21
Minor edits to the WAL document. (check-in: f84c08f7bf user: drh tags: trunk)
2010-06-15
12:50
Add the new book by Kay Droessler to the "Books About SQLite" page. (check-in: 089a50e46d user: drh tags: trunk)
12:07
Updates to WAL documentation. (check-in: 9f38773d3b user: drh tags: trunk)
2010-06-08
14:21
Fix problem in fts3.html - snippet() takes between 1 and 6 arguments, not between 1 and 4. (check-in: 1bbbb8afd0 user: dan tags: trunk)
2010-06-01
20:50
Updates to the WAL page. (check-in: 766ec51bfe user: drh tags: trunk)
2010-05-29
14:11
Change the icon background to #ffffff. (check-in: 34b189f235 user: drh tags: trunk)
2010-05-25
23:40
Update appearance with new logo and color scheme. (check-in: 225857b614 user: drh tags: trunk)
2010-05-24
22:39
Tweaks to the wal.html document. (check-in: 34cbc3f991 user: drh tags: trunk)
2010-05-08
14:05
Fix typos in the testing document. Change "insure" to "ensure" throughout the website. Ticket [6afbaac77a52917fc]. (check-in: 8c1658c1e2 user: drh tags: trunk)
2010-05-07
16:18
Fleshing out the WAL documentation. (check-in: a7c7d3a520 user: drh tags: trunk)
02:46
Add the new Kreibich book. Add preliminary documentation on WAL pragmas. Refactor the pragma.html document. (check-in: f1676af6d8 user: drh tags: trunk)
2010-05-06
23:48
Minor edits on the way toward 3.7.0 documentation. The wal.html document is created but is still mostly just a stub. (check-in: 019b60379f user: drh tags: trunk)
2010-04-12
13:57
Add initial automatic indexing documentation. (check-in: 906016ee92 user: drh tags: trunk)
2010-03-29
19:57
Updates prior to the release of 3.6.23.1 (check-in: 8327c0b926 user: drh tags: trunk)
2010-03-25
21:32
Corrected typo. (check-in: da61246532 user: shaneh tags: trunk)
21:31
Updates to text based bubble diagrams to fix minor issues and add linking. (check-in: 56374346ea user: shaneh tags: trunk)
21:30
Added psuedo-BNF generator for syntax diagrams. (check-in: 678b7b774c user: shaneh tags: trunk)