Small. Fast. Reliable.
Choose any three.
Choose any three.
|
EXPLAIN QUERY PLAN
(eqp.html)
1. The EXPLAIN QUERY PLAN Command
... command to turn automatic EXPLAIN QUERY PLAN mode back off.
EXPLAIN QUERY PLAN is most useful on a SELECT statement,
but may also appear with other statements that read data from database
tables (e.g. UPDATE, DELETE, INSERT INTO ... SELECT).
|
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
2. Differences From Ordinary Rowid Tables
... Hence, the update hook is not invoked when a WITHOUT ROWID table changes.
|
|
Dynamic Memory Allocation In SQLite
(malloc.html)
5. Stability Of Memory Interfaces
Update: As of SQLite version 3.7.0 (2010-07-21),
all of SQLite memory allocation interfaces
are considered stable and will be supported in future releases.
This page last modified on 2022-04-18 02:55:50 UTC
|
|
SQL Language Expressions
(lang_expr.html)
... A subquery that returns two or more columns is a row value
subquery and can only be used as an operand of a comparison operator or as
the value in an UPDATE SET clause whose column name list has the ...
|
|
Database File Format
(fileformat.html)
2.6.3. The sqlite_sequence table
... The sqlite_sequence.seq field is automatically updated if required when
new entries are inserted to an AUTOINCREMENT table.
The sqlite_sequence row for an AUTOINCREMENT table is automatically deleted
when the table is dropped.
If the sqlite_sequence row for an AUTOINCREMENT ...
|
|
Implementation Limits For SQLite
(limits.html)
... The number of columns in a table
The number of columns in an index
The number of columns in a view
The number of terms in the SET clause of an UPDATE statement
The number of columns in the result ...
|
|
The Advantages Of Flexible Typing
(flextypegood.html)
3.1. Attribute tables
... Flexible typing
of the "value" column makes the table conceptually simpler, more
space-efficient, and easier to access and update.
In the Fossil version control system, each
repository has a CONFIG table that is used to store all kinds of ...
|
|
The Virtual Database Engine of SQLite
(vdbe.html)
... The values of aggregate functions are updated by the instructions
between 11 and 21. Instructions 14 through 18 update memory
slot 1 to hold the next value "min(three+four)". Then the sum of the
"four" column is updated by ...
|
|
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 ...
... The SQLITE_FCNTL_CKPT_DONE opcode is invoked from within a checkpoint
in wal mode after the client has finished copying pages from the wal
file to the database file, but before the *-shm file is updated to
record the fact that the ...
|
|
Compile-time Options
(compile.html)
8. Options To Disable Features Normally Turned On
... SQLite typically attempts to sync the parent
directory when a file is deleted to ensure the directory
entries are updated immediately on disk.
SQLITE_DISABLE_FTS3_UNICODE
If this C-preprocessor macro is defined, the unicode61 tokenizer
in FTS3 is omitted from the ...
|
Page generated by FTS5 in about 134.41 ms.