SQLite Documentation

funcs

• "automerge" command
• "cache" query parameter
• "decimal" collating sequence
• "immutable" query parameter
• "mode" query parameter
• "nolock" query parameter
• "psow" query parameter
• "shm" file
• "vfs" query parameter
• %q
• %w
• %z
• --insert option
• -> and ->> operators
• -DHAVE_FDATASYNC
• -DHAVE_GMTIME_R
• -DHAVE_ISNAN
• -DHAVE_LOCALTIME_R
• -DHAVE_LOCALTIME_S
• -DHAVE_MALLOC_USABLE_SIZE
• -DHAVE_SQLITE_CONFIG_H
• -DHAVE_STRCHRNUL
• -DHAVE_UTIME
• -DSQLITE_4_BYTE_ALIGNED_MALLOC
• -DSQLITE_ALLOW_COVERING_INDEX_SCAN
• -DSQLITE_ALLOW_URI_AUTHORITY
• -DSQLITE_API
• -DSQLITE_APICALL
• -DSQLITE_BYTEORDER
• -DSQLITE_CALLBACK
• -DSQLITE_CASE_SENSITIVE_LIKE
• -DSQLITE_CDECL
• -DSQLITE_DEBUG
• -DSQLITE_DEFAULT_AUTOMATIC_INDEX
• -DSQLITE_DEFAULT_AUTOVACUUM
• -DSQLITE_DEFAULT_CACHE_SIZE
• -DSQLITE_DEFAULT_FILE_FORMAT
• -DSQLITE_DEFAULT_FILE_PERMISSIONS
• -DSQLITE_DEFAULT_FOREIGN_KEYS
• -DSQLITE_DEFAULT_JOURNAL_SIZE_LIMIT
• -DSQLITE_DEFAULT_LOCKING_MODE
• -DSQLITE_DEFAULT_LOOKASIDE
• -DSQLITE_DEFAULT_MEMSTATUS
• -DSQLITE_DEFAULT_MMAP_SIZE
• -DSQLITE_DEFAULT_PAGE_SIZE
• -DSQLITE_DEFAULT_PCACHE_INITSZ
• -DSQLITE_DEFAULT_SYNCHRONOUS
• -DSQLITE_DEFAULT_WAL_AUTOCHECKPOINT
• -DSQLITE_DEFAULT_WAL_SYNCHRONOUS
• -DSQLITE_DEFAULT_WORKER_THREADS
• -DSQLITE_DIRECT_OVERFLOW_READ
• -DSQLITE_DISABLE_DIRSYNC
• -DSQLITE_DISABLE_FTS3_UNICODE
• -DSQLITE_DISABLE_FTS4_DEFERRED
• -DSQLITE_DISABLE_INTRINSIC
• -DSQLITE_DISABLE_LFS
• -DSQLITE_DISABLE_PAGECACHE_OVERFLOW_STATS
• -DSQLITE_DQS
• -DSQLITE_ENABLE_8_3_NAMES
• -DSQLITE_ENABLE_API_ARMOR
• -DSQLITE_ENABLE_ATOMIC_WRITE
• -DSQLITE_ENABLE_BATCH_ATOMIC_WRITE
• -DSQLITE_ENABLE_BYTECODE_VTAB
• -DSQLITE_ENABLE_COLUMN_METADATA
• -DSQLITE_ENABLE_DBPAGE_VTAB
• -DSQLITE_ENABLE_DBSTAT_VTAB
• -DSQLITE_ENABLE_DESERIALIZE
• -DSQLITE_ENABLE_EXPLAIN_COMMENTS
• -DSQLITE_ENABLE_FTS3
• -DSQLITE_ENABLE_FTS3_PARENTHESIS
• -DSQLITE_ENABLE_FTS3_TOKENIZER
• -DSQLITE_ENABLE_FTS4
• -DSQLITE_ENABLE_FTS5
• -DSQLITE_ENABLE_GEOPOLY
• -DSQLITE_ENABLE_HIDDEN_COLUMNS
• -DSQLITE_ENABLE_ICU
• -DSQLITE_ENABLE_IOTRACE
• -DSQLITE_ENABLE_JSON1
• -DSQLITE_ENABLE_LOCKING_STYLE
• -DSQLITE_ENABLE_MATH_FUNCTIONS
• -DSQLITE_ENABLE_MEMORY_MANAGEMENT
• -DSQLITE_ENABLE_MEMSYS3
• -DSQLITE_ENABLE_MEMSYS5
• -DSQLITE_ENABLE_NORMALIZE
• -DSQLITE_ENABLE_NULL_TRIM
• -DSQLITE_ENABLE_OFFSET_SQL_FUNC
• -DSQLITE_ENABLE_ORDERED_SET_AGGREGATES
• -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_STMTVTAB
• -DSQLITE_ENABLE_STMT_SCANSTATUS
• -DSQLITE_ENABLE_TREE_EXPLAIN
• -DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTION
• -DSQLITE_ENABLE_UNLOCK_NOTIFY
• -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT
• -DSQLITE_EXTERN
• -DSQLITE_EXTRA_DURABLE
• -DSQLITE_FTS3_MAX_EXPR_DEPTH
• -DSQLITE_HAVE_ISNAN
• -DSQLITE_HAVE_ZLIB
• -DSQLITE_INTROSPECTION_PRAGMAS
• -DSQLITE_JSON_MAX_DEPTH
• -DSQLITE_LIKE_DOESNT_MATCH_BLOBS
• -DSQLITE_MAX_ALLOCATION_SIZE
• -DSQLITE_MAX_MEMORY
• -DSQLITE_MAX_MMAP_SIZE
• -DSQLITE_MAX_SCHEMA_RETRY
• -DSQLITE_MAX_WORKER_THREADS
• -DSQLITE_MEMDB_DEFAULT_MAXSIZE
• -DSQLITE_MEMDEBUG
• -DSQLITE_MINIMUM_FILE_DESCRIPTOR
• -DSQLITE_OMIT_ALTERTABLE
• -DSQLITE_OMIT_ANALYZE
• -DSQLITE_OMIT_ATTACH
• -DSQLITE_OMIT_AUTHORIZATION
• -DSQLITE_OMIT_AUTOINCREMENT
• -DSQLITE_OMIT_AUTOINIT
• -DSQLITE_OMIT_AUTOMATIC_INDEX
• -DSQLITE_OMIT_AUTORESET
• -DSQLITE_OMIT_AUTOVACUUM
• -DSQLITE_OMIT_BETWEEN_OPTIMIZATION
• -DSQLITE_OMIT_BLOB_LITERAL
• -DSQLITE_OMIT_BTREECOUNT
• -DSQLITE_OMIT_BUILTIN_TEST
• -DSQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA
• -DSQLITE_OMIT_CAST
• -DSQLITE_OMIT_CHECK
• -DSQLITE_OMIT_COMPILEOPTION_DIAGS
• -DSQLITE_OMIT_COMPLETE
• -DSQLITE_OMIT_COMPOUND_SELECT
• -DSQLITE_OMIT_CTE
• -DSQLITE_OMIT_DATETIME_FUNCS
• -DSQLITE_OMIT_DECLTYPE
• -DSQLITE_OMIT_DEPRECATED
• -DSQLITE_OMIT_DESERIALIZE
• -DSQLITE_OMIT_DISKIO
• -DSQLITE_OMIT_EXPLAIN
• -DSQLITE_OMIT_FLAG_PRAGMAS
• -DSQLITE_OMIT_FLOATING_POINT
• -DSQLITE_OMIT_FOREIGN_KEY
• -DSQLITE_OMIT_GENERATED_COLUMNS
• -DSQLITE_OMIT_GET_TABLE
• -DSQLITE_OMIT_HEX_INTEGER
• -DSQLITE_OMIT_INCRBLOB
• -DSQLITE_OMIT_INTEGRITY_CHECK
• -DSQLITE_OMIT_INTROSPECTION_PRAGMAS
• -DSQLITE_OMIT_JSON
• -DSQLITE_OMIT_LIKE_OPTIMIZATION
• -DSQLITE_OMIT_LOAD_EXTENSION
• -DSQLITE_OMIT_LOCALTIME
• -DSQLITE_OMIT_LOOKASIDE
• -DSQLITE_OMIT_MEMORYDB
• -DSQLITE_OMIT_OR_OPTIMIZATION
• -DSQLITE_OMIT_PAGER_PRAGMAS
• -DSQLITE_OMIT_PRAGMA
• -DSQLITE_OMIT_PROGRESS_CALLBACK
• -DSQLITE_OMIT_QUICKBALANCE
• -DSQLITE_OMIT_REINDEX
• -DSQLITE_OMIT_SCHEMA_PRAGMAS
• -DSQLITE_OMIT_SCHEMA_VERSION_PRAGMAS
• -DSQLITE_OMIT_SEH
• -DSQLITE_OMIT_SHARED_CACHE
• -DSQLITE_OMIT_SUBQUERY
• -DSQLITE_OMIT_TCL_VARIABLE
• -DSQLITE_OMIT_TEMPDB
• -DSQLITE_OMIT_TRACE
• -DSQLITE_OMIT_TRIGGER
• -DSQLITE_OMIT_TRUNCATE_OPTIMIZATION
• -DSQLITE_OMIT_UTF16
• -DSQLITE_OMIT_VACUUM
• -DSQLITE_OMIT_VIEW
• -DSQLITE_OMIT_VIRTUALTABLE
• -DSQLITE_OMIT_WAL
• -DSQLITE_OMIT_WINDOWFUNC
• -DSQLITE_OMIT_WSD
• -DSQLITE_OMIT_XFER_OPT
• -DSQLITE_OS_OTHER
• -DSQLITE_POWERSAFE_OVERWRITE
• -DSQLITE_PRINTF_PRECISION_LIMIT
• -DSQLITE_QUERY_PLANNER_LIMIT
• -DSQLITE_QUERY_PLANNER_LIMIT_INCR
• -DSQLITE_REVERSE_UNORDERED_SELECTS
• -DSQLITE_RTREE_INT_ONLY
• -DSQLITE_SECURE_DELETE
• -DSQLITE_SORTER_PMASZ
• -DSQLITE_SOUNDEX
• -DSQLITE_STDCALL
• -DSQLITE_STMTJRNL_SPILL
• -DSQLITE_STRICT_SUBTYPE
• -DSQLITE_SYSAPI
• -DSQLITE_TCLAPI
• -DSQLITE_TEMP_STORE
• -DSQLITE_THREADSAFE
• -DSQLITE_TRACE_SIZE_LIMIT
• -DSQLITE_TRUSTED_SCHEMA
• -DSQLITE_UNTESTABLE
• -DSQLITE_USE_ALLOCA
• -DSQLITE_USE_FCNTL_TRACE
• -DSQLITE_USE_SEH
• -DSQLITE_USE_URI
• -DSQLITE_WIN32_HEAP_CREATE
• -DSQLITE_WIN32_MALLOC
• -DSQLITE_WIN32_MALLOC_VALIDATE
• -DSQLITE_ZERO_MALLOC
• .archive command
• .connection
• .crlf dot-command
• .databases
• .dump
• .excel
• .expert command
• .fullschema
• .imposter dot-command
• .load command
• .mode
• .mode quote
• .once
• .open
• .parameter command
• .read
• .recover dot-command
• .schema
• .selftest dot-command
• .sha3sum dot-command
• .tables
• .www
• 35% Faster Than The Filesystem
• 3rd-party fuzzers
• ACID
• AFL
• ALTER
• ALTER TABLE DROP COLUMN
• ALTER TABLE RENAME
• ALTER TABLE RENAME COLUMN
• AUTOINCREMENT
• Adding to Zip
• Affinity Of Expressions
• Aggregate Functions
• Alphabetical List Of Documents
• Application File Format
• Application ID
• Appropriate Uses For SQLite
• B*-Trees
• BEGIN
• BEGIN EXCLUSIVE
• BETWEEN
• BINARY collating function
• BLOB I/O performance
• BLOB handle
• Books About SQLite
• C-API function list
• C-language Interface
• CASE expression
• CAST
• CHECK
• CLI
• COLLATE
• COLLATE clause
• COLLATE operator
• COMPLETION
• CPU cycles used
• CREATE INDEX
• CREATE TABLE
• CREATE TABLE AS
• CREATE TRIGGER
• CREATE VIEW
• CREATE VIRTUAL TABLE
• CROSS JOIN
• CSV export
• CSV import
• CVEs
• Categorical Document List
• Clustered indexes
• Code of Conduct
• Code of Ethics
• Core Functions
• DBCONFIG arguments
• DBSTAT aggregated mode
• DEFAULT clauses
• DESC
• DETACH DATABASE
• DISTINCT
• DROP INDEX
• DROP TABLE
• DROP TRIGGER
• DROP VIEW
• ESCAPE
• EXISTS operator
• Extending FTS5
• FILTER clause on aggregate functions
• FROM clause
• FTS MATCH
• FTS auxiliary functions
• FTS hidden column
• FTS shadow tables
• FTS4
• FTS4 "integrity-check" command
• FTS4 "merge" command
• FTS4 "optimize" command
• FTS4 "rebuild" command
• FTS4 commands
• FTS4 content option
• FTS4 languageid option
• FTS4 matchinfo option
• FTS4 notindexed option
• FTS4 options
• FTS4 order option
• FTS4 prefix option
• FTS5 CREATE TABLE Options
• FTS5 NEAR queries
• FTS5 Phrases
• FTS5 Strings
• FTS5 automerge option
• FTS5 auxiliary functions
• FTS5 bm25
• FTS5 boolean operators
• FTS5 building
• FTS5 column filters
• FTS5 columnsize option
• FTS5 content option
• FTS5 contentless tables
• FTS5 contentless-delete tables
• FTS5 contentless_unindexed option
• FTS5 custom auxiliary functions
• FTS5 delete command
• FTS5 delete-all command
• FTS5 detail option
• FTS5 external content pitfalls
• FTS5 external content tables
• FTS5 get_locale
• FTS5 highlight
• FTS5 initial token
• FTS5 initial token queries
• FTS5 insttoken
• FTS5 locale option
• FTS5 merge command
• FTS5 optimize command
• FTS5 pgsz option
• FTS5 prefix indexes
• FTS5 prefix queries
• FTS5 query syntax
• FTS5 rank configuration option
• FTS5 rebuild command
• FTS5 secure-delete command
• FTS5 snippet
• FTS5 tokendata option
• FTS5 tokenizers
• FTS5 usermerge option
• FULL JOIN
• Fossil NGQP Upgrade Case Study
• Full-featured SQL
• GROUP BY
• GROUPS frames
• Home
• How SQL Works
• How To Compile SQLite
• How To Corrupt Your Database Files
• IEEE 754 floating point values are approximations
• IN operator
• INDEXED BY
• INSTEAD OF
• INTEGER PRIMARY KEY
• IS DISTINCT FROM
• IS NOT operator
• JSON BLOB input bug
• JSON function path arguments
• JSON5
• JSONB
• LEFT JOIN strength reduction optimization
• LIKE optimization
• LIMIT
• Lemon
• License
• MATCH
• MC/DC testing
• Manual Control Of Query Plans Using SQLITE_STAT Tables
• N3 algorithm
• NEAR queries
• NOT NULL
• NUL characters in strings
• NULLS FIRST
• OPEN_EXRESCODE
• OPEN_NOFOLLOW
• ORDER BY clause in aggregate functions
• OS backend
• OSS Fuzz
• OpenOffice case study
• PRAGMA
• PRAGMA function
• 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
• PRIMARY KEY
• Permuted Document Title Index
• Programming Loadable Extensions
• QPSG
• Quirks
• R-Tree extension
• RAISE function
• RANGE frames
• RANGE n FOLLOWING
• RBU
• RBU Database Contents
• RBU Database Tables
• RBU FTS3/4 Tables
• RBU Update
• RBU Vacuum
• REGEXP
• RELEASE
• RETURNING clause
• RIGHT and FULL OUTER JOIN
• Recommended usage patterns for ANALYZE
• Robson proof
• SAVEPOINT bug
• SLT
• SQL Archive
• SQL statement compiler
• SQLITE_DBSTATUS options
• SQLITE_STMTSTATUS counter
• SQLite Archive smaller than ZIP
• SQLite Consortium
• STRICT
• Session Extension C-language Interface
• Session Module C-API function list
• Subqueries
• 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
• TEMP triggers on non-TEMP tables
• TH3
• Tcl extension
• Things That Can Go Wrong
• UINT
• UNION virtual table
• UNIQUE
• UPDATE
• UPDATE FROM
• UPSERT parsing ambiguity
• URI filename examples
• URI filenames in sqlite3_open()
• Uniform Resource Identifier
• Use Of assert() In SQLite
• VACUUM INTO
• VALUES
• WAL
• WAL backwards compatibility
• WAL checksum algorithm
• WAL concurrency
• WAL file
• WAL file format
• WAL read algorithm
• WAL without shared memory
• WAL-index File Format
• WAL-mode File Format
• WAL-mode locks
• WAL-mode read blocking
• WHERE clause
• WITHOUT ROWID virtual table
• Warranty of Title
• Why SQLite Uses Bytecode
• Win32 native memory allocator
• YYSTACKDEPTH
• YYTRACKMAXSTACKDEPTH
• ZIP file as database
• about 200 SQL statements per webpage
• abs() SQL function
• acos() SQL function
• acosh() SQL function
• add column
• advanced
• advantages of WAL-mode
• affinity
• affinity in compound VIEWs
• aggregate JSON SQL functions
• aggregate window functions
• aggregate-function-invocation
• alter-table-stmt
• ambiguous dates
• analysis_limit pragma
• analyze-stmt
• application-defined SQL function
• application-defined function attacks
• application-defined window functions
• application_id pragma
• appreciate the freedom
• approximate ANALYZE
• asin() SQL function
• asinh() SQL function
• asynchronous I/O backend
• atan() SQL function
• atan2() SQL function
• atanh() SQL function
• atomic commit
• attach
• attach-stmt
• attack resistance
• authorizer callback
• authorizer method
• auto modifier
• auto_vacuum pragma
• autocommit mode
• automated undo/redo stack
• automatic indexes
• automatic_index pragma
• automatically running ANALYZE
• auxiliary columns
• auxiliary function mapping
• avg() aggregate function
• avoiding large WAL files
• backup API
• backup method
• bare aggregate terms
• base64
• base85
• bcvtab
• begin-stmt
• benefits of using WITHOUT ROWID
• binary operators
• bind_fallback method
• block sorting
• boolean datatype
• boolean expression
• bound parameter
• bugs
• build product names
• building a DLL
• built-in SQL math functions
• built-in memory allocators
• built-in printf()
• built-in window functions
• builtin window functions
• busy handler
• busy method
• busy_timeout pragma
• byte-order determination rules
• bytecode
• cache method
• cache_size pragma
• cache_spill pragma
• canonical source code
• carray
• case_sensitive_like pragma
• ceil
• cell format summary
• cell payload
• cell_size_check pragma
• cfgerrors*
• change counter
• changes method
• changes() SQL function
• changeset
• char() SQL function
• checklist
• checkpoint
• checkpoint mode
• checkpoint_fullfsync pragma
• checksum VFS
• child key
• chronology
• clone the entire repository
• close method
• co-routines
• coalesce() SQL function
• code repositories
• colUsed field
• collate method
• collation_list pragma
• collation_needed method
• column access functions
• column definition
• column-constraint
• column-def
• column-name-list
• columnar output modes
• comma option
• command-line options
• commands
• comment
• comment-syntax
• commit-stmt
• commit_hook method
• common table expressions
• common-table-expression
• comparison affinity rules
• comparison expressions
• comparison with fts4
• compilation
• compile loadable extensions
• compile-time options
• compile_options pragma
• complete list of SQLite releases
• complete method
• compound query
• compound-operator
• compound-select-stmt
• compressed FTS4 content
• compute the Mandelbrot set
• computed columns
• concat() SQL function
• concat_ws() SQL function
• config method
• configurable edit distances
• configuration option
• conflict clause
• conflict resolution mode
• conflict-clause
• constant-propagation optimization
• contentless fts4 tables
• contentless-delete
• copy method
• 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
• create-index-stmt
• create-table-stmt
• create-trigger-stmt
• create-view-stmt
• create-virtual-table-stmt
• crew
• csv
• cte-table-name
• custom auxiliary functions
• custom auxiliary overview
• custom builds
• custom r-tree queries
• custom tokenizers
• custom virtual tables
• data container
• data transfer format
• data_store_directory pragma
• data_version pragma
• database as container object
• database connection
• database corruption caused by inconsistent use of 8+3 filenames
• database filename aliasing
• database header
• database_list pragma
• datatype
• date and time datatype
• date and time functions
• date()
• date/time modifiers
• date/time special case
• dbghints
• dbhash
• dbsqlfuzz
• dbstat
• debugging memory allocator
• decimal extension
• decimal_add
• decimal_exp
• decision checklist
• default memory allocator
• default_cache_size pragma
• defensive code
• defer_foreign_keys pragma
• degrees() SQL function
• delete-stmt
• delete-stmt-limited
• deletemerge
• deleting a hot journal
• deserialize method
• detach-stmt
• deterministic function
• dot-command
• double-quoted string literal
• drop-index-stmt
• drop-table-stmt
• drop-trigger-stmt
• drop-view-stmt
• dynamic string
• 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
• errorcode method
• eval method
• exclude clause
• exclusive locking mode
• exists method
• exp() SQL function
• experimental
• experimental memory allocators
• explain query plan
• export to TSV
• export to excel
• expr
• expression index
• expression syntax
• ext3 barrier problem
• extended error code
• extended result code definitions
• extension loading
• external content fts4 tables
• extract
• factored-select-stmt
• file I/O functions
• file control
• file control opcode
• file format
• file format version numbers
• file locking and concurrency control
• file locking states
• file-format benefits
• filesystem corruption
• filter-clause
• flattened
• floor() SQL function
• footprint
• foreign key actions
• foreign key constraint
• foreign key constraints are enabled
• foreign-key-clause
• foreign_key_check pragma
• foreign_key_list pragma
• foreign_keys pragma
• format() SQL function
• forum
• frame boundary
• frame specification
• frame type
• frame-spec
• free-page list
• freelist_count pragma
• fts3_tokenizer
• fts3tokenize
• fts4 compress option
• fts4aux
• fts4aux languageid column
• fts5 shadow tables
• fts5 technical differences
• fts5_insttoken
• fts5vocab
• full-text search
• full_column_names pragma
• fullfsync pragma
• function creation routines
• function method
• function-arguments
• function_list pragma
• functions within expressions
• fuzz testing
• fuzzcheck
• generalized ALTER TABLE procedure
• generate_series
• geopoly
• geopoly_area
• geopoly_bbox
• geopoly_blob
• geopoly_ccw
• geopoly_contains_point
• geopoly_json
• geopoly_overlap
• geopoly_regular
• geopoly_svg
• geopoly_within
• geopoly_xform
• get the canonical source code
• glob() SQL function
• group_concat() aggregate function
• hard_heap_limit pragma
• hash join
• hazards of upgrading to the NGQP
• hex() SQL function
• hexadecimal integer literals
• hidden column
• high-reliability
• host parameter
• hot journal
• how collation is determined
• how to corrupt
• how to corrupt a database
• how vacuum works
• ieee754 extension
• ieee754() function
• ieee754_exponent() function
• ieee754_from_blob() function
• if
• ifnull() SQL function
• ignore_check_constraints pragma
• imposter tables
• 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-column
• indexing
• insert-stmt
• instr() SQL function
• integer-valued r-trees
• integrity_check pragma
• internal index
• interrupt method
• invalid UTF
• isolation
• join order
• join-clause
• join-constraint
• join-operator
• journal_mode pragma
• journal_size_limit pragma
• json
• json1
• json_array
• json_array_length
• json_each
• json_error_position
• json_extract
• json_group_array
• json_group_object
• json_insert
• json_object
• json_patch
• json_pretty
• json_quote
• json_remove
• json_replace
• json_set
• json_tree
• json_type
• json_valid
• jsonb SQL function
• jsonb_array
• jsonb_extract
• jsonb_group_array
• jsonb_insert
• jsonb_object
• jsonb_patch
• jsonb_remove
• jsonb_replace
• jsonb_set
• julianday modifier
• julianday()
• keywords
• last_insert_rowid method
• last_insert_rowid() SQL function
• legacy_alter_table pragma
• legacy_file_format pragma
• length() SQL function
• like() SQL function
• likelihood() SQL function
• likely() SQL function
• limit category
• list of current bytecodes
• list of virtual tables
• literal value
• literal-value
• ln() SQL function
• load_extension() SQL function
• localtime modifier
• lock-byte page
• log
• log2() SQL function
• long term support
• lookaside
• low-dependency
• lower() SQL function
• ltrim() SQL function
• mailing lists
• managing SQLite Archives from the command-line
• master journal
• matchinfo
• matchinfo b flag
• matchinfo x flag
• matchinfo y flag
• materialization hints
• max() SQL function
• max() aggregate function
• max_page_count pragma
• maxopen parameter
• median
• memory allocation
• memory statistics
• memory-mapped I/O
• microoptimizations
• min() SQL function
• min() aggregate function
• min/max optimization
• missing callback
• mmap_size pragma
• mod() SQL function
• modeof
• module_list pragma
• most used
• mutation test script
• mutation testing
• mxFrame
• nBackfill
• next generation query planner
• non-standard SELECT syntax
• not open-contributin
• nullif() SQL function
• nullvalue method
• numeric-literal
• object resolution
• octet_length() SQL function
• omit-left-join optimization
• omitfeatures
• onecolumn method
• openclose callback
• optimize pragma
• optimizer
• or optimization
• or-connected-terms
• order by
• orderByConsumed
• ordering-term
• ordinary common table expressions
• over-clause
• overflow page
• page cache
• page_count pragma
• page_size pragma
• pagecache memory allocator
• parser_trace pragma
• partial index
• partition
• percentile
• percentile extension
• percentile_cont
• percentile_disc
• persistent loadable extensions
• phrase queries
• pi() SQL function
• pointer leak
• pointer passing interface
• pointer types
• pow() SQL function
• powersafe overwrite
• pragma list
• pragma-stmt
• pragma-value
• predicate push-down
• prefix queries
• prepared statement
• preupdate method
• primary versus extended result codes
• printf() SQL function
• private branches
• professional support
• profile method
• progress method
• protected sqlite3_value
• qbox
• qualified-table-name
• queries against graphs
• query parameters with special meaning to SQLite
• query planner checklist
• quote() SQL function
• radians() SQL function
• raise-function
• random() SQL function
• randomblob() SQL function
• range query optimization
• read-only WAL databases
• reading and writing an rtree at the same time
• recent CVEs
• recommended by the US Library of Congress
• recommended compile-time option
• record format
• recovery
• recovery extension
• recursive common table expression
• recursive-cte
• reindex-stmt
• release-stmt
• replace() SQL function
• reserve bytes
• reset the WAL
• restore method
• result code definitions
• result-column
• returning-clause
• rollback journal
• rollback journal format
• rollback-stmt
• rollback_hook method
• round() SQL function
• row value
• row value IN operator
• rowid table
• rtree shadow tables
• rtreecheck()
• rtrim() SQL function
• rules for determining column affinity
• rules for determining column affinity in VIEWs
• running ANALYZE via PRAGMA optimize
• safe command-line option
• savepoint-stmt
• scan status flags
• scanstatus options
• schema format
• schema storage
• search application tips
• segment btree
• select
• select-core
• select-stmt
• separating a database from its journal
• serial type
• serialize method
• server-side database
• session
• shadow table
• shadowtabs
• shared cache
• shims
• short filenames
• sign() SQL function
• signed-number
• simple SELECT
• simple fts queries
• simple-function-invocation
• simple-select-stmt
• sin() SQL function
• single-argument carray
• sinh() SQL function
• skip-scan
• snapshot
• solve Sudoku puzzles
• sort order
• sorting
• sorting subsets of the result
• soundex() SQL function
• spellfix1
• sql-stmt
• sql-stmt-list
• sqldiff
• sqldiff --rbu
• sqlite3_aggregate_context
• sqlite3_aggregate_count
• sqlite3_analyzer
• 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_parameter_count
• sqlite3_bind_parameter_index
• sqlite3_bind_parameter_name
• sqlite3_blob_bytes
• sqlite3_blob_close
• sqlite3_blob_open
• sqlite3_blob_read
• sqlite3_blob_reopen
• sqlite3_blob_write
• sqlite3_busy_timeout
• sqlite3_cancel_auto_extension
• sqlite3_changegroup
• sqlite3_changes
• sqlite3_changeset_iter
• sqlite3_clear_bindings
• sqlite3_close
• sqlite3_collation_needed
• sqlite3_column_count
• sqlite3_column_database_name
• sqlite3_column_decltype
• sqlite3_column_name
• sqlite3_commit_hook
• sqlite3_compileoption_get
• sqlite3_complete
• sqlite3_config
• sqlite3_context
• sqlite3_context_db_handle
• sqlite3_create_collation
• sqlite3_create_filename
• sqlite3_create_module
• 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_exec
• sqlite3_expanded_sql
• sqlite3_extended_result_codes
• sqlite3_file
• sqlite3_filename
• sqlite3_filename_database
• sqlite3_finalize
• sqlite3_free
• sqlite3_free_table
• sqlite3_get_auxdata
• sqlite3_get_clientdata
• sqlite3_hard_heap_limit64
• sqlite3_index_info
• sqlite3_initialize
• sqlite3_int64
• sqlite3_interrupt
• sqlite3_io_methods
• sqlite3_keyword_check
• sqlite3_last_insert_rowid
• sqlite3_libversion
• sqlite3_limit
• sqlite3_load_extension
• sqlite3_log
• sqlite3_mem_methods
• sqlite3_memory_highwater
• sqlite3_module
• sqlite3_module.xBegin
• sqlite3_module.xBestIndex
• sqlite3_module.xClose
• sqlite3_module.xColumn
• sqlite3_module.xCommit
• sqlite3_module.xConnect
• sqlite3_module.xCreate
• sqlite3_module.xDisconnect
• sqlite3_module.xEof
• sqlite3_module.xFilter
• sqlite3_module.xFindFunction
• sqlite3_module.xIntegrity
• sqlite3_module.xNext
• sqlite3_module.xOpen
• sqlite3_module.xRename
• sqlite3_module.xRollback
• sqlite3_module.xRowid
• sqlite3_module.xSavepoint
• sqlite3_module.xSync
• sqlite3_module.xUpdate
• sqlite3_mprintf
• sqlite3_mutex
• sqlite3_mutex_alloc
• sqlite3_mutex_held
• sqlite3_mutex_methods
• sqlite3_next_stmt
• sqlite3_open
• sqlite3_overload_function
• sqlite3_pcache
• sqlite3_pcache_page
• sqlite3_preupdate_blobwrite
• sqlite3_profile
• sqlite3_progress_handler
• sqlite3_randomness
• sqlite3_rebaser
• sqlite3_release_memory
• sqlite3_reset
• sqlite3_reset_auto_extension
• sqlite3_result_blob
• sqlite3_result_subtype
• sqlite3_rsync
• sqlite3_rtree_query_callback
• sqlite3_serialize
• sqlite3_session
• sqlite3_set_last_insert_rowid
• sqlite3_sleep
• sqlite3_snapshot_cmp
• sqlite3_snapshot_free
• sqlite3_snapshot_get
• sqlite3_snapshot_open
• sqlite3_snapshot_recover
• sqlite3_soft_heap_limit
• sqlite3_status
• sqlite3_step
• sqlite3_stmt_busy
• sqlite3_stmt_explain
• sqlite3_stmt_isexplain
• sqlite3_stmt_readonly
• sqlite3_stmt_scanstatus
• sqlite3_stmt_scanstatus_reset
• sqlite3_stmt_status
• sqlite3_str_append
• sqlite3_str_errcode
• sqlite3_str_finish
• sqlite3_str_new
• sqlite3_strglob
• sqlite3_stricmp
• sqlite3_strlike
• sqlite3_system_errno
• sqlite3_table_column_metadata
• sqlite3_temp_directory
• sqlite3_test_control
• sqlite3_threadsafe
• sqlite3_total_changes
• sqlite3_trace_v2
• sqlite3_txn_state
• sqlite3_unlock_notify
• sqlite3_update_hook
• sqlite3_uri_boolean
• sqlite3_user_data
• sqlite3_value_blob
• sqlite3_value_dup
• sqlite3_value_encoding
• sqlite3_value_subtype
• sqlite3_vfs
• sqlite3_vfs.xAccess
• sqlite3_vfs.xOpen
• sqlite3_vfs_find
• sqlite3_vtab
• sqlite3_vtab_collation
• sqlite3_vtab_config
• sqlite3_vtab_cursor
• sqlite3_vtab_distinct
• sqlite3_vtab_in
• sqlite3_vtab_in_first
• 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
• sqlite3changegroup_add
• sqlite3changegroup_add_change
• sqlite3changegroup_add_strm
• sqlite3changegroup_delete
• sqlite3changegroup_new
• sqlite3changegroup_output
• sqlite3changegroup_schema
• sqlite3changeset_apply
• sqlite3changeset_concat
• sqlite3changeset_conflict
• sqlite3changeset_finalize
• sqlite3changeset_fk_conflicts
• sqlite3changeset_invert
• sqlite3changeset_new
• sqlite3changeset_next
• sqlite3changeset_old
• sqlite3changeset_op
• sqlite3changeset_pk
• sqlite3changeset_start
• sqlite3changeset_upgrade
• sqlite3rebaser_configure
• sqlite3rebaser_create
• sqlite3rebaser_delete
• sqlite3rebaser_rebase
• sqlite3session_attach
• sqlite3session_changeset
• sqlite3session_changeset_size
• sqlite3session_config
• sqlite3session_create
• sqlite3session_delete
• sqlite3session_diff
• sqlite3session_enable
• sqlite3session_indirect
• sqlite3session_isempty
• sqlite3session_memory_used
• sqlite3session_object_config
• sqlite3session_patchset
• sqlite3session_table_filter
• sqlite_compileoption_get() SQL function
• sqlite_compileoption_used() SQL function
• sqlite_dbpage
• sqlite_master table
• sqlite_memstat
• sqlite_offset() SQL function
• sqlite_sequence
• sqlite_source_id() SQL function
• sqlite_stat1
• sqlite_stat2
• sqlite_stat3
• sqlite_stat4
• sqlite_stmt
• sqlite_version() SQL function
• sqrt() SQL function
• stale file descriptor
• star-query
• statement journal
• static ANALYZE results
• statically linked extensions
• status method
• status parameters
• storage class
• strategies
• strftime()
• subprograms
• subsec modifier
• substr() SQL function
• sum() aggregate function
• swarmvtab
• swarmvtab context
• syntax diagrams
• table data format
• table-constraint
• table-options
• table-or-subquery
• table-valued function
• table-valued functions in the FROM clause
• tan() SQL function
• tanh() SQL function
• temporary databases
• temporary directory search algorithm
• temporary disk files
• test coverage
• test harness
• test suite
• testcase macros
• text encoding
• threading mode
• time shift modifiers
• time value
• timediff()
• tokenizer
• torn page
• total_changes() SQL function
• transaction state
• treats the CROSS JOIN operator specially
• trigram indexes
• trim() SQL function
• trunc() SQL function
• truncate optimization
• type-name
• typeof() SQL function
• undefined BEFORE trigger behavior
• unhex() SQL function
• unicode() SQL function
• unicode61
• unindexed
• unique index
• unixepoch()
• unlikely() SQL function
• unlink corruption
• unsafe-testing command-line option
• untrusted database files
• update-stmt
• update-stmt-limited
• upper() SQL function
• upsert clause
• upsert-clause
• usable size
• use of shared cache mode is discouraged
• using SQLite for websites
• vacuum
• vacuum-stmt
• value argument
• variable-length integer
• version numbering conventions
• version-valid-for number
• virtual table
• virtual table configuration option
• when to use WITHOUT ROWID
• why ALTER TABLE is so difficult
• window chaining
• window function
• window-defn
• window-function-invocation
• with-clause
• wrapping text
• writer starvation
• xCachesize() page cache method
• xCreate() page cache methods
• xDestroy
• xDestroy() page cache method
• xFetch() page cache methods
• xInit() page cache method
• xPagecount() page cache methods
• xRekey() page cache methods
• xShrink() page cache method
• xShutdown() page cache method
• xUnpin() page cache method
• zero-configuration
• zero-malloc memory allocator
• zeroblob() SQL function
• zipfile

