Documentation Source Text

File History
Login

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

History of pages/pragma.in

2019-08-06
17:02
Improved documentation on how EXPLAIN only affects run-time but some PRAGMA statements operate at prepare-time and are thus unaffected by EXPLAIN. file: [94763216a4] check-in: [e167521765] user: drh branch: branch-3.29, size: 85082
2019-07-17
13:02
Preliminary documentation for the enhancements to index_info and index_xinfo to support viewing the on-disk representation of WITHOUT ROWID tables. file: [2c0aed1759] check-in: [296e23a4b8] user: drh branch: trunk, size: 85526
2019-07-10
11:45
Fix typos file: [f4c43a72c1] check-in: [7a5056a138] user: drh branch: trunk, size: 84765
2019-06-15
15:24
Documentation on the new SQLITE_DBCONFIG options. file: [b4163e2d34] check-in: [4ebc1051c2] user: drh branch: new-dbconfig-options, size: 84766
2019-05-17
20:39
Enhance the PRAGMA journal_mode=OFF documentation to make it clear that ordinary SQL can corrupt the database file while in that mode. See ticket https://www.sqlite.org/src/info/f4ec250930342e0c file: [59b811ee68] check-in: [5f361950a7] user: drh branch: trunk, size: 84594
2019-05-08
17:26
Document the fact that using PRAGMA case_sensitive_like in a database that uses LIKE operators in the schema can lead to problems. file: [a59731b46e] check-in: [bc4c1a7626] user: drh branch: trunk, size: 85250
2019-04-19
23:40
Clarify the documentation on PRAGMA cache_size to explain that the cache size will go up or down in proportion to a change in page size. file: [6d81cafba8] check-in: [184e897473] user: drh branch: trunk, size: 84049
2019-04-17
15:17
Additional information about the SQLITE_IOERR_SHMSIZE error code. file: [62fb460bfe] check-in: [5c5e6f523a] user: drh branch: trunk, size: 83125
2019-02-07
14:31
Fix typos detected by spellcheck. file: [3febbfbcd4] check-in: [8c65dc2deb] user: drh branch: trunk, size: 83089
2019-01-28
12:16
Fix typo on the "PRAGMA database_list" documentation. file: [859c859771] check-in: [70943cf0c8] user: drh branch: branch-3.26, size: 83088
2018-12-06
15:20
Enhanced ALTER TABLE documentation, and in particular show the dangers of not following the generalized 12-step ALTER TABLE procedure precisely. file: [3cfb91eb39] check-in: [4ffbc3f635] user: drh branch: trunk, size: 83092
2018-11-30
21:04
Fix documentation typos. file: [66458bd4b2] check-in: [297fc5035b] user: drh branch: trunk, size: 83080
2018-11-12
15:24
Enhancements to the documentation regarding security and shadow tables. file: [6d3b9498cd] check-in: [7b6b7a791b] user: drh branch: trunk, size: 83078
13:39
Begin adding a change log for version 3.26.0. file: [e79e5e57a6] check-in: [a74a421c12] user: drh branch: trunk, size: 83041
2018-09-25
16:26
Improvements to the legacy_alter_table pragma documentation. Typo fix in the change log. file: [a49b3892dc] check-in: [db3facf719] user: drh branch: branch-3.25, size: 82664
15:02
Preliminary changes for version 3.25.2. file: [0007911188] check-in: [e00e728eae] user: drh branch: branch-3.25, size: 82190
2018-09-14
16:34
The application_id is a signed integer. file: [0947c528ae] check-in: [3580ba4b5b] user: drh branch: trunk, size: 81054
2018-06-08
13:21
Use https for all internal hyperlinks. file: [91ddf5d932] check-in: [59e5f9e3da] user: drh branch: branch-3.24-https, size: 81057
2018-05-09
10:11
Merge fixes from the 3.23 branch. file: [8763721e82] check-in: [cc22fb914a] user: drh branch: trunk, size: 81056
2018-04-30
22:39
More detail on synchronous=NORMAL. file: [3af5ce62cb] check-in: [13c3dff046] user: drh branch: branch-3.23, size: 81025
2018-04-20
00:00
Document the fact that UPSERTs count INSERT operations but not UPDATEs. file: [b41ae0223e] check-in: [fcfd6e8be6] user: drh branch: trunk, size: 80643
2018-03-20
13:14
Remove obsolete text about SQLITE_EXTRA_DURABLE from the PRAGMA synchronous documentation. file: [15cee7abb0] check-in: [fc5ba69bb7] user: drh branch: trunk, size: 80612
2018-01-10
19:26
Improved documentation for recently added features such as SQL Archive support and the Zipfile extension. file: [5d37886252] check-in: [260f2fd7ee] user: drh branch: trunk, size: 80771
2018-01-01
17:54
Add documentation for the introspection pragmas that were really added in version 3.20.0 file: [8b8882ccd5] check-in: [73444ff7b8] user: drh branch: trunk, size: 80766
2017-07-13
22:24
Documentation for PRAGMA secure_delete=FAST. Better hyperlinks on the change log. file: [d19593c9c8] check-in: [ed98e4b3bf] user: drh branch: trunk, size: 79685
2017-05-02
01:31
Fix typo. file: [1b7b42e6c7] check-in: [f230c5ce7d] user: mistachkin branch: trunk, size: 79130
2017-04-17
18:13
Update the documentation on the foreign_key_check pragma to explain that the second output column is NULL for WITHOUT ROWID child tables. file: [c485240771] check-in: [af6ceab74d] user: drh branch: trunk, size: 79129
2017-04-12
20:02
Attempt to clarify the operation of the page_size pragma. file: [70e84a147f] check-in: [6d2df6128e] user: drh branch: trunk, size: 79070
2017-03-20
14:42
Improved documentation for automatic analyze using PRAGMA optimize. file: [a9acc9b5e4] check-in: [1bbfd06810] user: drh branch: trunk, size: 79171
2017-03-15
14:08
Fix typos and improve the wording of the .selftest documentation. file: [3cabe95aae] check-in: [6aaee6c270] user: drh branch: trunk, size: 79095
2017-03-07
00:51
Change the defined default mask for PRAGMA optimize to 0xfffe. file: [add975f45f] check-in: [b4f5fcc3c8] user: drh branch: trunk, size: 78869
2017-03-06
23:14
Fix typo in the pragma optimize documentation. file: [e9dd4bb8cd] check-in: [f61736804d] user: drh branch: trunk, size: 78716
20:49
Initial documentation changes for 3.18.0. Add documentation for PRAGMA optimize and update documentation for PRAGMA integrity_check and quick_check. file: [429e780e27] check-in: [f7a0591178] user: drh branch: trunk, size: 78717
2017-02-22
12:43
Fix typos in the documentation reported by Karol Swietlicki. file: [19bc65ed92] check-in: [d24b5395d0] user: drh branch: 3.17, size: 75531
2017-02-03
04:10
Clarify wording about PRAGMA synchronous=NORMAL and WAL mode. file: [a983b3b7c7] check-in: [7660cac647] user: drh branch: trunk, size: 75530
2017-01-02
11:56
Added news for 3.16.0. Typo fixes and last-minute changes. file: [967977a243] check-in: [eb70d3b295] user: drh branch: trunk, size: 75482
2016-12-22
18:58
Information on PRAGMA table functions. file: [bbb1645d68] check-in: [70f4c8ee07] user: drh branch: trunk, size: 75466
2016-10-27
15:12
Clarification to the incremental_vacuum documentation. file: [873958385f] check-in: [767d991dda] user: drh branch: trunk, size: 73142
2016-09-26
16:02
New warnings about the possibility of corruption the database when certain pragmas are used. file: [5e9a04f80b] check-in: [bc4e6344c0] user: drh branch: trunk, size: 73090
2016-09-14
18:40
Add and use the "[dateof:3.X.Y]" hyperlink target for automatically inserting release dates into the text. file: [4c782f21ed] check-in: [858d993381] user: drh branch: trunk, size: 72225
2016-09-12
10:59
Corrections to the statement that defines when the "PRAGMA page_size" macro is not a no-op. file: [40cd191bf4] check-in: [1d425258b1] user: drh branch: trunk, size: 72127
08:34
Fix the search script so that it can search for individual pragmas. Fix a mismatched tag in the document headers causing the search script to index the menubar on every page. file: [1ed12315c6] check-in: [4d25c80abf] user: dan branch: trunk, size: 72049
2016-09-02
16:57
Rename the output_list proc to hd_list_of_links and move its implementation from capi3ref.in into wrap.tcl, since it is used as common code. file: [3f299f3cf0] check-in: [c3c40d6711] user: drh branch: trunk, size: 71925
2016-09-01
00:48
Reformat the core and aggregate function descriptions in a way that works better on mobile. Use the "output_list" proc for the lists of pragma and aggregate and core functions. file: [f5c2814235] check-in: [fc4a66aa03] user: drh branch: mobile-friendly, size: 71920
2016-08-09
17:38
Improvements to the PRAGMA secure_delete documentation. file: [7125fd23ea] check-in: [ec87587f77] user: drh branch: trunk, size: 72510
2016-04-25
21:58
Clarify restrictions on the use of PRAGMA page_size. file: [076189dc11] check-in: [44656180a0] user: drh branch: branch-3.12, size: 72131
2016-03-08
13:15
Clarifications in "PRAGMA synchronous". file: [4f19b8b342] check-in: [73e31a3096] user: drh branch: trunk, size: 72091
2016-03-04
15:33
Application note on the default page size change. Updates to the change log. file: [be924d5af7] check-in: [954e5c9945] user: drh branch: trunk, size: 72064
2016-02-17
16:14
Fix the PRAGMA synchorous documentation. The default is always FULL even in WAL mode. file: [bc04895d55] check-in: [3540d671bc] user: drh branch: trunk, size: 73176
2016-02-03
19:47
Update the documentation for PRAGMA synchronous=EXTRA. file: [812b2cf946] check-in: [bcf687da9c] user: drh branch: trunk, size: 73242
2016-01-25
13:55
Merge 3.10.2 changes. Add the SQLITE_EXTRA_DURABLE=1 compile-time option. file: [1e540e20c3] check-in: [d39c6c7cfc] user: drh branch: trunk, size: 72426
2015-12-03
22:34
Fix requirement mark errors in the cache_spill pragma docs. file: [94a2b252f2] check-in: [ecd3254d36] user: drh branch: trunk, size: 72361
2015-11-25
18:42
Update the documentation for the LIKE/GLOB/REGEXP enhancement to virtual tables. file: [aad24ecc50] check-in: [6b8138c898] user: drh branch: trunk, size: 72352
2015-11-13
18:14
Update the PRAGMA cache_spill documentation to show the new functionality. file: [71c2a2e740] check-in: [65c5ce0f21] user: drh branch: trunk, size: 72153
2015-09-09
15:39
Enhance wrap.tcl to recognize <yyterm> elements in the input HTML and convert them into real HTML that renders an terminal-symbol oval around the enclosed text. Use this markup when talking about terminal symbols in the language specification. file: [b6994dfbf8] check-in: [8e1d4f3bb5] user: drh branch: trunk, size: 71475
2015-07-27
19:57
Fix typos in documentation found by requirements coverage testing. file: [7a6cda7a85] check-in: [d7cc0cb1e0] user: drh branch: trunk, size: 71464
2015-05-29
19:05
Add an entry on the cell_size_check pragma. Updates to the change log. file: [d9da125a49] check-in: [0bf50a0382] user: drh branch: trunk, size: 71462
2015-05-25
09:22
Fix typo in the "deprecated" footnote on the pragma list. file: [6bc2f4941b] check-in: [7555c435cc] user: drh branch: trunk, size: 70941
2015-03-05
15:35
Fix the documentation of PRAGMA index_info to omit the three extra files that were reverted. Improve the documentation of PRAGMA index_list to detail the output fields. file: [39681fad8b] check-in: [8b3cf7e669] user: drh branch: trunk, size: 70910
2015-02-27
21:52
Remove mention of the SQLITE_DEFAULT_TEMP_CACHE_SIZE compile-time option, which is no longer used and has not been used for a while. Mention that the default cache_size for TEMP databases is 0. file: [6bb1087287] check-in: [b23ccdfcdf] user: drh branch: trunk, size: 70836
20:24
The "PRAGMA temp.cache_size" statement does not currently work. So omit it from the documentation. file: [ee816d8174] check-in: [54c55f5bd5] user: drh branch: trunk, size: 70750
20:09
Resurrect a couple of requirements on PRAGMA journal_mode that were mistakenly dropped by one of the previous few check-ins. file: [99eacb181f] check-in: [a9966eadef] user: drh branch: trunk, size: 70878
19:02
More corrections to the PRAGMA documentation. file: [29c5d4477f] check-in: [08b7956b61] user: drh branch: trunk, size: 70752
15:45
In the PRAGMA documentation, show the "database." prefix on all and only those pragmas for which it might make a difference. file: [ac432b8dca] check-in: [4a77b7e608] user: drh branch: trunk, size: 70532
2015-02-26
20:11
Improvements to the wording of documentation for index_info and index_xinfo pragmas. file: [0fcf990eaa] check-in: [4fca6ea06a] user: drh branch: trunk, size: 71095
17:29
Add documentation for the "PRAGMA index_xinfo" command. file: [fc5956383a] check-in: [fb31730b59] user: drh branch: trunk, size: 71085
2015-02-03
06:14
Fix a typo in the index_info pragma documentation. file: [3f08e039ea] check-in: [49266aeb5b] user: drh branch: trunk, size: 68916
2014-12-25
01:09
Fix a typo in the documentation for PRAGMA data_version. file: [1c0f330b15] check-in: [19930f5ff0] user: drh branch: trunk, size: 68912
2014-12-22
18:41
Refine the way PRAGMA data_version works. file: [8b003b8088] check-in: [5bc1374bd4] user: drh branch: trunk, size: 68912
2014-12-20
14:50
Add documentation for the "PRAGMA data_version" command. file: [877a5136f5] check-in: [115f3d9154] user: drh branch: trunk, size: 68436
2014-12-03
15:50
Updates related to SQLITE_CHECKPOINT_TRUNCATE and especially to the PRAGMA wal_checkpoint documentation. file: [1c4ce71e4e] check-in: [8418b34bb8] user: drh branch: trunk, size: 67519
2014-11-21
13:42
Clarification to the documentation on the reverse_unordered_selects pragma. file: [71ad54966a] check-in: [3d72482e47] user: drh branch: trunk, size: 67225
2014-09-01
18:16
Add documentation about the threads pragma and the WORKER_THREADS compile-time options. Update the change log to include the latest performance numbers and mention of multi-threaded sorting. file: [81ab7fa46c] check-in: [39b74ae928] user: drh branch: trunk, size: 66926
2014-08-12
22:47
Mention that the argument to pragma table_info can be a view. file: [386fcc2b65] check-in: [63eb2d2623] user: drh branch: trunk, size: 66208
2014-08-11
21:17
Fix requirements marks in the file format document. Improvements to PRAGMA documentation. file: [0c6b6284ff] check-in: [e09448dc9d] user: drh branch: trunk, size: 66135
2014-08-07
13:22
General documentation updates. Attempts to provide better links and improve wording for better readability. file: [f6fdb89fd9] check-in: [430bf0b418] user: drh branch: trunk, size: 66108
2014-08-01
03:11
Enhance the documentation on PRAGMA integrity_check to match recent implementation enhancements. Add the enhancements to PRAGMA integrity_check to the change log. file: [2862664aa4] check-in: [6b17e6415e] user: drh branch: trunk, size: 66121
2014-07-18
19:06
Clarify that PRAGMA wal_autocheckpoint always causes a PASSIVE checkpoint. Provide clearer definitions for PASSIVE, FULL, and RESET checkpoints. file: [e9641e30e3] check-in: [306698cb1d] user: drh branch: trunk, size: 65696
2014-04-01
15:02
Strengthen the disclaimers on the "speed.html" page and on the "PRAGMA stats" documentation. file: [30fad7b709] check-in: [0bbad9c76b] user: drh branch: trunk, size: 64174
2014-01-23
15:25
Recursive syntax diagram display. file: [bcaedf16ea] check-in: [87e7eb3d0d] user: drh branch: trunk, size: 63589
2013-11-18
18:48
Fix documentation typos pointed out on the mailing list by Philip Newton. file: [6ab66ad425] check-in: [b8e6ac4ce4] user: drh branch: trunk, size: 63594
2013-10-17
12:54
Add news for the 3.8.1 release. Other final documentation tweaks prior to release. file: [0612560621] check-in: [ca4b03a1f2] user: drh branch: trunk, size: 63591
2013-10-12
20:43
Update the change log and the pragma documentation to reflect restoring PRAGMA index_list to its old behavior. file: [cea63f10f2] check-in: [d585c58e71] user: drh branch: trunk, size: 63441
13:10
Fix the PRAGMA defer_foreign_keys documentation to explain that deferral is disabled whenever a transaction completes. file: [2b09af1957] check-in: [651b3720a7] user: drh branch: trunk, size: 63194
2013-10-11
20:16
Improve the text (rephrasing, not changing the meaning) of some requirements related to functions and pragmas. Improve or correct requirements marks. file: [c963f5fb5a] check-in: [77dee5dcd0] user: drh branch: trunk, size: 63001
2013-09-13
22:03
Add documentation for unlikely(), likelihood() and the soft_heap_limit pragma. file: [102be27b31] check-in: [dc4eae98aa] user: drh branch: trunk, size: 62734
2013-08-23
01:57
Add documentation for the query_only and defer_foreign_keys pragmas. Update the change log for the 3.8.0 release. file: [9b66f9d608] check-in: [8e16497ef1] user: drh branch: trunk, size: 62308
2013-08-20
17:06
Fix typos in the cache_spill pragma documentation. file: [003e39d6f5] check-in: [4bfef7edb7] user: drh branch: trunk, size: 61334
2013-08-17
17:56
Add documentation for the cache_spill pragma. file: [9fc2ceefe6] check-in: [74740a2d9e] user: drh branch: trunk, size: 61335
2013-08-02
23:41
Updates to requirements marks. file: [7a045b50b5] check-in: [498cd0709e] user: drh branch: trunk, size: 60502
2013-07-01
16:07
Lots of tweaking and enhancements to the documentation, especially regarding the query planner and ways of controlling the query planner. file: [763b5372a1] check-in: [641e107a66] user: drh branch: trunk, size: 60494
2013-05-23
11:48
Update the documentation for PRAGMA mmap_size to explain that it can sometimes be a no-op. file: [d2150181ff] check-in: [a577a4e618] user: drh branch: trunk, size: 60417
2013-05-03
15:43
Add documentation for the Application ID. Add a proposed release date for 3.7.17. file: [5588172951] check-in: [0d800b73f2] user: drh branch: trunk, size: 60013
2013-05-01
11:51
Fix a broken hyperlink in the pragma.html page. file: [cf3d929e0f] check-in: [76230867ab] user: drh branch: trunk, size: 59204
2013-04-15
17:13
Merge in the changes for 3.7.16.2. Update documentation for the mmap_size refactoring. file: [0b98a1adfb] check-in: [1e3f82a26e] user: drh branch: trunk, size: 59179
2013-04-08
02:12
Initial documentation updates for mmap_limit. file: [addb83669a] check-in: [4dd308afff] user: drh branch: trunk, size: 58858
2013-03-19
20:00
Improved documentation for PRAGMA foreign_key_check and foreign_key_list. file: [911f976a61] check-in: [72af2c4df1] user: drh branch: trunk, size: 57650
2013-03-13
17:11
Documentation updates and typo fixes in preparation for the next release. file: [1439c0c75c] check-in: [d29bab5808] user: drh branch: trunk, size: 57289
2013-03-03
00:19
Fix a typo on the pragma documentation. file: [a64f20c851] check-in: [556fe1bb34] user: drh branch: trunk, size: 57296
2013-03-02
17:37
Add a backwards compatibility note on the documentation of cache_size and its behavior when N is negative. file: [dc33a60fbc] check-in: [92f6694092] user: drh branch: trunk, size: 57299
2013-02-15
15:18
Update the change log and pragma documentation for 3.7.16. file: [e5566b2da9] check-in: [ba9b0b1040] user: drh branch: trunk, size: 57045
00:48
Begin making documentation changes for the 3.7.16 release. file: [7cf8b367c9] check-in: [685a544f00] user: drh branch: trunk, size: 56908
2012-12-11
19:43
Fix a typo in the requirements marks for "PRAGMA busy_timeout". file: [7f2367387d] check-in: [5081393990] user: drh branch: trunk, size: 55094
2012-10-15
06:10
Fix typo in the description of PRAGMA journal_mode. file: [9ef06c8b9d] check-in: [4eade435df] user: mistachkin branch: trunk, size: 55088
2012-10-09
16:18
Add documentation of recent changes. file: [274c677d64] check-in: [7417675f15] user: drh branch: trunk, size: 55090
2012-09-11
11:04
Add information on the values returned by the wal_checkpoint pragma. file: [447f07b090] check-in: [58cdffdea5] user: drh branch: trunk, size: 54655
2012-06-07
16:30
Updates in preparation for 3.7.13. file: [50a7f38d66] check-in: [45f3811cfd] user: drh branch: trunk, size: 53700
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. file: [8711eb279d] check-in: [cf86dcee73] user: drh branch: trunk, size: 52612
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. file: [87f868efca] check-in: [47c781b488] user: drh branch: trunk, size: 52364
2011-12-23
20:32
Add the psow.html document describing powersafe overwrite. file: [f4c8b31bcd] check-in: [38fb9e5380] user: drh branch: trunk, size: 52225
2011-11-30
18:46
Improvements to journal_size_limit documentation. file: [b302956753] check-in: [be40d822e3] user: drh branch: trunk, size: 51935
2011-11-17
18:03
Update the "changes" log for the next release. Fix all hyperlinks. file: [5e1402cd41] check-in: [4643d06dfe] user: drh branch: trunk, size: 51357
2011-06-20
21:48
Documentation typos. file: [e80554fd92] check-in: [b503d1f516] user: drh branch: trunk, size: 51120
20:27
Update the compile-time options. file: [127cedfd3f] check-in: [46855636fa] user: drh branch: trunk, size: 51121
2011-05-23
19:04
Edits to the VFS documentation. Better cross-referencing to VFS. file: [8744cce673] check-in: [e63c0ce4fb] user: drh branch: trunk, size: 51047
2011-05-11
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. file: [42dfdd5566] check-in: [66c5bcbaf8] user: drh branch: trunk, size: 51045
2011-04-07
11:14
Fix a typo in pragma.html. "RESTART" is a valid parameter to use with "PRAGMA wal_checkpoint", not "RESET". file: [1c40acebcf] check-in: [486f3e085d] user: dan branch: trunk, size: 51095
2011-02-10
20:25
Update pragma documentation to describe the parameters to the wal_checkpoint pragma that follow from the addition of sqlite3_wal_checkpoint_v2(). file: [7e92b94d57] check-in: [aefb07aa90] user: drh branch: trunk, size: 51093
2011-01-13
16:09
Fix typo in the pragma documentation: dartbase to database. file: [deb552eda2] check-in: [bd64b1f2ab] user: drh branch: trunk, size: 50657
2011-01-12
22:22
Fix documentation typo pointed out on the mailing list. file: [aff8818e81] check-in: [1927e7c245] user: drh branch: trunk, size: 50657
2010-12-16
17:19
Fix a detail of the case_sensitive_like pragma documentation to more accurately describe what really happens. file: [321d22f1b2] check-in: [78d484e889] user: drh branch: trunk, size: 50658
2010-12-09
18:56
Add documentation for the SQLITE_DEFAULT_WAL_AUTOCHECKPOINT compile-time option. Other updates to PRAGMA documentation. file: [da312b0c3d] check-in: [140df585c3] user: drh branch: trunk, size: 50548
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. file: [6b91d531a7] check-in: [d399230aae] user: drh branch: trunk, size: 50654
2010-12-01
12:57
Fix a requirement mark in the pragma documentation. file: [0e122f3960] check-in: [517974ad50] user: drh branch: trunk, size: 50802
2010-11-26
21:06
Updates to the FTS3 documentation to include additional discussion and links to FTS4 concepts. file: [1c4a6c34be] check-in: [b8865a0011] user: drh branch: trunk, size: 50802
15:18
Further updates to pragma documentation. Mark deprecated pragmas as such. Tag pragmas used for debugging only. file: [61076654a2] check-in: [e3dca045a2] user: drh branch: trunk, size: 50800
2010-11-23
15:57
Updates to the PRAGMA documentation. file: [e5ae2f5cfa] check-in: [b5201ace8f] user: drh branch: trunk, size: 48195
2010-11-21
01:36
Updates to documentation on date/time functions and pragmas. file: [82128b7dc0] check-in: [2d231c8139] user: drh branch: trunk, size: 48137
2010-11-20
01:45
Improved sync pragma documentation. file: [cce9db92ba] check-in: [3ae5d72cbd] user: drh branch: trunk, size: 47845
2010-11-18
20:42
Fix a typo in the PRAGMA auto_vacuum documentation. file: [1c55080f4d] check-in: [8c4c6ab123] user: drh branch: trunk, size: 46690
2010-11-03
01:22
Updates to PRAGMA locking_mode and WAL documentation. file: [ed0721f743] check-in: [8ff1145035] user: drh branch: trunk, size: 46670
2010-11-02
14:46
Documentation of the WAL in EXCLUSIVE locking-mode changes. file: [2d572ada8b] check-in: [0aa0be4de5] user: drh branch: trunk, size: 46270
2010-10-06
12:23
Update the change documentation for the 3.7.3 release. Fixes to the description of the index_info pragma. file: [6394acbb41] check-in: [d009514359] user: drh branch: trunk, size: 46114
2010-08-30
15:10
More typo and spelling fixes. file: [2413bb8a0c] check-in: [d7a2085524] user: shaneh branch: trunk, size: 45880
2010-08-28
05:48
Fix documentation typos. file: [e03bb046eb] check-in: [78fe166463] user: shaneh branch: trunk, size: 45879
2010-08-23
22:51
Preparation for the 3.7.2 release. file: [89e2a1544b] check-in: [7bf266483d] user: drh branch: trunk, size: 45879
2010-08-21
19:11
Preparations for the 3.7.1 release. file: [e02cf16662] check-in: [fb2b8b097b] user: drh branch: trunk, size: 46429
2010-08-09
15:45
Fix a bunch of documentation typos reported on the mailing list. file: [b9caa40c51] check-in: [d9e242f92a] user: drh branch: trunk, size: 46505
2010-07-13
14:50
Fix a typo on the temp_store_directory pragma documentation. file: [575a65d033] check-in: [40fa307f4e] user: drh branch: trunk, size: 46502
2010-07-08
18:12
Update PRAGMA journal_mode documentation. Fix typos in the wal.html document. file: [9520310b89] check-in: [b1e171c029] user: drh branch: trunk, size: 46501
2010-06-15
12:07
Updates to WAL documentation. file: [48a67133b4] check-in: [9f38773d3b] user: drh branch: trunk, size: 46506
2010-05-07
02:46
Add the new Kreibich book. Add preliminary documentation on WAL pragmas. Refactor the pragma.html document. file: [3a74eab1c0] check-in: [f1676af6d8] user: drh branch: trunk, size: 46599
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. file: [daa4854714] check-in: [019b60379f] user: drh branch: trunk, size: 45290
2010-04-12
13:57
Add initial automatic indexing documentation. file: [8edea416aa] check-in: [906016ee92] user: drh branch: trunk, size: 45057
2010-02-26
15:39
Add documentation for sqlite3_compileoption_get() and related routines and pragmas. Fix up hyperlinks. file: [3092f6d8a0] check-in: [4d3f01f58b] user: drh branch: trunk, size: 44563
2010-02-13
15:43
Correction to the PRAGMA secure_delete documentation. file: [be08fab27d] check-in: [9523519a73] user: drh branch: trunk, size: 44168
2010-02-12
19:58
Update the secure_delete pragma documentation to conform to the latest implementation. file: [cbdf8522f6] check-in: [e4d2cd7fd1] user: drh branch: trunk, size: 44589
18:34
Update the documentation to include information about the new secure_delete pragma. file: [596fca76d1] check-in: [ae2879358d] user: drh branch: trunk, size: 44426
2009-12-15
00:29
Add requirements markings to the pragma documentation. file: [b109001f28] check-in: [a900d49554] user: drh branch: trunk, size: 43179
2009-11-14
17:00
Be sure to mention that PRAGMA foreign_keys is a no-op within a transaction. file: [63fe5ed5a5] check-in: [a802dbe3fb] user: drh branch: trunk, size: 43015
2009-11-02
15:50
Added the website keyword index. file: [043a432a0b] check-in: [ec4a51db99] user: drh branch: trunk, size: 42831
2009-10-22
17:53
Updates to pragma and optimizer documents. Add the evidence formatter and make corresponding revisions to the tracability matrix generator. file: [7b9e9b5019] check-in: [687a957242] user: drh branch: trunk, size: 42830
2009-10-20
13:48
Clarification on the meaning of the cache_size pragma and how the default page cache implementation interprets that pragma. Changes driven by src ticket f80d443a3b. file: [69cfdba760] check-in: [6498c96895] user: drh branch: trunk, size: 42687
2009-10-14
02:43
Documentation updates prior to the release of version 3.6.19. file: [00d354e3fe] check-in: [9598affd43] user: drh branch: trunk, size: 42556
2009-10-07
10:45
Update the description of the "PRAGMA count_changes" command to describe the way changes made by foreign key actions are handled. file: [23dfe938ac] check-in: [52421d8609] user: dan branch: trunk, size: 42217
01:15
Add "See also:" annotations to the syntaxdiagrams.html page. Fix a quoting mistake on pragma.html. file: [c00eb9ee2a] check-in: [365401b552] user: drh branch: trunk, size: 42152
2009-10-02
05:48
Change pragma.html to say that the foreign_keys and recursive_triggers affect existing statements as well as those prepared after the setting is changed. file: [812914af56] check-in: [bdc6c4820c] user: dan branch: trunk, size: 42150
2009-09-22
15:32
Add documentation for the foreign_keys pragma. Fix broken hyperlinks in the new foreign key constraints document. file: [fb77cd8d72] check-in: [bdfaef8a63] user: drh branch: trunk, size: 41746
2009-09-09
17:04
Fix a typo in the recursive_triggers pragma documentation. file: [ab565481db] check-in: [00a2203dba] user: drh branch: trunk, size: 41379
2009-09-07
18:27
Add documentation of SQLITE_MAX_TRIGGER_DEPTH. file: [8d0b49f070] check-in: [df753f0371] user: drh branch: trunk, size: 41379
2009-06-09
00:55
Correct the description on how short_column_names and full_column_names interact. file: [ab48df2001] check-in: [787c316f3f] user: drh branch: trunk, size: 40430
2009-04-29
14:33
Update trigger documentation. file: [ad7535df49] check-in: [1179f9425f] user: drh branch: trunk, size: 40488
2009-04-20
17:43
Update documentation to describe how pragma journal_mode will work as long as there is no pending transaction. file: [09952ddc00] check-in: [8bb233e0af] user: drh branch: trunk, size: 40233
13:29
Update the documentation to explain that the journal_mode must be set prior to the first transaction. CVSTrac ticket #3811. file: [db9399ddf5] check-in: [3a4c37b08b] user: drh branch: trunk, size: 40705
2009-04-06
18:51
Add documentation for the collation_list pragma. file: [f08bd59866] check-in: [db4897a3dd] user: drh branch: trunk, size: 39911
16:42
Updates to the PRAGMA documentation. file: [1164634d75] check-in: [a84577d9a2] user: drh branch: trunk, size: 39684
2009-04-03
01:44
Updates, clarifications, and corrections to the pragma documentation. file: [f3fd02561a] check-in: [36a68629e1] user: drh branch: trunk, size: 39200
2009-04-02
20:17
Improvements and clarifications to the auto_vacuum pragma documentation. file: [1d20838f45] check-in: [ae7cc4efbb] user: drh branch: trunk, size: 38649
2009-03-27
15:12
Make it clear that the case_sensitive_like pragma installs a new application-defined LIKE function. file: [1ede413b98] check-in: [e96456b379] user: drh branch: trunk, size: 37990
2009-03-04
12:20
Fix spelling of precede and preceding in a few places. Cvs ticket 3700. file: [4bbaa0bfb1] check-in: [67c02fcc03] user: dan branch: trunk, size: 37948
2009-02-23
17:59
Add documentaion on the reverse_unordered_selects pragma. file: [d129929d00] check-in: [06452075a4] user: drh branch: trunk, size: 37948
2009-02-13
15:09
Additional hyperlinks associated with shared cache mode and limits. file: [8f4d1ec503] check-in: [1762225ee3] user: drh branch: trunk, size: 36679
2009-02-05
02:33
Enhancements to the SQL language documentation. file: [76b41988a2] check-in: [c8dc1e13d7] user: drh branch: trunk, size: 36193
2009-01-14
06:51
Fix minor typo in pragma.html. file: [a0e6868691] check-in: [0fec42b940] user: dan branch: trunk, size: 36136
2008-11-10
16:50
Various typos, etc. fixed; Improved consistency; Added more links for for omit options; file: [46a65abd89] check-in: [1a29400b8f] user: shaneh branch: trunk, size: 36127
2008-10-28
21:26
Update documentation to describe recent changes on the truncate optimization and on memory allocation. file: [c081b7b806] check-in: [cd968e8e43] user: drh branch: trunk, size: 36119
18:03
Add documentation on the journal_mode=MEMORY pragma. file: [0d1dcca2a1] check-in: [4ea1044b9b] user: drh branch: trunk, size: 36570
2008-10-22
17:59
Remove a misleading statement regarding shared-cache mode from pragma.html. file: [4862d39492] check-in: [0d4b98a77d] user: dan branch: trunk, size: 36162
2008-10-10
23:47
Add documentation on the SQLITE_OMIT_TRUNCATE_OPTIMIZATION compile-time option. file: [afd0c99d3e] check-in: [0e3d036dea] user: drh branch: trunk, size: 36228
2008-10-09
15:47
Fix the syntax diagram for PRAGMA. Other documentation updates. file: [735412ce8e] check-in: [262c3af24e] user: drh branch: trunk, size: 35601
2008-10-03
00:56
Add the syntaxdiagrams.html page to the documentation. Updates to the language documentation pages to talk about the LIMIT and ORDER BY clauses on DELETE and UPDATE. file: [00e0b286b1] check-in: [289df32643] user: drh branch: trunk, size: 35635
2008-10-02
18:04
Replace BNF with bubble diagrams in the language definition pages. Still a lot of text to update. file: [cb2fe6df3c] check-in: [c1cdac9b55] user: drh branch: trunk, size: 35715
2008-09-26
21:38
Add documentation on the TRUNCATE journal mode. file: [7a565673b2] check-in: [715819ca53] user: drh branch: trunk, size: 35741
2008-07-04
13:40
Fixed typo in PRAGMA documentation. file: [f3f1518070] check-in: [bd71688bcb] user: mihailim branch: trunk, size: 35446
2008-06-26
15:46
Continuing work on the compile-time options document. This is an incremental check-in. file: [9fecd5b66b] check-in: [daaf0b565e] user: drh branch: trunk, size: 35445
02:52
Updates to the documents in perparation for 3.6.0. file: [565633bfd3] check-in: [3cb62833af] user: drh branch: trunk, size: 35290
2008-06-11
13:22
Fix an unresolved hyperlink in the pragma.html documentation. file: [f579205e72] check-in: [571ec9cab5] user: drh branch: trunk, size: 35272
2008-06-05
17:03
Add documentation for new pragma "journal_size_limit". file: [d51d638f31] check-in: [f814d9bff5] user: dan branch: trunk, size: 35263
2008-05-16
05:00
Add the new page_count pragma to pragma.in. file: [8185493913] check-in: [120c7812dd] user: dan branch: trunk, size: 33492
2008-04-29
13:18
Use SQLITE_DEFAULT_PAGE_SIZE instead of 1024 in the page size algorithm. file: [e883ed47b1] check-in: [c4bd8f4f26] user: drh branch: trunk, size: 33331
13:10
Add details to the page_size pragma, including specification of the page size selection algorithm. file: [eb7f9a1c7c] check-in: [bc47f60abd] user: drh branch: trunk, size: 33263
2008-04-25
02:42
Updates to the temporary-files document. Create a link to the document from the main documentation index page. Also patch the journal_mode pragma documentation. file: [02d90aa787] check-in: [a192161bbc] user: drh branch: trunk, size: 31609
2008-04-21
19:14
Add documentation on the journal_mode pragma and the new tempfiles.html document. file: [f86ae51ba0] check-in: [85d1df2512] user: drh branch: trunk, size: 31608
2007-12-20
23:01
Additional work toward denser hyperlinking in the documentation. file: [8f4c5cd7df] check-in: [aa8a072b1b] user: drh branch: trunk, size: 29023
03:29
An attempt to get automatic hyperlinking working on all web pages. The website builds, but there are still many problems. file: [4566da8b1f] check-in: [16b1f03012] user: drh branch: trunk, size: 29425
2007-11-27
23:36
Clarify that the legacy_file_format pragma only effects new databases and does not provide information on the file format of the current database. CVSTrac ticket #2804. file: [0c4f1e4297] check-in: [84748f6b9b] user: drh branch: trunk, size: 29416
2007-11-14
03:14
Changes capi3ref.html references to c3ref/ pages everywhere. file: [4248fe5bac] check-in: [c3a14fe2c7] user: drh branch: trunk, size: 29162
2007-11-12
15:32
Complete reorganization of the documentation sources. file: [38ba8c81d7] check-in: [275febef8f] user: drh branch: trunk, size: 29173 Added