Search SQLite Documentation

(lang_altertable.html)

... Beginning with version 3.26.0, FOREIGN KEY constraints are always converted when a table is renamed, unless the PRAGMA legacy_alter_table=ON setting is engaged. The following table summarizes the difference: PRAGMA foreign_keys PRAGMA legacy_alter_table Parent Table references are updated ...

C API: Standard File Control Opcodes

(c3ref/c_fcntl_begin_atomic_write.html)

SQLITE_FCNTL_LOCKSTATE, SQLITE_FCNTL_GET_LOCKPROXYFILE, SQLITE_FCNTL_SET_LOCKPROXYFILE, SQLITE_FCNTL_LAST_ERRNO, SQLITE_FCNTL_SIZE_HINT, SQLITE_FCNTL_CHUNK_SIZE ...

... Whenever a PRAGMA statement is parsed, an SQLITE_FCNTL_PRAGMA file control is sent to the open sqlite3_file object corresponding to the database file to which the pragma statement refers. The argument to the SQLITE_FCNTL_PRAGMA file control is an array of pointers ...

List of SQLite Syntax Diagrams

(syntax.html)

... indexed-column insert-stmt join-clause join-constraint join-operator literal-value numeric-literal ordering-term over-clause pragma-stmt pragma-value qualified-table-name raise-function recursive-cte reindex-stmt release-stmt result-column returning-clause rollback-stmt savepoint ...

Temporary Files Used By SQLite

(tempfiles.html)

3. The SQLITE_TEMP_STORE Compile-Time Parameter and Pragma ... Temporary files are always stored on disk regardless of the setting of the temp_store pragma. Temporary files are stored on disk by default but this can be overridden by the temp_store pragma. Temporary files are stored in memory by default ...

Memory-Mapped I/O

(mmap.html)

... To activate memory-mapped I/O, use the mmap_size pragma and set the mmap_size to some large number, usually 256MB or larger, depending on how much address space your application can spare. The rest is automatic. The PRAGMA mmap_size statement ...

Isolation In SQLite

(isolation.html)

... The previous paragraph is also true (separate database connections are isolated from one another) in shared cache mode as long as the read_uncommitted pragma remains turned off. The read_uncommitted pragma is off by default and so if the application does ...

STRICT Tables

(stricttables.html)

4.1. Accessing STRICT tables in earlier versions of SQLite Because of a quirk in the SQL language parser, versions of SQLite prior to 3.37.0 can still read and write STRICT tables if they set "PRAGMA writable_schema=ON" immediately after opening the database file, prior to doing anything ...

Invalid UTF Policy

(invalidutf.html)

3. Best effort to preserve text ... For example, if you insert some UTF-16LE with invalid surrogates into a TEXT column of a table of a database that has PRAGMA encoding=UTF16LE, then later query that column using sqlite3_column_text16(), you will probably get back the same ...

Compile-time Options

(compile.html)

9. Options To Omit Features ... This includes sqlite3_aggregate_count(), sqlite3_expired(), sqlite3_transfer_bindings(), sqlite3_global_recover(), sqlite3_thread_cleanup() and sqlite3_memory_alarm() interfaces and PRAGMA statements PRAGMA count_changes, PRAGMA data_store_directory, PRAGMA default_cache_size, PRAGMA empty_result_callbacks, PRAGMA full_column_names, PRAGMA short_column_names, and PRAGMA temp_store_directory. SQLITE_OMIT_DESERIALIZE This option causes the sqlite3_serialize() and sqlite3_deserialize() interfaces to be omitted ...

The dbhash.exe Utility Program

(dbhash.html)

1. Overview ... VACUUM PRAGMA page_size PRAGMA journal_mode REINDEX ANALYZE copied via the backup API ... and so forth The operations above can potentially cause vast changes the raw database file, and hence cause very different SHA1 hashes at the file level. But since ...