Documentation Source Text

Timeline
Login

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

121 check-ins using file search/search.tcl version 7a455e1a12

2012-05-30
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 ^ 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)