WAL-mode File Format
(walformat.html)
2.1. The WAL-Index Header
... 13bigEndCksum
True if the WAL file uses big-ending checksums. 0 if the WAL
uses little-endian checksums.
14..15szPage
The database page size in bytes, or 1 if the page size is 65536.
16..19mxFrame
Number of valid and ...
|
Datatypes In SQLite
(datatype3.html)
2.1. Boolean Datatype
... Instead, Boolean values are stored as integers 0 (false) and 1 (true).
SQLite recognizes the keywords "TRUE" and "FALSE",
as of version 3.23.0 (2018-04-02) but those keywords are
really just alternative spellings for the integer literals ...
|
How To Corrupt An SQLite Database File
(howtocorrupt.html)
2.1. Filesystems with broken or missing lock implementations
... This is especially true of network filesystems and NFS in particular.
If SQLite is used on a filesystem where the locking primitives contain
bugs, and if two or more threads or processes try to access the same
database at the ...
|
SQLite Database Speed Comparison
(speed.html)
... It is true that
SQLite is not as fast at creating new index entries as the other engines
(see Test 6 below) but its overall speed is still better.
Test 4: 100 SELECTs without an index
BEGIN;
SELECT count(*), avg ...
|
C API: Configuration Options
(c3ref/c_config_covering_index_scan.html)
SQLITE_CONFIG_SINGLETHREAD, SQLITE_CONFIG_MULTITHREAD, SQLITE_CONFIG_SERIALIZED, SQLITE_CONFIG_MALLOC, SQLITE_CONFIG_GETMALLOC, SQLITE_CONFIG_SCRATCH ...
... SQLITE_CONFIG_SMALL_MALLOC
The SQLITE_CONFIG_SMALL_MALLOC option takes single argument of
type int, interpreted as a boolean, which if true provides a hint to
SQLite that it should avoid large memory allocations if possible.
SQLite will run faster if it is free to ...
|
Pointer Passing Interfaces
(bindptr.html)
2.1. Upping The Threat Level
... For most cases, it is true that potential attackers have no way of injecting
arbitrary SQL, and so most uses of SQLite are immune to the attack above.
But there are some notable exceptions. To wit:
The WebSQL interface
to ...
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA case_sensitive_like
... Hence, by default 'a' LIKE 'A' is
true. The case_sensitive_like pragma installs a new application-defined
LIKE function that is either case sensitive or insensitive depending
on the value of the case_sensitive_like pragma.
When case_sensitive_like is disabled, the default LIKE ...
|
The C language interface to SQLite Version 2
(c_interface.html)
... If the sqlite_complete function returns true when its input
is a string, then the argument forms a complete SQL statement.
There are no guarantees that the syntax of that statement is correct,
but we at least know the statement is ...
|
SQLite As An Application File Format
(appfileformat.html)
... It is true
that command-line tools such as text editors or "grep" or "awk" are
not useful on an SQLite database, but the SQL query language is a much
more powerful and convenient way for examining the content, so ...
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
1.4. Simple FTS Queries
... In this case, the MATCH
expression evaluates to true for all documents that contain one or more
instances of the specified word ("sqlite", "search" or "database", depending
on which example you look at). Specifying a single term as the right ...
|
Page generated by FTS5 in about 69.09 ms.