Small. Fast. Reliable.
Choose any three.
About
Sitemap
Documentation
Download
License
News
Support
Website Keyword Index
Other Documentation Indices:
Categorical Document List
Books About SQLite
Alphabetical List Of Documents
Permuted Document Title Index
"automerge" command
"merge" command
"optimize" command
"rebuild" command
abs() SQL function
affinity
Aggregate Functions
alphabetical listing of SQLite documents
ALTER TABLE
alter-table-stmt syntax diagram
amalgamation
amalgamation tarball
ANALYZE
analyze-stmt syntax diagram
application file-format
application-defined SQL function
asynchronous I/O backend
asynchronous VFS
atomic commit
ATTACH DATABASE
attach-stmt syntax diagram
auto_vacuum pragma
autocommit mode
AUTOINCREMENT
automatic indexing
Automatic indexing
automatic_index pragma
avg() aggregate function
backup API
BEGIN TRANSACTION
begin-stmt syntax diagram
BETWEEN
BINARY collating function
binary operators
BLOB handle
books about SQLite
boolean datatype
boolean expression
bound parameter
btree design
build product names
building the amalgamation
built-in memory allocators
C-API function list
C-language Interface
cache_size pragma
CASE expression
case_sensitive_like pragma
CAST expression
categorical listing of SQLite documents
cell format summary
cell payload
change counter
changes() SQL function
CHECK
CHECK constraint
checkpoint
checkpoint_fullfsync pragma
checkpointed
checkpointing
child key
child table
CLI
coalesce() SQL function
COLLATE operator
collating function
collation_list pragma
column access functions
column affinity
column definition
column-constraint syntax diagram
column-def syntax diagram
Command Line Interface
command-line shell
commands
comment
comment-syntax syntax diagram
COMMIT
commit-stmt syntax diagram
comparison affinity rules
comparison expressions
compile fts
compile-time options
compile_options pragma
compiling the CLI
compiling the TCL interface
compound query
compound select
compound-operator syntax diagram
compressed FTS4 content
configuration option
conflict clause
conflict-clause syntax diagram
constraints
Core Functions
core URI query parameters
count() aggregate function
count_changes pragma
covering index
covering indices
CREATE INDEX
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
CREATE VIRTUAL TABLE
create-index-stmt syntax diagram
create-table-stmt syntax diagram
create-trigger-stmt syntax diagram
create-view-stmt syntax diagram
create-virtual-table-stmt syntax diagram
custom builds
custom r-tree queries
data_store_directory pragma
database connection
database corruption caused by inconsistent use of 8+3 filenames
database header
Database Object Name Resolution
database_list pragma
datatype
date and time datatype
Date And Time Functions
date() SQL function
datetime() SQL function
debugging memory allocator
default memory allocator
default_cache_size pragma
DELETE
delete-stmt syntax diagram
delete-stmt-limited syntax diagram
deleting a hot journal
deprecated
descending index
descending indices
DETACH DATABASE
detach-stmt syntax diagram
DISTINCT
download page
DROP INDEX
DROP TABLE
DROP TRIGGER
DROP VIEW
drop-index-stmt syntax diagram
drop-table-stmt syntax diagram
drop-trigger-stmt syntax diagram
drop-view-stmt syntax diagram
dynamic typing
empty_result_callbacks pragma
encoding pragma
enhanced query syntax
error code
ESCAPE
EXCLUSIVE lock
EXISTS operator
experimental
experimental memory allocators
EXPLAIN
explain query plan
EXPLAIN QUERY PLAN
expr syntax diagram
expression affinity
expression syntax
extended error code
extended result code
file format
file I/O
file locking and concurrency control
file locking states
flattening optimization
footprint
foreign key actions
foreign key constraint
FOREIGN KEY constraints
foreign key constraints are enabled
foreign-key-clause syntax diagram
foreign_key_list pragma
foreign_keys pragma
free-page list
freelist
freelist_count pragma
FROM clause
FTS auxiliary functions
FTS hidden column
FTS MATCH
FTS shadow tables
FTS3
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 content option
FTS4 languageid option
fts4 languageid option
FTS4 matchinfo option
fts4 matchinfo option
FTS4 options
FTS4 order option
FTS4 prefix option
fts4 prefix option
fts4aux
full-text search
full_column_names pragma
fullfsync pragma
function creation routines
GLOB
glob() SQL function
GROUP BY
group_concat() aggregate function
hex() SQL function
hidden column
host parameter
host parameter name
hot journal
how to compile
how to corrupt
How To Corrupt Your Database Files
ifnull() SQL function
ignore_check_constraints pragma
IN operator
in-header database size
in-memory database
in-memory shared cache database
in-memory shared-cache
incremental_vacuum pragma
index_info pragma
index_list pragma
INDEXED BY
indexed-column syntax diagram
indexing
indexing tutorial
INSERT
insert-stmt syntax diagram
INSTEAD OF
INSTEAD OF trigger
INTEGER PRIMARY KEY
integer-valued r-trees
integrity_check pragma
internal index
internal indices
internal schema object
internal table
IS NOT operator
IS operator
join order
join-constraint syntax diagram
join-op syntax diagram
join-source syntax diagram
journal_mode pragma
journal_size_limit pragma
julianday() SQL function
keyword index
last_insert_rowid() SQL function
legacy_file_format pragma
length() SQL function
library size
LIKE
LIKE optimization
like() SQL function
limit category
limits
literal value
literal-value syntax diagram
load_extension() SQL function
locking_mode pragma
lookaside memory allocator
lower() SQL function
ltrim() SQL function
mailing lists
MATCH
matchinfo
max() aggregate function
max() SQL function
max_page_count pragma
MC/DC testing
memory
memory allocation
memory statistics
min() aggregate function
min() SQL function
NOCASE collating function
NOT EXISTS operator
NOT IN operator
NOT INDEXED
NOT NULL
NOT NULL constraint
nullif() SQL function
numeric-literal syntax diagram
object resolution
offsets
omitfeatures
ON CONFLICT
ON CONFLICT clause
optimizer
or optimization
or-connected-terms
order by
ordering-term syntax diagram
OS backend
overflow page
page cache
page_count pragma
page_size pragma
pagecache memory allocator
parameter
parameter binding
parent key
parent table
parser_trace pragma
PENDING lock
permuted index
porting SQLite
powersafe overwrite
PRAGMA
PRAGMA auto_vacuum
PRAGMA automatic_index
PRAGMA cache_size
PRAGMA case_sensitive_like
PRAGMA checkpoint_fullfsync
PRAGMA collation_list
PRAGMA compile_options
PRAGMA count_changes
PRAGMA data_store_directory
PRAGMA database_list
PRAGMA default_cache_size
PRAGMA empty_result_callbacks
PRAGMA encoding
PRAGMA foreign_key_list
PRAGMA foreign_keys
PRAGMA freelist_count
PRAGMA full_column_names
PRAGMA fullfsync
PRAGMA ignore_check_constraints
PRAGMA incremental_vacuum
PRAGMA index_info
PRAGMA index_list
PRAGMA integrity_check
PRAGMA journal_mode
PRAGMA journal_size_limit
PRAGMA legacy_file_format
pragma list
PRAGMA locking_mode
PRAGMA max_page_count
PRAGMA page_count
PRAGMA page_size
PRAGMA parser_trace
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 synchronous
PRAGMA table_info
PRAGMA temp_store
PRAGMA temp_store_directory
PRAGMA user_version
PRAGMA vdbe_listing
PRAGMA vdbe_trace
PRAGMA wal_autocheckpoint
PRAGMA wal_checkpoint
PRAGMA writable_schema
pragma-stmt syntax diagram
pragma-value syntax diagram
prefix queries
prefix query
prepared statement
PRIMARY KEY
PRIMARY KEY constraint
private branches
professional support
protected sqlite3_value
PSOW
qualified-table-name syntax diagram
query
query parameters with special meaning to SQLite
query planner
Quick Start Guide
quick_check pragma
quote() SQL function
R-Tree extension
R-Trees
raise-function syntax diagram
random() SQL function
randomblob() SQL function
range query optimization
read-only WAL databases
read_uncommitted pragma
record format
recursive_triggers pragma
REGEXP
REINDEX
reindex-stmt syntax diagram
RELEASE
release-stmt syntax diagram
relfootprint
REPLACE
replace() SQL function
RESERVED lock
result code
result-column syntax diagram
result-set expressions
reverse_unordered_selects pragma
Robson proof
ROLLBACK
rollback journal
rollback journal format
rollback-stmt syntax diagram
round() SQL function
ROWID
rowid
RTRIM collating function
rtrim() SQL function
rules for determining column affinity
SAVEPOINT
savepoint-stmt syntax diagram
schema format number
schema_version pragma
scratch memory allocator
search application tips
second edition file format document
secure_delete pragma
segment btree
SELECT
select-core syntax diagram
select-stmt syntax diagram
serial type
Session Module C-API function list
Session Module C-language Interface
shadow tables
shadowtabs
shared cache
shared cache mode
SHARED lock
short filenames
short_column_names pragma
shrink_memory pragma
signed-number syntax diagram
simple fts queries
single-source syntax diagram
SLT
snippet
sorting
soundex() SQL function
SQL Logic Tests
SQL parameter
SQL statement compiler
sql-stmt syntax diagram
sql-stmt-list syntax diagram
SQLite Consortium
SQLite Keywords
SQLite Shared-Cache Mode
sqlite3
sqlite3_aggregate_context
sqlite3_aggregate_count
sqlite3_auto_extension
sqlite3_backup
sqlite3_backup__remaining()
sqlite3_backup_finish()
sqlite3_backup_init()
sqlite3_backup_pagecount()
sqlite3_backup_remaining
sqlite3_backup_step()
sqlite3_bind_blob
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_text
sqlite3_bind_text16
sqlite3_bind_value
sqlite3_bind_zeroblob
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_changes
sqlite3_clear_bindings
sqlite3_close
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_function
sqlite3_create_function16
sqlite3_create_function_v2
sqlite3_create_module
sqlite3_create_module_v2
sqlite3_data_count
sqlite3_data_directory
sqlite3_db_config
sqlite3_db_filename
sqlite3_db_handle
sqlite3_db_mutex
sqlite3_db_readonly
sqlite3_db_release_memory
sqlite3_db_status
sqlite3_declare_vtab
sqlite3_enable_load_extension
sqlite3_enable_shared_cache
sqlite3_errcode
sqlite3_errmsg
sqlite3_errmsg16
sqlite3_exec
sqlite3_expired
sqlite3_extended_errcode
sqlite3_extended_result_codes
sqlite3_file
sqlite3_file_control
sqlite3_finalize
sqlite3_free
sqlite3_free_table
sqlite3_get_autocommit
sqlite3_get_auxdata
sqlite3_get_table
sqlite3_global_recover
sqlite3_index_info
sqlite3_initialize
sqlite3_int64
sqlite3_interrupt
sqlite3_io_methods
sqlite3_last_insert_rowid
sqlite3_libversion
sqlite3_libversion_number
sqlite3_limit
sqlite3_load_extension
sqlite3_log
sqlite3_malloc
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.xNext
sqlite3_module.xOpen
sqlite3_module.xRename
sqlite3_module.xRollback
sqlite3_module.xRowid
sqlite3_module.xSavepoint
sqlite3_module.xSync
sqlite3_module.xUpdate
sqlite3_mprintf
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_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_prepare_v2
sqlite3_profile
sqlite3_progress_handler
sqlite3_randomness
sqlite3_realloc
sqlite3_release_memory
sqlite3_reset
sqlite3_reset_auto_extension
sqlite3_result_blob
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_text
sqlite3_result_text16
sqlite3_result_text16be
sqlite3_result_text16le
sqlite3_result_value
sqlite3_result_zeroblob
sqlite3_rollback_hook
sqlite3_set_authorizer
sqlite3_set_auxdata
sqlite3_shutdown
sqlite3_sleep
sqlite3_snprintf
sqlite3_soft_heap_limit
sqlite3_soft_heap_limit64
sqlite3_sourceid
sqlite3_sql
sqlite3_status
sqlite3_step
sqlite3_stmt
sqlite3_stmt_busy
sqlite3_stmt_readonly
sqlite3_stmt_status
sqlite3_stricmp
sqlite3_strnicmp
sqlite3_table_column_metadata
sqlite3_temp_directory
sqlite3_test_control
sqlite3_thread_cleanup
sqlite3_threadsafe
sqlite3_total_changes
sqlite3_trace
sqlite3_transfer_bindings
sqlite3_uint64
sqlite3_unlock_notify
sqlite3_update_hook
sqlite3_uri_boolean
sqlite3_uri_int64
sqlite3_uri_parameter
sqlite3_user_data
sqlite3_value
sqlite3_value_blob
sqlite3_value_bytes
sqlite3_value_bytes16
sqlite3_value_double
sqlite3_value_int
sqlite3_value_int64
sqlite3_value_numeric_type
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_config
sqlite3_vtab_cursor
sqlite3_vtab_on_conflict
sqlite3_wal_autocheckpoint
sqlite3_wal_checkpoint
sqlite3_wal_checkpoint_v2
sqlite3_wal_hook
SQLITE_4_BYTE_ALIGNED_MALLOC
SQLITE_ABORT
SQLITE_ABORT_ROLLBACK
SQLITE_ACCESS_EXISTS
SQLITE_ACCESS_READ
SQLITE_ACCESS_READWRITE
SQLITE_ALTER_TABLE
SQLITE_ANALYZE
SQLITE_ANY
SQLITE_ATTACH
SQLITE_AUTH
SQLITE_BLOB
SQLITE_BUSY
SQLITE_BUSY_RECOVERY
SQLITE_CANTOPEN
SQLITE_CANTOPEN_ISDIR
SQLITE_CANTOPEN_NOTEMPDIR
SQLITE_CASE_SENSITIVE_LIKE
SQLITE_CHECKPOINT_FULL
SQLITE_CHECKPOINT_PASSIVE
SQLITE_CHECKPOINT_RESTART
sqlite_compileoption_get() SQL function
sqlite_compileoption_used() SQL function
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_MEMSTATUS
SQLITE_CONFIG_MULTITHREAD
SQLITE_CONFIG_MUTEX
SQLITE_CONFIG_PAGECACHE
SQLITE_CONFIG_PCACHE
SQLITE_CONFIG_PCACHE2
SQLITE_CONFIG_SCRATCH
SQLITE_CONFIG_SERIALIZED
SQLITE_CONFIG_SINGLETHREAD
SQLITE_CONFIG_URI
SQLITE_CONSTRAINT
SQLITE_COPY
SQLITE_CORRUPT
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_ENABLE_FKEY
SQLITE_DBCONFIG_ENABLE_TRIGGER
SQLITE_DBCONFIG_LOOKASIDE
SQLITE_DBSTATUS options
SQLITE_DBSTATUS_CACHE_HIT
SQLITE_DBSTATUS_CACHE_MISS
SQLITE_DBSTATUS_CACHE_USED
SQLITE_DBSTATUS_CACHE_WRITE
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_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_MEMSTATUS
SQLITE_DEFAULT_PAGE_SIZE
SQLITE_DEFAULT_TEMP_CACHE_SIZE
SQLITE_DEFAULT_WAL_AUTOCHECKPOINT
SQLITE_DELETE
SQLITE_DENY
SQLITE_DETACH
SQLITE_DIRECT_OVERFLOW_READ
SQLITE_DISABLE_DIRSYNC
SQLITE_DISABLE_FTS3_UNICODE
SQLITE_DISABLE_LFS
SQLITE_DONE
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_ATOMIC_WRITE
SQLITE_ENABLE_COLUMN_METADATA
SQLITE_ENABLE_FTS3
SQLITE_ENABLE_FTS3_PARENTHESIS
SQLITE_ENABLE_FTS4
SQLITE_ENABLE_ICU
SQLITE_ENABLE_IOTRACE
SQLITE_ENABLE_LOCKING_STYLE
SQLITE_ENABLE_MEMORY_MANAGEMENT
SQLITE_ENABLE_MEMSYS3
SQLITE_ENABLE_MEMSYS5
SQLITE_ENABLE_RTREE
SQLITE_ENABLE_STAT2
SQLITE_ENABLE_STAT3
SQLITE_ENABLE_TREE_EXPLAIN
SQLITE_ENABLE_UNLOCK_NOTIFY
SQLITE_ENABLE_UPDATE_DELETE_LIMIT
SQLITE_ERROR
SQLITE_FAIL
SQLITE_FCNTL_CHUNK_SIZE
SQLITE_FCNTL_FILE_POINTER
SQLITE_FCNTL_LOCKSTATE
SQLITE_FCNTL_OVERWRITE
SQLITE_FCNTL_PERSIST_WAL
SQLITE_FCNTL_POWERSAFE_OVERWRITE
SQLITE_FCNTL_PRAGMA
SQLITE_FCNTL_SIZE_HINT
SQLITE_FCNTL_SYNC_OMITTED
SQLITE_FCNTL_VFSNAME
SQLITE_FCNTL_WIN32_AV_RETRY
SQLITE_FLOAT
SQLITE_FORMAT
SQLITE_FULL
SQLITE_FUNCTION
SQLITE_GET_LOCKPROXYFILE
SQLITE_HAVE_ISNAN
SQLITE_IGNORE
SQLITE_INDEX_CONSTRAINT_EQ
SQLITE_INDEX_CONSTRAINT_GE
SQLITE_INDEX_CONSTRAINT_GT
SQLITE_INDEX_CONSTRAINT_LE
SQLITE_INDEX_CONSTRAINT_LT
SQLITE_INDEX_CONSTRAINT_MATCH
SQLITE_INSERT
sqlite_int64
SQLITE_INTEGER
SQLITE_INTERNAL
SQLITE_INTERRUPT
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_POWERSAFE_OVERWRITE
SQLITE_IOCAP_SAFE_APPEND
SQLITE_IOCAP_SEQUENTIAL
SQLITE_IOCAP_UNDELETABLE_WHEN_OPEN
SQLITE_IOERR
SQLITE_IOERR_ACCESS
SQLITE_IOERR_BLOCKED
SQLITE_IOERR_CHECKRESERVEDLOCK
SQLITE_IOERR_CLOSE
SQLITE_IOERR_DELETE
SQLITE_IOERR_DIR_CLOSE
SQLITE_IOERR_DIR_FSYNC
SQLITE_IOERR_FSTAT
SQLITE_IOERR_FSYNC
SQLITE_IOERR_LOCK
SQLITE_IOERR_NOMEM
SQLITE_IOERR_RDLOCK
SQLITE_IOERR_READ
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_WRITE
SQLITE_LAST_ERRNO
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_LOCK_EXCLUSIVE
SQLITE_LOCK_NONE
SQLITE_LOCK_PENDING
SQLITE_LOCK_RESERVED
SQLITE_LOCK_SHARED
SQLITE_LOCKED
SQLITE_LOCKED_SHAREDCACHE
sqlite_master
sqlite_master table
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_PAGE_COUNT
SQLITE_MAX_SCHEMA_RETRY
SQLITE_MAX_SQL_LENGTH
SQLITE_MAX_TRIGGER_DEPTH
SQLITE_MAX_VARIABLE_NUMBER
SQLITE_MEMDEBUG
SQLITE_MISMATCH
SQLITE_MISUSE
SQLITE_MUTEX_FAST
SQLITE_MUTEX_RECURSIVE
SQLITE_MUTEX_STATIC_LRU
SQLITE_MUTEX_STATIC_LRU2
SQLITE_MUTEX_STATIC_MASTER
SQLITE_MUTEX_STATIC_MEM
SQLITE_MUTEX_STATIC_MEM2
SQLITE_MUTEX_STATIC_OPEN
SQLITE_MUTEX_STATIC_PMEM
SQLITE_MUTEX_STATIC_PRNG
SQLITE_NOLFS
SQLITE_NOMEM
SQLITE_NOTADB
SQLITE_NOTFOUND
SQLITE_NULL
SQLITE_OK
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_CAST
SQLITE_OMIT_CHECK
SQLITE_OMIT_COMPILEOPTION_DIAGS
SQLITE_OMIT_COMPLETE
SQLITE_OMIT_COMPOUND_SELECT
SQLITE_OMIT_DATETIME_FUNCS
SQLITE_OMIT_DECLTYPE
SQLITE_OMIT_DEPRECATED
SQLITE_OMIT_DISKIO
SQLITE_OMIT_EXPLAIN
SQLITE_OMIT_FLAG_PRAGMAS
SQLITE_OMIT_FLOATING_POINT
SQLITE_OMIT_FOREIGN_KEY
SQLITE_OMIT_GET_TABLE
SQLITE_OMIT_INCRBLOB
SQLITE_OMIT_INTEGRITY_CHECK
SQLITE_OMIT_LIKE_OPTIMIZATION
SQLITE_OMIT_LOAD_EXTENSION
SQLITE_OMIT_LOCALTIME
SQLITE_OMIT_LOOKASIDE
SQLITE_OMIT_MEMORYDB
SQLITE_OMIT_MERGE_SORT
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_WSD
SQLITE_OMIT_XFER_OPT
SQLITE_OPEN_AUTOPROXY
SQLITE_OPEN_CREATE
SQLITE_OPEN_DELETEONCLOSE
SQLITE_OPEN_EXCLUSIVE
SQLITE_OPEN_FULLMUTEX
SQLITE_OPEN_MAIN_DB
SQLITE_OPEN_MAIN_JOURNAL
SQLITE_OPEN_MASTER_JOURNAL
SQLITE_OPEN_MEMORY
SQLITE_OPEN_NOMUTEX
SQLITE_OPEN_PRIVATECACHE
SQLITE_OPEN_READONLY
SQLITE_OPEN_READWRITE
SQLITE_OPEN_SHAREDCACHE
SQLITE_OPEN_SUBJOURNAL
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_PROTOCOL
SQLITE_RANGE
SQLITE_READ
SQLITE_READONLY
SQLITE_READONLY_CANTLOCK
SQLITE_READONLY_RECOVERY
SQLITE_REINDEX
SQLITE_REPLACE
SQLITE_ROLLBACK
SQLITE_ROW
SQLITE_RTREE_INT_ONLY
SQLITE_SAVEPOINT
SQLITE_SCHEMA
SQLITE_SECURE_DELETE
SQLITE_SELECT
sqlite_sequence
SQLITE_SET_LOCKPROXYFILE
SQLITE_SHM_EXCLUSIVE
SQLITE_SHM_LOCK
SQLITE_SHM_NLOCK
SQLITE_SHM_SHARED
SQLITE_SHM_UNLOCK
SQLITE_SOUNDEX
SQLITE_SOURCE_ID
sqlite_source_id() SQL function
sqlite_stat1
sqlite_stat2
sqlite_stat3
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_STMTSTATUS counter
SQLITE_STMTSTATUS_AUTOINDEX
SQLITE_STMTSTATUS_FULLSCAN_STEP
SQLITE_STMTSTATUS_SORT
SQLITE_SYNC_DATAONLY
SQLITE_SYNC_FULL
SQLITE_SYNC_NORMAL
SQLITE_TEMP_STORE
SQLITE_TESTCTRL_ALWAYS
SQLITE_TESTCTRL_ASSERT
SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS
SQLITE_TESTCTRL_BITVEC_TEST
SQLITE_TESTCTRL_EXPLAIN_STMT
SQLITE_TESTCTRL_FAULT_INSTALL
SQLITE_TESTCTRL_FIRST
SQLITE_TESTCTRL_ISKEYWORD
SQLITE_TESTCTRL_LAST
SQLITE_TESTCTRL_LOCALTIME_FAULT
SQLITE_TESTCTRL_OPTIMIZATIONS
SQLITE_TESTCTRL_PENDING_BYTE
SQLITE_TESTCTRL_PRNG_RESET
SQLITE_TESTCTRL_PRNG_RESTORE
SQLITE_TESTCTRL_PRNG_SAVE
SQLITE_TESTCTRL_RESERVE
SQLITE_TESTCTRL_SCRATCHMALLOC
SQLITE_TEXT
SQLITE_THREADSAFE
SQLITE_TOOBIG
SQLITE_TRANSACTION
SQLITE_TRANSIENT
sqlite_uint64
SQLITE_UPDATE
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_ZERO_MALLOC
status parameters
storage class
strategies
strftime() SQL function
substr() SQL function
sum() aggregate function
synchronous pragma
syntax diagrams
table-constraint syntax diagram
table_info pragma
Tcl extension
TCL Interface
TCL test suite
TCL variable substitution
TEA tarball
temp_store pragma
temp_store_directory pragma
temporary databases
temporary disk files
temporary tables
test coverage
test harness
test suite
testcase macros
testing
TH3
the amalgamation
the ext3 barrier problem
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
three test harnesses
time() SQL function
tokenizer
torn page
total() aggregate function
total_changes() SQL function
trim() SQL function
truncate optimization
type affinity
type-name syntax diagram
typeof() SQL function
undefined BEFORE trigger behavior
unicode61
Uniform Resource Identifier
UNIQUE
unique constraint
unique index
unprotected sqlite3_value
UPDATE
update-stmt syntax diagram
update-stmt-limited syntax diagram
upper() SQL function
URI
URI filename
URI filename examples
URI filenames in sqlite3_open()
usable size
user_version pragma
Using the SQLite Online Backup API
Using the SQLite Unlock Notification Feature
VACUUM
vacuum-stmt syntax diagram
variable-length integer
varint
vdbe_listing pragma
vdbe_trace pragma
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.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.3.0
Version 3.3.1
Version 3.3.10
Version 3.3.11
Version 3.3.12
Version 3.3.13
Version 3.3.14
Version 3.3.15
Version 3.3.16
Version 3.3.17
Version 3.3.2
Version 3.3.3
Version 3.3.4
Version 3.3.5
Version 3.3.6
Version 3.3.7
Version 3.3.8
Version 3.3.9
Version 3.4.0
Version 3.4.1
Version 3.4.2
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.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.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-valid-for number
VFS
VFSes
view
virtual machine instructions
virtual table
virtual table cursor
virtual table module
WAL
WAL backwards compatibility
WAL checksum algorithm
WAL concurrency
WAL format
WAL mode
WAL read algorithm
WAL without shared memory
wal-index
WAL-index format
wal_autocheckpoint pragma
wal_checkpoint pragma
WHERE clause
writable_schema pragma
write-ahead log
writer starvation
xBegin
xBestIndex
xColumn
xCommit
xConnect
xCreate
xDestroy
xDisconnect
xEof
xFilter
xFindFunction
xNext
xRelease
xRename
xRollback
xRollbackTo
xRowid
xSavepoint
xUpdate
YYSTACKDEPTH
YYTRACKMAXSTACKDEPTH
zero-malloc memory allocator
zeroblob() SQL function