Documentation Source Text

Check-in [cb850cf9a5]
Login

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

Overview
Comment:Add documentation for SQLITE_CONFIG_MEMDB_MAXSIZE.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: cb850cf9a57b1f8de2a19f2d484adba1f2f1198b3801f14eda5b5aba897e314e
User & Date: drh 2019-01-31 17:51:45.032
Context
2019-02-01
14:44
Fix a typo on the index page. (check-in: 139fa7c746 user: drh tags: trunk)
2019-01-31
17:51
Add documentation for SQLITE_CONFIG_MEMDB_MAXSIZE. (check-in: cb850cf9a5 user: drh tags: trunk)
2019-01-28
20:31
Updates to the change log for version 3.27.0. (check-in: 03bca65239 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
34
35
36
37
38
39
40
41


42
43
44
45
46
47
48
Use that option to prevent circular references to [shadow tables] from
causing resource leaks.
<li>Enhancements to the [sqlite3_deserialize()] interface:
<ol type="a">
<li> Add the [SQLITE_FCNTL_SIZE_LIMIT] [sqlite3_file_control|file-control] for
     setting an upper bound on the size of the in-memory database created
     by sqlite3_deserialize.  The default upper bound is 1GiB, or whatever
     alternative value is specified by [SQLITE_MEMDB_DEFAULT_MAXSIZE].


<li> Honor the [SQLITE_DESERIALIZE_READONLY] flag, which was previously described
     in the documentation, but was previously a no-op.
<li> Enhance the "deserialize" command of the [TCL Interface] to give it
     new "--maxsize N" and "--readonly BOOLEAN" options.
</ol>
<li>Enhancements to the [CLI], mostly to support testing and debugging
of the SQLite library itself:







|
>
>







34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Use that option to prevent circular references to [shadow tables] from
causing resource leaks.
<li>Enhancements to the [sqlite3_deserialize()] interface:
<ol type="a">
<li> Add the [SQLITE_FCNTL_SIZE_LIMIT] [sqlite3_file_control|file-control] for
     setting an upper bound on the size of the in-memory database created
     by sqlite3_deserialize.  The default upper bound is 1GiB, or whatever
     alternative value is specified by
     [sqlite3_config]([SQLITE_CONFIG_MEMDB_MAXSIZE])
     and/or [SQLITE_MEMDB_DEFAULT_MAXSIZE].
<li> Honor the [SQLITE_DESERIALIZE_READONLY] flag, which was previously described
     in the documentation, but was previously a no-op.
<li> Enhance the "deserialize" command of the [TCL Interface] to give it
     new "--maxsize N" and "--readonly BOOLEAN" options.
</ol>
<li>Enhancements to the [CLI], mostly to support testing and debugging
of the SQLite library itself:
Changes to pages/compile.in.
487
488
489
490
491
492
493


494
495
496
497
498
499
500
501
  [prepared statement] will use to aid with CPU-intensive computations
  (mostly sorting).  See also the [SQLITE_DEFAULT_WORKER_THREADS] options.
}

COMPILE_OPTION {SQLITE_MEMDB_DEFAULT_MAXSIZE=<i>N</i>} {
  Set the default size limit (in bytes) for in-memory databases created using
  [sqlite3_deserialize()].  This is just the default.  The limit can be


  changed at run-time for individual databases using the
  [SQLITE_FCNTL_SIZE_LIMIT] [sqlite3_file_control|file-control].
  If no default is specified, 1073741824 is used.
}

COMPILE_OPTION {SQLITE_MINIMUM_FILE_DESCRIPTOR=<i>N</i>} {
  The unix [VFS] will never use a file descriptor less than <i>N</i>.  The
  default value of <i>N</i> is 3.







>
>
|







487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
  [prepared statement] will use to aid with CPU-intensive computations
  (mostly sorting).  See also the [SQLITE_DEFAULT_WORKER_THREADS] options.
}

COMPILE_OPTION {SQLITE_MEMDB_DEFAULT_MAXSIZE=<i>N</i>} {
  Set the default size limit (in bytes) for in-memory databases created using
  [sqlite3_deserialize()].  This is just the default.  The limit can be
  changed at start-time using
  [sqlite3_config]([SQLITE_CONFIG_MEMDB_MAXSIZE],N)
  or at run-time for individual databases using the
  [SQLITE_FCNTL_SIZE_LIMIT] [sqlite3_file_control|file-control].
  If no default is specified, 1073741824 is used.
}

COMPILE_OPTION {SQLITE_MINIMUM_FILE_DESCRIPTOR=<i>N</i>} {
  The unix [VFS] will never use a file descriptor less than <i>N</i>.  The
  default value of <i>N</i> is 3.