The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... set and either reg(P1) or
reg(P3) is NULL then the take the jump. If the SQLITE_JUMPIFNULL
bit is clear then fall through if either operand is NULL.
The SQLITE_AFF_MASK portion of P5 must be an affinity character -
SQLITE_AFF_TEXT ...
|
The Advantages Of Flexible Typing
(flextypegood.html)
3.5. Data typename cross-compatibility
Every SQL database engine seems to have its own unique set of supported
datatype names:
BIGINT
UNSIGNED SMALL INT
TEXT
VARCHAR
VARYING CHARACTER
NATIONAL VARYING CHARACTER
NVARCHAR
JSON
REAL
FLOAT
DOUBLE PRECISION
... and so forth ...
The fact that SQLite will ...
|
WAL-mode File Format
(walformat.html)
1.3. The Wal-Index or "-shm" file
... Because the shm is only used to coordinate access between concurrent
clients, the shm file is omitted if exclusive locking mode
is set, as an optimization. When exclusive locking mode is set,
SQLite uses heap memory in place of the ...
|
The Tcl interface to the SQLite library
(tclsqlite.html)
... dbcmd cache size N
This sets the maximum number of statements that can be cached.
The upper limit is 100. The default is 10. If you set the cache size
to 0, no caching is done ...
|
SQLite Older News
(oldnews.html)
... The fix is a 4-character
edit to a single line of code. Other than this 4-character change and
the update of the version number, nothing has changed from
version 3.7.15.1.
2012-12-19 - Release 3 ...
|
Pragma statements supported by SQLite
(pragma.html)
... When querying the value of a setting, many pragmas return the number
rather than the keyword.
A pragma may have an optional schema-name
before the pragma name.
The schema-name is the name of an ATTACH-ed database
or ...
|
Quality Management
(qmplan.html)
... The set of checklist items for release checklist is potentially
updated for each release. The content and complete
history of each release checklist are retained for the historical
record.
5. Software Configuration Management
5.1. Version Control
SQLite source code ...
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.21. The xShadowName Method
... The xShadowName method returns true when its input is the part
of the table name past the last "_" character.
If SQLite recognizes a table as a shadow table, and if the
SQLITE_DBCONFIG_DEFENSIVE flag is set, then the shadow table ...
|
Date And Time Functions
(lang_datefunc.html)
... The 's' character at the end of the modifier names in 1 through 6 is optional.
The NNN value can be any floating point number, with an optional '+' or '-' prefix.
The time shift modifiers (7 through 13) move the time ...
|
Distinctive Features Of SQLite
(different.html)
... Programs that use SQLite require no administrative support
for setting up the database engine before they are run. Any program
that is able to access the disk is able to use an SQLite database.
On the other hand, a database ...
|
Page generated by FTS5 in about 52.73 ms.