Documentation Source Text

Timeline
Login

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

102 check-ins using file pages/fileformat2.in version c412f9a158

2014-06-30
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)