Small. Fast. Reliable.
Choose any three.
Home
Menu
About
Documentation
Download
License
Support
Purchase
Search
About
Documentation
Download
Support
Purchase
Search Documentation
Search Changelog
Keyword Index
Other Documentation Indexes:
Categorical Document List
Books About SQLite
Alphabetical List Of Documents
Permuted Document Title Index
%q
%w
%z
35% Faster Than The Filesystem
3rd-party fuzzers
about 200 SQL statements per webpage
abs() SQL function
ACID
acos() SQL function
acosh() SQL function
add column
Adding to Zip
advanced
advantages of WAL-mode
affinity
affinity in compound VIEWs
Affinity Of Expressions
AFL
Aggregate Functions
aggregate JSON SQL functions
aggregate SQL functions
aggregate window functions
aggregate-function-invocation
aggregate-function-invocation syntax diagram
alphabetical listing of documents
ALTER
ALTER TABLE
ALTER TABLE ADD COLUMN
ALTER TABLE DROP COLUMN
ALTER TABLE RENAME
ALTER TABLE RENAME COLUMN
ALTER TABLE RENAME documentation
alter-table-stmt
alter-table-stmt syntax diagram
amalgamation
amalgamation tarball
ambiguous dates
American Fuzzy Lop fuzzer
analysis_limit pragma
analyze-stmt
analyze-stmt syntax diagram
Application File Format
application file-format
Application ID
application-defined function attacks
application-defined SQL function
application-defined window functions
application_id pragma
appreciate the freedom
Appropriate Uses For SQLite
approximate ANALYZE
Approximate ANALYZE For Large Databases
.archive command
asin() SQL function
asinh() SQL function
asynchronous I/O backend
asynchronous VFS
atan() SQL function
atan2() SQL function
atanh() SQL function
atomic commit
attach
ATTACH DATABASE
attach-stmt
attach-stmt syntax diagram
attached
attack resistance
authorizer callback
authorizer method
auto modifier
auto_vacuum pragma
autocommit mode
AUTOINCREMENT
automated undo/redo stack
automatic indexes
automatic indexing
automatic_index pragma
automatically running ANALYZE
"automerge" command
auxiliary columns
auxiliary columns in r-tree tables
auxiliary function mapping
avg() aggregate function
avoiding large WAL files
B*-Trees
B-tree
backup API
backup method
bare aggregate terms
base64() SQL function
base85() SQL function
bcvtab
BEGIN
BEGIN EXCLUSIVE
BEGIN IMMEDIATE
begin-stmt
begin-stmt syntax diagram
benefits of using WITHOUT ROWID
BETWEEN
BINARY collating function
binary operators
bind_fallback method
BLOB handle
BLOB I/O performance
block sorting
books about SQLite
boolean datatype
boolean expression
bound parameter
bugs
build product names
building a DLL
building the amalgamation
built-in memory allocators
built-in printf()
built-in SQL math functions
built-in window functions
built-ins
builtin window functions
busy handler
busy method
busy-handler callback
busy_timeout pragma
byte-order determination rules
bytecode
bytecode and tables_used virtual tables
bytecode engine
bytecode virtual table
C-API function list
C-language Interface
cache method
"cache" query parameter
cache_size pragma
cache_spill pragma
canonical source code
carray
carray() table-valued function
CASE expression
case_sensitive_like pragma
CAST
CAST expression
CAST operator
categorical listing of SQLite documents
ceil
ceiling
cell format summary
cell payload
cell_size_check pragma
cfgerrors*
change counter
changes method
changes() SQL function
changeset
char() SQL function
CHECK
CHECK constraint
checklist
checkpoint
checkpoint mode
checkpoint_fullfsync pragma
checkpointed
checkpointing
checksum VFS
checksum VFS shim
child key
child table
chronology
cksumvfs
CLI
clone the entire repository
close method
Clustered indexes
co-routines
coalesce() SQL function
Code of Conduct
Code of Ethics
Code of Ethics of the Project Founder
code repositories
COLLATE
COLLATE clause
COLLATE constraint
collate method
COLLATE operator
collating function
collation_list pragma
collation_needed method
column access functions
column affinity
column definition
column-constraint
column-constraint syntax diagram
column-def
column-def syntax diagram
column-name-list
column-name-list syntax diagram
columnar output modes
colUsed field
comma option
Command Line Interface
command-line interface
command-line options
command-line shell
commands
comment
comment-syntax
comment-syntax syntax diagram
COMMIT
commit-stmt
commit-stmt syntax diagram
commit_hook method
common table expressions
common-table-expression
common-table-expression syntax diagram
comparison affinity rules
comparison expressions
comparison with fts4
compilation
compile fts
compile loadable extensions
compile-time options
compile_options pragma
Compiling Loadable Extensions
compiling the CLI
compiling the TCL interface
complete list of SQLite releases
complete method
COMPLETION
COMPLETION extension
COMPLETION table-valued function
compound query
compound select
compound-operator
compound-operator syntax diagram
compound-select-stmt
compound-select-stmt syntax diagram
compressed FTS4 content
compute the Mandelbrot set
computed columns
concat() SQL function
concat_ws() SQL function
config method
configurable edit distances
configuration option
conflict clause
conflict resolution algorithm
conflict resolution mode
conflict-clause
conflict-clause syntax diagram
.connection
constant-propagation optimization
contentless fts4 tables
contentless-delete
copy method
copyright
Core Functions
core URI query parameters
correlated subqueries
cos() SQL function
cosh() SQL function
count() aggregate function
count_changes pragma
coverage testing vs. fuzz testing
covering index
covering indexes
covering indices
CPU cycles used
CPU performance measurement
CREATE INDEX
CREATE TABLE
CREATE TABLE AS
CREATE TRIGGER
CREATE VIEW
CREATE VIRTUAL TABLE
create-index-stmt
create-index-stmt syntax diagram
create-table-stmt
create-table-stmt syntax diagram
create-trigger-stmt
create-trigger-stmt syntax diagram
create-view-stmt
create-view-stmt syntax diagram
create-virtual-table-stmt
create-virtual-table-stmt syntax diagram
crew
CROSS JOIN
csv
CSV export
CSV import
CSV virtual table
cte-table-name
cte-table-name syntax diagram
custom auxiliary functions
custom auxiliary overview
custom builds
custom r-tree queries
custom SQL function
custom tokenizers
custom virtual tables
CVEs
Dan Kennedy
data container
data transfer format
data_store_directory pragma
data_version pragma
database as container object
database as object
database connection
database corruption caused by inconsistent use of 8+3 filenames
database filename aliasing
database header
database_list pragma
.databases
.databases command
datatype
date and time datatype
date and time functions
date()
date() SQL function
date/time modifiers
date/time special case
datetime()
datetime() SQL function
dbghints
dbhash
dbhash.exe
dbsqlfuzz
dbstat
DBSTAT aggregated mode
dbstat virtual table
debugging hints
debugging memory allocator
decimal extension
decision checklist
DEFAULT clauses
default column value
default memory allocator
default value
default_cache_size pragma
defense against dark arts
defense against the dark arts
defensive code
defer_foreign_keys pragma
degrees() SQL function
delete-stmt
delete-stmt syntax diagram
delete-stmt-limited
delete-stmt-limited syntax diagram
deletemerge
deleting a hot journal
deprecated
DESC
descending index
descending indexes
descending indices
deserialize method
DETACH DATABASE
detach-stmt
detach-stmt syntax diagram
deterministic function
deterministic SQL functions
-DHAVE_FDATASYNC
-DHAVE_GMTIME_R
-DHAVE_ISNAN
-DHAVE_LOCALTIME_R
-DHAVE_LOCALTIME_S
-DHAVE_MALLOC_USABLE_SIZE
-DHAVE_SQLITE_CONFIG_H
-DHAVE_STRCHRNUL
-DHAVE_UTIME
DISTINCT
documents by category
dot-commands
double-quoted string literal
double-quoted string misfeature
download page
drop column
DROP INDEX
DROP TABLE
DROP TRIGGER
DROP VIEW
drop-index-stmt
drop-index-stmt syntax diagram
drop-table-stmt
drop-table-stmt syntax diagram
drop-trigger-stmt
drop-trigger-stmt syntax diagram
drop-view-stmt
drop-view-stmt syntax diagram
-DSQLITE_4_BYTE_ALIGNED_MALLOC
-DSQLITE_ALLOW_COVERING_INDEX_SCAN
-DSQLITE_ALLOW_URI_AUTHORITY
-DSQLITE_API
-DSQLITE_APICALL
-DSQLITE_BYTEORDER
-DSQLITE_CALLBACK
-DSQLITE_CASE_SENSITIVE_LIKE
-DSQLITE_CDECL
-DSQLITE_DEBUG
-DSQLITE_DEFAULT_AUTOMATIC_INDEX
-DSQLITE_DEFAULT_AUTOVACUUM
-DSQLITE_DEFAULT_CACHE_SIZE
-DSQLITE_DEFAULT_FILE_FORMAT
-DSQLITE_DEFAULT_FILE_PERMISSIONS
-DSQLITE_DEFAULT_FOREIGN_KEYS
-DSQLITE_DEFAULT_JOURNAL_SIZE_LIMIT
-DSQLITE_DEFAULT_LOCKING_MODE
-DSQLITE_DEFAULT_LOOKASIDE
-DSQLITE_DEFAULT_MEMSTATUS
-DSQLITE_DEFAULT_MMAP_SIZE
-DSQLITE_DEFAULT_PAGE_SIZE
-DSQLITE_DEFAULT_PCACHE_INITSZ
-DSQLITE_DEFAULT_SYNCHRONOUS
-DSQLITE_DEFAULT_WAL_AUTOCHECKPOINT
-DSQLITE_DEFAULT_WAL_SYNCHRONOUS
-DSQLITE_DEFAULT_WORKER_THREADS
-DSQLITE_DIRECT_OVERFLOW_READ
-DSQLITE_DISABLE_DIRSYNC
-DSQLITE_DISABLE_FTS3_UNICODE
-DSQLITE_DISABLE_FTS4_DEFERRED
-DSQLITE_DISABLE_INTRINSIC
-DSQLITE_DISABLE_LFS
-DSQLITE_DISABLE_PAGECACHE_OVERFLOW_STATS
-DSQLITE_DQS
-DSQLITE_ENABLE_8_3_NAMES
-DSQLITE_ENABLE_API_ARMOR
-DSQLITE_ENABLE_ATOMIC_WRITE
-DSQLITE_ENABLE_BATCH_ATOMIC_WRITE
-DSQLITE_ENABLE_BYTECODE_VTAB
-DSQLITE_ENABLE_COLUMN_METADATA
-DSQLITE_ENABLE_DBPAGE_VTAB
-DSQLITE_ENABLE_DBSTAT_VTAB
-DSQLITE_ENABLE_DESERIALIZE
-DSQLITE_ENABLE_EXPLAIN_COMMENTS
-DSQLITE_ENABLE_FTS3
-DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_ENABLE_FTS3_TOKENIZER
-DSQLITE_ENABLE_FTS4
-DSQLITE_ENABLE_FTS5
-DSQLITE_ENABLE_GEOPOLY
-DSQLITE_ENABLE_HIDDEN_COLUMNS
-DSQLITE_ENABLE_ICU
-DSQLITE_ENABLE_IOTRACE
-DSQLITE_ENABLE_JSON1
-DSQLITE_ENABLE_LOCKING_STYLE
-DSQLITE_ENABLE_MATH_FUNCTIONS
-DSQLITE_ENABLE_MEMORY_MANAGEMENT
-DSQLITE_ENABLE_MEMSYS3
-DSQLITE_ENABLE_MEMSYS5
-DSQLITE_ENABLE_NORMALIZE
-DSQLITE_ENABLE_NULL_TRIM
-DSQLITE_ENABLE_OFFSET_SQL_FUNC
-DSQLITE_ENABLE_PREUPDATE_HOOK
-DSQLITE_ENABLE_QPSG
-DSQLITE_ENABLE_RBU
-DSQLITE_ENABLE_RTREE
-DSQLITE_ENABLE_SESSION
-DSQLITE_ENABLE_SNAPSHOT
-DSQLITE_ENABLE_SORTER_REFERENCES
-DSQLITE_ENABLE_SQLLOG
-DSQLITE_ENABLE_STAT2
-DSQLITE_ENABLE_STAT3
-DSQLITE_ENABLE_STAT4
-DSQLITE_ENABLE_STMT_SCANSTATUS
-DSQLITE_ENABLE_STMTVTAB
-DSQLITE_ENABLE_TREE_EXPLAIN
-DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTION
-DSQLITE_ENABLE_UNLOCK_NOTIFY
-DSQLITE_ENABLE_UPDATE_DELETE_LIMIT
-DSQLITE_EXTERN
-DSQLITE_EXTRA_DURABLE
-DSQLITE_FTS3_MAX_EXPR_DEPTH
-DSQLITE_HAVE_ISNAN
-DSQLITE_HAVE_ZLIB
-DSQLITE_INTROSPECTION_PRAGMAS
-DSQLITE_JSON_MAX_DEPTH
-DSQLITE_LIKE_DOESNT_MATCH_BLOBS
-DSQLITE_MAX_ALLOCATION_SIZE
-DSQLITE_MAX_MEMORY
-DSQLITE_MAX_MMAP_SIZE
-DSQLITE_MAX_SCHEMA_RETRY
-DSQLITE_MAX_WORKER_THREADS
-DSQLITE_MEMDB_DEFAULT_MAXSIZE
-DSQLITE_MEMDEBUG
-DSQLITE_MINIMUM_FILE_DESCRIPTOR
-DSQLITE_OMIT_ALTERTABLE
-DSQLITE_OMIT_ANALYZE
-DSQLITE_OMIT_ATTACH
-DSQLITE_OMIT_AUTHORIZATION
-DSQLITE_OMIT_AUTOINCREMENT
-DSQLITE_OMIT_AUTOINIT
-DSQLITE_OMIT_AUTOMATIC_INDEX
-DSQLITE_OMIT_AUTORESET
-DSQLITE_OMIT_AUTOVACUUM
-DSQLITE_OMIT_BETWEEN_OPTIMIZATION
-DSQLITE_OMIT_BLOB_LITERAL
-DSQLITE_OMIT_BTREECOUNT
-DSQLITE_OMIT_BUILTIN_TEST
-DSQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA
-DSQLITE_OMIT_CAST
-DSQLITE_OMIT_CHECK
-DSQLITE_OMIT_COMPILEOPTION_DIAGS
-DSQLITE_OMIT_COMPLETE
-DSQLITE_OMIT_COMPOUND_SELECT
-DSQLITE_OMIT_CTE
-DSQLITE_OMIT_DATETIME_FUNCS
-DSQLITE_OMIT_DECLTYPE
-DSQLITE_OMIT_DEPRECATED
-DSQLITE_OMIT_DESERIALIZE
-DSQLITE_OMIT_DISKIO
-DSQLITE_OMIT_EXPLAIN
-DSQLITE_OMIT_FLAG_PRAGMAS
-DSQLITE_OMIT_FLOATING_POINT
-DSQLITE_OMIT_FOREIGN_KEY
-DSQLITE_OMIT_GENERATED_COLUMNS
-DSQLITE_OMIT_GET_TABLE
-DSQLITE_OMIT_HEX_INTEGER
-DSQLITE_OMIT_INCRBLOB
-DSQLITE_OMIT_INTEGRITY_CHECK
-DSQLITE_OMIT_INTROSPECTION_PRAGMAS
-DSQLITE_OMIT_JSON
-DSQLITE_OMIT_LIKE_OPTIMIZATION
-DSQLITE_OMIT_LOAD_EXTENSION
-DSQLITE_OMIT_LOCALTIME
-DSQLITE_OMIT_LOOKASIDE
-DSQLITE_OMIT_MEMORYDB
-DSQLITE_OMIT_OR_OPTIMIZATION
-DSQLITE_OMIT_PAGER_PRAGMAS
-DSQLITE_OMIT_PRAGMA
-DSQLITE_OMIT_PROGRESS_CALLBACK
-DSQLITE_OMIT_QUICKBALANCE
-DSQLITE_OMIT_REINDEX
-DSQLITE_OMIT_SCHEMA_PRAGMAS
-DSQLITE_OMIT_SCHEMA_VERSION_PRAGMAS
-DSQLITE_OMIT_SHARED_CACHE
-DSQLITE_OMIT_SUBQUERY
-DSQLITE_OMIT_TCL_VARIABLE
-DSQLITE_OMIT_TEMPDB
-DSQLITE_OMIT_TRACE
-DSQLITE_OMIT_TRIGGER
-DSQLITE_OMIT_TRUNCATE_OPTIMIZATION
-DSQLITE_OMIT_UTF16
-DSQLITE_OMIT_VACUUM
-DSQLITE_OMIT_VIEW
-DSQLITE_OMIT_VIRTUALTABLE
-DSQLITE_OMIT_WAL
-DSQLITE_OMIT_WINDOWFUNC
-DSQLITE_OMIT_WSD
-DSQLITE_OMIT_XFER_OPT
-DSQLITE_OS_OTHER
-DSQLITE_POWERSAFE_OVERWRITE
-DSQLITE_PRINTF_PRECISION_LIMIT
-DSQLITE_QUERY_PLANNER_LIMIT
-DSQLITE_QUERY_PLANNER_LIMIT_INCR
-DSQLITE_REVERSE_UNORDERED_SELECTS
-DSQLITE_RTREE_INT_ONLY
-DSQLITE_SECURE_DELETE
-DSQLITE_SORTER_PMASZ
-DSQLITE_SOUNDEX
-DSQLITE_STDCALL
-DSQLITE_STMTJRNL_SPILL
-DSQLITE_STRICT_SUBTYPE
-DSQLITE_SYSAPI
-DSQLITE_TCLAPI
-DSQLITE_TEMP_STORE
-DSQLITE_THREADSAFE
-DSQLITE_TRACE_SIZE_LIMIT
-DSQLITE_TRUSTED_SCHEMA
-DSQLITE_UNTESTABLE
-DSQLITE_USE_ALLOCA
-DSQLITE_USE_FCNTL_TRACE
-DSQLITE_USE_SEH
-DSQLITE_USE_URI
-DSQLITE_WIN32_HEAP_CREATE
-DSQLITE_WIN32_MALLOC
-DSQLITE_WIN32_MALLOC_VALIDATE
-DSQLITE_ZERO_MALLOC
.dump
dynamic string
dynamic typing
edit() SQL function
editdist3
embedded
empty_result_callbacks pragma
enable_load_extension method
encoding pragma
enhanced query syntax
eponymous virtual table
eponymous-only virtual table
errlog
error code
error log
errorcode method
ESCAPE
eval method
.excel
exclude clause
exclusive locking mode
exists method
EXISTS operator
exp() SQL function
experimental
experimental memory allocators
.expert command
explain query plan
export to excel
export to TSV
expr
expr syntax diagram
expression affinity
expression index
expression indexes
expression syntax
extended error code
extended result code
extended result code definitions
Extending FTS5
extension loading
external content fts4 tables
extract
factored-select-stmt
factored-select-stmt syntax diagram
faster than the filesystem
file control
file control opcode
file format
file format version numbers
file I/O functions
file locking and concurrency control
file locking states
file-format benefits
filesystem corruption
FILTER clause on aggregate functions
filter-clause
filter-clause syntax diagram
flattened
flattening optimization
flexible type system
Flexible typing is a feature
floor() SQL function
footprint
foreign key actions
foreign key constraint
foreign key constraints are enabled
foreign-key-clause
foreign-key-clause syntax diagram
foreign_key_check pragma
foreign_key_list pragma
foreign_keys pragma
format() SQL function
forum
frame boundary
frame specification
frame type
frame-spec
frame-spec syntax diagram
frames
free-page list
freelist
freelist_count pragma
FROM clause
FTS auxiliary functions
FTS hidden column
FTS MATCH
FTS shadow tables
fts3_tokenizer
fts3tokenize
fts3tokenize virtual table
FTS4
FTS4 "automerge" command
FTS4 "integrity-check" command
FTS4 "merge" command
FTS4 "optimize" command
FTS4 "rebuild" command
FTS4 commands
fts4 compress option
FTS4 content option
FTS4 languageid option
FTS4 matchinfo option
FTS4 notindexed option
FTS4 options
FTS4 order option
FTS4 prefix option
fts4aux
fts4aux languageid column
FTS5 automerge option
FTS5 auxiliary functions
FTS5 bm25
FTS5 boolean operators
FTS5 building
FTS5 column filters
FTS5 columnsize option
FTS5 content option
FTS5 contentless tables
FTS5 contentless-delete tables
FTS5 CREATE TABLE Options
FTS5 custom auxiliary functions
FTS5 delete command
FTS5 delete-all command
FTS5 detail option
FTS5 external content pitfalls
FTS5 external content tables
FTS5 highlight
FTS5 initial token
FTS5 initial token queries
FTS5 merge command
FTS5 NEAR queries
FTS5 optimize command
FTS5 pgsz option
FTS5 Phrases
FTS5 prefix indexes
FTS5 prefix queries
FTS5 query syntax
FTS5 rank configuration option
FTS5 rebuild command
FTS5 secure-delete command
fts5 shadow tables
FTS5 snippet
FTS5 Strings
fts5 technical differences
FTS5 tokendata option
FTS5 tokenizers
FTS5 usermerge option
fts5vocab
FULL JOIN
FULL OUTER JOIN
Full-featured SQL
full-text search
full_column_names pragma
fullfsync pragma
.fullschema
function creation routines
function method
function-arguments
function-arguments syntax diagram
function_list pragma
functions within expressions
fuzz testing
fuzzcheck
generalized ALTER TABLE procedure
generate_series
generated column
geopoly
Geopoly extension
Geopoly module
geopoly_area
geopoly_bbox
geopoly_blob
geopoly_ccw
geopoly_contains_point
geopoly_group_bbox
geopoly_json
geopoly_overlap
geopoly_regular
geopoly_svg
geopoly_within
geopoly_xform
get the canonical source code
glob() SQL function
GROUP BY
GROUP BY clause
group_concat() aggregate function
GROUPS frames
hard_heap_limit pragma
hash join
HAVE_FDATASYNC
HAVE_GMTIME_R
HAVE_ISNAN
HAVE_LOCALTIME_R
HAVE_LOCALTIME_S
HAVE_MALLOC_USABLE_SIZE
HAVE_SQLITE_CONFIG_H
HAVE_STRCHRNUL
HAVE_UTIME
HAVING
HAVING clause
hazards of upgrading to the NGQP
hex() SQL function
hexadecimal integer literals
hexadecimal integers
hidden column
high-reliability
Hipp
host parameter
host parameter name
hot journal
hot journal files
how collation is determined
How SQL Works
How SQLite Works
how to compile
How To Compile SQLite
how to corrupt
how to corrupt a database
How To Corrupt Your Database Files
how vacuum works
IEEE 754 floating point values are approximations
ieee754 extension
ieee754() function
ieee754_exponent() function
ieee754_from_blob() function
ieee754_mantissa() function
ieee754_to_blob() function
ifnull() SQL function
ignore_check_constraints pragma
iif() SQL function
"immutable" query parameter
.import
.import command
.imposter dot-command
imposter tables
IN operator
in-header database size
in-memory database
in-memory shared cache database
in-memory shared-cache
incrblob method
increase in the default page size
incremental_vacuum pragma
index b-tree
index_info pragma
index_list pragma
index_xinfo pragma
INDEXED BY
indexed expression
indexed-column
indexed-column syntax diagram
Indexes
indexes on expressions
indexing
indexing tutorial
--insert option
insert-stmt
insert-stmt syntax diagram
INSTEAD OF
INSTEAD OF trigger
instr() SQL function
INTEGER PRIMARY KEY
integer-valued r-trees
integrity_check pragma
internal index
internal indexes
internal schema object
internal table
Internal Versus External BLOBs
interrupt method
invalid UTF
IS DISTINCT FROM
IS NOT DISTINCT FROM
IS NOT operator
IS operator
isolation
jfuzz
join order
join-clause
join-clause syntax diagram
join-constraint
join-constraint syntax diagram
join-operator
join-operator syntax diagram
journal_mode pragma
journal_size_limit pragma
json
JSON BLOB input bug
JSON function path arguments
JSON paths
json SQL function
json1
JSON5
JSON5 extensions
json_array
json_array SQL function
json_array_length
json_array_length SQL function
json_each
json_each table-valued function
json_error_position
json_error_position SQL function
json_extract
json_extract SQL function
json_group_array
json_group_array SQL function
json_group_object
json_group_object SQL function
json_insert
json_insert SQL function
json_object
json_object SQL function
json_patch
json_patch SQL function
json_pretty
json_pretty SQL function
json_quote
json_quote SQL function
json_remove
json_remove SQL function
json_replace
json_replace SQL function
json_set
json_set SQL function
json_tree
json_tree table-valued function
json_type
json_type SQL function
json_valid
json_valid SQL function
JSONB
jsonb SQL function
jsonb_array
jsonb_array SQL function
jsonb_extract
jsonb_extract SQL function
jsonb_group_array
jsonb_group_array SQL function
jsonb_group_object
jsonb_group_object SQL function
jsonb_insert
jsonb_insert SQL function
jsonb_object
jsonb_object SQL function
jsonb_patch
jsonb_patch SQL function
jsonb_remove
jsonb_remove SQL function
jsonb_replace
jsonb_replace SQL function
jsonb_set
jsonb_set SQL function
julianday modifier
julianday()
julianday() SQL function
Kennedy
keyword index
keywords
languageid
large WAL files
last_insert_rowid method
last_insert_rowid() SQL function
LEFT JOIN strength reduction optimization
legacy_alter_table pragma
legacy_file_format pragma
Lemon
Lemon LALR parser generator
Lemon parser generator
length() SQL function
library size
license
LIKE optimization
like() SQL function
likelihood() SQL function
likely() SQL function
LIMIT
limit category
list of current bytecodes
list of virtual tables
literal value
literal-value
literal-value syntax diagram
ln() SQL function
.load command
load_extension() SQL function
loadable extension
loadext
localtime modifier
lock-byte page
locking_mode pragma
log
log10
log2() SQL function
long term support
lookaside
lookaside buffer
lookaside memory
lookaside memory allocator
low-dependency
lower() SQL function
ltrim() SQL function
mailing lists
managing SQLite Archives from the command-line
Manual Control Of Query Plans Using CROSS JOIN
Manual Control Of Query Plans Using SQLITE_STAT Tables
master journal
MATCH
matchinfo
matchinfo b flag
matchinfo x flag
matchinfo y flag
materialization hints
MATERIALIZED
Math Functions
max() aggregate function
max() SQL function
max_page_count pragma
maxopen parameter
MC/DC testing
memory
memory allocation
memory statistics
memory-mapped I/O
"merge" command
microoptimizations
min() aggregate function
min() SQL function
min/max optimization
missing callback
mmap
mmap_size pragma
mod() SQL function
.mode
.mode quote
"mode" query parameter
modeof
"modeof" query parameter
modifiers
module_list pragma
most used
most widely deployed
most widely used
mutation test script
mutation testing
mxFrame
nBackfill
NEAR queries
network filesystem use
next generation query planner
NGQP
NOCASE collating function
"nolock" query parameter
non-deterministic functions
non-standard SELECT syntax
NOT EXISTS operator
NOT IN operator
NOT INDEXED
NOT MATERIALIZED
NOT NULL
NOT NULL constraint
not open-contributin
NUL characters in strings
nullif() SQL function
NULLS FIRST
NULLS LAST
nullvalue method
numeric literals
numeric-literal
numeric-literal syntax diagram
object resolution
octet_length() SQL function
OFFSET
omit-left-join optimization
omit-outer-join optimization
omitfeatures
ON CONFLICT
ON CONFLICT clause
on-disk format
.once
onecolumn method
opcode definitions
opcodes
.open
.open command
OPEN_EXRESCODE
OPEN_NOFOLLOW
openclose callback
OpenOffice case study
optimize pragma
"optimize" command
optimizer
or optimization
or-connected-terms
order by
ORDER BY clause in aggregate functions
orderByConsumed
ordering-term
ordering-term syntax diagram
ordinary common table expressions
OS backend
OSS Fuzz
OUTER JOIN strength reduction
OUTER JOIN strength reduction optimization
.output
output mode
over-clause
over-clause syntax diagram
overflow page
page cache
page_count pragma
page_size pragma
pagecache memory allocator
parameter
parameter binding
.parameter command
parent key
parent table
parser_trace pragma
partial index
partial indexes
partial indices
partial sorting by index
partition
patchset
permuted index
persistent journal mode
persistent loadable extensions
phrase queries
pi() SQL function
pointer leak
pointer passing interface
pointer types
pointer value
porting SQLite
pow() SQL function
power-safe
power-safe transactions
powersafe overwrite
PRAGMA
PRAGMA analysis_limit
PRAGMA application_id
PRAGMA auto_vacuum
PRAGMA automatic_index
PRAGMA busy_timeout
PRAGMA cache_size
PRAGMA cache_spill
PRAGMA case_sensitive_like
PRAGMA cell_size_check
PRAGMA checkpoint_fullfsync
PRAGMA collation_list
PRAGMA compile_options
PRAGMA count_changes
PRAGMA data_store_directory
PRAGMA data_version
PRAGMA database_list
PRAGMA default_cache_size
PRAGMA defer_foreign_keys
PRAGMA empty_result_callbacks
PRAGMA encoding
PRAGMA foreign_key_check
PRAGMA foreign_key_list
PRAGMA foreign_keys
PRAGMA freelist_count
PRAGMA full_column_names
PRAGMA fullfsync
PRAGMA function
PRAGMA function_list
PRAGMA hard_heap_limit
PRAGMA ignore_check_constraints
PRAGMA incremental_vacuum
PRAGMA index_info
PRAGMA index_list
PRAGMA index_xinfo
PRAGMA integrity_check
PRAGMA journal_mode
PRAGMA journal_size_limit
PRAGMA legacy_alter_table
PRAGMA legacy_file_format
pragma list
PRAGMA locking_mode
PRAGMA max_page_count
PRAGMA mmap_size
PRAGMA module_list
PRAGMA optimize
PRAGMA page_count
PRAGMA page_size
PRAGMA parser_trace
PRAGMA pragma_list
PRAGMA query_only
PRAGMA quick_check
PRAGMA read_uncommitted
PRAGMA recursive_triggers
PRAGMA reverse_unordered_selects
PRAGMA schema_version
PRAGMA secure_delete
PRAGMA short_column_names
PRAGMA shrink_memory
PRAGMA soft_heap_limit
PRAGMA stats
PRAGMA synchronous
PRAGMA table_info
PRAGMA table_list
PRAGMA table_xinfo
PRAGMA temp_store
PRAGMA temp_store_directory
PRAGMA threads
PRAGMA trusted_schema
PRAGMA user_version
PRAGMA vdbe_addoptrace
PRAGMA vdbe_debug
PRAGMA vdbe_listing
PRAGMA vdbe_trace
PRAGMA wal_autocheckpoint
PRAGMA wal_checkpoint
PRAGMA writable_schema
pragma-stmt
pragma-stmt syntax diagram
pragma-value
pragma-value syntax diagram
pragma_list pragma
precompiled amalgamation tarballs
prefix queries
prefix query
prepared statement
preupdate method
PRIMARY KEY
PRIMARY KEY constraint
primary versus extended result codes
printf() SQL function
prior releases
private branches
professional support
profile method
Programming Loadable Extensions
progress method
protected sqlite3_value
PSOW
"psow" query parameter
public-domain
push-down optimization
qbox
qbox output mode
QPSG
qualified-table-name
qualified-table-name syntax diagram
queries against graphs
query flattener
query parameters with special meaning to SQLite
query planner
query planner checklist
query planner stability guarantee
query-time index
Query-time indexes
query-time indexing
query_only pragma
Quick Start Guide
quick_check pragma
Quirks
quote() SQL function
R-Tree extension
R-Trees
radians() SQL function
RAISE function
raise-function
raise-function syntax diagram
random() SQL function
randomblob() SQL function
RANGE frames
RANGE n FOLLOWING
RANGE n PRECEDING
range query optimization
RBU
RBU Database Contents
RBU Database Tables
RBU extension
RBU FTS3/4 Tables
RBU Update
RBU Vacuum
.read
read-only WAL databases
read_uncommitted pragma
reading and writing an rtree at the same time
"rebuild" command
recent CVEs
recommended by the US Library of Congress
recommended compile-time option
recommended storage format
Recommended usage patterns for ANALYZE
record format
.recover dot-command
recovery
recovery extension
recursive common table expression
recursive query
recursive-cte
recursive-cte syntax diagram
recursive_triggers pragma
REGEXP
reindex-stmt
reindex-stmt syntax diagram
RELEASE
release history
release testing checklists
release-stmt
release-stmt syntax diagram
relfootprint
rename column
rename table
replace() SQL function
reported vulnerabilities
reserve bytes
reset the WAL
restore method
result code
result code definitions
result-column
result-column syntax diagram
result-set expressions
RETURNING clause
returning-clause
returning-clause syntax diagram
reverse_unordered_selects pragma
RIGHT and FULL OUTER JOIN
RIGHT JOIN
Robson proof
ROLLBACK
rollback journal
rollback journal format
rollback-stmt
rollback-stmt syntax diagram
rollback_hook method
round() SQL function
row value
row value IN operator
ROWID
rowid table
rowvalue
rtree shadow tables
rtreecheck()
RTRIM collating function
rtrim() SQL function
rules for determining column affinity
rules for determining column affinity in VIEWs
Run-Time Loadable Extensions
running ANALYZE via PRAGMA optimize
safe command-line option
--safe command-line option
SAVEPOINT bug
savepoint-stmt
savepoint-stmt syntax diagram
Scalar Functions
scan status flags
scanstatus options
.schema
schema format
schema format number
schema storage
schema_version pragma
search application tips
second edition file format document
secure_delete pragma
security
segment btree
select
SELECT query
SELECT statement
select-core
select-core syntax diagram
select-stmt
select-stmt syntax diagram
self-contained
.selftest dot-command
separating a database from its journal
serial type
serialize method
series
server-side database
serverless
session
session extension
Session Extension C-language Interface
Session Module C-API function list
.sha3sum dot-command
shadow table
shadowtabs
shared cache
shared cache mode
shims
"shm" file
short filenames
short_column_names pragma
shrink_memory pragma
sign() SQL function
signed-number
signed-number syntax diagram
simple fts queries
simple SELECT
simple-function-invocation
simple-function-invocation syntax diagram
simple-select-stmt
simple-select-stmt syntax diagram
sin() SQL function
single-argument carray
sinh() SQL function
skip-scan
skip-scan optimization
SLT
snapshot
snippet
soft_heap_limit pragma
solve Sudoku puzzles
sort order
sorting
sorting subsets of the result
soundex() SQL function
spellfix1
split amalgamation
SQL Archive
SQL fuzzing
SQL Logic Tests
SQL parameter
SQL statement compiler
sql-stmt
sql-stmt syntax diagram
sql-stmt-list
sql-stmt-list syntax diagram
SQLAR
sqldiff
sqldiff --rbu
sqldiff.exe
SQLite amalgamation source file
SQLite Archive
SQLite Archive files
SQLite Archive format
SQLite Archive smaller than ZIP
SQLite Consortium
SQLite database file format
SQLite extension
SQLite Keywords
SQLite query planner
SQLite Shared-Cache Mode
SQLite source code repositories
sqlite3
sqlite3.exe
sqlite3.exe command-line shell
sqlite3_aggregate_context
sqlite3_aggregate_count
sqlite3_analyzer
sqlite3_analyzer.exe
sqlite3_api_routines
sqlite3_auto_extension
sqlite3_autovacuum_pages
sqlite3_backup
sqlite3_backup_finish()
sqlite3_backup_init()
sqlite3_backup_pagecount()
sqlite3_backup_remaining()
sqlite3_backup_step()
sqlite3_bind_blob
sqlite3_bind_blob64
sqlite3_bind_double
sqlite3_bind_int
sqlite3_bind_int64
sqlite3_bind_null
sqlite3_bind_parameter_count
sqlite3_bind_parameter_index
sqlite3_bind_parameter_name
sqlite3_bind_pointer
sqlite3_bind_text
sqlite3_bind_text16
sqlite3_bind_text64
sqlite3_bind_value
sqlite3_bind_zeroblob
sqlite3_bind_zeroblob64
sqlite3_blob
sqlite3_blob_bytes
sqlite3_blob_close
sqlite3_blob_open
sqlite3_blob_read
sqlite3_blob_reopen
sqlite3_blob_write
sqlite3_busy_handler
sqlite3_busy_timeout
sqlite3_cancel_auto_extension
sqlite3_carray_bind
sqlite3_changegroup
sqlite3_changes
sqlite3_changes64
sqlite3_changeset_iter
sqlite3_clear_bindings
sqlite3_close
sqlite3_close_v2
sqlite3_collation_needed
sqlite3_collation_needed16
sqlite3_column_blob
sqlite3_column_bytes
sqlite3_column_bytes16
sqlite3_column_count
sqlite3_column_database_name
sqlite3_column_database_name16
sqlite3_column_decltype
sqlite3_column_decltype16
sqlite3_column_double
sqlite3_column_int
sqlite3_column_int64
sqlite3_column_name
sqlite3_column_name16
sqlite3_column_origin_name
sqlite3_column_origin_name16
sqlite3_column_table_name
sqlite3_column_table_name16
sqlite3_column_text
sqlite3_column_text16
sqlite3_column_type
sqlite3_column_value
sqlite3_commit_hook
sqlite3_compileoption_get
sqlite3_compileoption_used
sqlite3_complete
sqlite3_complete16
sqlite3_config
sqlite3_context
sqlite3_context_db_handle
sqlite3_create_collation
sqlite3_create_collation16
sqlite3_create_collation_v2
sqlite3_create_filename
sqlite3_create_function
sqlite3_create_function16
sqlite3_create_function_v2
sqlite3_create_module
sqlite3_create_module_v2
sqlite3_create_window_function
sqlite3_data_count
sqlite3_data_directory
sqlite3_database_file_object
sqlite3_db_cacheflush
sqlite3_db_config
sqlite3_db_filename
sqlite3_db_handle
sqlite3_db_mutex
sqlite3_db_name
sqlite3_db_readonly
sqlite3_db_release_memory
sqlite3_db_status
sqlite3_declare_vtab
sqlite3_deserialize
sqlite3_drop_modules
sqlite3_enable_load_extension
sqlite3_enable_shared_cache
sqlite3_errcode
sqlite3_errmsg
sqlite3_errmsg16
sqlite3_error_offset
sqlite3_errstr
sqlite3_exec
sqlite3_expanded_sql
sqlite3_expired
sqlite3_extended_errcode
sqlite3_extended_result_codes
sqlite3_file
sqlite3_file_control
sqlite3_filename
sqlite3_filename_database
sqlite3_filename_journal
sqlite3_filename_wal
sqlite3_finalize
sqlite3_free
sqlite3_free_filename
sqlite3_free_table
sqlite3_get_autocommit
sqlite3_get_auxdata
sqlite3_get_clientdata
sqlite3_get_table
sqlite3_global_recover
sqlite3_hard_heap_limit64
sqlite3_index_info
sqlite3_initialize
sqlite3_int64
sqlite3_interrupt
sqlite3_io_methods
sqlite3_is_interrupted
sqlite3_keyword_check
sqlite3_keyword_count
sqlite3_keyword_name
sqlite3_last_insert_rowid
sqlite3_libversion
sqlite3_libversion_number
sqlite3_limit
sqlite3_load_extension
sqlite3_log
sqlite3_malloc
sqlite3_malloc64
sqlite3_mem_methods
sqlite3_memory_alarm
sqlite3_memory_highwater
sqlite3_memory_used
sqlite3_module
sqlite3_module.xBegin
sqlite3_module.xBestIndex
sqlite3_module.xClose
sqlite3_module.xColumn
sqlite3_module.xCommit
sqlite3_module.xConnect
sqlite3_module.xCreate
sqlite3_module.xDisconnect
sqlite3_module.xEof
sqlite3_module.xFilter
sqlite3_module.xFindFunction
sqlite3_module.xIntegrity
sqlite3_module.xNext
sqlite3_module.xOpen
sqlite3_module.xRename
sqlite3_module.xRollback
sqlite3_module.xRowid
sqlite3_module.xSavepoint
sqlite3_module.xShadowName
sqlite3_module.xSync
sqlite3_module.xUpdate
sqlite3_mprintf
sqlite3_msize
sqlite3_mutex
sqlite3_mutex_alloc
sqlite3_mutex_enter
sqlite3_mutex_free
sqlite3_mutex_held
sqlite3_mutex_leave
sqlite3_mutex_methods
sqlite3_mutex_notheld
sqlite3_mutex_try
sqlite3_next_stmt
sqlite3_normalized_sql
sqlite3_open
sqlite3_open16
sqlite3_open_v2
sqlite3_os_end
sqlite3_os_init
sqlite3_overload_function
sqlite3_pcache
sqlite3_pcache_methods2
sqlite3_pcache_page
sqlite3_prepare
sqlite3_prepare16
sqlite3_prepare16_v2
sqlite3_prepare16_v3
sqlite3_prepare_v2
sqlite3_prepare_v3
sqlite3_preupdate_blobwrite
sqlite3_preupdate_count
sqlite3_preupdate_depth
sqlite3_preupdate_hook
sqlite3_preupdate_new
sqlite3_preupdate_old
sqlite3_profile
sqlite3_progress_handler
sqlite3_randomness
sqlite3_realloc
sqlite3_realloc64
sqlite3_rebaser
sqlite3_release_memory
sqlite3_reset
sqlite3_reset_auto_extension
sqlite3_result_blob
sqlite3_result_blob64
sqlite3_result_double
sqlite3_result_error
sqlite3_result_error16
sqlite3_result_error_code
sqlite3_result_error_nomem
sqlite3_result_error_toobig
sqlite3_result_int
sqlite3_result_int64
sqlite3_result_null
sqlite3_result_pointer
sqlite3_result_subtype
sqlite3_result_text
sqlite3_result_text16
sqlite3_result_text16be
sqlite3_result_text16le
sqlite3_result_text64
sqlite3_result_value
sqlite3_result_zeroblob
sqlite3_result_zeroblob64
sqlite3_rollback_hook
sqlite3_rtree_query_callback
sqlite3_serialize
sqlite3_session
sqlite3_set_authorizer
sqlite3_set_auxdata
sqlite3_set_clientdata
sqlite3_set_last_insert_rowid
sqlite3_shutdown
sqlite3_sleep
sqlite3_snapshot
sqlite3_snapshot_cmp
sqlite3_snapshot_free
sqlite3_snapshot_get
sqlite3_snapshot_open
sqlite3_snapshot_recover
sqlite3_snprintf
sqlite3_soft_heap_limit
sqlite3_soft_heap_limit64
sqlite3_sourceid
sqlite3_sql
sqlite3_status
sqlite3_status64
sqlite3_step
sqlite3_stmt
sqlite3_stmt_busy
sqlite3_stmt_explain
sqlite3_stmt_isexplain
sqlite3_stmt_readonly
sqlite3_stmt_scanstatus
sqlite3_stmt_scanstatus_reset
sqlite3_stmt_scanstatus_v2
sqlite3_stmt_status
sqlite3_str
sqlite3_str_append
sqlite3_str_appendall
sqlite3_str_appendchar
sqlite3_str_appendf
sqlite3_str_errcode
sqlite3_str_finish
sqlite3_str_length
sqlite3_str_new
sqlite3_str_reset
sqlite3_str_value
sqlite3_str_vappendf
sqlite3_strglob
sqlite3_stricmp
sqlite3_strlike
sqlite3_strnicmp
sqlite3_system_errno
sqlite3_table_column_metadata
sqlite3_temp_directory
sqlite3_test_control
sqlite3_thread_cleanup
sqlite3_threadsafe
sqlite3_total_changes
sqlite3_total_changes64
sqlite3_trace
sqlite3_trace_v2
sqlite3_transfer_bindings
sqlite3_txn_state
sqlite3_uint64
sqlite3_unlock_notify
sqlite3_update_hook
sqlite3_uri_boolean
sqlite3_uri_int64
sqlite3_uri_key
sqlite3_uri_parameter
sqlite3_user_data
sqlite3_value
sqlite3_value_blob
sqlite3_value_bytes
sqlite3_value_bytes16
sqlite3_value_double
sqlite3_value_dup
sqlite3_value_encoding
sqlite3_value_free
sqlite3_value_frombind
sqlite3_value_int
sqlite3_value_int64
sqlite3_value_nochange
sqlite3_value_numeric_type
sqlite3_value_pointer
sqlite3_value_subtype
sqlite3_value_text
sqlite3_value_text16
sqlite3_value_text16be
sqlite3_value_text16le
sqlite3_value_type
sqlite3_version
sqlite3_vfs
sqlite3_vfs.xAccess
sqlite3_vfs.xOpen
sqlite3_vfs_find
sqlite3_vfs_register
sqlite3_vfs_unregister
sqlite3_vmprintf
sqlite3_vsnprintf
sqlite3_vtab
sqlite3_vtab_collation
sqlite3_vtab_config
sqlite3_vtab_cursor
sqlite3_vtab_distinct
sqlite3_vtab_in
sqlite3_vtab_in_first
sqlite3_vtab_in_next
sqlite3_vtab_nochange
sqlite3_vtab_on_conflict
sqlite3_vtab_rhs_value
sqlite3_wal_autocheckpoint
sqlite3_wal_checkpoint
sqlite3_wal_checkpoint_v2
sqlite3_wal_hook
sqlite3_win32_set_directory
sqlite3_win32_set_directory16
sqlite3_win32_set_directory8
sqlite3changegroup_add
sqlite3changegroup_add_change
sqlite3changegroup_add_strm
sqlite3changegroup_delete
sqlite3changegroup_new
sqlite3changegroup_output
sqlite3changegroup_output_strm
sqlite3changegroup_schema
sqlite3changeset_apply
sqlite3changeset_apply_strm
sqlite3changeset_apply_v2
sqlite3changeset_apply_v2_strm
sqlite3changeset_concat
sqlite3changeset_concat_strm
sqlite3changeset_conflict
sqlite3changeset_finalize
sqlite3changeset_fk_conflicts
sqlite3changeset_invert
sqlite3changeset_invert_strm
sqlite3changeset_new
sqlite3changeset_next
sqlite3changeset_old
sqlite3changeset_op
sqlite3changeset_pk
sqlite3changeset_start
sqlite3changeset_start_strm
sqlite3changeset_start_v2
sqlite3changeset_start_v2_strm
sqlite3changeset_upgrade
sqlite3rebaser_configure
sqlite3rebaser_create
sqlite3rebaser_delete
sqlite3rebaser_rebase
sqlite3rebaser_rebase_strm
sqlite3session_attach
sqlite3session_changeset
sqlite3session_changeset_size
sqlite3session_changeset_strm
sqlite3session_config
sqlite3session_create
sqlite3session_delete
sqlite3session_diff
sqlite3session_enable
sqlite3session_indirect
sqlite3session_isempty
sqlite3session_memory_used
sqlite3session_object_config
sqlite3session_patchset
sqlite3session_patchset_strm
sqlite3session_table_filter
SQLITE_4_BYTE_ALIGNED_MALLOC
SQLITE_ABORT
SQLITE_ABORT_ROLLBACK
SQLITE_ACCESS_EXISTS
SQLITE_ACCESS_READ
SQLITE_ACCESS_READWRITE
SQLITE_ALLOW_COVERING_INDEX_SCAN
SQLITE_ALLOW_URI_AUTHORITY
SQLITE_ALTER_TABLE
SQLITE_ANALYZE
SQLITE_ANY
SQLITE_API
SQLITE_APICALL
SQLITE_ATTACH
SQLITE_AUTH
SQLITE_AUTH_USER
SQLITE_BLOB
SQLITE_BUSY
SQLITE_BUSY_RECOVERY
SQLITE_BUSY_SNAPSHOT
SQLITE_BUSY_TIMEOUT
SQLITE_BYTEORDER
SQLITE_CALLBACK
SQLITE_CANTOPEN
SQLITE_CANTOPEN_CONVPATH
SQLITE_CANTOPEN_DIRTYWAL
SQLITE_CANTOPEN_FULLPATH
SQLITE_CANTOPEN_ISDIR
SQLITE_CANTOPEN_NOTEMPDIR
SQLITE_CANTOPEN_SYMLINK
SQLITE_CASE_SENSITIVE_LIKE
SQLITE_CDECL
SQLITE_CHANGESET_ABORT
SQLITE_CHANGESET_CONFLICT
SQLITE_CHANGESET_CONSTRAINT
SQLITE_CHANGESET_DATA
SQLITE_CHANGESET_FOREIGN_KEY
SQLITE_CHANGESET_NOTFOUND
SQLITE_CHANGESET_OMIT
SQLITE_CHANGESET_REPLACE
SQLITE_CHANGESETAPPLY_FKNOACTION
SQLITE_CHANGESETAPPLY_IGNORENOOP
SQLITE_CHANGESETAPPLY_INVERT
SQLITE_CHANGESETAPPLY_NOSAVEPOINT
SQLITE_CHANGESETSTART_INVERT
SQLITE_CHECKPOINT_FULL
SQLITE_CHECKPOINT_PASSIVE
SQLITE_CHECKPOINT_RESTART
SQLITE_CHECKPOINT_TRUNCATE
sqlite_compileoption_get() SQL function
sqlite_compileoption_used() SQL function
SQLITE_CONFIG_COVERING_INDEX_SCAN
SQLITE_CONFIG_GETMALLOC
SQLITE_CONFIG_GETMUTEX
SQLITE_CONFIG_GETPCACHE
SQLITE_CONFIG_GETPCACHE2
SQLITE_CONFIG_HEAP
SQLITE_CONFIG_LOG
SQLITE_CONFIG_LOOKASIDE
SQLITE_CONFIG_MALLOC
SQLITE_CONFIG_MEMDB_MAXSIZE
SQLITE_CONFIG_MEMSTATUS
SQLITE_CONFIG_MMAP_SIZE
SQLITE_CONFIG_MULTITHREAD
SQLITE_CONFIG_MUTEX
SQLITE_CONFIG_PAGECACHE
SQLITE_CONFIG_PCACHE
SQLITE_CONFIG_PCACHE2
SQLITE_CONFIG_PCACHE_HDRSZ
SQLITE_CONFIG_PMASZ
SQLITE_CONFIG_ROWID_IN_VIEW
SQLITE_CONFIG_SCRATCH
SQLITE_CONFIG_SERIALIZED
SQLITE_CONFIG_SINGLETHREAD
SQLITE_CONFIG_SMALL_MALLOC
SQLITE_CONFIG_SORTERREF_SIZE
SQLITE_CONFIG_SQLLOG
SQLITE_CONFIG_STMTJRNL_SPILL
SQLITE_CONFIG_URI
SQLITE_CONFIG_WIN32_HEAPSIZE
SQLITE_CONSTRAINT
SQLITE_CONSTRAINT_CHECK
SQLITE_CONSTRAINT_COMMITHOOK
SQLITE_CONSTRAINT_DATATYPE
SQLITE_CONSTRAINT_FOREIGNKEY
SQLITE_CONSTRAINT_FUNCTION
SQLITE_CONSTRAINT_NOTNULL
SQLITE_CONSTRAINT_PINNED
SQLITE_CONSTRAINT_PRIMARYKEY
SQLITE_CONSTRAINT_ROWID
SQLITE_CONSTRAINT_TRIGGER
SQLITE_CONSTRAINT_UNIQUE
SQLITE_CONSTRAINT_VTAB
SQLITE_COPY
SQLITE_CORRUPT
SQLITE_CORRUPT_INDEX
SQLITE_CORRUPT_SEQUENCE
SQLITE_CORRUPT_VTAB
SQLITE_CREATE_INDEX
SQLITE_CREATE_TABLE
SQLITE_CREATE_TEMP_INDEX
SQLITE_CREATE_TEMP_TABLE
SQLITE_CREATE_TEMP_TRIGGER
SQLITE_CREATE_TEMP_VIEW
SQLITE_CREATE_TRIGGER
SQLITE_CREATE_VIEW
SQLITE_CREATE_VTABLE
SQLITE_DBCONFIG_DEFENSIVE
SQLITE_DBCONFIG_DQS_DDL
SQLITE_DBCONFIG_DQS_DML
SQLITE_DBCONFIG_ENABLE_FKEY
SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION
SQLITE_DBCONFIG_ENABLE_QPSG
SQLITE_DBCONFIG_ENABLE_TRIGGER
SQLITE_DBCONFIG_ENABLE_VIEW
SQLITE_DBCONFIG_LEGACY_ALTER_TABLE
SQLITE_DBCONFIG_LEGACY_FILE_FORMAT
SQLITE_DBCONFIG_LOOKASIDE
SQLITE_DBCONFIG_MAINDBNAME
SQLITE_DBCONFIG_MAX
SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE
SQLITE_DBCONFIG_RESET_DATABASE
SQLITE_DBCONFIG_REVERSE_SCANORDER
SQLITE_DBCONFIG_STMT_SCANSTATUS
SQLITE_DBCONFIG_TRIGGER_EQP
SQLITE_DBCONFIG_TRUSTED_SCHEMA
SQLITE_DBCONFIG_WRITABLE_SCHEMA
sqlite_dbpage
SQLITE_DBPAGE virtual table
SQLITE_DBSTATUS options
SQLITE_DBSTATUS_CACHE_HIT
SQLITE_DBSTATUS_CACHE_MISS
SQLITE_DBSTATUS_CACHE_SPILL
SQLITE_DBSTATUS_CACHE_USED
SQLITE_DBSTATUS_CACHE_USED_SHARED
SQLITE_DBSTATUS_CACHE_WRITE
SQLITE_DBSTATUS_DEFERRED_FKS
SQLITE_DBSTATUS_LOOKASIDE_HIT
SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL
SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE
SQLITE_DBSTATUS_LOOKASIDE_USED
SQLITE_DBSTATUS_MAX
SQLITE_DBSTATUS_SCHEMA_USED
SQLITE_DBSTATUS_STMT_USED
SQLITE_DEBUG
SQLITE_DEFAULT_AUTOMATIC_INDEX
SQLITE_DEFAULT_AUTOVACUUM
SQLITE_DEFAULT_CACHE_SIZE
SQLITE_DEFAULT_FILE_FORMAT
SQLITE_DEFAULT_FILE_PERMISSIONS
SQLITE_DEFAULT_FOREIGN_KEYS
SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT
SQLITE_DEFAULT_LOCKING_MODE
SQLITE_DEFAULT_LOOKASIDE
SQLITE_DEFAULT_MEMSTATUS
SQLITE_DEFAULT_MMAP_SIZE
SQLITE_DEFAULT_PAGE_SIZE
SQLITE_DEFAULT_PCACHE_INITSZ
SQLITE_DEFAULT_SYNCHRONOUS
SQLITE_DEFAULT_WAL_AUTOCHECKPOINT
SQLITE_DEFAULT_WAL_SYNCHRONOUS
SQLITE_DEFAULT_WORKER_THREADS
SQLITE_DELETE
SQLITE_DENY
SQLITE_DESERIALIZE_FREEONCLOSE
SQLITE_DESERIALIZE_READONLY
SQLITE_DESERIALIZE_RESIZEABLE
SQLITE_DETACH
SQLITE_DETERMINISTIC
SQLITE_DIRECT_OVERFLOW_READ
SQLITE_DIRECTONLY
SQLITE_DISABLE_DIRSYNC
SQLITE_DISABLE_FTS3_UNICODE
SQLITE_DISABLE_FTS4_DEFERRED
SQLITE_DISABLE_INTRINSIC
SQLITE_DISABLE_LFS
SQLITE_DISABLE_PAGECACHE_OVERFLOW_STATS
SQLITE_DONE
SQLITE_DQS
SQLITE_DROP_INDEX
SQLITE_DROP_TABLE
SQLITE_DROP_TEMP_INDEX
SQLITE_DROP_TEMP_TABLE
SQLITE_DROP_TEMP_TRIGGER
SQLITE_DROP_TEMP_VIEW
SQLITE_DROP_TRIGGER
SQLITE_DROP_VIEW
SQLITE_DROP_VTABLE
SQLITE_EMPTY
SQLITE_ENABLE_8_3_NAMES
SQLITE_ENABLE_API_ARMOR
SQLITE_ENABLE_ATOMIC_WRITE
SQLITE_ENABLE_BATCH_ATOMIC_WRITE
SQLITE_ENABLE_BYTECODE_VTAB
SQLITE_ENABLE_COLUMN_METADATA
SQLITE_ENABLE_DBPAGE_VTAB
SQLITE_ENABLE_DBSTAT_VTAB
SQLITE_ENABLE_DESERIALIZE
SQLITE_ENABLE_EXPLAIN_COMMENTS
SQLITE_ENABLE_FTS3
SQLITE_ENABLE_FTS3_PARENTHESIS
SQLITE_ENABLE_FTS3_TOKENIZER
SQLITE_ENABLE_FTS4
SQLITE_ENABLE_FTS5
SQLITE_ENABLE_GEOPOLY
SQLITE_ENABLE_HIDDEN_COLUMNS
SQLITE_ENABLE_ICU
SQLITE_ENABLE_IOTRACE
SQLITE_ENABLE_JSON1
SQLITE_ENABLE_LOCKING_STYLE
SQLITE_ENABLE_MATH_FUNCTIONS
SQLITE_ENABLE_MEMORY_MANAGEMENT
SQLITE_ENABLE_MEMSYS3
SQLITE_ENABLE_MEMSYS5
SQLITE_ENABLE_NORMALIZE
SQLITE_ENABLE_NULL_TRIM
SQLITE_ENABLE_OFFSET_SQL_FUNC
SQLITE_ENABLE_PREUPDATE_HOOK
SQLITE_ENABLE_QPSG
SQLITE_ENABLE_RBU
SQLITE_ENABLE_RTREE
SQLITE_ENABLE_SESSION
SQLITE_ENABLE_SNAPSHOT
SQLITE_ENABLE_SORTER_REFERENCES
SQLITE_ENABLE_SQLLOG
SQLITE_ENABLE_STAT2
SQLITE_ENABLE_STAT3
SQLITE_ENABLE_STAT4
SQLITE_ENABLE_STMT_SCANSTATUS
SQLITE_ENABLE_STMTVTAB
SQLITE_ENABLE_TREE_EXPLAIN
SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION
SQLITE_ENABLE_UNLOCK_NOTIFY
SQLITE_ENABLE_UPDATE_DELETE_LIMIT
SQLITE_ERROR
SQLITE_ERROR_MISSING_COLLSEQ
SQLITE_ERROR_RETRY
SQLITE_ERROR_SNAPSHOT
SQLITE_EXTERN
SQLITE_EXTRA_DURABLE
SQLITE_FAIL
SQLITE_FCNTL_BEGIN_ATOMIC_WRITE
SQLITE_FCNTL_BUSYHANDLER
SQLITE_FCNTL_CHUNK_SIZE
SQLITE_FCNTL_CKPT_DONE
SQLITE_FCNTL_CKPT_START
SQLITE_FCNTL_CKSM_FILE
SQLITE_FCNTL_COMMIT_ATOMIC_WRITE
SQLITE_FCNTL_COMMIT_PHASETWO
SQLITE_FCNTL_DATA_VERSION
SQLITE_FCNTL_EXTERNAL_READER
SQLITE_FCNTL_FILE_POINTER
SQLITE_FCNTL_GET_LOCKPROXYFILE
SQLITE_FCNTL_HAS_MOVED
SQLITE_FCNTL_JOURNAL_POINTER
SQLITE_FCNTL_LAST_ERRNO
SQLITE_FCNTL_LOCK_TIMEOUT
SQLITE_FCNTL_LOCKSTATE
SQLITE_FCNTL_MMAP_SIZE
SQLITE_FCNTL_OVERWRITE
SQLITE_FCNTL_PDB
SQLITE_FCNTL_PERSIST_WAL
SQLITE_FCNTL_POWERSAFE_OVERWRITE
SQLITE_FCNTL_PRAGMA
SQLITE_FCNTL_RBU
SQLITE_FCNTL_RESERVE_BYTES
SQLITE_FCNTL_RESET_CACHE
SQLITE_FCNTL_ROLLBACK_ATOMIC_WRITE
SQLITE_FCNTL_SET_LOCKPROXYFILE
SQLITE_FCNTL_SIZE_HINT
SQLITE_FCNTL_SIZE_LIMIT
SQLITE_FCNTL_SYNC
SQLITE_FCNTL_SYNC_OMITTED
SQLITE_FCNTL_TEMPFILENAME
SQLITE_FCNTL_TRACE
SQLITE_FCNTL_VFS_POINTER
SQLITE_FCNTL_VFSNAME
SQLITE_FCNTL_WAL_BLOCK
SQLITE_FCNTL_WIN32_AV_RETRY
SQLITE_FCNTL_WIN32_GET_HANDLE
SQLITE_FCNTL_WIN32_SET_HANDLE
SQLITE_FCNTL_ZIPVFS
SQLITE_FLOAT
SQLITE_FORMAT
SQLITE_FTS3_MAX_EXPR_DEPTH
SQLITE_FULL
SQLITE_FUNCTION
SQLITE_HAVE_ISNAN
SQLITE_HAVE_ZLIB
SQLITE_IGNORE
SQLITE_INDEX_CONSTRAINT_EQ
SQLITE_INDEX_CONSTRAINT_FUNCTION
SQLITE_INDEX_CONSTRAINT_GE
SQLITE_INDEX_CONSTRAINT_GLOB
SQLITE_INDEX_CONSTRAINT_GT
SQLITE_INDEX_CONSTRAINT_IS
SQLITE_INDEX_CONSTRAINT_ISNOT
SQLITE_INDEX_CONSTRAINT_ISNOTNULL
SQLITE_INDEX_CONSTRAINT_ISNULL
SQLITE_INDEX_CONSTRAINT_LE
SQLITE_INDEX_CONSTRAINT_LIKE
SQLITE_INDEX_CONSTRAINT_LIMIT
SQLITE_INDEX_CONSTRAINT_LT
SQLITE_INDEX_CONSTRAINT_MATCH
SQLITE_INDEX_CONSTRAINT_NE
SQLITE_INDEX_CONSTRAINT_OFFSET
SQLITE_INDEX_CONSTRAINT_REGEXP
SQLITE_INDEX_SCAN_UNIQUE
SQLITE_INNOCUOUS
SQLITE_INSERT
sqlite_int64
SQLITE_INTEGER
SQLITE_INTERNAL
SQLITE_INTERRUPT
SQLITE_INTROSPECTION_PRAGMAS
SQLITE_IOCAP_ATOMIC
SQLITE_IOCAP_ATOMIC16K
SQLITE_IOCAP_ATOMIC1K
SQLITE_IOCAP_ATOMIC2K
SQLITE_IOCAP_ATOMIC32K
SQLITE_IOCAP_ATOMIC4K
SQLITE_IOCAP_ATOMIC512
SQLITE_IOCAP_ATOMIC64K
SQLITE_IOCAP_ATOMIC8K
SQLITE_IOCAP_BATCH_ATOMIC
SQLITE_IOCAP_IMMUTABLE
SQLITE_IOCAP_POWERSAFE_OVERWRITE
SQLITE_IOCAP_SAFE_APPEND
SQLITE_IOCAP_SEQUENTIAL
SQLITE_IOCAP_UNDELETABLE_WHEN_OPEN
SQLITE_IOERR
SQLITE_IOERR_ACCESS
SQLITE_IOERR_AUTH
SQLITE_IOERR_BEGIN_ATOMIC
SQLITE_IOERR_BLOCKED
SQLITE_IOERR_CHECKRESERVEDLOCK
SQLITE_IOERR_CLOSE
SQLITE_IOERR_COMMIT_ATOMIC
SQLITE_IOERR_CONVPATH
SQLITE_IOERR_CORRUPTFS
SQLITE_IOERR_DATA
SQLITE_IOERR_DELETE
SQLITE_IOERR_DELETE_NOENT
SQLITE_IOERR_DIR_CLOSE
SQLITE_IOERR_DIR_FSYNC
SQLITE_IOERR_FSTAT
SQLITE_IOERR_FSYNC
SQLITE_IOERR_GETTEMPPATH
SQLITE_IOERR_IN_PAGE
SQLITE_IOERR_LOCK
SQLITE_IOERR_MMAP
SQLITE_IOERR_NOMEM
SQLITE_IOERR_RDLOCK
SQLITE_IOERR_READ
SQLITE_IOERR_ROLLBACK_ATOMIC
SQLITE_IOERR_SEEK
SQLITE_IOERR_SHMLOCK
SQLITE_IOERR_SHMMAP
SQLITE_IOERR_SHMOPEN
SQLITE_IOERR_SHMSIZE
SQLITE_IOERR_SHORT_READ
SQLITE_IOERR_TRUNCATE
SQLITE_IOERR_UNLOCK
SQLITE_IOERR_VNODE
SQLITE_IOERR_WRITE
SQLITE_JSON_MAX_DEPTH
SQLITE_LIKE_DOESNT_MATCH_BLOBS
SQLITE_LIMIT_ATTACHED
SQLITE_LIMIT_COLUMN
SQLITE_LIMIT_COMPOUND_SELECT
SQLITE_LIMIT_EXPR_DEPTH
SQLITE_LIMIT_FUNCTION_ARG
SQLITE_LIMIT_LENGTH
SQLITE_LIMIT_LIKE_PATTERN_LENGTH
SQLITE_LIMIT_SQL_LENGTH
SQLITE_LIMIT_TRIGGER_DEPTH
SQLITE_LIMIT_VARIABLE_NUMBER
SQLITE_LIMIT_VDBE_OP
SQLITE_LIMIT_WORKER_THREADS
SQLITE_LOCK_EXCLUSIVE
SQLITE_LOCK_NONE
SQLITE_LOCK_PENDING
SQLITE_LOCK_RESERVED
SQLITE_LOCK_SHARED
SQLITE_LOCKED
SQLITE_LOCKED_SHAREDCACHE
SQLITE_LOCKED_VTAB
sqlite_master table
SQLITE_MAX_ALLOCATION_SIZE
SQLITE_MAX_ATTACHED
SQLITE_MAX_COLUMN
SQLITE_MAX_COMPOUND_SELECT
SQLITE_MAX_EXPR_DEPTH
SQLITE_MAX_FUNCTION_ARG
SQLITE_MAX_LENGTH
SQLITE_MAX_LIKE_PATTERN_LENGTH
SQLITE_MAX_MEMORY
SQLITE_MAX_MMAP_SIZE
SQLITE_MAX_PAGE_COUNT
SQLITE_MAX_SCHEMA_RETRY
SQLITE_MAX_SQL_LENGTH
SQLITE_MAX_TRIGGER_DEPTH
SQLITE_MAX_VARIABLE_NUMBER
SQLITE_MAX_WORKER_THREADS
SQLITE_MEMDB_DEFAULT_MAXSIZE
SQLITE_MEMDEBUG
sqlite_memstat
SQLITE_MEMSTAT virtual table
SQLITE_MINIMUM_FILE_DESCRIPTOR
SQLITE_MISMATCH
SQLITE_MISUSE
SQLITE_MUTEX_FAST
SQLITE_MUTEX_RECURSIVE
SQLITE_MUTEX_STATIC_APP1
SQLITE_MUTEX_STATIC_APP2
SQLITE_MUTEX_STATIC_APP3
SQLITE_MUTEX_STATIC_LRU
SQLITE_MUTEX_STATIC_LRU2
SQLITE_MUTEX_STATIC_MAIN
SQLITE_MUTEX_STATIC_MEM
SQLITE_MUTEX_STATIC_MEM2
SQLITE_MUTEX_STATIC_OPEN
SQLITE_MUTEX_STATIC_PMEM
SQLITE_MUTEX_STATIC_PRNG
SQLITE_MUTEX_STATIC_VFS1
SQLITE_MUTEX_STATIC_VFS2
SQLITE_MUTEX_STATIC_VFS3
SQLITE_NOLFS
SQLITE_NOMEM
SQLITE_NOTADB
SQLITE_NOTFOUND
SQLITE_NOTICE
SQLITE_NOTICE_RBU
SQLITE_NOTICE_RECOVER_ROLLBACK
SQLITE_NOTICE_RECOVER_WAL
SQLITE_NULL
sqlite_offset() SQL function
SQLITE_OK
SQLITE_OK_LOAD_PERMANENTLY
SQLITE_OK_SYMLINK
SQLITE_OMIT_ALTERTABLE
SQLITE_OMIT_ANALYZE
SQLITE_OMIT_ATTACH
SQLITE_OMIT_AUTHORIZATION
SQLITE_OMIT_AUTOINCREMENT
SQLITE_OMIT_AUTOINIT
SQLITE_OMIT_AUTOMATIC_INDEX
SQLITE_OMIT_AUTORESET
SQLITE_OMIT_AUTOVACUUM
SQLITE_OMIT_BETWEEN_OPTIMIZATION
SQLITE_OMIT_BLOB_LITERAL
SQLITE_OMIT_BTREECOUNT
SQLITE_OMIT_BUILTIN_TEST
SQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA
SQLITE_OMIT_CAST
SQLITE_OMIT_CHECK
SQLITE_OMIT_COMPILEOPTION_DIAGS
SQLITE_OMIT_COMPLETE
SQLITE_OMIT_COMPOUND_SELECT
SQLITE_OMIT_CTE
SQLITE_OMIT_DATETIME_FUNCS
SQLITE_OMIT_DECLTYPE
SQLITE_OMIT_DEPRECATED
SQLITE_OMIT_DESERIALIZE
SQLITE_OMIT_DISKIO
SQLITE_OMIT_EXPLAIN
SQLITE_OMIT_FLAG_PRAGMAS
SQLITE_OMIT_FLOATING_POINT
SQLITE_OMIT_FOREIGN_KEY
SQLITE_OMIT_GENERATED_COLUMNS
SQLITE_OMIT_GET_TABLE
SQLITE_OMIT_HEX_INTEGER
SQLITE_OMIT_INCRBLOB
SQLITE_OMIT_INTEGRITY_CHECK
SQLITE_OMIT_INTROSPECTION_PRAGMAS
SQLITE_OMIT_JSON
SQLITE_OMIT_LIKE_OPTIMIZATION
SQLITE_OMIT_LOAD_EXTENSION
SQLITE_OMIT_LOCALTIME
SQLITE_OMIT_LOOKASIDE
SQLITE_OMIT_MEMORYDB
SQLITE_OMIT_OR_OPTIMIZATION
SQLITE_OMIT_PAGER_PRAGMAS
SQLITE_OMIT_PRAGMA
SQLITE_OMIT_PROGRESS_CALLBACK
SQLITE_OMIT_QUICKBALANCE
SQLITE_OMIT_REINDEX
SQLITE_OMIT_SCHEMA_PRAGMAS
SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS
SQLITE_OMIT_SHARED_CACHE
SQLITE_OMIT_SUBQUERY
SQLITE_OMIT_TCL_VARIABLE
SQLITE_OMIT_TEMPDB
SQLITE_OMIT_TRACE
SQLITE_OMIT_TRIGGER
SQLITE_OMIT_TRUNCATE_OPTIMIZATION
SQLITE_OMIT_UTF16
SQLITE_OMIT_VACUUM
SQLITE_OMIT_VIEW
SQLITE_OMIT_VIRTUALTABLE
SQLITE_OMIT_WAL
SQLITE_OMIT_WINDOWFUNC
SQLITE_OMIT_WSD
SQLITE_OMIT_XFER_OPT
SQLITE_OPEN_AUTOPROXY
SQLITE_OPEN_CREATE
SQLITE_OPEN_DELETEONCLOSE
SQLITE_OPEN_EXCLUSIVE
SQLITE_OPEN_EXRESCODE
SQLITE_OPEN_FULLMUTEX
SQLITE_OPEN_MAIN_DB
SQLITE_OPEN_MAIN_JOURNAL
SQLITE_OPEN_MEMORY
SQLITE_OPEN_NOFOLLOW
SQLITE_OPEN_NOMUTEX
SQLITE_OPEN_PRIVATECACHE
SQLITE_OPEN_READONLY
SQLITE_OPEN_READWRITE
SQLITE_OPEN_SHAREDCACHE
SQLITE_OPEN_SUBJOURNAL
SQLITE_OPEN_SUPER_JOURNAL
SQLITE_OPEN_TEMP_DB
SQLITE_OPEN_TEMP_JOURNAL
SQLITE_OPEN_TRANSIENT_DB
SQLITE_OPEN_URI
SQLITE_OPEN_WAL
SQLITE_OS_OTHER
SQLITE_PERM
SQLITE_POWERSAFE_OVERWRITE
SQLITE_PRAGMA
SQLITE_PREPARE_NO_VTAB
SQLITE_PREPARE_NORMALIZE
SQLITE_PREPARE_PERSISTENT
SQLITE_PRINTF_PRECISION_LIMIT
SQLITE_PROTOCOL
SQLITE_QUERY_PLANNER_LIMIT
SQLITE_QUERY_PLANNER_LIMIT_INCR
SQLITE_RANGE
SQLITE_READ
SQLITE_READONLY
SQLITE_READONLY_CANTINIT
SQLITE_READONLY_CANTLOCK
SQLITE_READONLY_DBMOVED
SQLITE_READONLY_DIRECTORY
SQLITE_READONLY_RECOVERY
SQLITE_READONLY_ROLLBACK
SQLITE_RECURSIVE
SQLITE_REINDEX
SQLITE_REPLACE
SQLITE_RESULT_SUBTYPE
SQLITE_REVERSE_UNORDERED_SELECTS
SQLITE_ROLLBACK
SQLITE_ROW
SQLITE_RTREE_INT_ONLY
SQLITE_SAVEPOINT
SQLITE_SCANSTAT_COMPLEX
SQLITE_SCANSTAT_EST
SQLITE_SCANSTAT_EXPLAIN
SQLITE_SCANSTAT_NAME
SQLITE_SCANSTAT_NCYCLE
SQLITE_SCANSTAT_NLOOP
SQLITE_SCANSTAT_NVISIT
SQLITE_SCANSTAT_PARENTID
SQLITE_SCANSTAT_SELECTID
SQLITE_SCHEMA
sqlite_schema table
SQLITE_SECURE_DELETE
SQLITE_SELECT
sqlite_sequence
SQLITE_SERIALIZE_NOCOPY
SQLITE_SESSION_CONFIG_STRMSIZE
SQLITE_SESSION_OBJCONFIG_ROWID
SQLITE_SESSION_OBJCONFIG_SIZE
SQLITE_SHM_EXCLUSIVE
SQLITE_SHM_LOCK
SQLITE_SHM_NLOCK
SQLITE_SHM_SHARED
SQLITE_SHM_UNLOCK
SQLITE_SORTER_PMASZ
SQLITE_SOUNDEX
SQLITE_SOURCE_ID
sqlite_source_id() SQL function
sqlite_stat1
sqlite_stat2
sqlite_stat3
sqlite_stat4
SQLITE_STATIC
SQLITE_STATUS_MALLOC_COUNT
SQLITE_STATUS_MALLOC_SIZE
SQLITE_STATUS_MEMORY_USED
SQLITE_STATUS_PAGECACHE_OVERFLOW
SQLITE_STATUS_PAGECACHE_SIZE
SQLITE_STATUS_PAGECACHE_USED
SQLITE_STATUS_PARSER_STACK
SQLITE_STATUS_SCRATCH_OVERFLOW
SQLITE_STATUS_SCRATCH_SIZE
SQLITE_STATUS_SCRATCH_USED
SQLITE_STDCALL
sqlite_stmt
SQLITE_STMT virtual table
SQLITE_STMTJRNL_SPILL
SQLITE_STMTSTATUS counter
SQLITE_STMTSTATUS_AUTOINDEX
SQLITE_STMTSTATUS_FILTER HIT
SQLITE_STMTSTATUS_FILTER_HIT
SQLITE_STMTSTATUS_FILTER_MISS
SQLITE_STMTSTATUS_FULLSCAN_STEP
SQLITE_STMTSTATUS_MEMUSED
SQLITE_STMTSTATUS_REPREPARE
SQLITE_STMTSTATUS_RUN
SQLITE_STMTSTATUS_SORT
SQLITE_STMTSTATUS_VM_STEP
SQLITE_STRICT_SUBTYPE
SQLITE_SUBTYPE
SQLITE_SYNC_DATAONLY
SQLITE_SYNC_FULL
SQLITE_SYNC_NORMAL
SQLITE_SYSAPI
SQLITE_TCLAPI
sqlite_temp_schema
SQLITE_TEMP_STORE
SQLITE_TESTCTRL_ALWAYS
SQLITE_TESTCTRL_ASSERT
SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS
SQLITE_TESTCTRL_BITVEC_TEST
SQLITE_TESTCTRL_BYTEORDER
SQLITE_TESTCTRL_EXPLAIN_STMT
SQLITE_TESTCTRL_EXTRA_SCHEMA_CHECKS
SQLITE_TESTCTRL_FAULT_INSTALL
SQLITE_TESTCTRL_FIRST
SQLITE_TESTCTRL_FK_NO_ACTION
SQLITE_TESTCTRL_IMPOSTER
SQLITE_TESTCTRL_INTERNAL_FUNCTIONS
SQLITE_TESTCTRL_ISINIT
SQLITE_TESTCTRL_ISKEYWORD
SQLITE_TESTCTRL_JSON_SELFCHECK
SQLITE_TESTCTRL_LAST
SQLITE_TESTCTRL_LOCALTIME_FAULT
SQLITE_TESTCTRL_LOGEST
SQLITE_TESTCTRL_NEVER_CORRUPT
SQLITE_TESTCTRL_ONCE_RESET_THRESHOLD
SQLITE_TESTCTRL_OPTIMIZATIONS
SQLITE_TESTCTRL_PARSER_COVERAGE
SQLITE_TESTCTRL_PENDING_BYTE
SQLITE_TESTCTRL_PRNG_RESET
SQLITE_TESTCTRL_PRNG_RESTORE
SQLITE_TESTCTRL_PRNG_SAVE
SQLITE_TESTCTRL_PRNG_SEED
SQLITE_TESTCTRL_RESERVE
SQLITE_TESTCTRL_RESULT_INTREAL
SQLITE_TESTCTRL_SCRATCHMALLOC
SQLITE_TESTCTRL_SEEK_COUNT
SQLITE_TESTCTRL_SORTER_MMAP
SQLITE_TESTCTRL_TRACEFLAGS
SQLITE_TESTCTRL_TUNE
SQLITE_TESTCTRL_USELONGDOUBLE
SQLITE_TESTCTRL_VDBE_COVERAGE
SQLITE_TEXT
SQLITE_THREADSAFE
SQLITE_TOOBIG
SQLITE_TRACE
SQLITE_TRACE_CLOSE
SQLITE_TRACE_PROFILE
SQLITE_TRACE_ROW
SQLITE_TRACE_SIZE_LIMIT
SQLITE_TRACE_STMT
SQLITE_TRANSACTION
SQLITE_TRANSIENT
SQLITE_TRUSTED_SCHEMA
SQLITE_TXN_NONE
SQLITE_TXN_READ
SQLITE_TXN_WRITE
sqlite_uint64
SQLITE_UNTESTABLE
SQLITE_UPDATE
SQLITE_USE_ALLOCA
SQLITE_USE_FCNTL_TRACE
SQLITE_USE_SEH
SQLITE_USE_URI
SQLITE_UTF16
SQLITE_UTF16_ALIGNED
SQLITE_UTF16BE
SQLITE_UTF16LE
SQLITE_UTF8
SQLITE_VERSION
sqlite_version() SQL function
SQLITE_VERSION_NUMBER
SQLITE_VTAB_CONSTRAINT_SUPPORT
SQLITE_VTAB_DIRECTONLY
SQLITE_VTAB_INNOCUOUS
SQLITE_VTAB_USES_ALL_SCHEMAS
SQLITE_WARNING
SQLITE_WARNING_AUTOINDEX
SQLITE_WIN32_DATA_DIRECTORY_TYPE
SQLITE_WIN32_HEAP_CREATE
SQLITE_WIN32_MALLOC
SQLITE_WIN32_MALLOC_VALIDATE
SQLITE_WIN32_TEMP_DIRECTORY_TYPE
SQLITE_ZERO_MALLOC
sqrt() SQL function
stale file descriptor
standard query parameters
statement journal
static ANALYZE results
statically linked extensions
stats pragma
status method
status parameters
storage class
strategies
strftime()
strftime() SQL function
STRICT
STRICT table
strict type checking
string_agg
string_agg() aggregate function
subprograms
Subqueries
subquery co-routines
subsec modifier
subsecond modifier
substr() SQL function
sum() aggregate function
super-journal
swarmvtab
swarmvtab context
synchronous pragma
syntax diagrams
table b-tree
table data format
table-constraint
table-constraint syntax diagram
table-options
table-options syntax diagram
table-or-subquery
table-or-subquery syntax diagram
table-valued function
table-valued functions in the FROM clause
table_info pragma
table_list pragma
table_xinfo pragma
.tables
tables_used virtual table
tan() SQL function
tanh() SQL function
Tcl extension
TCL Interface
TCL interface authorizer method
TCL interface backup method
TCL interface bind_fallback method
TCL interface busy method
TCL interface cache method
TCL interface changes method
TCL interface close method
TCL interface collate method
TCL interface collation_needed method
TCL interface commit_hook method
TCL interface complete method
TCL interface config method
TCL interface copy method
TCL interface deserialize method
TCL interface enable_load_extension method
TCL interface errorcode method
TCL interface eval method
TCL interface exists method
TCL interface function method
TCL interface incrblob method
TCL interface interrupt method
TCL interface last_insert_rowid method
TCL interface nullvalue method
TCL interface onecolumn method
TCL interface preupdate method
TCL interface profile method
TCL interface progress method
TCL interface restore method
TCL interface rollback_hook method
TCL interface serialize method
TCL interface status method
TCL interface timeout method
TCL interface total_changes method
TCL interface trace method
TCL interface trace_v2 method
TCL interface transaction method
TCL interface unlock_notify method
TCL interface update_hook method
TCL interface version method
TCL interface wal_hook method
TCL test suite
TCL variable substitution
TEA tarball
TEMP triggers on non-TEMP tables
temp_store pragma
temp_store_directory pragma
temporary databases
temporary directory search algorithm
temporary disk files
temporary tables
test coverage
test harness
test suite
testcase macros
testing
text encoding
TH3
the -> and ->> operators
the -> operator
the .fullschema dot-command
the amalgamation
the ext3 barrier problem
The Fossil NGQP Upgrade Case Study
the json1 extension
the SQLITE_DBPAGE extension
the SQLITE_MEMSTAT extension
the SQLITE_STMT extension
The Use Of assert() In SQLite
the xCachesize() page cache method
the xCreate() page cache methods
the xDestroy() page cache method
the xFetch() page cache methods
the xInit() page cache method
the xPagecount() page cache methods
the xRekey() page cache methods
the xShrink() page cache method
the xShutdown() page cache method
the xUnpin() page cache method
Things That Can Go Wrong
threading mode
threads pragma
three test harnesses
time shift modifiers
time value
time()
time() SQL function
time-value
timediff()
timediff() SQL function
timeout method
tokenizer
torn page
total() aggregate function
total_changes method
total_changes() SQL function
trace method
trace_v2 method
transaction
transaction method
transaction state
transactional
treats the CROSS JOIN operator specially
trigger
trigram indexes
trigram tokenizer
trim() SQL function
trunc() SQL function
truncate optimization
trusted_schema pragma
type affinity
type-name
type-name syntax diagram
typeof() SQL function
UINT
UINT collating sequence
undefined BEFORE trigger behavior
undo/redo
unhex() SQL function
unicode() SQL function
unicode61
Uniform Resource Identifier
unindexed
UNION virtual table
union-vtab
unionvtab
UNIQUE
unique constraint
unique index
unixepoch modifier
unixepoch()
unixepoch() function
unixepoch() SQL function
unlikely() SQL function
unlink corruption
unlinked database files
unlock_notify method
unprotected sqlite3_value
unsafe-testing command-line option
--unsafe-testing command-line option
untrusted database files
UPDATE
UPDATE FROM
--update option
UPDATE trigger
update-stmt
update-stmt syntax diagram
update-stmt-limited
update-stmt-limited syntax diagram
update_hook method
upper() SQL function
upsert clause
UPSERT parsing ambiguity
upsert-clause
upsert-clause syntax diagram
URI
URI filename
URI filename examples
URI filenames in sqlite3_open()
URI query parameters
usable size
use of shared cache mode is discouraged
user-defined window functions
user_version pragma
using SQLite for websites
Using the SQLite Online Backup API
Using the SQLite Unlock Notification Feature
'utc' and 'localtime' modifiers
'utc' modifier
vacuum
VACUUM INTO
vacuum-stmt
vacuum-stmt syntax diagram
value argument
VALUES
VALUES clause
variable-length integer
varint
VDBE
vdbe_addoptrace pragma
vdbe_debug pragma
vdbe_listing pragma
vdbe_trace pragma
vectors
Version 3.0.0
Version 3.0.1
Version 3.0.2
Version 3.0.3
Version 3.0.4
Version 3.0.5
Version 3.0.6
Version 3.0.7
Version 3.0.8
Version 3.1.0
Version 3.1.1
Version 3.1.2
Version 3.1.3
Version 3.1.4
Version 3.1.5
Version 3.1.6
Version 3.10.0
Version 3.10.1
Version 3.10.2
Version 3.11.0
Version 3.11.1
Version 3.12.0
version 3.12.0 page size change
Version 3.12.1
Version 3.12.2
Version 3.13.0
Version 3.13.0.0
Version 3.14
Version 3.14.0
Version 3.14.1
Version 3.14.2
Version 3.15.0
Version 3.15.1
Version 3.15.2
Version 3.16.0
Version 3.16.1
Version 3.16.2
Version 3.17.0
Version 3.18.0
Version 3.18.1
Version 3.18.2
Version 3.19.0
Version 3.19.1
Version 3.19.2
Version 3.19.3
Version 3.2.0
Version 3.2.1
Version 3.2.2
Version 3.2.3
Version 3.2.4
Version 3.2.5
Version 3.2.6
Version 3.2.7
Version 3.2.8
Version 3.20.0
Version 3.20.1
Version 3.21.0
Version 3.22.0
Version 3.23.0
Version 3.23.0.0
Version 3.23.1
Version 3.23.1.0
Version 3.24.0
Version 3.25.0
Version 3.25.1
Version 3.25.2
Version 3.25.3
Version 3.26.0
Version 3.27.0
Version 3.27.1
Version 3.27.2
Version 3.28.0
Version 3.29.0
Version 3.3.0
Version 3.3.0.0
Version 3.3.1
Version 3.3.1.0
Version 3.3.10
Version 3.3.10.0
Version 3.3.11
Version 3.3.11.0
Version 3.3.12
Version 3.3.12.0
Version 3.3.13
Version 3.3.13.0
Version 3.3.14
Version 3.3.14.0
Version 3.3.15
Version 3.3.15.0
Version 3.3.16
Version 3.3.16.0
Version 3.3.17
Version 3.3.17.0
Version 3.3.2
Version 3.3.2.0
Version 3.3.3
Version 3.3.3.0
Version 3.3.4
Version 3.3.4.0
Version 3.3.5
Version 3.3.5.0
Version 3.3.6
Version 3.3.6.0
Version 3.3.7
Version 3.3.7.0
Version 3.3.8
Version 3.3.8.0
Version 3.3.9
Version 3.3.9.0
Version 3.30.0
Version 3.30.1
Version 3.31.0
Version 3.31.1
Version 3.32.0
Version 3.32.1
Version 3.32.2
Version 3.32.3
Version 3.33.0
Version 3.33.0.0
Version 3.34.0
Version 3.34.1
Version 3.35.0
Version 3.35.1
Version 3.35.2
Version 3.35.3
Version 3.35.4
Version 3.35.5
Version 3.36.0
Version 3.37.0
Version 3.37.1
Version 3.37.2
Version 3.38.0
Version 3.38.1
Version 3.38.2
Version 3.38.3
Version 3.38.4
Version 3.38.5
Version 3.39.0
Version 3.39.1
Version 3.39.2
Version 3.39.3
Version 3.39.4
Version 3.4.0
Version 3.4.1
Version 3.4.2
Version 3.40.0
Version 3.40.1
Version 3.41.0
Version 3.41.1
Version 3.41.2
Version 3.42.0
Version 3.43.0
Version 3.43.0.0
Version 3.43.1
Version 3.43.1.0
Version 3.43.2
Version 3.43.2.0
Version 3.44.0
Version 3.44.1
Version 3.44.2
Version 3.45.0
Version 3.45.1
Version 3.45.2
Version 3.45.3
Version 3.46.0
Version 3.5.0
Version 3.5.1
Version 3.5.2
Version 3.5.3
Version 3.5.4
Version 3.5.5
Version 3.5.6
Version 3.5.7
Version 3.5.8
Version 3.5.9
Version 3.6.0
Version 3.6.1
Version 3.6.10
Version 3.6.11
Version 3.6.12
Version 3.6.13
Version 3.6.14
Version 3.6.14.1
Version 3.6.14.2
Version 3.6.15
Version 3.6.16
Version 3.6.16.1
Version 3.6.17
Version 3.6.18
Version 3.6.19
Version 3.6.2
Version 3.6.20
Version 3.6.21
Version 3.6.22
Version 3.6.23
Version 3.6.23.1
Version 3.6.23.1.0
Version 3.6.3
Version 3.6.4
Version 3.6.5
Version 3.6.6
Version 3.6.6.1
Version 3.6.6.2
Version 3.6.7
Version 3.6.8
Version 3.6.9
Version 3.7.0
Version 3.7.0.1
Version 3.7.1
Version 3.7.10
Version 3.7.11
Version 3.7.12
Version 3.7.12.1
Version 3.7.13
Version 3.7.14
Version 3.7.14.1
Version 3.7.15
Version 3.7.15.1
Version 3.7.15.2
Version 3.7.16
Version 3.7.16.1
Version 3.7.16.2
Version 3.7.17
Version 3.7.2
Version 3.7.3
Version 3.7.4
Version 3.7.5
Version 3.7.6
Version 3.7.6.1
Version 3.7.6.2
Version 3.7.6.3
Version 3.7.7
Version 3.7.7.1
Version 3.7.8
Version 3.7.9
Version 3.8.0
Version 3.8.0.1
Version 3.8.0.2
Version 3.8.1
Version 3.8.10
Version 3.8.10.1
Version 3.8.10.2
Version 3.8.11
Version 3.8.11.1
Version 3.8.2
Version 3.8.3
Version 3.8.3.1
Version 3.8.3.1.0
Version 3.8.4
Version 3.8.4.1
Version 3.8.4.2
Version 3.8.4.3
Version 3.8.5
Version 3.8.6
Version 3.8.7
Version 3.8.7.1
Version 3.8.7.2
Version 3.8.7.3
Version 3.8.7.4
Version 3.8.8
Version 3.8.8.1
Version 3.8.8.2
Version 3.8.8.3
Version 3.8.9
Version 3.9.0
Version 3.9.1
Version 3.9.2
Version 3.9.3
version method
version numbering conventions
version-valid-for number
VFS
VFS shim
"vfs" query parameter
VFSes
view
virtual machine
virtual machine instructions
virtual table
virtual table configuration option
virtual table cursor
virtual table list
virtual table module
vulnerabilities
WAL
WAL backwards compatibility
WAL checksum algorithm
WAL concurrency
WAL file
WAL file format
WAL format
WAL mode
WAL read algorithm
WAL reset
WAL without shared memory
wal-index
WAL-index File Format
WAL-index format
WAL-mode crash recovery
WAL-mode File Format
WAL-mode locks
WAL-mode read blocking
wal_autocheckpoint pragma
wal_checkpoint pragma
wal_hook method
Warranty of Title
What If OpenOffice Used SQLite
when to use WITHOUT ROWID
WHERE clause
WHERE-clause push-down optimization
why ALTER TABLE is so difficult
Why SQLite Uses Bytecode
Win32 native memory allocator
window chaining
window function
window-defn
window-defn syntax diagram
window-function-invocation
window-function-invocation syntax diagram
WITH clause
with-clause
with-clause syntax diagram
WITHOUT rowid
WITHOUT ROWID virtual table
wrapping text
writable_schema pragma
write-ahead log
writer starvation
xBegin
xBestIndex
xColumn
xCommit
xConnect
xCreate
xDestroy
xDisconnect
xEof
xFilter
xFindFunction
xIntegrity
xIntegrity method
xNext
xQueryFunc R*Tree callback
xRelease
xRename
xRollback
xRollbackTo
xRowid
xSavepoint
xShadowName
xUpdate
YYSTACKDEPTH
YYTRACKMAXSTACKDEPTH
zero-configuration
zero-malloc memory allocator
zeroblob() SQL function
ZIP file as database
zipfile
Zipfile virtual table
This page last modified on
2022-01-08 05:02:57
UTC