Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
118 check-ins using file art/syntax/numeric-literal.gif version 02ec0f6c91
2014-07-24
| ||
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:18 | Fix Win32 to say Win64 for 64-bit DLLs on the download page. (Leaf check-in: e56e2046b0 user: drh tags: version-3.8.4.3) | |
23:16 | Fixes the download of pre-release DLLs. (check-in: 57d62024df user: drh tags: trunk) | |
23:16 | Fixes the download of pre-release DLLs. (check-in: 076319aa90 user: drh tags: version-3.8.4.3) | |
22:56 | Update the download page to support DLL snapshots. (check-in: 3cfd0f3e9a user: drh tags: version-3.8.4.3) | |
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-26
| ||
00:30 | Update althttpd.c client to log SIGPIPE and SIGSEGV in addition to SIGALRM. (check-in: 5a80e1c8e7 user: drh tags: version-3.8.4.3) | |
2014-04-25
| ||
20:47 | Fix more typos in the foreignkey.html document. (check-in: 25bc66990e user: drh tags: version-3.8.4.3) | |
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) | |
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) | |