Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for pages/pragma.in
|
2024-04-16
| ||
| 16:29 | [c5681f40cb] part of check-in [4159d99277] Fix a few misspellings and grammos. (check-in: [4159d99277] user: larrybr branch: trunk, size: 96348) | |
|
2024-03-29
| ||
| 20:57 | [9c64838456] part of check-in [b7af73016b] Fix typo in the pragma optimize documentation. (check-in: [b7af73016b] user: drh branch: trunk, size: 96349) | |
|
2024-02-21
| ||
| 13:43 | [81ded5cf3c] part of check-in [4c0d69d594] Still more tweaks to the PRAGMA optimize documentation and usage recommendations. (check-in: [4c0d69d594] user: drh branch: trunk, size: 96353) | |
|
2024-02-20
| ||
| 18:47 | [0ae50568ad] part of check-in [8442623cb4] Update documentation to talk about enhancements to PRAGMA optimize. (check-in: [8442623cb4] user: drh branch: trunk, size: 96049) | |
|
2024-02-16
| ||
| 18:43 | [e7573f6b38] part of check-in [da19a9e007] New hyperlinks and refinements to the enhanced ANALYZE documentation. (check-in: [da19a9e007] user: drh branch: trunk, size: 95225) | |
|
2023-10-16
| ||
| 15:24 | [402bc96491] part of check-in [7f8395a8ad] Tweaks to the deprecation warning on PRAGMA case_sensitive_like. (check-in: [7f8395a8ad] user: drh branch: trunk, size: 95141) | |
| 15:17 | [36f7c2170f] part of check-in [2bfc682559] Change documentation to say that the case_sensitive_like pragma is deprecated. (check-in: [2bfc682559] user: drh branch: trunk, size: 95113) | |
|
2023-10-06
| ||
| 10:46 | [a220f65c84] part of check-in [57bf6c4ae7] Global replace http://www.sqlite.org with https://www.sqlite.org in pages/*.in. (check-in: [57bf6c4ae7] user: stephan branch: trunk, size: 94370) | |
|
2023-02-16
| ||
| 21:36 | [87e8125487] part of check-in [fc347f72ff] Add a note to the secure_delete documentation to point out that forensic traces might be left behind in shadow tables of FTS3 and FTS5. (check-in: [fc347f72ff] user: drh branch: trunk, size: 94369) | |
|
2022-12-25
| ||
| 13:08 | [bee51f8e90] part of check-in [2a5f5900ae] The PRAGMA table-valued function feature is no longer experiemental. It is a long-established and stable feature that we depend upon. Update the docs to say as much. (check-in: [2a5f5900ae] user: drh branch: trunk, size: 93869) | |
|
2022-11-21
| ||
| 19:17 | [eb1e52298c] part of check-in [ae3ab2d9be] Document column names for pragma_table_{info,xinfo} and disclaim some meanings for the "cid" column. (check-in: [ae3ab2d9be] user: larrybr branch: trunk, size: 94066) | |
|
2022-11-15
| ||
| 22:37 | [0f695165ea] part of check-in [a47332b43d] Documentation for the restriction of schema_version in defensive mode. (check-in: [a47332b43d] user: drh branch: trunk, size: 93772) | |
|
2022-11-09
| ||
| 20:09 | [23d315f837] part of check-in [142ff38050] Enhance the documentation to talk about the differences between PRAGMA table_info and table_xinfo with regard to generated columns. Forum post 90d7fb12ac. (check-in: [142ff38050] user: drh branch: branch-3.39, size: 93417) | |
|
2022-06-09
| ||
| 21:48 | [ab11de4fab] part of check-in [f44bbff888] Typo and minor grammar cleanup for pragma page (check-in: [f44bbff888] user: larrybr branch: trunk, size: 93225) | |
|
2022-02-15
| ||
| 14:12 | [7e01ba2954] part of check-in [76a5234d62] Omit the extra schema change warning associated with PRAGMA writable_schema. We reserve the right to reintroduce that warning later. (check-in: [76a5234d62] user: drh branch: trunk, size: 93222) | |
| 00:09 | [f237f99219] part of check-in [b2bee1591b] s/DML/DDL/ in last checkin (check-in: [b2bee1591b] user: larrybr branch: trunk, size: 93665) | |
|
2022-02-14
| ||
| 23:42 | [8730fe8452] part of check-in [9601920175] Clarify that schema table modifiers are on their own. (check-in: [9601920175] user: larrybr branch: trunk, size: 93665) | |
|
2022-01-16
| ||
| 20:12 | [e4813e5447] part of check-in [0f053562cd] Clarify how schema may be passed into pragma functions (check-in: [0f053562cd] user: larrybr branch: trunk, size: 93219) | |
|
2021-10-14
| ||
| 17:25 | [9c63dfa31f] part of check-in [7da3b63866] Fix a typo in requirement markup. Change the candidate release date for 3.37.0 to 2021-11-16. (check-in: [7da3b63866] user: drh branch: trunk, size: 93172) | |
|
2021-10-08
| ||
| 17:02 | [e0e90bdb2c] part of check-in [7cb21e6a2b] Add documentation for "PRAGMA writable_schema=RESET". (check-in: [7cb21e6a2b] user: drh branch: trunk, size: 93171) | |
|
2021-09-24
| ||
| 23:48 | [1de9d642ff] part of check-in [21477e3b60] Update the change log and the pragma documentation for the new table_list pragma. (check-in: [21477e3b60] user: drh branch: trunk, size: 92967) | |
|
2021-03-04
| ||
| 00:53 | [80f79658ec] part of check-in [ee3112fbee] For pragma encoding doc, indicate how the default encoding is determined. (check-in: [ee3112fbee] user: larrybr branch: trunk, size: 91412) | |
|
2021-02-01
| ||
| 19:25 | [30e8d4cec8] part of check-in [f8e651e0eb] Typo fix and clarification to PRAGMA analysis_limit. (check-in: [f8e651e0eb] user: drh branch: branch-3.34, size: 91194) | |
|
2020-08-26
| ||
| 19:41 | [bee4dbe7b9] part of check-in [52e85453bb] Clarify the long-standing behavior of the "PRAGMA query_only=TRUE;" command. (check-in: [52e85453bb] user: drh branch: trunk, size: 91201) | |
|
2020-08-08
| ||
| 15:37 | [a523e39097] part of check-in [70e6eb5281] Fix a requirement mark formatting error on the integrity_check docs. (check-in: [70e6eb5281] user: drh branch: trunk, size: 90879) | |
| 15:13 | [97573b7d8b] part of check-in [91ba2807f5] Improvements to wording and typo fixes in pragma documentation. (check-in: [91ba2807f5] user: drh branch: trunk, size: 90876) | |
|
2020-07-23
| ||
| 09:32 | [bd0bd00bb7] part of check-in [95ab7854dd] Add documentation for partial integrity_check. (check-in: [95ab7854dd] user: drh branch: trunk, size: 90841) | |
|
2020-06-18
| ||
| 21:18 | [7ef7f436ae] part of check-in [e01d8c6144] Terminology adjustments. (check-in: [e01d8c6144] user: drh branch: trunk, size: 89693) | |
|
2020-05-14
| ||
| 14:41 | [781061432a] part of check-in [f43bf45ac3] Merge recent fixes from the 3.31 branch. (check-in: [f43bf45ac3] user: drh branch: trunk, size: 89693) | |
|
2020-05-09
| ||
| 18:47 | [ceae3f071e] part of check-in [33a99a578b] Fix typo in documentation for PRAGMA analysis_limit. (check-in: [33a99a578b] user: drh branch: trunk, size: 89396) | |
|
2020-05-06
| ||
| 18:39 | [61350ea51d] part of check-in [d8587f5d39] Clarify that PRAGMA legacy_alter_table is a per-connection setting. (check-in: [d8587f5d39] user: drh branch: branch-3.31, size: 87815) | |
|
2020-05-02
| ||
| 18:12 | [35f080f0d5] part of check-in [88c3a54623] Documentation for approximate ANALYZE. (check-in: [88c3a54623] user: drh branch: trunk, size: 89395) | |
|
2020-01-13
| ||
| 13:33 | [45d42c773d] part of check-in [19599a7e1b] Typo fixes. (check-in: [19599a7e1b] user: drh branch: trunk, size: 87518) | |
|
2020-01-10
| ||
| 00:00 | [8c3e55ca7d] part of check-in [0fc93d49ce] Reference the trusted_schema capability in the 3.31.0 change log. (check-in: [0fc93d49ce] user: drh branch: trunk, size: 87514) | |
|
2019-12-21
| ||
| 15:22 | [7b4690c36e] part of check-in [e92fb43396] Enhance CLI documentation to talk more about reading ZIP archives as database files. (check-in: [e92fb43396] user: drh branch: trunk, size: 86147) | |
|
2019-12-14
| ||
| 11:02 | [9baf217c63] part of check-in [2a413e2e3e] Fix typo on the schema_version pragma documentation. (check-in: [2a413e2e3e] user: drh branch: branch-3.30, size: 86003) | |
|
2019-11-14
| ||
| 18:57 | [988f7fe9bf] part of check-in [2252627a39] Documentation on hard-heap-limit. (check-in: [2252627a39] user: drh branch: trunk, size: 86150) | |
|
2019-10-29
| ||
| 16:31 | [fce7ca3d15] part of check-in [4b80493d37] Updates to the generated column documentation. Notate that the legacy_file_format pragma has been removed and replaced by the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). (check-in: [4b80493d37] user: drh branch: trunk, size: 85288) | |
|
2019-09-27
| ||
| 11:30 | [2a7422061d] part of check-in [de8b5d698b] Merge fixes from the 3.20 branch. (check-in: [de8b5d698b] user: drh branch: trunk, size: 86006) | |
|
2019-09-26
| ||
| 19:24 | [f503f9cb4d] part of check-in [d9d337b927] More documentation on how PRAGMA index_info and PRAGMA index_xinfo handle indexes on expressions. (check-in: [d9d337b927] user: drh branch: trunk, size: 86006) | |
| 19:02 | [cf68ca3379] part of check-in [a94ea31acb] Fix introspection pragma documentation to show that they are now on by default. Add documentation for the TCL Interface config method. (check-in: [a94ea31acb] user: drh branch: trunk, size: 85674) | |
|
2019-09-24
| ||
| 10:30 | [3101be0778] part of check-in [4c6aa056b7] Use single-quoted strings in the documention for PRAGMA encoding. (check-in: [4c6aa056b7] user: drh branch: branch-3.29, size: 85083) | |
|
2019-09-16
| ||
| 14:49 | [0761c71108] part of check-in [518f7b3bdd] Add SQLITE_DIRECTONLY to the change log and documentation. Fix a typo in changes to the index_info pragma. (check-in: [518f7b3bdd] user: drh branch: trunk, size: 85828) | |
| 14:09 | [813281fd85] part of check-in [b10a80aacd] Remove documentation fixes from the release branch. (check-in: [b10a80aacd] user: drh branch: trunk, size: 85844) | |
|
2019-09-13
| ||
| 17:55 | [013ce8ac1f] part of check-in [d83262cc8b] Fix a bug in the documentation generator for PRAGMAs. (check-in: [d83262cc8b] user: drh branch: branch-3.29, size: 85083) | |
|
2019-08-06
| ||
| 17:02 | [94763216a4] part of check-in [e167521765] Improved documentation on how EXPLAIN only affects run-time but some PRAGMA statements operate at prepare-time and are thus unaffected by EXPLAIN. (check-in: [e167521765] user: drh branch: branch-3.29, size: 85082) | |
|
2019-07-17
| ||
| 13:02 | [2c0aed1759] part of check-in [296e23a4b8] Preliminary documentation for the enhancements to index_info and index_xinfo to support viewing the on-disk representation of WITHOUT ROWID tables. (check-in: [296e23a4b8] user: drh branch: trunk, size: 85526) | |
|
2019-07-10
| ||
| 11:45 | [f4c43a72c1] part of check-in [7a5056a138] Fix typos (check-in: [7a5056a138] user: drh branch: trunk, size: 84765) | |
|
2019-06-15
| ||
| 15:24 | [b4163e2d34] part of check-in [4ebc1051c2] Documentation on the new SQLITE_DBCONFIG options. (check-in: [4ebc1051c2] user: drh branch: new-dbconfig-options, size: 84766) | |
|
2019-05-17
| ||
| 20:39 | [59b811ee68] part of check-in [5f361950a7] 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 (check-in: [5f361950a7] user: drh branch: trunk, size: 84594) | |
|
2019-05-08
| ||
| 17:26 | [a59731b46e] part of check-in [bc4c1a7626] Document the fact that using PRAGMA case_sensitive_like in a database that uses LIKE operators in the schema can lead to problems. (check-in: [bc4c1a7626] user: drh branch: trunk, size: 85250) | |
|
2019-04-19
| ||
| 23:40 | [6d81cafba8] part of check-in [184e897473] 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. (check-in: [184e897473] user: drh branch: trunk, size: 84049) | |
|
2019-04-17
| ||
| 15:17 | [62fb460bfe] part of check-in [5c5e6f523a] Additional information about the SQLITE_IOERR_SHMSIZE error code. (check-in: [5c5e6f523a] user: drh branch: trunk, size: 83125) | |
|
2019-02-07
| ||
| 14:31 | [3febbfbcd4] part of check-in [8c65dc2deb] Fix typos detected by spellcheck. (check-in: [8c65dc2deb] user: drh branch: trunk, size: 83089) | |
|
2019-01-28
| ||
| 12:16 | [859c859771] part of check-in [70943cf0c8] Fix typo on the "PRAGMA database_list" documentation. (check-in: [70943cf0c8] user: drh branch: branch-3.26, size: 83088) | |
|
2018-12-06
| ||
| 15:20 | [3cfb91eb39] part of check-in [4ffbc3f635] Enhanced ALTER TABLE documentation, and in particular show the dangers of not following the generalized 12-step ALTER TABLE procedure precisely. (check-in: [4ffbc3f635] user: drh branch: trunk, size: 83092) | |
|
2018-11-30
| ||
| 21:04 | [66458bd4b2] part of check-in [297fc5035b] Fix documentation typos. (check-in: [297fc5035b] user: drh branch: trunk, size: 83080) | |
|
2018-11-12
| ||
| 15:24 | [6d3b9498cd] part of check-in [7b6b7a791b] Enhancements to the documentation regarding security and shadow tables. (check-in: [7b6b7a791b] user: drh branch: trunk, size: 83078) | |
| 13:39 | [e79e5e57a6] part of check-in [a74a421c12] Begin adding a change log for version 3.26.0. (check-in: [a74a421c12] user: drh branch: trunk, size: 83041) | |
|
2018-09-25
| ||
| 16:26 | [a49b3892dc] part of check-in [db3facf719] Improvements to the legacy_alter_table pragma documentation. Typo fix in the change log. (check-in: [db3facf719] user: drh branch: branch-3.25, size: 82664) | |
| 15:02 | [0007911188] part of check-in [e00e728eae] Preliminary changes for version 3.25.2. (check-in: [e00e728eae] user: drh branch: branch-3.25, size: 82190) | |
|
2018-09-14
| ||
| 16:34 | [0947c528ae] part of check-in [3580ba4b5b] The application_id is a signed integer. (check-in: [3580ba4b5b] user: drh branch: trunk, size: 81054) | |
|
2018-06-08
| ||
| 13:21 | [91ddf5d932] part of check-in [59e5f9e3da] Use https for all internal hyperlinks. (check-in: [59e5f9e3da] user: drh branch: branch-3.24-https, size: 81057) | |
|
2018-05-09
| ||
| 10:11 | [8763721e82] part of check-in [cc22fb914a] Merge fixes from the 3.23 branch. (check-in: [cc22fb914a] user: drh branch: trunk, size: 81056) | |
|
2018-04-30
| ||
| 22:39 | [3af5ce62cb] part of check-in [13c3dff046] More detail on synchronous=NORMAL. (check-in: [13c3dff046] user: drh branch: branch-3.23, size: 81025) | |
|
2018-04-20
| ||
| 00:00 | [b41ae0223e] part of check-in [fcfd6e8be6] Document the fact that UPSERTs count INSERT operations but not UPDATEs. (check-in: [fcfd6e8be6] user: drh branch: trunk, size: 80643) | |
|
2018-03-20
| ||
| 13:14 | [15cee7abb0] part of check-in [fc5ba69bb7] Remove obsolete text about SQLITE_EXTRA_DURABLE from the PRAGMA synchronous documentation. (check-in: [fc5ba69bb7] user: drh branch: trunk, size: 80612) | |
|
2018-01-10
| ||
| 19:26 | [5d37886252] part of check-in [260f2fd7ee] Improved documentation for recently added features such as SQL Archive support and the Zipfile extension. (check-in: [260f2fd7ee] user: drh branch: trunk, size: 80771) | |
|
2018-01-01
| ||
| 17:54 | [8b8882ccd5] part of check-in [73444ff7b8] Add documentation for the introspection pragmas that were really added in version 3.20.0 (check-in: [73444ff7b8] user: drh branch: trunk, size: 80766) | |
|
2017-07-13
| ||
| 22:24 | [d19593c9c8] part of check-in [ed98e4b3bf] Documentation for PRAGMA secure_delete=FAST. Better hyperlinks on the change log. (check-in: [ed98e4b3bf] user: drh branch: trunk, size: 79685) | |
|
2017-05-02
| ||
| 01:31 | [1b7b42e6c7] part of check-in [f230c5ce7d] Fix typo. (check-in: [f230c5ce7d] user: mistachkin branch: trunk, size: 79130) | |
|
2017-04-17
| ||
| 18:13 | [c485240771] part of check-in [af6ceab74d] Update the documentation on the foreign_key_check pragma to explain that the second output column is NULL for WITHOUT ROWID child tables. (check-in: [af6ceab74d] user: drh branch: trunk, size: 79129) | |
|
2017-04-12
| ||
| 20:02 | [70e84a147f] part of check-in [6d2df6128e] Attempt to clarify the operation of the page_size pragma. (check-in: [6d2df6128e] user: drh branch: trunk, size: 79070) | |
|
2017-03-20
| ||
| 14:42 | [a9acc9b5e4] part of check-in [1bbfd06810] Improved documentation for automatic analyze using PRAGMA optimize. (check-in: [1bbfd06810] user: drh branch: trunk, size: 79171) | |
|
2017-03-15
| ||
| 14:08 | [3cabe95aae] part of check-in [6aaee6c270] Fix typos and improve the wording of the .selftest documentation. (check-in: [6aaee6c270] user: drh branch: trunk, size: 79095) | |
|
2017-03-07
| ||
| 00:51 | [add975f45f] part of check-in [b4f5fcc3c8] Change the defined default mask for PRAGMA optimize to 0xfffe. (check-in: [b4f5fcc3c8] user: drh branch: trunk, size: 78869) | |
|
2017-03-06
| ||
| 23:14 | [e9dd4bb8cd] part of check-in [f61736804d] Fix typo in the pragma optimize documentation. (check-in: [f61736804d] user: drh branch: trunk, size: 78716) | |
| 20:49 | [429e780e27] part of check-in [f7a0591178] Initial documentation changes for 3.18.0. Add documentation for PRAGMA optimize and update documentation for PRAGMA integrity_check and quick_check. (check-in: [f7a0591178] user: drh branch: trunk, size: 78717) | |
|
2017-02-22
| ||
| 12:43 | [19bc65ed92] part of check-in [d24b5395d0] Fix typos in the documentation reported by Karol Swietlicki. (check-in: [d24b5395d0] user: drh branch: 3.17, size: 75531) | |
|
2017-02-03
| ||
| 04:10 | [a983b3b7c7] part of check-in [7660cac647] Clarify wording about PRAGMA synchronous=NORMAL and WAL mode. (check-in: [7660cac647] user: drh branch: trunk, size: 75530) | |
|
2017-01-02
| ||
| 11:56 | [967977a243] part of check-in [eb70d3b295] Added news for 3.16.0. Typo fixes and last-minute changes. (check-in: [eb70d3b295] user: drh branch: trunk, size: 75482) | |
|
2016-12-22
| ||
| 18:58 | [bbb1645d68] part of check-in [70f4c8ee07] Information on PRAGMA table functions. (check-in: [70f4c8ee07] user: drh branch: trunk, size: 75466) | |
|
2016-10-27
| ||
| 15:12 | [873958385f] part of check-in [767d991dda] Clarification to the incremental_vacuum documentation. (check-in: [767d991dda] user: drh branch: trunk, size: 73142) | |
|
2016-09-26
| ||
| 16:02 | [5e9a04f80b] part of check-in [bc4e6344c0] New warnings about the possibility of corruption the database when certain pragmas are used. (check-in: [bc4e6344c0] user: drh branch: trunk, size: 73090) | |
|
2016-09-14
| ||
| 18:40 | [4c782f21ed] part of check-in [858d993381] Add and use the "[dateof:3.X.Y]" hyperlink target for automatically inserting release dates into the text. (check-in: [858d993381] user: drh branch: trunk, size: 72225) | |
|
2016-09-12
| ||
| 10:59 | [40cd191bf4] part of check-in [1d425258b1] Corrections to the statement that defines when the "PRAGMA page_size" macro is not a no-op. (check-in: [1d425258b1] user: drh branch: trunk, size: 72127) | |
| 08:34 | [1ed12315c6] part of check-in [4d25c80abf] 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. (check-in: [4d25c80abf] user: dan branch: trunk, size: 72049) | |
|
2016-09-02
| ||
| 16:57 | [3f299f3cf0] part of check-in [c3c40d6711] 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. (check-in: [c3c40d6711] user: drh branch: trunk, size: 71925) | |
|
2016-09-01
| ||
| 00:48 | [f5c2814235] part of check-in [fc4a66aa03] 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. (check-in: [fc4a66aa03] user: drh branch: mobile-friendly, size: 71920) | |
|
2016-08-09
| ||
| 17:38 | [7125fd23ea] part of check-in [ec87587f77] Improvements to the PRAGMA secure_delete documentation. (check-in: [ec87587f77] user: drh branch: trunk, size: 72510) | |
|
2016-04-25
| ||
| 21:58 | [076189dc11] part of check-in [44656180a0] Clarify restrictions on the use of PRAGMA page_size. (check-in: [44656180a0] user: drh branch: branch-3.12, size: 72131) | |
|
2016-03-08
| ||
| 13:15 | [4f19b8b342] part of check-in [73e31a3096] Clarifications in "PRAGMA synchronous". (check-in: [73e31a3096] user: drh branch: trunk, size: 72091) | |
|
2016-03-04
| ||
| 15:33 | [be924d5af7] part of check-in [954e5c9945] Application note on the default page size change. Updates to the change log. (check-in: [954e5c9945] user: drh branch: trunk, size: 72064) | |
|
2016-02-17
| ||
| 16:14 | [bc04895d55] part of check-in [3540d671bc] Fix the PRAGMA synchorous documentation. The default is always FULL even in WAL mode. (check-in: [3540d671bc] user: drh branch: trunk, size: 73176) | |
|
2016-02-03
| ||
| 19:47 | [812b2cf946] part of check-in [bcf687da9c] Update the documentation for PRAGMA synchronous=EXTRA. (check-in: [bcf687da9c] user: drh branch: trunk, size: 73242) | |
|
2016-01-25
| ||
| 13:55 | [1e540e20c3] part of check-in [d39c6c7cfc] Merge 3.10.2 changes. Add the SQLITE_EXTRA_DURABLE=1 compile-time option. (check-in: [d39c6c7cfc] user: drh branch: trunk, size: 72426) | |
|
2015-12-03
| ||
| 22:34 | [94a2b252f2] part of check-in [ecd3254d36] Fix requirement mark errors in the cache_spill pragma docs. (check-in: [ecd3254d36] user: drh branch: trunk, size: 72361) | |
|
2015-11-25
| ||
| 18:42 | [aad24ecc50] part of check-in [6b8138c898] Update the documentation for the LIKE/GLOB/REGEXP enhancement to virtual tables. (check-in: [6b8138c898] user: drh branch: trunk, size: 72352) | |
|
2015-11-13
| ||
| 18:14 | [71c2a2e740] part of check-in [65c5ce0f21] Update the PRAGMA cache_spill documentation to show the new functionality. (check-in: [65c5ce0f21] user: drh branch: trunk, size: 72153) | |
|
2015-09-09
| ||
| 15:39 | [b6994dfbf8] part of check-in [8e1d4f3bb5] 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. (check-in: [8e1d4f3bb5] user: drh branch: trunk, size: 71475) | |
|
2015-07-27
| ||
| 19:57 | [7a6cda7a85] part of check-in [d7cc0cb1e0] Fix typos in documentation found by requirements coverage testing. (check-in: [d7cc0cb1e0] user: drh branch: trunk, size: 71464) | |
|
2015-05-29
| ||
| 19:05 | [d9da125a49] part of check-in [0bf50a0382] Add an entry on the cell_size_check pragma. Updates to the change log. (check-in: [0bf50a0382] user: drh branch: trunk, size: 71462) | |
|
2015-05-25
| ||
| 09:22 | [6bc2f4941b] part of check-in [7555c435cc] Fix typo in the "deprecated" footnote on the pragma list. (check-in: [7555c435cc] user: drh branch: trunk, size: 70941) | |
|
2015-03-05
| ||
| 15:35 | [39681fad8b] part of check-in [8b3cf7e669] 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. (check-in: [8b3cf7e669] user: drh branch: trunk, size: 70910) | |
|
2015-02-27
| ||
| 21:52 | [6bb1087287] part of check-in [b23ccdfcdf] 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. (check-in: [b23ccdfcdf] user: drh branch: trunk, size: 70836) | |
| 20:24 | [ee816d8174] part of check-in [54c55f5bd5] The "PRAGMA temp.cache_size" statement does not currently work. So omit it from the documentation. (check-in: [54c55f5bd5] user: drh branch: trunk, size: 70750) | |
| 20:09 | [99eacb181f] part of check-in [a9966eadef] Resurrect a couple of requirements on PRAGMA journal_mode that were mistakenly dropped by one of the previous few check-ins. (check-in: [a9966eadef] user: drh branch: trunk, size: 70878) | |
| 19:02 | [29c5d4477f] part of check-in [08b7956b61] More corrections to the PRAGMA documentation. (check-in: [08b7956b61] user: drh branch: trunk, size: 70752) | |
| 15:45 | [ac432b8dca] part of check-in [4a77b7e608] In the PRAGMA documentation, show the "database." prefix on all and only those pragmas for which it might make a difference. (check-in: [4a77b7e608] user: drh branch: trunk, size: 70532) | |
|
2015-02-26
| ||
| 20:11 | [0fcf990eaa] part of check-in [4fca6ea06a] Improvements to the wording of documentation for index_info and index_xinfo pragmas. (check-in: [4fca6ea06a] user: drh branch: trunk, size: 71095) | |
| 17:29 | [fc5956383a] part of check-in [fb31730b59] Add documentation for the "PRAGMA index_xinfo" command. (check-in: [fb31730b59] user: drh branch: trunk, size: 71085) | |
|
2015-02-03
| ||
| 06:14 | [3f08e039ea] part of check-in [49266aeb5b] Fix a typo in the index_info pragma documentation. (check-in: [49266aeb5b] user: drh branch: trunk, size: 68916) | |
|
2014-12-25
| ||
| 01:09 | [1c0f330b15] part of check-in [19930f5ff0] Fix a typo in the documentation for PRAGMA data_version. (check-in: [19930f5ff0] user: drh branch: trunk, size: 68912) | |
|
2014-12-22
| ||
| 18:41 | [8b003b8088] part of check-in [5bc1374bd4] Refine the way PRAGMA data_version works. (check-in: [5bc1374bd4] user: drh branch: trunk, size: 68912) | |
|
2014-12-20
| ||
| 14:50 | [877a5136f5] part of check-in [115f3d9154] Add documentation for the "PRAGMA data_version" command. (check-in: [115f3d9154] user: drh branch: trunk, size: 68436) | |
|
2014-12-03
| ||
| 15:50 | [1c4ce71e4e] part of check-in [8418b34bb8] Updates related to SQLITE_CHECKPOINT_TRUNCATE and especially to the PRAGMA wal_checkpoint documentation. (check-in: [8418b34bb8] user: drh branch: trunk, size: 67519) | |
|
2014-11-21
| ||
| 13:42 | [71ad54966a] part of check-in [3d72482e47] Clarification to the documentation on the reverse_unordered_selects pragma. (check-in: [3d72482e47] user: drh branch: trunk, size: 67225) | |
|
2014-09-01
| ||
| 18:16 | [81ab7fa46c] part of check-in [39b74ae928] 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. (check-in: [39b74ae928] user: drh branch: trunk, size: 66926) | |
|
2014-08-12
| ||
| 22:47 | [386fcc2b65] part of check-in [63eb2d2623] Mention that the argument to pragma table_info can be a view. (check-in: [63eb2d2623] user: drh branch: trunk, size: 66208) | |
|
2014-08-11
| ||
| 21:17 | [0c6b6284ff] part of check-in [e09448dc9d] Fix requirements marks in the file format document. Improvements to PRAGMA documentation. (check-in: [e09448dc9d] user: drh branch: trunk, size: 66135) | |
|
2014-08-07
| ||
| 13:22 | [f6fdb89fd9] part of check-in [430bf0b418] General documentation updates. Attempts to provide better links and improve wording for better readability. (check-in: [430bf0b418] user: drh branch: trunk, size: 66108) | |
|
2014-08-01
| ||
| 03:11 | [2862664aa4] part of check-in [6b17e6415e] Enhance the documentation on PRAGMA integrity_check to match recent implementation enhancements. Add the enhancements to PRAGMA integrity_check to the change log. (check-in: [6b17e6415e] user: drh branch: trunk, size: 66121) | |
|
2014-07-18
| ||
| 19:06 | [e9641e30e3] part of check-in [306698cb1d] Clarify that PRAGMA wal_autocheckpoint always causes a PASSIVE checkpoint. Provide clearer definitions for PASSIVE, FULL, and RESET checkpoints. (check-in: [306698cb1d] user: drh branch: trunk, size: 65696) | |
|
2014-04-01
| ||
| 15:02 | [30fad7b709] part of check-in [0bbad9c76b] Strengthen the disclaimers on the "speed.html" page and on the "PRAGMA stats" documentation. (check-in: [0bbad9c76b] user: drh branch: trunk, size: 64174) | |
|
2014-01-23
| ||
| 15:25 | [bcaedf16ea] part of check-in [87e7eb3d0d] Recursive syntax diagram display. (check-in: [87e7eb3d0d] user: drh branch: trunk, size: 63589) | |
|
2013-11-18
| ||
| 18:48 | [6ab66ad425] part of check-in [b8e6ac4ce4] Fix documentation typos pointed out on the mailing list by Philip Newton. (check-in: [b8e6ac4ce4] user: drh branch: trunk, size: 63594) | |
|
2013-10-17
| ||
| 12:54 | [0612560621] part of check-in [ca4b03a1f2] Add news for the 3.8.1 release. Other final documentation tweaks prior to release. (check-in: [ca4b03a1f2] user: drh branch: trunk, size: 63591) | |
|
2013-10-12
| ||
| 20:43 | [cea63f10f2] part of check-in [d585c58e71] Update the change log and the pragma documentation to reflect restoring PRAGMA index_list to its old behavior. (check-in: [d585c58e71] user: drh branch: trunk, size: 63441) | |
| 13:10 | [2b09af1957] part of check-in [651b3720a7] Fix the PRAGMA defer_foreign_keys documentation to explain that deferral is disabled whenever a transaction completes. (check-in: [651b3720a7] user: drh branch: trunk, size: 63194) | |
|
2013-10-11
| ||
| 20:16 | [c963f5fb5a] part of check-in [77dee5dcd0] Improve the text (rephrasing, not changing the meaning) of some requirements related to functions and pragmas. Improve or correct requirements marks. (check-in: [77dee5dcd0] user: drh branch: trunk, size: 63001) | |
|
2013-09-13
| ||
| 22:03 | [102be27b31] part of check-in [dc4eae98aa] Add documentation for unlikely(), likelihood() and the soft_heap_limit pragma. (check-in: [dc4eae98aa] user: drh branch: trunk, size: 62734) | |
|
2013-08-23
| ||
| 01:57 | [9b66f9d608] part of check-in [8e16497ef1] Add documentation for the query_only and defer_foreign_keys pragmas. Update the change log for the 3.8.0 release. (check-in: [8e16497ef1] user: drh branch: trunk, size: 62308) | |
|
2013-08-20
| ||
| 17:06 | [003e39d6f5] part of check-in [4bfef7edb7] Fix typos in the cache_spill pragma documentation. (check-in: [4bfef7edb7] user: drh branch: trunk, size: 61334) | |
|
2013-08-17
| ||
| 17:56 | [9fc2ceefe6] part of check-in [74740a2d9e] Add documentation for the cache_spill pragma. (check-in: [74740a2d9e] user: drh branch: trunk, size: 61335) | |
|
2013-08-02
| ||
| 23:41 | [7a045b50b5] part of check-in [498cd0709e] Updates to requirements marks. (check-in: [498cd0709e] user: drh branch: trunk, size: 60502) | |
|
2013-07-01
| ||
| 16:07 | [763b5372a1] part of check-in [641e107a66] Lots of tweaking and enhancements to the documentation, especially regarding the query planner and ways of controlling the query planner. (check-in: [641e107a66] user: drh branch: trunk, size: 60494) | |
|
2013-05-23
| ||
| 11:48 | [d2150181ff] part of check-in [a577a4e618] Update the documentation for PRAGMA mmap_size to explain that it can sometimes be a no-op. (check-in: [a577a4e618] user: drh branch: trunk, size: 60417) | |
|
2013-05-03
| ||
| 15:43 | [5588172951] part of check-in [0d800b73f2] Add documentation for the Application ID. Add a proposed release date for 3.7.17. (check-in: [0d800b73f2] user: drh branch: trunk, size: 60013) | |
|
2013-05-01
| ||
| 11:51 | [cf3d929e0f] part of check-in [76230867ab] Fix a broken hyperlink in the pragma.html page. (check-in: [76230867ab] user: drh branch: trunk, size: 59204) | |
|
2013-04-15
| ||
| 17:13 | [0b98a1adfb] part of check-in [1e3f82a26e] Merge in the changes for 3.7.16.2. Update documentation for the mmap_size refactoring. (check-in: [1e3f82a26e] user: drh branch: trunk, size: 59179) | |
|
2013-04-08
| ||
| 02:12 | [addb83669a] part of check-in [4dd308afff] Initial documentation updates for mmap_limit. (check-in: [4dd308afff] user: drh branch: trunk, size: 58858) | |
|
2013-03-19
| ||
| 20:00 | [911f976a61] part of check-in [72af2c4df1] Improved documentation for PRAGMA foreign_key_check and foreign_key_list. (check-in: [72af2c4df1] user: drh branch: trunk, size: 57650) | |
|
2013-03-13
| ||
| 17:11 | [1439c0c75c] part of check-in [d29bab5808] Documentation updates and typo fixes in preparation for the next release. (check-in: [d29bab5808] user: drh branch: trunk, size: 57289) | |
|
2013-03-03
| ||
| 00:19 | [a64f20c851] part of check-in [556fe1bb34] Fix a typo on the pragma documentation. (check-in: [556fe1bb34] user: drh branch: trunk, size: 57296) | |
|
2013-03-02
| ||
| 17:37 | [dc33a60fbc] part of check-in [92f6694092] Add a backwards compatibility note on the documentation of cache_size and its behavior when N is negative. (check-in: [92f6694092] user: drh branch: trunk, size: 57299) | |
|
2013-02-15
| ||
| 15:18 | [e5566b2da9] part of check-in [ba9b0b1040] Update the change log and pragma documentation for 3.7.16. (check-in: [ba9b0b1040] user: drh branch: trunk, size: 57045) | |
| 00:48 | [7cf8b367c9] part of check-in [685a544f00] Begin making documentation changes for the 3.7.16 release. (check-in: [685a544f00] user: drh branch: trunk, size: 56908) | |
|
2012-12-11
| ||
| 19:43 | [7f2367387d] part of check-in [5081393990] Fix a typo in the requirements marks for "PRAGMA busy_timeout". (check-in: [5081393990] user: drh branch: trunk, size: 55094) | |
|
2012-10-15
| ||
| 06:10 | [9ef06c8b9d] part of check-in [4eade435df] Fix typo in the description of PRAGMA journal_mode. (check-in: [4eade435df] user: mistachkin branch: trunk, size: 55088) | |
|
2012-10-09
| ||
| 16:18 | [274c677d64] part of check-in [7417675f15] Add documentation of recent changes. (check-in: [7417675f15] user: drh branch: trunk, size: 55090) | |
|
2012-09-11
| ||
| 11:04 | [447f07b090] part of check-in [58cdffdea5] Add information on the values returned by the wal_checkpoint pragma. (check-in: [58cdffdea5] user: drh branch: trunk, size: 54655) | |
|
2012-06-07
| ||
| 16:30 | [50a7f38d66] part of check-in [45f3811cfd] Updates in preparation for 3.7.13. (check-in: [45f3811cfd] user: drh branch: trunk, size: 53700) | |
|
2012-02-23
| ||
| 14:40 | [8711eb279d] part of check-in [cf86dcee73] 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 branch: trunk, size: 52612) | |
|
2012-01-02
| ||
| 15:48 | [87f868efca] part of check-in [47c781b488] 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 branch: trunk, size: 52364) | |
|
2011-12-23
| ||
| 20:32 | [f4c8b31bcd] part of check-in [38fb9e5380] Add the psow.html document describing powersafe overwrite. (check-in: [38fb9e5380] user: drh branch: trunk, size: 52225) | |
|
2011-11-30
| ||
| 18:46 | [b302956753] part of check-in [be40d822e3] Improvements to journal_size_limit documentation. (check-in: [be40d822e3] user: drh branch: trunk, size: 51935) | |
|
2011-11-17
| ||
| 18:03 | [5e1402cd41] part of check-in [4643d06dfe] Update the "changes" log for the next release. Fix all hyperlinks. (check-in: [4643d06dfe] user: drh branch: trunk, size: 51357) | |
|
2011-06-20
| ||
| 21:48 | [e80554fd92] part of check-in [b503d1f516] Documentation typos. (check-in: [b503d1f516] user: drh branch: trunk, size: 51120) | |
| 20:27 | [127cedfd3f] part of check-in [46855636fa] Update the compile-time options. (check-in: [46855636fa] user: drh branch: trunk, size: 51121) | |
|
2011-05-23
| ||
| 19:04 | [8744cce673] part of check-in [e63c0ce4fb] Edits to the VFS documentation. Better cross-referencing to VFS. (check-in: [e63c0ce4fb] user: drh branch: trunk, size: 51047) | |
|
2011-05-11
| ||
| 19:01 | [42dfdd5566] part of check-in [66c5bcbaf8] 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. (check-in: [66c5bcbaf8] user: drh branch: trunk, size: 51045) | |
|
2011-04-07
| ||
| 11:14 | [1c40acebcf] part of check-in [486f3e085d] Fix a typo in pragma.html. "RESTART" is a valid parameter to use with "PRAGMA wal_checkpoint", not "RESET". (check-in: [486f3e085d] user: dan branch: trunk, size: 51095) | |
|
2011-02-10
| ||
| 20:25 | [7e92b94d57] part of check-in [aefb07aa90] Update pragma documentation to describe the parameters to the wal_checkpoint pragma that follow from the addition of sqlite3_wal_checkpoint_v2(). (check-in: [aefb07aa90] user: drh branch: trunk, size: 51093) | |
|
2011-01-13
| ||
| 16:09 | [deb552eda2] part of check-in [bd64b1f2ab] Fix typo in the pragma documentation: dartbase to database. (check-in: [bd64b1f2ab] user: drh branch: trunk, size: 50657) | |
|
2011-01-12
| ||
| 22:22 | [aff8818e81] part of check-in [1927e7c245] Fix documentation typo pointed out on the mailing list. (check-in: [1927e7c245] user: drh branch: trunk, size: 50657) | |
|
2010-12-16
| ||
| 17:19 | [321d22f1b2] part of check-in [78d484e889] Fix a detail of the case_sensitive_like pragma documentation to more accurately describe what really happens. (check-in: [78d484e889] user: drh branch: trunk, size: 50658) | |
|
2010-12-09
| ||
| 18:56 | [da312b0c3d] part of check-in [140df585c3] Add documentation for the SQLITE_DEFAULT_WAL_AUTOCHECKPOINT compile-time option. Other updates to PRAGMA documentation. (check-in: [140df585c3] user: drh branch: trunk, size: 50548) | |
|
2010-12-08
| ||
| 21:13 | [6b91d531a7] part of check-in [d399230aae] 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. (check-in: [d399230aae] user: drh branch: trunk, size: 50654) | |
|
2010-12-01
| ||
| 12:57 | [0e122f3960] part of check-in [517974ad50] Fix a requirement mark in the pragma documentation. (check-in: [517974ad50] user: drh branch: trunk, size: 50802) | |
|
2010-11-26
| ||
| 21:06 | [1c4a6c34be] part of check-in [b8865a0011] Updates to the FTS3 documentation to include additional discussion and links to FTS4 concepts. (check-in: [b8865a0011] user: drh branch: trunk, size: 50802) | |
| 15:18 | [61076654a2] part of check-in [e3dca045a2] Further updates to pragma documentation. Mark deprecated pragmas as such. Tag pragmas used for debugging only. (check-in: [e3dca045a2] user: drh branch: trunk, size: 50800) | |
|
2010-11-23
| ||
| 15:57 | [e5ae2f5cfa] part of check-in [b5201ace8f] Updates to the PRAGMA documentation. (check-in: [b5201ace8f] user: drh branch: trunk, size: 48195) | |
|
2010-11-21
| ||
| 01:36 | [82128b7dc0] part of check-in [2d231c8139] Updates to documentation on date/time functions and pragmas. (check-in: [2d231c8139] user: drh branch: trunk, size: 48137) | |
|
2010-11-20
| ||
| 01:45 | [cce9db92ba] part of check-in [3ae5d72cbd] Improved sync pragma documentation. (check-in: [3ae5d72cbd] user: drh branch: trunk, size: 47845) | |
|
2010-11-18
| ||
| 20:42 | [1c55080f4d] part of check-in [8c4c6ab123] Fix a typo in the PRAGMA auto_vacuum documentation. (check-in: [8c4c6ab123] user: drh branch: trunk, size: 46690) | |
|
2010-11-03
| ||
| 01:22 | [ed0721f743] part of check-in [8ff1145035] Updates to PRAGMA locking_mode and WAL documentation. (check-in: [8ff1145035] user: drh branch: trunk, size: 46670) | |
|
2010-11-02
| ||
| 14:46 | [2d572ada8b] part of check-in [0aa0be4de5] Documentation of the WAL in EXCLUSIVE locking-mode changes. (check-in: [0aa0be4de5] user: drh branch: trunk, size: 46270) | |
|
2010-10-06
| ||
| 12:23 | [6394acbb41] part of check-in [d009514359] Update the change documentation for the 3.7.3 release. Fixes to the description of the index_info pragma. (check-in: [d009514359] user: drh branch: trunk, size: 46114) | |
|
2010-08-30
| ||
| 15:10 | [2413bb8a0c] part of check-in [d7a2085524] More typo and spelling fixes. (check-in: [d7a2085524] user: shaneh branch: trunk, size: 45880) | |
|
2010-08-28
| ||
| 05:48 | [e03bb046eb] part of check-in [78fe166463] Fix documentation typos. (check-in: [78fe166463] user: shaneh branch: trunk, size: 45879) | |
|
2010-08-23
| ||
| 22:51 | [89e2a1544b] part of check-in [7bf266483d] Preparation for the 3.7.2 release. (check-in: [7bf266483d] user: drh branch: trunk, size: 45879) | |
|
2010-08-21
| ||
| 19:11 | [e02cf16662] part of check-in [fb2b8b097b] Preparations for the 3.7.1 release. (check-in: [fb2b8b097b] user: drh branch: trunk, size: 46429) | |
|
2010-08-09
| ||
| 15:45 | [b9caa40c51] part of check-in [d9e242f92a] Fix a bunch of documentation typos reported on the mailing list. (check-in: [d9e242f92a] user: drh branch: trunk, size: 46505) | |
|
2010-07-13
| ||
| 14:50 | [575a65d033] part of check-in [40fa307f4e] Fix a typo on the temp_store_directory pragma documentation. (check-in: [40fa307f4e] user: drh branch: trunk, size: 46502) | |
|
2010-07-08
| ||
| 18:12 | [9520310b89] part of check-in [b1e171c029] Update PRAGMA journal_mode documentation. Fix typos in the wal.html document. (check-in: [b1e171c029] user: drh branch: trunk, size: 46501) | |
|
2010-06-15
| ||
| 12:07 | [48a67133b4] part of check-in [9f38773d3b] Updates to WAL documentation. (check-in: [9f38773d3b] user: drh branch: trunk, size: 46506) | |
|
2010-05-07
| ||
| 02:46 | [3a74eab1c0] part of check-in [f1676af6d8] Add the new Kreibich book. Add preliminary documentation on WAL pragmas. Refactor the pragma.html document. (check-in: [f1676af6d8] user: drh branch: trunk, size: 46599) | |
|
2010-05-06
| ||
| 23:48 | [daa4854714] part of check-in [019b60379f] Minor edits on the way toward 3.7.0 documentation. The wal.html document is created but is still mostly just a stub. (check-in: [019b60379f] user: drh branch: trunk, size: 45290) | |
|
2010-04-12
| ||
| 13:57 | [8edea416aa] part of check-in [906016ee92] Add initial automatic indexing documentation. (check-in: [906016ee92] user: drh branch: trunk, size: 45057) | |
|
2010-02-26
| ||
| 15:39 | [3092f6d8a0] part of check-in [4d3f01f58b] Add documentation for sqlite3_compileoption_get() and related routines and pragmas. Fix up hyperlinks. (check-in: [4d3f01f58b] user: drh branch: trunk, size: 44563) | |
|
2010-02-13
| ||
| 15:43 | [be08fab27d] part of check-in [9523519a73] Correction to the PRAGMA secure_delete documentation. (check-in: [9523519a73] user: drh branch: trunk, size: 44168) | |
|
2010-02-12
| ||
| 19:58 | [cbdf8522f6] part of check-in [e4d2cd7fd1] Update the secure_delete pragma documentation to conform to the latest implementation. (check-in: [e4d2cd7fd1] user: drh branch: trunk, size: 44589) | |
| 18:34 | [596fca76d1] part of check-in [ae2879358d] Update the documentation to include information about the new secure_delete pragma. (check-in: [ae2879358d] user: drh branch: trunk, size: 44426) | |
|
2009-12-15
| ||
| 00:29 | [b109001f28] part of check-in [a900d49554] Add requirements markings to the pragma documentation. (check-in: [a900d49554] user: drh branch: trunk, size: 43179) | |
|
2009-11-14
| ||
| 17:00 | [63fe5ed5a5] part of check-in [a802dbe3fb] Be sure to mention that PRAGMA foreign_keys is a no-op within a transaction. (check-in: [a802dbe3fb] user: drh branch: trunk, size: 43015) | |
|
2009-11-02
| ||
| 15:50 | [043a432a0b] part of check-in [ec4a51db99] Added the website keyword index. (check-in: [ec4a51db99] user: drh branch: trunk, size: 42831) | |
|
2009-10-22
| ||
| 17:53 | [7b9e9b5019] part of check-in [687a957242] Updates to pragma and optimizer documents. Add the evidence formatter and make corresponding revisions to the tracability matrix generator. (check-in: [687a957242] user: drh branch: trunk, size: 42830) | |
|
2009-10-20
| ||
| 13:48 | [69cfdba760] part of check-in [6498c96895] 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. (check-in: [6498c96895] user: drh branch: trunk, size: 42687) | |
|
2009-10-14
| ||
| 02:43 | [00d354e3fe] part of check-in [9598affd43] Documentation updates prior to the release of version 3.6.19. (check-in: [9598affd43] user: drh branch: trunk, size: 42556) | |
|
2009-10-07
| ||
| 10:45 | [23dfe938ac] part of check-in [52421d8609] Update the description of the "PRAGMA count_changes" command to describe the way changes made by foreign key actions are handled. (check-in: [52421d8609] user: dan branch: trunk, size: 42217) | |
| 01:15 | [c00eb9ee2a] part of check-in [365401b552] Add "See also:" annotations to the syntaxdiagrams.html page. Fix a quoting mistake on pragma.html. (check-in: [365401b552] user: drh branch: trunk, size: 42152) | |
|
2009-10-02
| ||
| 05:48 | [812914af56] part of check-in [bdc6c4820c] 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. (check-in: [bdc6c4820c] user: dan branch: trunk, size: 42150) | |
|
2009-09-22
| ||
| 15:32 | [fb77cd8d72] part of check-in [bdfaef8a63] Add documentation for the foreign_keys pragma. Fix broken hyperlinks in the new foreign key constraints document. (check-in: [bdfaef8a63] user: drh branch: trunk, size: 41746) | |
|
2009-09-09
| ||
| 17:04 | [ab565481db] part of check-in [00a2203dba] Fix a typo in the recursive_triggers pragma documentation. (check-in: [00a2203dba] user: drh branch: trunk, size: 41379) | |
|
2009-09-07
| ||
| 18:27 | [8d0b49f070] part of check-in [df753f0371] Add documentation of SQLITE_MAX_TRIGGER_DEPTH. (check-in: [df753f0371] user: drh branch: trunk, size: 41379) | |
|
2009-06-09
| ||
| 00:55 | [ab48df2001] part of check-in [787c316f3f] Correct the description on how short_column_names and full_column_names interact. (check-in: [787c316f3f] user: drh branch: trunk, size: 40430) | |
|
2009-04-29
| ||
| 14:33 | [ad7535df49] part of check-in [1179f9425f] Update trigger documentation. (check-in: [1179f9425f] user: drh branch: trunk, size: 40488) | |
|
2009-04-20
| ||
| 17:43 | [09952ddc00] part of check-in [8bb233e0af] Update documentation to describe how pragma journal_mode will work as long as there is no pending transaction. (check-in: [8bb233e0af] user: drh branch: trunk, size: 40233) | |
| 13:29 | [db9399ddf5] part of check-in [3a4c37b08b] Update the documentation to explain that the journal_mode must be set prior to the first transaction. CVSTrac ticket #3811. (check-in: [3a4c37b08b] user: drh branch: trunk, size: 40705) | |
|
2009-04-06
| ||
| 18:51 | [f08bd59866] part of check-in [db4897a3dd] Add documentation for the collation_list pragma. (check-in: [db4897a3dd] user: drh branch: trunk, size: 39911) | |
| 16:42 | [1164634d75] part of check-in [a84577d9a2] Updates to the PRAGMA documentation. (check-in: [a84577d9a2] user: drh branch: trunk, size: 39684) | |
|
2009-04-03
| ||
| 01:44 | [f3fd02561a] part of check-in [36a68629e1] Updates, clarifications, and corrections to the pragma documentation. (check-in: [36a68629e1] user: drh branch: trunk, size: 39200) | |
|
2009-04-02
| ||
| 20:17 | [1d20838f45] part of check-in [ae7cc4efbb] Improvements and clarifications to the auto_vacuum pragma documentation. (check-in: [ae7cc4efbb] user: drh branch: trunk, size: 38649) | |
|
2009-03-27
| ||
| 15:12 | [1ede413b98] part of check-in [e96456b379] Make it clear that the case_sensitive_like pragma installs a new application-defined LIKE function. (check-in: [e96456b379] user: drh branch: trunk, size: 37990) | |
|
2009-03-04
| ||
| 12:20 | [4bbaa0bfb1] part of check-in [67c02fcc03] Fix spelling of precede and preceding in a few places. Cvs ticket 3700. (check-in: [67c02fcc03] user: dan branch: trunk, size: 37948) | |
|
2009-02-23
| ||
| 17:59 | [d129929d00] part of check-in [06452075a4] Add documentaion on the reverse_unordered_selects pragma. (check-in: [06452075a4] user: drh branch: trunk, size: 37948) | |
|
2009-02-13
| ||
| 15:09 | [8f4d1ec503] part of check-in [1762225ee3] Additional hyperlinks associated with shared cache mode and limits. (check-in: [1762225ee3] user: drh branch: trunk, size: 36679) | |
|
2009-02-05
| ||
| 02:33 | [76b41988a2] part of check-in [c8dc1e13d7] Enhancements to the SQL language documentation. (check-in: [c8dc1e13d7] user: drh branch: trunk, size: 36193) | |
|
2009-01-14
| ||
| 06:51 | [a0e6868691] part of check-in [0fec42b940] Fix minor typo in pragma.html. (check-in: [0fec42b940] user: dan branch: trunk, size: 36136) | |
|
2008-11-10
| ||
| 16:50 | [46a65abd89] part of check-in [1a29400b8f] Various typos, etc. fixed; Improved consistency; Added more links for for omit options; (check-in: [1a29400b8f] user: shaneh branch: trunk, size: 36127) | |
|
2008-10-28
| ||
| 21:26 | [c081b7b806] part of check-in [cd968e8e43] Update documentation to describe recent changes on the truncate optimization and on memory allocation. (check-in: [cd968e8e43] user: drh branch: trunk, size: 36119) | |
| 18:03 | [0d1dcca2a1] part of check-in [4ea1044b9b] Add documentation on the journal_mode=MEMORY pragma. (check-in: [4ea1044b9b] user: drh branch: trunk, size: 36570) | |
|
2008-10-22
| ||
| 17:59 | [4862d39492] part of check-in [0d4b98a77d] Remove a misleading statement regarding shared-cache mode from pragma.html. (check-in: [0d4b98a77d] user: dan branch: trunk, size: 36162) | |
|
2008-10-10
| ||
| 23:47 | [afd0c99d3e] part of check-in [0e3d036dea] Add documentation on the SQLITE_OMIT_TRUNCATE_OPTIMIZATION compile-time option. (check-in: [0e3d036dea] user: drh branch: trunk, size: 36228) | |
|
2008-10-09
| ||
| 15:47 | [735412ce8e] part of check-in [262c3af24e] Fix the syntax diagram for PRAGMA. Other documentation updates. (check-in: [262c3af24e] user: drh branch: trunk, size: 35601) | |
|
2008-10-03
| ||
| 00:56 | [00e0b286b1] part of check-in [289df32643] 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. (check-in: [289df32643] user: drh branch: trunk, size: 35635) | |
|
2008-10-02
| ||
| 18:04 | [cb2fe6df3c] part of check-in [c1cdac9b55] Replace BNF with bubble diagrams in the language definition pages. Still a lot of text to update. (check-in: [c1cdac9b55] user: drh branch: trunk, size: 35715) | |
|
2008-09-26
| ||
| 21:38 | [7a565673b2] part of check-in [715819ca53] Add documentation on the TRUNCATE journal mode. (check-in: [715819ca53] user: drh branch: trunk, size: 35741) | |
|
2008-07-04
| ||
| 13:40 | [f3f1518070] part of check-in [bd71688bcb] Fixed typo in PRAGMA documentation. (check-in: [bd71688bcb] user: mihailim branch: trunk, size: 35446) | |
|
2008-06-26
| ||
| 15:46 | [9fecd5b66b] part of check-in [daaf0b565e] Continuing work on the compile-time options document. This is an incremental check-in. (check-in: [daaf0b565e] user: drh branch: trunk, size: 35445) | |
| 02:52 | [565633bfd3] part of check-in [3cb62833af] Updates to the documents in perparation for 3.6.0. (check-in: [3cb62833af] user: drh branch: trunk, size: 35290) | |
|
2008-06-11
| ||
| 13:22 | [f579205e72] part of check-in [571ec9cab5] Fix an unresolved hyperlink in the pragma.html documentation. (check-in: [571ec9cab5] user: drh branch: trunk, size: 35272) | |
|
2008-06-05
| ||
| 17:03 | [d51d638f31] part of check-in [f814d9bff5] Add documentation for new pragma "journal_size_limit". (check-in: [f814d9bff5] user: dan branch: trunk, size: 35263) | |
|
2008-05-16
| ||
| 05:00 | [8185493913] part of check-in [120c7812dd] Add the new page_count pragma to pragma.in. (check-in: [120c7812dd] user: dan branch: trunk, size: 33492) | |
|
2008-04-29
| ||
| 13:18 | [e883ed47b1] part of check-in [c4bd8f4f26] Use SQLITE_DEFAULT_PAGE_SIZE instead of 1024 in the page size algorithm. (check-in: [c4bd8f4f26] user: drh branch: trunk, size: 33331) | |
| 13:10 | [eb7f9a1c7c] part of check-in [bc47f60abd] Add details to the page_size pragma, including specification of the page size selection algorithm. (check-in: [bc47f60abd] user: drh branch: trunk, size: 33263) | |
|
2008-04-25
| ||
| 02:42 | [02d90aa787] part of check-in [a192161bbc] 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. (check-in: [a192161bbc] user: drh branch: trunk, size: 31609) | |
|
2008-04-21
| ||
| 19:14 | [f86ae51ba0] part of check-in [85d1df2512] Add documentation on the journal_mode pragma and the new tempfiles.html document. (check-in: [85d1df2512] user: drh branch: trunk, size: 31608) | |
|
2007-12-20
| ||
| 23:01 | [8f4c5cd7df] part of check-in [aa8a072b1b] Additional work toward denser hyperlinking in the documentation. (check-in: [aa8a072b1b] user: drh branch: trunk, size: 29023) | |
| 03:29 | [4566da8b1f] part of check-in [16b1f03012] An attempt to get automatic hyperlinking working on all web pages. The website builds, but there are still many problems. (check-in: [16b1f03012] user: drh branch: trunk, size: 29425) | |
|
2007-11-27
| ||
| 23:36 | [0c4f1e4297] part of check-in [84748f6b9b] 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. (check-in: [84748f6b9b] user: drh branch: trunk, size: 29416) | |
|
2007-11-14
| ||
| 03:14 | [4248fe5bac] part of check-in [c3a14fe2c7] Changes capi3ref.html references to c3ref/ pages everywhere. (check-in: [c3a14fe2c7] user: drh branch: trunk, size: 29162) | |
|
2007-11-12
| ||
| 15:32 | Added: [38ba8c81d7] part of check-in [275febef8f] Complete reorganization of the documentation sources. (check-in: [275febef8f] user: drh branch: trunk, size: 29173) | |