Documentation Source Text

Timeline
Login

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

154 check-ins using file pages/th3.in version 3902a52970

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