Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Update documentation for SQLITE_DEFAULT_SYNCHRONOUS and related changes. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
ab3cf23c741925ec6b3db856437d9dfe |
User & Date: | drh 2016-03-08 16:42:57.521 |
Context
2016-03-08
| ||
17:23 | Correct and clarify the computation of local and overflow payload sizes in the file format documentation. (check-in: 9ec8b470d5 user: drh tags: trunk) | |
16:42 | Update documentation for SQLITE_DEFAULT_SYNCHRONOUS and related changes. (check-in: ab3cf23c74 user: drh tags: trunk) | |
13:15 | Clarifications in "PRAGMA synchronous". (check-in: 73e31a3096 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
36 37 38 39 40 41 42 43 44 45 46 47 48 49 | (currently 64KiB). Otherwise the journal is held in memory and no I/O occurs. <p><b>New Features:</b> <li>Added the [SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER] option to [sqlite3_db_config()] which allows the two-argument version of the [fts3_tokenizer()] SQL function to be enabled or disabled at run-time. <li>The [PRAGMA defer_foreign_keys=ON] statement now also disables [foreign key actions|RESTRICT actions] on foreign key. <p><b>Bug fixes:</b> <li>Make sure the [sqlite3_set_auxdata()] values from multiple triggers within a single statement do not interfere with one another. Fix for ticket [https://www.sqlite.org/src/info/dc9b1c91|dc9b1c91]. } chng {2016-03-03 (3.11.1)} { | > > > | 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 | (currently 64KiB). Otherwise the journal is held in memory and no I/O occurs. <p><b>New Features:</b> <li>Added the [SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER] option to [sqlite3_db_config()] which allows the two-argument version of the [fts3_tokenizer()] SQL function to be enabled or disabled at run-time. <li>The [PRAGMA defer_foreign_keys=ON] statement now also disables [foreign key actions|RESTRICT actions] on foreign key. <li>Added the [SQLITE_DEFAULT_SYNCHRONOUS] and [SQLITE_DEFAULT_WAL_SYNCHRONOUS] compile-time options. The [SQLITE_DEFAULT_SYNCHRONOUS] compile-time option replaces the [SQLITE_EXTRA_DURABLE] option, which is no longer supported. <p><b>Bug fixes:</b> <li>Make sure the [sqlite3_set_auxdata()] values from multiple triggers within a single statement do not interfere with one another. Fix for ticket [https://www.sqlite.org/src/info/dc9b1c91|dc9b1c91]. } chng {2016-03-03 (3.11.1)} { |
︙ | ︙ |
Changes to pages/compile.in.
︙ | ︙ | |||
228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 | COMPILE_OPTION {SQLITE_DEFAULT_PAGE_SIZE=<i><bytes></i>} { This macro is used to set the default page-size used when a database is created. The value assigned must be a power of 2. The default value is 4096. The compile-time default may be overridden at runtime by the [PRAGMA page_size] command. } COMPILE_OPTION {SQLITE_DEFAULT_WAL_AUTOCHECKPOINT=<i><pages></i>} { This macro sets the default page count for the [WAL] [checkpointing | automatic checkpointing] feature. If unspecified, the default page count is 1000. } COMPILE_OPTION {SQLITE_DEFAULT_WORKER_THREADS=<i>N</i>} { This macro sets the default value for the [SQLITE_LIMIT_WORKER_THREADS] parameter. The [SQLITE_LIMIT_WORKER_THREADS] parameter sets the maximum number of auxiliary threads that a single [prepared statement] will launch to assist it with a query. If not specified, the default maximum is 0. The value set here cannot be more than [SQLITE_MAX_WORKER_THREADS]. } COMPILE_OPTION {SQLITE_EXTRA_DURABLE} { | > > > > > > > > > > > > > > > > > > > > > > > > | | > > | 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 | COMPILE_OPTION {SQLITE_DEFAULT_PAGE_SIZE=<i><bytes></i>} { This macro is used to set the default page-size used when a database is created. The value assigned must be a power of 2. The default value is 4096. The compile-time default may be overridden at runtime by the [PRAGMA page_size] command. } COMPILE_OPTION {SQLITE_DEFAULT_SYNCHRONOUS=<i><0-3></i>} { This macro determines the default value of the [PRAGMA synchronous] setting. If not overridden at compile-time, the default setting is 2 (FULL). } COMPILE_OPTION {SQLITE_DEFAULT_WAL_SYNCHRONOUS=<i><0-3></i>} { This macro determines the default value of the [PRAGMA synchronous] setting for database files that open in [WAL mode]. If not overridden at compile-time, this value is the same as [SQLITE_DEFAULT_SYNCHRONOUS]. <p> If SQLITE_DEFAULT_WAL_SYNCHRONOUS differs from SQLITE_DEFAULT_SYNCHRONOUS, and if the application has not modified the synchronous setting for the database file using the [PRAGMA synchronous] statement, then the synchronous setting is changed to value defined by SQLITE_DEFAULT_WAL_SYNCHRONOUS when the database connection switches into WAL mode for the first time. If the SQLITE_DEFAULT_WAL_SYNCHRONOUS value is not overridden at compile-time, then it will always be the same as [SQLITE_DEFAULT_SYNCHRONOUS] and so no automatic synchronous setting changes will ever occur. } COMPILE_OPTION {SQLITE_DEFAULT_WAL_AUTOCHECKPOINT=<i><pages></i>} { This macro sets the default page count for the [WAL] [checkpointing | automatic checkpointing] feature. If unspecified, the default page count is 1000. } COMPILE_OPTION {SQLITE_DEFAULT_WORKER_THREADS=<i>N</i>} { This macro sets the default value for the [SQLITE_LIMIT_WORKER_THREADS] parameter. The [SQLITE_LIMIT_WORKER_THREADS] parameter sets the maximum number of auxiliary threads that a single [prepared statement] will launch to assist it with a query. If not specified, the default maximum is 0. The value set here cannot be more than [SQLITE_MAX_WORKER_THREADS]. } COMPILE_OPTION {SQLITE_EXTRA_DURABLE} { The SQLITE_EXTRA_DURABLE compile-time option that used to cause the default [PRAGMA synchronous] setting to be EXTRA, rather than FULL. This option is no longer supported. Use [SQLITE_DEFAULT_SYNCHRONOUS|SQLITE_DEFAULT_SYNCHRONOUS=3] instead. } COMPILE_OPTION {SQLITE_FTS3_MAX_EXPR_DEPTH=<i>N</i>} { This macro sets the maximum depth of the search tree that corresponds to the right-hand side of the MATCH operator in an [FTS3] or [FTS4] full-text index. The full-text search uses a recursive algorithm, so the depth of the tree is limited to prevent using too much stack space. The default |
︙ | ︙ |
Changes to pages/tempfiles.in.
︙ | ︙ | |||
250 251 252 253 254 255 256 | [WAL mode], individual database files are updated atomically across a power-loss, but in the case of a multi-file transactions, some files might rollback while others roll forward after power is restored. </p> | | > | 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 | [WAL mode], individual database files are updated atomically across a power-loss, but in the case of a multi-file transactions, some files might rollback while others roll forward after power is restored. </p> <tcl>hd_fragment stmtjrnl {statement journal} {statement journals} \ {Statement journals}</tcl> <h3>2.5 Statement Journal Files</h3> <p> A statement journal file is used to rollback partial results of a single statement within a larger transaction. For example, suppose an UPDATE statement will attempt to modify 100 rows in the database. But after modifying the first 50 rows, the UPDATE hits |
︙ | ︙ |