macros

• SQLITE_ACCESS_EXISTS
• SQLITE_ALTER_TABLE
• SQLITE_ANY
• SQLITE_BLOB
• SQLITE_CHANGESETAPPLY_FKNOACTION
• SQLITE_CHANGESETSTART_INVERT
• SQLITE_CHANGESET_ABORT
• SQLITE_CHANGESET_CONFLICT
• SQLITE_CONFIG_COVERING_INDEX_SCAN
• SQLITE_CONFIG_GETMALLOC
• SQLITE_CONFIG_GETMUTEX
• SQLITE_CONFIG_GETPCACHE
• SQLITE_CONFIG_GETPCACHE2
• SQLITE_CONFIG_HEAP
• SQLITE_CONFIG_LOG
• SQLITE_CONFIG_LOOKASIDE
• SQLITE_CONFIG_MALLOC
• SQLITE_CONFIG_MEMDB_MAXSIZE
• SQLITE_CONFIG_MEMSTATUS
• SQLITE_CONFIG_MMAP_SIZE
• SQLITE_CONFIG_MULTITHREAD
• SQLITE_CONFIG_MUTEX
• SQLITE_CONFIG_PAGECACHE
• SQLITE_CONFIG_PCACHE
• SQLITE_CONFIG_PCACHE2
• SQLITE_CONFIG_PCACHE_HDRSZ
• SQLITE_CONFIG_PMASZ
• SQLITE_CONFIG_ROWID_IN_VIEW
• SQLITE_CONFIG_SCRATCH
• SQLITE_CONFIG_SERIALIZED
• SQLITE_CONFIG_SINGLETHREAD
• SQLITE_CONFIG_SMALL_MALLOC
• SQLITE_CONFIG_SORTERREF_SIZE
• SQLITE_CONFIG_SQLLOG
• SQLITE_CONFIG_STMTJRNL_SPILL
• SQLITE_CONFIG_URI
• SQLITE_CONFIG_WIN32_HEAPSIZE
• SQLITE_DBCONFIG_DEFENSIVE
• SQLITE_DBCONFIG_DQS_DDL
• SQLITE_DBCONFIG_DQS_DML
• SQLITE_DBCONFIG_ENABLE_ATTACH_CREATE
• SQLITE_DBCONFIG_ENABLE_ATTACH_WRITE
• SQLITE_DBCONFIG_ENABLE_COMMENTS
• SQLITE_DBCONFIG_ENABLE_FKEY
• SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
• SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION
• SQLITE_DBCONFIG_ENABLE_QPSG
• SQLITE_DBCONFIG_ENABLE_TRIGGER
• SQLITE_DBCONFIG_ENABLE_VIEW
• SQLITE_DBCONFIG_LEGACY_ALTER_TABLE
• SQLITE_DBCONFIG_LEGACY_FILE_FORMAT
• SQLITE_DBCONFIG_LOOKASIDE
• SQLITE_DBCONFIG_MAINDBNAME
• SQLITE_DBCONFIG_MAX
• SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE
• SQLITE_DBCONFIG_RESET_DATABASE
• SQLITE_DBCONFIG_REVERSE_SCANORDER
• SQLITE_DBCONFIG_STMT_SCANSTATUS
• SQLITE_DBCONFIG_TRIGGER_EQP
• SQLITE_DBCONFIG_TRUSTED_SCHEMA
• SQLITE_DBCONFIG_WRITABLE_SCHEMA
• SQLITE_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_SCHEMA_USED
• SQLITE_DBSTATUS_STMT_USED
• SQLITE_DENY
• SQLITE_DESERIALIZE_FREEONCLOSE
• SQLITE_DETERMINISTIC
• SQLITE_DIRECTONLY
• 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_HAS_MOVED
• SQLITE_FCNTL_JOURNAL_POINTER
• SQLITE_FCNTL_LOCKSTATE
• SQLITE_FCNTL_LOCK_TIMEOUT
• SQLITE_FCNTL_MMAP_SIZE
• SQLITE_FCNTL_NULL_IO
• SQLITE_FCNTL_OVERWRITE
• SQLITE_FCNTL_PERSIST_WAL
• SQLITE_FCNTL_POWERSAFE_OVERWRITE
• SQLITE_FCNTL_PRAGMA
• SQLITE_FCNTL_RBU
• SQLITE_FCNTL_RESET_CACHE
• SQLITE_FCNTL_ROLLBACK_ATOMIC_WRITE
• SQLITE_FCNTL_SIZE_HINT
• SQLITE_FCNTL_SIZE_LIMIT
• SQLITE_FCNTL_SYNC
• SQLITE_FCNTL_SYNC_OMITTED
• SQLITE_FCNTL_TEMPFILENAME
• SQLITE_FCNTL_TRACE
• SQLITE_FCNTL_VFSNAME
• SQLITE_FCNTL_VFS_POINTER
• SQLITE_FCNTL_WAL_BLOCK
• SQLITE_FCNTL_WIN32_AV_RETRY
• SQLITE_FCNTL_WIN32_GET_HANDLE
• SQLITE_FCNTL_WIN32_SET_HANDLE
• SQLITE_FCNTL_ZIPVFS
• SQLITE_INDEX_CONSTRAINT_EQ
• SQLITE_INDEX_SCAN_HEX
• SQLITE_INNOCUOUS
• SQLITE_IOCAP_ATOMIC
• 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_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_SQL_LENGTH
• SQLITE_MAX_TRIGGER_DEPTH
• SQLITE_MAX_VARIABLE_NUMBER
• SQLITE_MUTEX_FAST
• SQLITE_OPEN_AUTOPROXY
• SQLITE_PREPARE_DONT_LOG
• SQLITE_PREPARE_NORMALIZE
• SQLITE_PREPARE_NO_VTAB
• SQLITE_PREPARE_PERSISTENT
• SQLITE_RESULT_SUBTYPE
• SQLITE_SCANSTAT_EST
• SQLITE_SCANSTAT_EXPLAIN
• SQLITE_SCANSTAT_NAME
• SQLITE_SCANSTAT_NCYCLE
• SQLITE_SCANSTAT_NLOOP
• SQLITE_SCANSTAT_NVISIT
• SQLITE_SCANSTAT_PARENTID
• SQLITE_SCANSTAT_SELECTID
• SQLITE_SELFORDER1
• SQLITE_SERIALIZE_NOCOPY
• SQLITE_SESSION_CONFIG_STRMSIZE
• SQLITE_SESSION_OBJCONFIG_ROWID
• SQLITE_SHM_EXCLUSIVE
• SQLITE_SHM_NLOCK
• SQLITE_SOURCE_ID
• 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_AUTOINDEX
• 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_TESTCTRL_ALWAYS
• SQLITE_TRACE
• SQLITE_TRACE_CLOSE
• SQLITE_TRACE_PROFILE
• SQLITE_TRACE_ROW
• SQLITE_TRACE_STMT
• SQLITE_TXN_NONE
• SQLITE_TXN_READ
• SQLITE_TXN_WRITE
• SQLITE_VTAB_CONSTRAINT_SUPPORT
• SQLITE_VTAB_DIRECTONLY
• SQLITE_VTAB_INNOCUOUS
• SQLITE_VTAB_USES_ALL_SCHEMAS
• SQLITE_WIN32_DATA_DIRECTORY_TYPE