Small. Fast. Reliable.Choose any three. Home Menu About Documentation Download License Support Purchase Search About Documentation Download Support Purchase Search Documentation Search Changelog Keyword Index Other Documentation Indexes: Categorical Document List Books About SQLite Alphabetical List Of Documents Permuted Document Title Index %q %w %z 35% Faster Than The Filesystem 3rd-party fuzzers about 200 SQL statements per webpage abs() SQL function ACID acos() SQL function acosh() SQL function add column Adding to Zip advanced advantages of WAL-mode affinity affinity in compound VIEWs Affinity Of Expressions AFL Aggregate Functions aggregate SQL functions aggregate window functions aggregate-function-invocation aggregate-function-invocation syntax diagram alphabetical listing of documents ALTER ALTER TABLE ALTER TABLE ADD COLUMN ALTER TABLE DROP COLUMN ALTER TABLE RENAME ALTER TABLE RENAME COLUMN ALTER TABLE RENAME documentation alter-table-stmt alter-table-stmt syntax diagram amalgamation amalgamation tarball 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 base64() SQL function base85() SQL function bcvtab BEGIN BEGIN EXCLUSIVE BEGIN IMMEDIATE begin-stmt begin-stmt syntax diagram benefits of using WITHOUT ROWID BETWEEN BINARY collating function binary operators bind_fallback method BLOB handle BLOB I/O performance block sorting books about SQLite boolean datatype boolean expression bound parameter bugs build product names building a DLL building the amalgamation built-in memory allocators built-in printf() built-in SQL math functions built-in window functions built-ins builtin window functions busy handler busy method busy-handler callback busy_timeout pragma byte-order determination rules bytecode bytecode and tables_used virtual tables bytecode engine bytecode virtual table C-API function list C-language Interface cache method "cache" query parameter cache_size pragma cache_spill pragma canonical source code carray carray() table-valued function CASE expression case_sensitive_like pragma CAST CAST expression CAST operator categorical listing of SQLite documents ceil ceiling cell format summary cell payload cell_size_check pragma cfgerrors* change counter changes method changes() SQL function changeset char() SQL function CHECK CHECK constraint checklist checkpoint checkpoint mode checkpoint_fullfsync pragma checkpointed checkpointing checksum VFS checksum VFS shim child key child table chronology cksumvfs CLI clone the entire repository close method Clustered indexes co-routines coalesce() SQL function Code of Conduct Code of Ethics Code of Ethics of the Project Founder code repositories COLLATE COLLATE clause COLLATE constraint collate method COLLATE operator collating function collation_list pragma collation_needed method column access functions column affinity column definition column-constraint column-constraint syntax diagram column-def column-def syntax diagram column-name-list column-name-list syntax diagram columnar output modes colUsed field comma option Command Line Interface command-line interface command-line options command-line shell commands comment comment-syntax comment-syntax syntax diagram COMMIT commit-stmt commit-stmt syntax diagram commit_hook method common table expressions common-table-expression common-table-expression syntax diagram comparison affinity rules comparison expressions comparison with fts4 compilation compile fts compile loadable extensions compile-time options compile_options pragma Compiling Loadable Extensions compiling the CLI compiling the TCL interface complete list of SQLite releases complete method COMPLETION COMPLETION extension COMPLETION table-valued function compound query compound select compound-operator compound-operator syntax diagram compound-select-stmt compound-select-stmt syntax diagram compressed FTS4 content compute the Mandelbrot set computed columns concat() SQL function concat_ws() SQL function config method configurable edit distances configuration option conflict clause conflict resolution algorithm conflict resolution mode conflict-clause conflict-clause syntax diagram .connection constant-propagation optimization contentless fts4 tables contentless-delete copy method copyright Core Functions core URI query parameters correlated subqueries cos() SQL function cosh() SQL function count() aggregate function count_changes pragma coverage testing vs. fuzz testing covering index covering indexes covering indices CPU cycles used CPU performance measurement CREATE INDEX CREATE TABLE CREATE TABLE AS CREATE TRIGGER CREATE VIEW CREATE VIRTUAL TABLE create-index-stmt create-index-stmt syntax diagram create-table-stmt create-table-stmt syntax diagram create-trigger-stmt create-trigger-stmt syntax diagram create-view-stmt create-view-stmt syntax diagram create-virtual-table-stmt create-virtual-table-stmt syntax diagram crew CROSS JOIN csv CSV export CSV import CSV virtual table cte-table-name cte-table-name syntax diagram custom auxiliary functions custom builds custom r-tree queries custom SQL function custom tokenizers custom virtual tables CVEs Dan Kennedy data container data transfer format data_store_directory pragma data_version pragma database as container object database as object database connection database corruption caused by inconsistent use of 8+3 filenames database filename aliasing database header database_list pragma .databases .databases command datatype date and time datatype date and time functions date() date() SQL function date/time modifiers date/time special case datetime() datetime() SQL function dbghints dbhash dbhash.exe dbsqlfuzz dbstat DBSTAT aggregated mode dbstat virtual table debugging hints debugging memory allocator decimal extension decision checklist DEFAULT clauses default column value default memory allocator default value default_cache_size pragma defense against dark arts defense against the dark arts defensive code defer_foreign_keys pragma degrees() SQL function delete-stmt delete-stmt syntax diagram delete-stmt-limited delete-stmt-limited syntax diagram deletemerge deleting a hot journal deprecated DESC descending index descending indexes descending indices deserialize method DETACH DATABASE detach-stmt detach-stmt syntax diagram deterministic function deterministic SQL functions -DHAVE_FDATASYNC -DHAVE_GMTIME_R -DHAVE_ISNAN -DHAVE_LOCALTIME_R -DHAVE_LOCALTIME_S -DHAVE_MALLOC_USABLE_SIZE -DHAVE_SQLITE_CONFIG_H -DHAVE_STRCHRNUL -DHAVE_UTIME DISTINCT documents by category dot-commands double-quoted string literal double-quoted string misfeature download page drop column DROP INDEX DROP TABLE DROP TRIGGER DROP VIEW drop-index-stmt drop-index-stmt syntax diagram drop-table-stmt drop-table-stmt syntax diagram drop-trigger-stmt drop-trigger-stmt syntax diagram drop-view-stmt drop-view-stmt syntax diagram -DSQLITE_4_BYTE_ALIGNED_MALLOC -DSQLITE_ALLOW_COVERING_INDEX_SCAN -DSQLITE_ALLOW_URI_AUTHORITY -DSQLITE_API -DSQLITE_APICALL -DSQLITE_BYTEORDER -DSQLITE_CALLBACK -DSQLITE_CASE_SENSITIVE_LIKE -DSQLITE_CDECL -DSQLITE_DEBUG -DSQLITE_DEFAULT_AUTOMATIC_INDEX -DSQLITE_DEFAULT_AUTOVACUUM -DSQLITE_DEFAULT_CACHE_SIZE -DSQLITE_DEFAULT_FILE_FORMAT -DSQLITE_DEFAULT_FILE_PERMISSIONS -DSQLITE_DEFAULT_FOREIGN_KEYS -DSQLITE_DEFAULT_JOURNAL_SIZE_LIMIT -DSQLITE_DEFAULT_LOCKING_MODE -DSQLITE_DEFAULT_LOOKASIDE -DSQLITE_DEFAULT_MEMSTATUS -DSQLITE_DEFAULT_MMAP_SIZE -DSQLITE_DEFAULT_PAGE_SIZE -DSQLITE_DEFAULT_PCACHE_INITSZ -DSQLITE_DEFAULT_SYNCHRONOUS -DSQLITE_DEFAULT_WAL_AUTOCHECKPOINT -DSQLITE_DEFAULT_WAL_SYNCHRONOUS -DSQLITE_DEFAULT_WORKER_THREADS -DSQLITE_DIRECT_OVERFLOW_READ -DSQLITE_DISABLE_DIRSYNC -DSQLITE_DISABLE_FTS3_UNICODE -DSQLITE_DISABLE_FTS4_DEFERRED -DSQLITE_DISABLE_INTRINSIC -DSQLITE_DISABLE_LFS -DSQLITE_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_SEH -DSQLITE_USE_URI -DSQLITE_WIN32_HEAP_CREATE -DSQLITE_WIN32_MALLOC -DSQLITE_WIN32_MALLOC_VALIDATE -DSQLITE_ZERO_MALLOC .dump dynamic string dynamic typing edit() SQL function editdist3 embedded empty_result_callbacks pragma enable_load_extension method encoding pragma enhanced query syntax eponymous virtual table eponymous-only virtual table errlog error code error log errorcode method ESCAPE eval method .excel exclude clause exclusive locking mode exists method EXISTS operator exp() SQL function experimental experimental memory allocators .expert command explain query plan export to excel export to TSV expr expr syntax diagram expression affinity expression index expression indexes expression syntax extended error code extended result code extended result code definitions Extending FTS5 extension loading external content fts4 tables extract factored-select-stmt factored-select-stmt syntax diagram faster than the filesystem file control file control opcode file format file format version numbers file I/O functions file locking and concurrency control file locking states file-format benefits filesystem corruption FILTER clause on aggregate functions filter-clause filter-clause syntax diagram flattened flattening optimization flexible type system Flexible typing is a feature floor() SQL function footprint foreign key actions foreign key constraint foreign key constraints are enabled foreign-key-clause foreign-key-clause syntax diagram foreign_key_check pragma foreign_key_list pragma foreign_keys pragma format() SQL function forum frame boundary frame specification frame type frame-spec frame-spec syntax diagram frames free-page list freelist freelist_count pragma FROM clause FTS auxiliary functions FTS hidden column FTS MATCH FTS shadow tables fts3_tokenizer fts3tokenize fts3tokenize virtual table FTS4 FTS4 "automerge" command FTS4 "integrity-check" command FTS4 "merge" command FTS4 "optimize" command FTS4 "rebuild" command FTS4 commands fts4 compress option FTS4 content option FTS4 languageid option FTS4 matchinfo option FTS4 notindexed option FTS4 options FTS4 order option FTS4 prefix option fts4aux fts4aux languageid column FTS5 automerge option FTS5 auxiliary functions FTS5 bm25 FTS5 boolean operators FTS5 building FTS5 column filters FTS5 columnsize option FTS5 content option FTS5 contentless tables FTS5 contentless-delete tables FTS5 CREATE TABLE Options FTS5 custom auxiliary functions FTS5 delete command FTS5 delete-all command FTS5 detail option FTS5 external content pitfalls FTS5 external content tables FTS5 highlight FTS5 initial token FTS5 initial token queries FTS5 merge command FTS5 NEAR queries FTS5 optimize command FTS5 pgsz option FTS5 Phrases FTS5 prefix indexes FTS5 prefix queries FTS5 query syntax FTS5 rank configuration option FTS5 rebuild command FTS5 secure-delete command fts5 shadow tables FTS5 snippet FTS5 Strings fts5 technical differences FTS5 tokenizers FTS5 usermerge option fts5vocab FULL JOIN FULL OUTER JOIN Full-featured SQL full-text search full_column_names pragma fullfsync pragma .fullschema function creation routines function method function-arguments function-arguments syntax diagram function_list pragma functions within expressions fuzz testing fuzzcheck generalized ALTER TABLE procedure generate_series generated column geopoly Geopoly extension Geopoly module geopoly_area geopoly_bbox geopoly_blob geopoly_ccw geopoly_contains_point geopoly_group_bbox geopoly_json geopoly_overlap geopoly_regular geopoly_svg geopoly_within geopoly_xform get the canonical source code glob() SQL function GROUP BY GROUP BY clause group_concat() aggregate function GROUPS frames hard_heap_limit pragma hash join HAVE_FDATASYNC HAVE_GMTIME_R HAVE_ISNAN HAVE_LOCALTIME_R HAVE_LOCALTIME_S HAVE_MALLOC_USABLE_SIZE HAVE_SQLITE_CONFIG_H HAVE_STRCHRNUL HAVE_UTIME HAVING HAVING clause hazards of upgrading to the NGQP hex() SQL function hexadecimal integer literals hexadecimal integers hidden column high-reliability Hipp host parameter host parameter name hot journal hot journal files how collation is determined How SQL Works How SQLite Works how to compile How To Compile SQLite how to corrupt how to corrupt a database How To Corrupt Your Database Files how vacuum works IEEE 754 floating point values are approximations ieee754 extension ieee754() function ieee754_exponent() function ieee754_from_blob() function ieee754_mantissa() function ieee754_to_blob() function ifnull() SQL function ignore_check_constraints pragma iif() SQL function "immutable" query parameter .import .import command .imposter dot-command imposter tables IN operator in-header database size in-memory database in-memory shared cache database in-memory shared-cache incrblob method increase in the default page size incremental_vacuum pragma index b-tree index_info pragma index_list pragma index_xinfo pragma INDEXED BY indexed expression indexed-column indexed-column syntax diagram Indexes indexes on expressions indexing indexing tutorial --insert option insert-stmt insert-stmt syntax diagram INSTEAD OF INSTEAD OF trigger instr() SQL function INTEGER PRIMARY KEY integer-valued r-trees integrity_check pragma internal index internal indexes internal schema object internal table Internal Versus External BLOBs interrupt method invalid UTF IS DISTINCT FROM IS NOT DISTINCT FROM IS NOT operator IS operator isolation 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 JSON5 JSON5 extensions json_array json_array SQL function json_array_length json_array_length SQL function json_each json_each table-valued function json_error_position json_error_position SQL function json_extract json_extract SQL function json_group_array json_group_array SQL function json_group_object json_group_object SQL function json_insert json_insert SQL function json_object json_object SQL function json_patch json_patch SQL function json_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() 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 octet_length() SQL function OFFSET omit-left-join optimization omit-outer-join optimization omitfeatures ON CONFLICT ON CONFLICT clause on-disk format .once onecolumn method opcode definitions opcodes .open .open command OPEN_EXRESCODE OPEN_NOFOLLOW openclose callback OpenOffice case study optimize pragma "optimize" command optimizer or optimization or-connected-terms order by ORDER BY clause in aggregate functions orderByConsumed ordering-term ordering-term syntax diagram ordinary common table expressions OS backend OSS Fuzz OUTER JOIN strength reduction OUTER JOIN strength reduction optimization .output output mode over-clause over-clause syntax diagram overflow page page cache page_count pragma page_size pragma pagecache memory allocator parameter parameter binding .parameter command parent key parent table parser_trace pragma partial index partial indexes partial indices partial sorting by index partition patchset permuted index persistent journal mode persistent loadable extensions phrase queries pi() SQL function pointer leak pointer passing interface pointer types pointer value porting SQLite pow() SQL function power-safe power-safe transactions powersafe overwrite PRAGMA PRAGMA analysis_limit PRAGMA application_id PRAGMA auto_vacuum PRAGMA automatic_index PRAGMA busy_timeout PRAGMA cache_size PRAGMA cache_spill PRAGMA case_sensitive_like PRAGMA cell_size_check PRAGMA checkpoint_fullfsync PRAGMA collation_list PRAGMA compile_options PRAGMA count_changes PRAGMA data_store_directory PRAGMA data_version PRAGMA database_list PRAGMA default_cache_size PRAGMA defer_foreign_keys PRAGMA empty_result_callbacks PRAGMA encoding PRAGMA foreign_key_check PRAGMA foreign_key_list PRAGMA foreign_keys PRAGMA freelist_count PRAGMA full_column_names PRAGMA fullfsync PRAGMA function PRAGMA function_list PRAGMA hard_heap_limit PRAGMA ignore_check_constraints PRAGMA incremental_vacuum PRAGMA index_info PRAGMA index_list PRAGMA index_xinfo PRAGMA integrity_check PRAGMA journal_mode PRAGMA journal_size_limit PRAGMA legacy_alter_table PRAGMA legacy_file_format pragma list PRAGMA locking_mode PRAGMA max_page_count PRAGMA mmap_size PRAGMA module_list PRAGMA optimize PRAGMA page_count PRAGMA page_size PRAGMA parser_trace PRAGMA pragma_list PRAGMA query_only PRAGMA quick_check PRAGMA read_uncommitted PRAGMA recursive_triggers PRAGMA reverse_unordered_selects PRAGMA schema_version PRAGMA secure_delete PRAGMA short_column_names PRAGMA shrink_memory PRAGMA soft_heap_limit PRAGMA stats PRAGMA synchronous PRAGMA table_info PRAGMA table_list PRAGMA table_xinfo PRAGMA temp_store PRAGMA temp_store_directory PRAGMA threads PRAGMA trusted_schema PRAGMA user_version PRAGMA vdbe_addoptrace PRAGMA vdbe_debug PRAGMA vdbe_listing PRAGMA vdbe_trace PRAGMA wal_autocheckpoint PRAGMA wal_checkpoint PRAGMA writable_schema pragma-stmt pragma-stmt syntax diagram pragma-value pragma-value syntax diagram pragma_list pragma precompiled amalgamation tarballs prefix queries prefix query prepared statement preupdate method PRIMARY KEY PRIMARY KEY constraint primary versus extended result codes printf() SQL function prior releases private branches professional support profile method Programming Loadable Extensions progress method protected sqlite3_value PSOW "psow" query parameter public-domain push-down optimization qbox qbox output mode QPSG qualified-table-name qualified-table-name syntax diagram queries against graphs query flattener query parameters with special meaning to SQLite query planner query planner checklist query planner stability guarantee query_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 Scalar Functions scan status flags scanstatus options .schema schema format schema format number schema storage schema_version pragma search application tips second edition file format document secure_delete pragma security segment btree select SELECT query SELECT statement select-core select-core syntax diagram select-stmt select-stmt syntax diagram self-contained .selftest dot-command separating a database from its journal serial type serialize method series server-side database serverless session session extension Session Extension C-language Interface Session Module C-API function list .sha3sum dot-command shadow table shadowtabs shared cache shared cache mode shims "shm" file short filenames short_column_names pragma shrink_memory pragma sign() SQL function signed-number signed-number syntax diagram simple fts queries simple SELECT simple-function-invocation simple-function-invocation syntax diagram simple-select-stmt simple-select-stmt syntax diagram sin() SQL function single-argument carray sinh() SQL function skip-scan skip-scan optimization SLT snapshot snippet soft_heap_limit pragma solve Sudoku puzzles sort order sorting sorting subsets of the result soundex() SQL function spellfix1 split amalgamation SQL Archive SQL fuzzing SQL Logic Tests SQL parameter SQL statement compiler sql-stmt sql-stmt syntax diagram sql-stmt-list sql-stmt-list syntax diagram SQLAR sqldiff sqldiff --rbu sqldiff.exe SQLite amalgamation source file SQLite Archive SQLite Archive files SQLite Archive format SQLite Archive smaller than ZIP SQLite Consortium SQLite database file format SQLite extension SQLite Keywords SQLite query planner SQLite Shared-Cache Mode SQLite source code repositories sqlite3 sqlite3.exe sqlite3.exe command-line shell sqlite3_aggregate_context sqlite3_aggregate_count sqlite3_analyzer sqlite3_analyzer.exe sqlite3_api_routines sqlite3_auto_extension sqlite3_autovacuum_pages sqlite3_backup sqlite3_backup_finish() sqlite3_backup_init() sqlite3_backup_pagecount() sqlite3_backup_remaining() sqlite3_backup_step() sqlite3_bind_blob sqlite3_bind_blob64 sqlite3_bind_double sqlite3_bind_int sqlite3_bind_int64 sqlite3_bind_null sqlite3_bind_parameter_count sqlite3_bind_parameter_index sqlite3_bind_parameter_name sqlite3_bind_pointer sqlite3_bind_text sqlite3_bind_text16 sqlite3_bind_text64 sqlite3_bind_value sqlite3_bind_zeroblob sqlite3_bind_zeroblob64 sqlite3_blob sqlite3_blob_bytes sqlite3_blob_close sqlite3_blob_open sqlite3_blob_read sqlite3_blob_reopen sqlite3_blob_write sqlite3_busy_handler sqlite3_busy_timeout sqlite3_cancel_auto_extension sqlite3_carray_bind sqlite3_changegroup sqlite3_changes sqlite3_changes64 sqlite3_changeset_iter sqlite3_clear_bindings sqlite3_close sqlite3_close_v2 sqlite3_collation_needed sqlite3_collation_needed16 sqlite3_column_blob sqlite3_column_bytes sqlite3_column_bytes16 sqlite3_column_count sqlite3_column_database_name sqlite3_column_database_name16 sqlite3_column_decltype sqlite3_column_decltype16 sqlite3_column_double sqlite3_column_int sqlite3_column_int64 sqlite3_column_name sqlite3_column_name16 sqlite3_column_origin_name sqlite3_column_origin_name16 sqlite3_column_table_name sqlite3_column_table_name16 sqlite3_column_text sqlite3_column_text16 sqlite3_column_type sqlite3_column_value sqlite3_commit_hook sqlite3_compileoption_get sqlite3_compileoption_used sqlite3_complete sqlite3_complete16 sqlite3_config sqlite3_context sqlite3_context_db_handle sqlite3_create_collation sqlite3_create_collation16 sqlite3_create_collation_v2 sqlite3_create_filename sqlite3_create_function sqlite3_create_function16 sqlite3_create_function_v2 sqlite3_create_module sqlite3_create_module_v2 sqlite3_create_window_function sqlite3_data_count sqlite3_data_directory sqlite3_database_file_object sqlite3_db_cacheflush sqlite3_db_config sqlite3_db_filename sqlite3_db_handle sqlite3_db_mutex sqlite3_db_name sqlite3_db_readonly sqlite3_db_release_memory sqlite3_db_status sqlite3_declare_vtab sqlite3_deserialize sqlite3_drop_modules sqlite3_enable_load_extension sqlite3_enable_shared_cache sqlite3_errcode sqlite3_errmsg sqlite3_errmsg16 sqlite3_error_offset sqlite3_errstr sqlite3_exec sqlite3_expanded_sql sqlite3_expired sqlite3_extended_errcode sqlite3_extended_result_codes sqlite3_file sqlite3_file_control sqlite3_filename sqlite3_filename_database sqlite3_filename_journal sqlite3_filename_wal sqlite3_finalize sqlite3_free sqlite3_free_filename sqlite3_free_table sqlite3_get_autocommit sqlite3_get_auxdata sqlite3_get_clientdata sqlite3_get_table sqlite3_global_recover sqlite3_hard_heap_limit64 sqlite3_index_info sqlite3_initialize sqlite3_int64 sqlite3_interrupt sqlite3_io_methods sqlite3_is_interrupted sqlite3_keyword_check sqlite3_keyword_count sqlite3_keyword_name sqlite3_last_insert_rowid sqlite3_libversion sqlite3_libversion_number sqlite3_limit sqlite3_load_extension sqlite3_log sqlite3_malloc sqlite3_malloc64 sqlite3_mem_methods sqlite3_memory_alarm sqlite3_memory_highwater sqlite3_memory_used sqlite3_module sqlite3_module.xBegin sqlite3_module.xBestIndex sqlite3_module.xClose sqlite3_module.xColumn sqlite3_module.xCommit sqlite3_module.xConnect sqlite3_module.xCreate sqlite3_module.xDisconnect sqlite3_module.xEof sqlite3_module.xFilter sqlite3_module.xFindFunction sqlite3_module.xIntegrity sqlite3_module.xNext sqlite3_module.xOpen sqlite3_module.xRename sqlite3_module.xRollback sqlite3_module.xRowid sqlite3_module.xSavepoint sqlite3_module.xShadowName sqlite3_module.xSync sqlite3_module.xUpdate sqlite3_mprintf sqlite3_msize sqlite3_mutex sqlite3_mutex_alloc sqlite3_mutex_enter sqlite3_mutex_free sqlite3_mutex_held sqlite3_mutex_leave sqlite3_mutex_methods sqlite3_mutex_notheld sqlite3_mutex_try sqlite3_next_stmt sqlite3_normalized_sql sqlite3_open sqlite3_open16 sqlite3_open_v2 sqlite3_os_end sqlite3_os_init sqlite3_overload_function sqlite3_pcache sqlite3_pcache_methods2 sqlite3_pcache_page sqlite3_prepare sqlite3_prepare16 sqlite3_prepare16_v2 sqlite3_prepare16_v3 sqlite3_prepare_v2 sqlite3_prepare_v3 sqlite3_preupdate_blobwrite sqlite3_preupdate_count sqlite3_preupdate_depth sqlite3_preupdate_hook sqlite3_preupdate_new sqlite3_preupdate_old sqlite3_profile sqlite3_progress_handler sqlite3_randomness sqlite3_realloc sqlite3_realloc64 sqlite3_rebaser sqlite3_release_memory sqlite3_reset sqlite3_reset_auto_extension sqlite3_result_blob sqlite3_result_blob64 sqlite3_result_double sqlite3_result_error sqlite3_result_error16 sqlite3_result_error_code sqlite3_result_error_nomem sqlite3_result_error_toobig sqlite3_result_int sqlite3_result_int64 sqlite3_result_null sqlite3_result_pointer sqlite3_result_subtype sqlite3_result_text sqlite3_result_text16 sqlite3_result_text16be sqlite3_result_text16le sqlite3_result_text64 sqlite3_result_value sqlite3_result_zeroblob sqlite3_result_zeroblob64 sqlite3_rollback_hook sqlite3_rtree_query_callback sqlite3_serialize sqlite3_session sqlite3_set_authorizer sqlite3_set_auxdata sqlite3_set_clientdata sqlite3_set_last_insert_rowid sqlite3_shutdown sqlite3_sleep sqlite3_snapshot sqlite3_snapshot_cmp sqlite3_snapshot_free sqlite3_snapshot_get sqlite3_snapshot_open sqlite3_snapshot_recover sqlite3_snprintf sqlite3_soft_heap_limit sqlite3_soft_heap_limit64 sqlite3_sourceid sqlite3_sql sqlite3_status sqlite3_status64 sqlite3_step sqlite3_stmt sqlite3_stmt_busy sqlite3_stmt_explain sqlite3_stmt_isexplain sqlite3_stmt_readonly sqlite3_stmt_scanstatus sqlite3_stmt_scanstatus_reset sqlite3_stmt_scanstatus_v2 sqlite3_stmt_status sqlite3_str sqlite3_str_append sqlite3_str_appendall sqlite3_str_appendchar sqlite3_str_appendf sqlite3_str_errcode sqlite3_str_finish sqlite3_str_length sqlite3_str_new sqlite3_str_reset sqlite3_str_value sqlite3_str_vappendf sqlite3_strglob sqlite3_stricmp sqlite3_strlike sqlite3_strnicmp sqlite3_system_errno sqlite3_table_column_metadata sqlite3_temp_directory sqlite3_test_control sqlite3_thread_cleanup sqlite3_threadsafe sqlite3_total_changes sqlite3_total_changes64 sqlite3_trace sqlite3_trace_v2 sqlite3_transfer_bindings sqlite3_txn_state sqlite3_uint64 sqlite3_unlock_notify sqlite3_update_hook sqlite3_uri_boolean sqlite3_uri_int64 sqlite3_uri_key sqlite3_uri_parameter sqlite3_user_data sqlite3_value sqlite3_value_blob sqlite3_value_bytes sqlite3_value_bytes16 sqlite3_value_double sqlite3_value_dup sqlite3_value_encoding sqlite3_value_free sqlite3_value_frombind sqlite3_value_int sqlite3_value_int64 sqlite3_value_nochange sqlite3_value_numeric_type sqlite3_value_pointer sqlite3_value_subtype sqlite3_value_text sqlite3_value_text16 sqlite3_value_text16be sqlite3_value_text16le sqlite3_value_type sqlite3_version sqlite3_vfs sqlite3_vfs.xAccess sqlite3_vfs.xOpen sqlite3_vfs_find sqlite3_vfs_register sqlite3_vfs_unregister sqlite3_vmprintf sqlite3_vsnprintf sqlite3_vtab sqlite3_vtab_collation sqlite3_vtab_config sqlite3_vtab_cursor sqlite3_vtab_distinct sqlite3_vtab_in sqlite3_vtab_in_first sqlite3_vtab_in_next sqlite3_vtab_nochange sqlite3_vtab_on_conflict sqlite3_vtab_rhs_value sqlite3_wal_autocheckpoint sqlite3_wal_checkpoint sqlite3_wal_checkpoint_v2 sqlite3_wal_hook sqlite3_win32_set_directory sqlite3_win32_set_directory16 sqlite3_win32_set_directory8 sqlite3changegroup_add sqlite3changegroup_add_strm sqlite3changegroup_delete sqlite3changegroup_new sqlite3changegroup_output sqlite3changegroup_output_strm sqlite3changegroup_schema sqlite3changeset_apply sqlite3changeset_apply_strm sqlite3changeset_apply_v2 sqlite3changeset_apply_v2_strm sqlite3changeset_concat sqlite3changeset_concat_strm sqlite3changeset_conflict sqlite3changeset_finalize sqlite3changeset_fk_conflicts sqlite3changeset_invert sqlite3changeset_invert_strm sqlite3changeset_new sqlite3changeset_next sqlite3changeset_old sqlite3changeset_op sqlite3changeset_pk sqlite3changeset_start sqlite3changeset_start_strm sqlite3changeset_start_v2 sqlite3changeset_start_v2_strm sqlite3changeset_upgrade sqlite3rebaser_configure sqlite3rebaser_create sqlite3rebaser_delete sqlite3rebaser_rebase sqlite3rebaser_rebase_strm sqlite3session_attach sqlite3session_changeset sqlite3session_changeset_size sqlite3session_changeset_strm sqlite3session_config sqlite3session_create sqlite3session_delete sqlite3session_diff sqlite3session_enable sqlite3session_indirect sqlite3session_isempty sqlite3session_memory_used sqlite3session_object_config sqlite3session_patchset sqlite3session_patchset_strm sqlite3session_table_filter SQLITE_4_BYTE_ALIGNED_MALLOC SQLITE_ABORT SQLITE_ABORT_ROLLBACK SQLITE_ACCESS_EXISTS SQLITE_ACCESS_READ SQLITE_ACCESS_READWRITE SQLITE_ALLOW_COVERING_INDEX_SCAN SQLITE_ALLOW_URI_AUTHORITY SQLITE_ALTER_TABLE SQLITE_ANALYZE SQLITE_ANY SQLITE_API SQLITE_APICALL SQLITE_ATTACH SQLITE_AUTH SQLITE_AUTH_USER SQLITE_BLOB SQLITE_BUSY SQLITE_BUSY_RECOVERY SQLITE_BUSY_SNAPSHOT SQLITE_BUSY_TIMEOUT SQLITE_BYTEORDER SQLITE_CALLBACK SQLITE_CANTOPEN SQLITE_CANTOPEN_CONVPATH SQLITE_CANTOPEN_DIRTYWAL SQLITE_CANTOPEN_FULLPATH SQLITE_CANTOPEN_ISDIR SQLITE_CANTOPEN_NOTEMPDIR SQLITE_CANTOPEN_SYMLINK SQLITE_CASE_SENSITIVE_LIKE SQLITE_CDECL SQLITE_CHANGESET_ABORT SQLITE_CHANGESET_CONFLICT SQLITE_CHANGESET_CONSTRAINT SQLITE_CHANGESET_DATA SQLITE_CHANGESET_FOREIGN_KEY SQLITE_CHANGESET_NOTFOUND SQLITE_CHANGESET_OMIT SQLITE_CHANGESET_REPLACE SQLITE_CHANGESETAPPLY_FKNOACTION SQLITE_CHANGESETAPPLY_IGNORENOOP SQLITE_CHANGESETAPPLY_INVERT SQLITE_CHANGESETAPPLY_NOSAVEPOINT SQLITE_CHANGESETSTART_INVERT SQLITE_CHECKPOINT_FULL SQLITE_CHECKPOINT_PASSIVE SQLITE_CHECKPOINT_RESTART SQLITE_CHECKPOINT_TRUNCATE sqlite_compileoption_get() SQL function sqlite_compileoption_used() SQL function SQLITE_CONFIG_COVERING_INDEX_SCAN SQLITE_CONFIG_GETMALLOC SQLITE_CONFIG_GETMUTEX SQLITE_CONFIG_GETPCACHE SQLITE_CONFIG_GETPCACHE2 SQLITE_CONFIG_HEAP SQLITE_CONFIG_LOG SQLITE_CONFIG_LOOKASIDE SQLITE_CONFIG_MALLOC SQLITE_CONFIG_MEMDB_MAXSIZE SQLITE_CONFIG_MEMSTATUS SQLITE_CONFIG_MMAP_SIZE SQLITE_CONFIG_MULTITHREAD SQLITE_CONFIG_MUTEX SQLITE_CONFIG_PAGECACHE SQLITE_CONFIG_PCACHE SQLITE_CONFIG_PCACHE2 SQLITE_CONFIG_PCACHE_HDRSZ SQLITE_CONFIG_PMASZ SQLITE_CONFIG_SCRATCH SQLITE_CONFIG_SERIALIZED SQLITE_CONFIG_SINGLETHREAD SQLITE_CONFIG_SMALL_MALLOC SQLITE_CONFIG_SORTERREF_SIZE SQLITE_CONFIG_SQLLOG SQLITE_CONFIG_STMTJRNL_SPILL SQLITE_CONFIG_URI SQLITE_CONFIG_WIN32_HEAPSIZE SQLITE_CONSTRAINT SQLITE_CONSTRAINT_CHECK SQLITE_CONSTRAINT_COMMITHOOK SQLITE_CONSTRAINT_DATATYPE SQLITE_CONSTRAINT_FOREIGNKEY SQLITE_CONSTRAINT_FUNCTION SQLITE_CONSTRAINT_NOTNULL SQLITE_CONSTRAINT_PINNED SQLITE_CONSTRAINT_PRIMARYKEY SQLITE_CONSTRAINT_ROWID SQLITE_CONSTRAINT_TRIGGER SQLITE_CONSTRAINT_UNIQUE SQLITE_CONSTRAINT_VTAB SQLITE_COPY SQLITE_CORRUPT SQLITE_CORRUPT_INDEX SQLITE_CORRUPT_SEQUENCE SQLITE_CORRUPT_VTAB SQLITE_CREATE_INDEX SQLITE_CREATE_TABLE SQLITE_CREATE_TEMP_INDEX SQLITE_CREATE_TEMP_TABLE SQLITE_CREATE_TEMP_TRIGGER SQLITE_CREATE_TEMP_VIEW SQLITE_CREATE_TRIGGER SQLITE_CREATE_VIEW SQLITE_CREATE_VTABLE SQLITE_DBCONFIG_DEFENSIVE SQLITE_DBCONFIG_DQS_DDL SQLITE_DBCONFIG_DQS_DML SQLITE_DBCONFIG_ENABLE_FKEY SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION SQLITE_DBCONFIG_ENABLE_QPSG SQLITE_DBCONFIG_ENABLE_TRIGGER SQLITE_DBCONFIG_ENABLE_VIEW SQLITE_DBCONFIG_LEGACY_ALTER_TABLE SQLITE_DBCONFIG_LEGACY_FILE_FORMAT SQLITE_DBCONFIG_LOOKASIDE SQLITE_DBCONFIG_MAINDBNAME SQLITE_DBCONFIG_MAX SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE SQLITE_DBCONFIG_RESET_DATABASE SQLITE_DBCONFIG_REVERSE_SCANORDER SQLITE_DBCONFIG_STMT_SCANSTATUS SQLITE_DBCONFIG_TRIGGER_EQP SQLITE_DBCONFIG_TRUSTED_SCHEMA SQLITE_DBCONFIG_WRITABLE_SCHEMA sqlite_dbpage SQLITE_DBPAGE virtual table SQLITE_DBSTATUS options SQLITE_DBSTATUS_CACHE_HIT SQLITE_DBSTATUS_CACHE_MISS SQLITE_DBSTATUS_CACHE_SPILL SQLITE_DBSTATUS_CACHE_USED SQLITE_DBSTATUS_CACHE_USED_SHARED SQLITE_DBSTATUS_CACHE_WRITE SQLITE_DBSTATUS_DEFERRED_FKS SQLITE_DBSTATUS_LOOKASIDE_HIT SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE SQLITE_DBSTATUS_LOOKASIDE_USED SQLITE_DBSTATUS_MAX SQLITE_DBSTATUS_SCHEMA_USED SQLITE_DBSTATUS_STMT_USED SQLITE_DEBUG SQLITE_DEFAULT_AUTOMATIC_INDEX SQLITE_DEFAULT_AUTOVACUUM SQLITE_DEFAULT_CACHE_SIZE SQLITE_DEFAULT_FILE_FORMAT SQLITE_DEFAULT_FILE_PERMISSIONS SQLITE_DEFAULT_FOREIGN_KEYS SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT SQLITE_DEFAULT_LOCKING_MODE SQLITE_DEFAULT_LOOKASIDE SQLITE_DEFAULT_MEMSTATUS SQLITE_DEFAULT_MMAP_SIZE SQLITE_DEFAULT_PAGE_SIZE SQLITE_DEFAULT_PCACHE_INITSZ SQLITE_DEFAULT_SYNCHRONOUS SQLITE_DEFAULT_WAL_AUTOCHECKPOINT SQLITE_DEFAULT_WAL_SYNCHRONOUS SQLITE_DEFAULT_WORKER_THREADS SQLITE_DELETE SQLITE_DENY SQLITE_DESERIALIZE_FREEONCLOSE SQLITE_DESERIALIZE_READONLY SQLITE_DESERIALIZE_RESIZEABLE SQLITE_DETACH SQLITE_DETERMINISTIC SQLITE_DIRECT_OVERFLOW_READ SQLITE_DIRECTONLY SQLITE_DISABLE_DIRSYNC SQLITE_DISABLE_FTS3_UNICODE SQLITE_DISABLE_FTS4_DEFERRED SQLITE_DISABLE_INTRINSIC SQLITE_DISABLE_LFS SQLITE_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_IN_PAGE SQLITE_IOERR_LOCK SQLITE_IOERR_MMAP SQLITE_IOERR_NOMEM SQLITE_IOERR_RDLOCK SQLITE_IOERR_READ SQLITE_IOERR_ROLLBACK_ATOMIC SQLITE_IOERR_SEEK SQLITE_IOERR_SHMLOCK SQLITE_IOERR_SHMMAP SQLITE_IOERR_SHMOPEN SQLITE_IOERR_SHMSIZE SQLITE_IOERR_SHORT_READ SQLITE_IOERR_TRUNCATE SQLITE_IOERR_UNLOCK SQLITE_IOERR_VNODE SQLITE_IOERR_WRITE SQLITE_LIKE_DOESNT_MATCH_BLOBS SQLITE_LIMIT_ATTACHED SQLITE_LIMIT_COLUMN SQLITE_LIMIT_COMPOUND_SELECT SQLITE_LIMIT_EXPR_DEPTH SQLITE_LIMIT_FUNCTION_ARG SQLITE_LIMIT_LENGTH SQLITE_LIMIT_LIKE_PATTERN_LENGTH SQLITE_LIMIT_SQL_LENGTH SQLITE_LIMIT_TRIGGER_DEPTH SQLITE_LIMIT_VARIABLE_NUMBER SQLITE_LIMIT_VDBE_OP SQLITE_LIMIT_WORKER_THREADS SQLITE_LOCK_EXCLUSIVE SQLITE_LOCK_NONE SQLITE_LOCK_PENDING SQLITE_LOCK_RESERVED SQLITE_LOCK_SHARED SQLITE_LOCKED SQLITE_LOCKED_SHAREDCACHE SQLITE_LOCKED_VTAB sqlite_master table SQLITE_MAX_ALLOCATION_SIZE SQLITE_MAX_ATTACHED SQLITE_MAX_COLUMN SQLITE_MAX_COMPOUND_SELECT SQLITE_MAX_EXPR_DEPTH SQLITE_MAX_FUNCTION_ARG SQLITE_MAX_LENGTH SQLITE_MAX_LIKE_PATTERN_LENGTH SQLITE_MAX_MEMORY SQLITE_MAX_MMAP_SIZE SQLITE_MAX_PAGE_COUNT SQLITE_MAX_SCHEMA_RETRY SQLITE_MAX_SQL_LENGTH SQLITE_MAX_TRIGGER_DEPTH SQLITE_MAX_VARIABLE_NUMBER SQLITE_MAX_WORKER_THREADS SQLITE_MEMDB_DEFAULT_MAXSIZE SQLITE_MEMDEBUG sqlite_memstat SQLITE_MEMSTAT virtual table SQLITE_MINIMUM_FILE_DESCRIPTOR SQLITE_MISMATCH SQLITE_MISUSE SQLITE_MUTEX_FAST SQLITE_MUTEX_RECURSIVE SQLITE_MUTEX_STATIC_APP1 SQLITE_MUTEX_STATIC_APP2 SQLITE_MUTEX_STATIC_APP3 SQLITE_MUTEX_STATIC_LRU SQLITE_MUTEX_STATIC_LRU2 SQLITE_MUTEX_STATIC_MAIN SQLITE_MUTEX_STATIC_MEM SQLITE_MUTEX_STATIC_MEM2 SQLITE_MUTEX_STATIC_OPEN SQLITE_MUTEX_STATIC_PMEM SQLITE_MUTEX_STATIC_PRNG SQLITE_MUTEX_STATIC_VFS1 SQLITE_MUTEX_STATIC_VFS2 SQLITE_MUTEX_STATIC_VFS3 SQLITE_NOLFS SQLITE_NOMEM SQLITE_NOTADB SQLITE_NOTFOUND SQLITE_NOTICE SQLITE_NOTICE_RBU SQLITE_NOTICE_RECOVER_ROLLBACK SQLITE_NOTICE_RECOVER_WAL SQLITE_NULL sqlite_offset() SQL function SQLITE_OK SQLITE_OK_LOAD_PERMANENTLY SQLITE_OK_SYMLINK SQLITE_OMIT_ALTERTABLE SQLITE_OMIT_ANALYZE SQLITE_OMIT_ATTACH SQLITE_OMIT_AUTHORIZATION SQLITE_OMIT_AUTOINCREMENT SQLITE_OMIT_AUTOINIT SQLITE_OMIT_AUTOMATIC_INDEX SQLITE_OMIT_AUTORESET SQLITE_OMIT_AUTOVACUUM SQLITE_OMIT_BETWEEN_OPTIMIZATION SQLITE_OMIT_BLOB_LITERAL SQLITE_OMIT_BTREECOUNT SQLITE_OMIT_BUILTIN_TEST SQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA SQLITE_OMIT_CAST SQLITE_OMIT_CHECK SQLITE_OMIT_COMPILEOPTION_DIAGS SQLITE_OMIT_COMPLETE SQLITE_OMIT_COMPOUND_SELECT SQLITE_OMIT_CTE SQLITE_OMIT_DATETIME_FUNCS SQLITE_OMIT_DECLTYPE SQLITE_OMIT_DEPRECATED SQLITE_OMIT_DESERIALIZE SQLITE_OMIT_DISKIO SQLITE_OMIT_EXPLAIN SQLITE_OMIT_FLAG_PRAGMAS SQLITE_OMIT_FLOATING_POINT SQLITE_OMIT_FOREIGN_KEY SQLITE_OMIT_GENERATED_COLUMNS SQLITE_OMIT_GET_TABLE SQLITE_OMIT_HEX_INTEGER SQLITE_OMIT_INCRBLOB SQLITE_OMIT_INTEGRITY_CHECK SQLITE_OMIT_INTROSPECTION_PRAGMAS SQLITE_OMIT_JSON SQLITE_OMIT_LIKE_OPTIMIZATION SQLITE_OMIT_LOAD_EXTENSION SQLITE_OMIT_LOCALTIME SQLITE_OMIT_LOOKASIDE SQLITE_OMIT_MEMORYDB SQLITE_OMIT_OR_OPTIMIZATION SQLITE_OMIT_PAGER_PRAGMAS SQLITE_OMIT_PRAGMA SQLITE_OMIT_PROGRESS_CALLBACK SQLITE_OMIT_QUICKBALANCE SQLITE_OMIT_REINDEX SQLITE_OMIT_SCHEMA_PRAGMAS SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS SQLITE_OMIT_SHARED_CACHE SQLITE_OMIT_SUBQUERY SQLITE_OMIT_TCL_VARIABLE SQLITE_OMIT_TEMPDB SQLITE_OMIT_TRACE SQLITE_OMIT_TRIGGER SQLITE_OMIT_TRUNCATE_OPTIMIZATION SQLITE_OMIT_UTF16 SQLITE_OMIT_VACUUM SQLITE_OMIT_VIEW SQLITE_OMIT_VIRTUALTABLE SQLITE_OMIT_WAL SQLITE_OMIT_WINDOWFUNC SQLITE_OMIT_WSD SQLITE_OMIT_XFER_OPT SQLITE_OPEN_AUTOPROXY SQLITE_OPEN_CREATE SQLITE_OPEN_DELETEONCLOSE SQLITE_OPEN_EXCLUSIVE SQLITE_OPEN_EXRESCODE SQLITE_OPEN_FULLMUTEX SQLITE_OPEN_MAIN_DB SQLITE_OPEN_MAIN_JOURNAL SQLITE_OPEN_MEMORY SQLITE_OPEN_NOFOLLOW SQLITE_OPEN_NOMUTEX SQLITE_OPEN_PRIVATECACHE SQLITE_OPEN_READONLY SQLITE_OPEN_READWRITE SQLITE_OPEN_SHAREDCACHE SQLITE_OPEN_SUBJOURNAL SQLITE_OPEN_SUPER_JOURNAL SQLITE_OPEN_TEMP_DB SQLITE_OPEN_TEMP_JOURNAL SQLITE_OPEN_TRANSIENT_DB SQLITE_OPEN_URI SQLITE_OPEN_WAL SQLITE_OS_OTHER SQLITE_PERM SQLITE_POWERSAFE_OVERWRITE SQLITE_PRAGMA SQLITE_PREPARE_NO_VTAB SQLITE_PREPARE_NORMALIZE SQLITE_PREPARE_PERSISTENT SQLITE_PRINTF_PRECISION_LIMIT SQLITE_PROTOCOL SQLITE_QUERY_PLANNER_LIMIT SQLITE_QUERY_PLANNER_LIMIT_INCR SQLITE_RANGE SQLITE_READ SQLITE_READONLY SQLITE_READONLY_CANTINIT SQLITE_READONLY_CANTLOCK SQLITE_READONLY_DBMOVED SQLITE_READONLY_DIRECTORY SQLITE_READONLY_RECOVERY SQLITE_READONLY_ROLLBACK SQLITE_RECURSIVE SQLITE_REINDEX SQLITE_REPLACE SQLITE_REVERSE_UNORDERED_SELECTS SQLITE_ROLLBACK SQLITE_ROW SQLITE_RTREE_INT_ONLY SQLITE_SAVEPOINT SQLITE_SCANSTAT_COMPLEX SQLITE_SCANSTAT_EST SQLITE_SCANSTAT_EXPLAIN SQLITE_SCANSTAT_NAME SQLITE_SCANSTAT_NCYCLE SQLITE_SCANSTAT_NLOOP SQLITE_SCANSTAT_NVISIT SQLITE_SCANSTAT_PARENTID SQLITE_SCANSTAT_SELECTID SQLITE_SCHEMA sqlite_schema table SQLITE_SECURE_DELETE SQLITE_SELECT sqlite_sequence SQLITE_SERIALIZE_NOCOPY SQLITE_SESSION_CONFIG_STRMSIZE SQLITE_SESSION_OBJCONFIG_ROWID SQLITE_SESSION_OBJCONFIG_SIZE SQLITE_SHM_EXCLUSIVE SQLITE_SHM_LOCK SQLITE_SHM_NLOCK SQLITE_SHM_SHARED SQLITE_SHM_UNLOCK SQLITE_SORTER_PMASZ SQLITE_SOUNDEX SQLITE_SOURCE_ID sqlite_source_id() SQL function sqlite_stat1 sqlite_stat2 sqlite_stat3 sqlite_stat4 SQLITE_STATIC SQLITE_STATUS_MALLOC_COUNT SQLITE_STATUS_MALLOC_SIZE SQLITE_STATUS_MEMORY_USED SQLITE_STATUS_PAGECACHE_OVERFLOW SQLITE_STATUS_PAGECACHE_SIZE SQLITE_STATUS_PAGECACHE_USED SQLITE_STATUS_PARSER_STACK SQLITE_STATUS_SCRATCH_OVERFLOW SQLITE_STATUS_SCRATCH_SIZE SQLITE_STATUS_SCRATCH_USED SQLITE_STDCALL sqlite_stmt SQLITE_STMT virtual table SQLITE_STMTJRNL_SPILL SQLITE_STMTSTATUS counter SQLITE_STMTSTATUS_AUTOINDEX SQLITE_STMTSTATUS_FILTER HIT SQLITE_STMTSTATUS_FILTER_HIT SQLITE_STMTSTATUS_FILTER_MISS SQLITE_STMTSTATUS_FULLSCAN_STEP SQLITE_STMTSTATUS_MEMUSED SQLITE_STMTSTATUS_REPREPARE SQLITE_STMTSTATUS_RUN SQLITE_STMTSTATUS_SORT SQLITE_STMTSTATUS_VM_STEP SQLITE_SUBTYPE SQLITE_SYNC_DATAONLY SQLITE_SYNC_FULL SQLITE_SYNC_NORMAL SQLITE_SYSAPI SQLITE_TCLAPI sqlite_temp_schema SQLITE_TEMP_STORE SQLITE_TESTCTRL_ALWAYS SQLITE_TESTCTRL_ASSERT SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS SQLITE_TESTCTRL_BITVEC_TEST SQLITE_TESTCTRL_BYTEORDER SQLITE_TESTCTRL_EXPLAIN_STMT SQLITE_TESTCTRL_EXTRA_SCHEMA_CHECKS SQLITE_TESTCTRL_FAULT_INSTALL SQLITE_TESTCTRL_FIRST SQLITE_TESTCTRL_FK_NO_ACTION SQLITE_TESTCTRL_IMPOSTER SQLITE_TESTCTRL_INTERNAL_FUNCTIONS SQLITE_TESTCTRL_ISINIT SQLITE_TESTCTRL_ISKEYWORD SQLITE_TESTCTRL_LAST SQLITE_TESTCTRL_LOCALTIME_FAULT SQLITE_TESTCTRL_LOGEST SQLITE_TESTCTRL_NEVER_CORRUPT SQLITE_TESTCTRL_ONCE_RESET_THRESHOLD SQLITE_TESTCTRL_OPTIMIZATIONS SQLITE_TESTCTRL_PARSER_COVERAGE SQLITE_TESTCTRL_PENDING_BYTE SQLITE_TESTCTRL_PRNG_RESET SQLITE_TESTCTRL_PRNG_RESTORE SQLITE_TESTCTRL_PRNG_SAVE SQLITE_TESTCTRL_PRNG_SEED SQLITE_TESTCTRL_RESERVE SQLITE_TESTCTRL_RESULT_INTREAL SQLITE_TESTCTRL_SCRATCHMALLOC SQLITE_TESTCTRL_SEEK_COUNT SQLITE_TESTCTRL_SORTER_MMAP SQLITE_TESTCTRL_TRACEFLAGS SQLITE_TESTCTRL_TUNE SQLITE_TESTCTRL_USELONGDOUBLE SQLITE_TESTCTRL_VDBE_COVERAGE SQLITE_TEXT SQLITE_THREADSAFE SQLITE_TOOBIG SQLITE_TRACE SQLITE_TRACE_CLOSE SQLITE_TRACE_PROFILE SQLITE_TRACE_ROW SQLITE_TRACE_SIZE_LIMIT SQLITE_TRACE_STMT SQLITE_TRANSACTION SQLITE_TRANSIENT SQLITE_TRUSTED_SCHEMA SQLITE_TXN_NONE SQLITE_TXN_READ SQLITE_TXN_WRITE sqlite_uint64 SQLITE_UNTESTABLE SQLITE_UPDATE SQLITE_USE_ALLOCA SQLITE_USE_FCNTL_TRACE SQLITE_USE_SEH SQLITE_USE_URI SQLITE_UTF16 SQLITE_UTF16_ALIGNED SQLITE_UTF16BE SQLITE_UTF16LE SQLITE_UTF8 SQLITE_VERSION sqlite_version() SQL function SQLITE_VERSION_NUMBER SQLITE_VTAB_CONSTRAINT_SUPPORT SQLITE_VTAB_DIRECTONLY SQLITE_VTAB_INNOCUOUS SQLITE_VTAB_USES_ALL_SCHEMAS SQLITE_WARNING SQLITE_WARNING_AUTOINDEX SQLITE_WIN32_DATA_DIRECTORY_TYPE SQLITE_WIN32_HEAP_CREATE SQLITE_WIN32_MALLOC SQLITE_WIN32_MALLOC_VALIDATE SQLITE_WIN32_TEMP_DIRECTORY_TYPE SQLITE_ZERO_MALLOC sqrt() SQL function stale file descriptor standard query parameters statement journal statically linked extensions stats pragma status method status parameters storage class strategies strftime() strftime() SQL function STRICT STRICT table strict type checking string_agg string_agg() aggregate function subprograms Subqueries subquery co-routines subsec modifier subsecond modifier substr() SQL function sum() aggregate function super-journal swarmvtab swarmvtab context synchronous pragma syntax diagrams table b-tree table data format table-constraint table-constraint syntax diagram table-options table-options syntax diagram table-or-subquery table-or-subquery syntax diagram table-valued function table-valued functions in the FROM clause table_info pragma table_list pragma table_xinfo pragma .tables tables_used virtual table tan() SQL function tanh() SQL function Tcl extension TCL Interface TCL interface authorizer method TCL interface backup method TCL interface bind_fallback method TCL interface busy method TCL interface cache method TCL interface changes method TCL interface close method TCL interface collate method TCL interface collation_needed method TCL interface commit_hook method TCL interface complete method TCL interface config method TCL interface copy method TCL interface deserialize method TCL interface enable_load_extension method TCL interface errorcode method TCL interface eval method TCL interface exists method TCL interface function method TCL interface incrblob method TCL interface interrupt method TCL interface last_insert_rowid method TCL interface nullvalue method TCL interface onecolumn method TCL interface preupdate method TCL interface profile method TCL interface progress method TCL interface restore method TCL interface rollback_hook method TCL interface serialize method TCL interface status method TCL interface timeout method TCL interface total_changes method TCL interface trace method TCL interface trace_v2 method TCL interface transaction method TCL interface unlock_notify method TCL interface update_hook method TCL interface version method TCL interface wal_hook method TCL test suite TCL variable substitution TEA tarball TEMP triggers on non-TEMP tables temp_store pragma temp_store_directory pragma temporary databases temporary directory search algorithm temporary disk files temporary tables test coverage test harness test suite testcase macros testing text encoding TH3 the -> and ->> operators the -> operator the .fullschema dot-command the amalgamation the ext3 barrier problem The Fossil NGQP Upgrade Case Study the json1 extension the SQLITE_DBPAGE extension the SQLITE_MEMSTAT extension the SQLITE_STMT extension The Use Of assert() In SQLite the xCachesize() page cache method the xCreate() page cache methods the xDestroy() page cache method the xFetch() page cache methods the xInit() page cache method the xPagecount() page cache methods the xRekey() page cache methods the xShrink() page cache method the xShutdown() page cache method the xUnpin() page cache method Things That Can Go Wrong threading mode threads pragma three test harnesses time shift modifiers time() time() SQL function timediff() timediff() SQL function timeout method tokenizer torn page total() aggregate function total_changes method total_changes() SQL function trace method trace_v2 method transaction transaction method transaction state transactional treats the CROSS JOIN operator specially trigger trigram indexes trigram tokenizer trim() SQL function trunc() SQL function truncate optimization trusted_schema pragma type affinity type-name type-name syntax diagram typeof() SQL function UINT UINT collating sequence undefined BEFORE trigger behavior undo/redo unhex() SQL function unicode() SQL function unicode61 Uniform Resource Identifier unindexed UNION virtual table union-vtab unionvtab UNIQUE unique constraint unique index unixepoch() unixepoch() function unixepoch() SQL function unlikely() SQL function unlink corruption unlinked database files unlock_notify method unprotected sqlite3_value unsafe-testing command-line option --unsafe-testing command-line option untrusted database files UPDATE UPDATE FROM --update option UPDATE trigger update-stmt update-stmt syntax diagram update-stmt-limited update-stmt-limited syntax diagram update_hook method upper() SQL function upsert clause UPSERT parsing ambiguity upsert-clause upsert-clause syntax diagram URI URI filename URI filename examples URI filenames in sqlite3_open() URI query parameters usable size use of shared cache mode is discouraged user-defined window functions user_version pragma using SQLite for websites Using the SQLite Online Backup API Using the SQLite Unlock Notification Feature 'utc' modifier vacuum VACUUM INTO vacuum-stmt vacuum-stmt syntax diagram value argument VALUES VALUES clause variable-length integer varint VDBE vdbe_addoptrace pragma vdbe_debug pragma vdbe_listing pragma vdbe_trace pragma vectors Version 3.0.0 Version 3.0.1 Version 3.0.2 Version 3.0.3 Version 3.0.4 Version 3.0.5 Version 3.0.6 Version 3.0.7 Version 3.0.8 Version 3.1.0 Version 3.1.1 Version 3.1.2 Version 3.1.3 Version 3.1.4 Version 3.1.5 Version 3.1.6 Version 3.10.0 Version 3.10.1 Version 3.10.2 Version 3.11.0 Version 3.11.1 Version 3.12.0 version 3.12.0 page size change Version 3.12.1 Version 3.12.2 Version 3.13.0 Version 3.13.0.0 Version 3.14 Version 3.14.0 Version 3.14.1 Version 3.14.2 Version 3.15.0 Version 3.15.1 Version 3.15.2 Version 3.16.0 Version 3.16.1 Version 3.16.2 Version 3.17.0 Version 3.18.0 Version 3.18.1 Version 3.18.2 Version 3.19.0 Version 3.19.1 Version 3.19.2 Version 3.19.3 Version 3.2.0 Version 3.2.1 Version 3.2.2 Version 3.2.3 Version 3.2.4 Version 3.2.5 Version 3.2.6 Version 3.2.7 Version 3.2.8 Version 3.20.0 Version 3.20.1 Version 3.21.0 Version 3.22.0 Version 3.23.0 Version 3.23.0.0 Version 3.23.1 Version 3.23.1.0 Version 3.24.0 Version 3.25.0 Version 3.25.1 Version 3.25.2 Version 3.25.3 Version 3.26.0 Version 3.27.0 Version 3.27.1 Version 3.27.2 Version 3.28.0 Version 3.29.0 Version 3.3.0 Version 3.3.0.0 Version 3.3.1 Version 3.3.1.0 Version 3.3.10 Version 3.3.10.0 Version 3.3.11 Version 3.3.11.0 Version 3.3.12 Version 3.3.12.0 Version 3.3.13 Version 3.3.13.0 Version 3.3.14 Version 3.3.14.0 Version 3.3.15 Version 3.3.15.0 Version 3.3.16 Version 3.3.16.0 Version 3.3.17 Version 3.3.17.0 Version 3.3.2 Version 3.3.2.0 Version 3.3.3 Version 3.3.3.0 Version 3.3.4 Version 3.3.4.0 Version 3.3.5 Version 3.3.5.0 Version 3.3.6 Version 3.3.6.0 Version 3.3.7 Version 3.3.7.0 Version 3.3.8 Version 3.3.8.0 Version 3.3.9 Version 3.3.9.0 Version 3.30.0 Version 3.30.1 Version 3.31.0 Version 3.31.1 Version 3.32.0 Version 3.32.1 Version 3.32.2 Version 3.32.3 Version 3.33.0 Version 3.33.0.0 Version 3.34.0 Version 3.34.1 Version 3.35.0 Version 3.35.1 Version 3.35.2 Version 3.35.3 Version 3.35.4 Version 3.35.5 Version 3.36.0 Version 3.37.0 Version 3.37.1 Version 3.37.2 Version 3.38.0 Version 3.38.1 Version 3.38.2 Version 3.38.3 Version 3.38.4 Version 3.38.5 Version 3.39.0 Version 3.39.1 Version 3.39.2 Version 3.39.3 Version 3.39.4 Version 3.4.0 Version 3.4.1 Version 3.4.2 Version 3.40.0 Version 3.40.1 Version 3.41.0 Version 3.41.1 Version 3.41.2 Version 3.42.0 Version 3.43.0 Version 3.43.0.0 Version 3.43.1 Version 3.43.1.0 Version 3.43.2 Version 3.43.2.0 Version 3.44.0 Version 3.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 xIntegrity xIntegrity method xNext xQueryFunc R*Tree callback xRelease xRename xRollback xRollbackTo xRowid xSavepoint xShadowName xUpdate YYSTACKDEPTH YYTRACKMAXSTACKDEPTH zero-configuration zero-malloc memory allocator zeroblob() SQL function ZIP file as database zipfile Zipfile virtual table
