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

• %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 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
• 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
• .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
• 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
• 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
• 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
• 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 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() SQL function
• date/time modifiers
• date/time special case
• 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
• 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_USLEEP
• -DHAVE_UTIME
• DISTINCT
• documents by category
• dot-commands
• double-quoted string literal
• 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_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_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_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_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_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 CREATE TABLE Options
• FTS5 custom auxiliary functions
• FTS5 delete command
• FTS5 delete-all command
• FTS5 detail option
• 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 shadow tables
• FTS5 snippet
• FTS5 Strings
• fts5 technical differences
• 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_list pragma
• 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_USLEEP
• 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
• 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-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
• 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 function path arguments
• JSON paths
• json SQL function
• json1
• json_array
• json_array SQL function
• json_array_length
• json_array_length SQL function
• json_each
• json_each table-valued 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_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
• julianday modifier
• 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-literal
• numeric-literal syntax diagram
• object resolution
• OFFSET
• omit-left-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
• orderByConsumed
• ordering-term
• ordering-term syntax diagram
• ordinary common table expressions
• OS backend
• OSS Fuzz
• .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
• prefix queries
• prefix query
• prepared statement
• 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_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 ANALYZE usage pattern
• recommended by the US Library of Congress
• recommended compile-time option
• recommended storage format
• 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
• safe command-line option
• --safe command-line option
• SAVEPOINT bug
• savepoint-stmt
• savepoint-stmt syntax diagram
• 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_table
• sqlite3_global_recover
• sqlite3_hard_heap_limit64
• sqlite3_index_info
• sqlite3_initialize
• sqlite3_int64
• sqlite3_interrupt
• sqlite3_io_methods
• 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.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_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_isexplain
• sqlite3_stmt_readonly
• sqlite3_stmt_scanstatus
• sqlite3_stmt_scanstatus_reset
• 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_strm
• sqlite3changegroup_delete
• sqlite3changegroup_new
• sqlite3changegroup_output
• sqlite3changegroup_output_strm
• 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
• 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_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_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_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_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_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_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_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_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_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_REVERSE_UNORDERED_SELECTS
• SQLITE_ROLLBACK
• SQLITE_ROW
• SQLITE_RTREE_INT_ONLY
• SQLITE_SAVEPOINT
• SQLITE_SCANSTAT_EST
• SQLITE_SCANSTAT_EXPLAIN
• SQLITE_SCANSTAT_NAME
• SQLITE_SCANSTAT_NLOOP
• SQLITE_SCANSTAT_NVISIT
• SQLITE_SCANSTAT_SELECTID
• SQLITE_SCHEMA
• sqlite_schema table
• SQLITE_SECURE_DELETE
• SQLITE_SELECT
• sqlite_sequence
• SQLITE_SERIALIZE_NOCOPY
• SQLITE_SESSION_CONFIG_STRMSIZE
• 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_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_IMPOSTER
• SQLITE_TESTCTRL_INTERNAL_FUNCTIONS
• SQLITE_TESTCTRL_ISINIT
• SQLITE_TESTCTRL_ISKEYWORD
• 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_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_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_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
• stats pragma
• status method
• status parameters
• storage class
• strategies
• strftime() SQL function
• STRICT
• STRICT table
• strict type checking
• subprograms
• Subqueries
• subquery co-routines
• 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 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() 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
• unicode() SQL function
• unicode61
• Uniform Resource Identifier
• unindexed
• UNION virtual table
• union-vtab
• unionvtab
• UNIQUE
• unique constraint
• unique index
• unixepoch() function
• unlikely() SQL function
• unlink corruption
• unlinked database files
• unlock_notify method
• unprotected sqlite3_value
• 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' 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.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
• why ALTER TABLE is so difficult
• 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
• 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 2016-12-03 20:43:57 UTC