SQLite 官方文档

Full-Text Search

  • "automerge" command
  • "merge" command
  • "optimize" command
  • "rebuild" command
  • Auxiliary function mapping
  • commands
  • Comparison with fts4
  • Compile fts
  • Compressed FTS4 content
  • Contentless fts4 tables
  • Custom auxiliary functions
  • Custom tokenizers
  • Enhanced query syntax
  • Extending FTS5
  • External content fts4 tables
  • FTS auxiliary functions
  • FTS hidden column
  • FTS MATCH
  • FTS shadow tables
  • fts3tokenize
  • fts3_tokenizer
  • FTS4
  • FTS4 "integrity-check" command
  • FTS4 commands
  • fts4 compress option
  • FTS4 content option
  • FTS4 languageid option
  • FTS4 matchinfo option
  • FTS4 notindexed option
  • FTS4 options
  • FTS4 order option
  • FTS4 prefix option
  • fts4aux
  • fts4aux languageid column
  • FTS5 automerge option
  • FTS5 auxiliary functions
  • FTS5 bm25
  • FTS5 boolean operators
  • FTS5 building
  • FTS5 column filters
  • FTS5 columnsize option
  • FTS5 content option
  • FTS5 contentless tables
  • FTS5 CREATE TABLE Options
  • FTS5 custom auxiliary functions
  • FTS5 delete command
  • FTS5 delete-all command
  • FTS5 detail option
  • FTS5 external content tables
  • FTS5 highlight
  • FTS5 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 snippet
  • FTS5 Strings
  • fts5 technical differences
  • FTS5 tokenizers
  • FTS5 usermerge option
  • fts5vocab
  • matchinfo
  • Matchinfo b flag
  • Matchinfo x flag
  • Matchinfo y flag
  • NEAR queries
  • Phrase queries
  • Prefix queries
  • Search application tips
  • Segment btree
  • shadowtabs
  • Simple fts queries
  • SQLite FTS3 and FTS4 Extensions
  • SQLite FTS5 Extension
  • tokenizer
  • unicode61
  • unindexed

    • Language

  • 'utc' modifier
  • abs()
  • Aggregate Functions
  • ALTER TABLE
  • ANALYZE
  • ATTACH DATABASE
  • Automatically running ANALYZE
  • avg() aggregate function
  • Bare aggregate terms
  • BEGIN EXCLUSIVE
  • BEGIN TRANSACTION
  • BETWEEN
  • Binary operators
  • Boolean expression
  • Bound parameter
  • CASE expression
  • CAST
  • changes()
  • char()
  • CHECK
  • coalesce()
  • COLLATE
  • COLLATE operator
  • Column definition
  • comment
  • Compound query
  • Compute the Mandelbrot set
  • constraints
  • Core Functions
  • Correlated subqueries
  • count() aggregate function
  • CREATE INDEX
  • CREATE TABLE
  • CREATE TABLE AS
  • CREATE TRIGGER
  • CREATE VIEW
  • CREATE VIRTUAL TABLE
  • Database Object Name Resolution
  • Date And Time Functions
  • Default column value
  • DELETE
  • DESC
  • DETACH DATABASE
  • DISTINCT
  • DROP INDEX
  • DROP TABLE
  • DROP TRIGGER
  • DROP VIEW
  • ESCAPE
  • EXISTS operator
  • EXPLAIN
  • expression
  • FROM clause
  • GLOB
  • glob()
  • GROUP BY
  • group_concat() aggregate function
  • hex()
  • Hexadecimal integer literals
  • ifnull()
  • INDEXED BY
  • INSERT
  • INSTEAD OF
  • instr()
  • INTEGER PRIMARY KEY
  • IS NOT operator
  • last_insert_rowid()
  • length()
  • like()
  • likelihood()
  • likely()
  • LIMIT
  • Literal value
  • load_extension()
  • lower()
  • ltrim()
  • MATCH
  • max()
  • max() aggregate function
  • min()
  • min() aggregate function
  • NOT NULL
  • nullif()
  • ON CONFLICT clause
  • ORDER BY
  • Ordinary common table expressions
  • PRIMARY KEY
  • printf()
  • Query Language Understood by SQLite
  • quote()
  • RAISE function
  • random()
  • randomblob()
  • Recursive common table expression
  • REGEXP
  • REINDEX
  • REPLACE
  • replace()
  • round()
  • rtrim()
  • SAVEPOINT
  • SELECT
  • Simple SELECT
  • Solve Sudoku puzzles
  • soundex()
  • SQLite Keywords
  • sqlite_compileoption_get()
  • sqlite_compileoption_used()
  • sqlite_source_id()
  • sqlite_version()
  • Subqueries
  • substr()
  • sum() aggregate function
  • table-valued functions in the FROM clause
  • TEMP triggers on non-TEMP tables
  • total_changes()
  • Treats the CROSS JOIN operator specially
  • trim()
  • Truncate optimization
  • typeof()
  • Undefined BEFORE trigger behavior
  • unicode()
  • UNIQUE
  • Unique index
  • unlikely()
  • UPDATE
  • upper()
  • VACUUM
  • VALUES
  • WHERE clause
  • WITH clause
  • zeroblob()

    • CLI

  • .fullschema
  • .selftest dot-command
  • .sha3sum dot-command
  • Command Line Shell For SQLite
  • CSV export
  • CSV import
  • dot-commands
  • Explain dot-command
  • File I/O functions

    • Miscellaneous

  • .imposter dot-command
  • 35% Faster Than The Filesystem
  • 8+3 Filenames
  • An Asynchronous I/O Module For SQLite
  • Appropriate Uses For SQLite
  • Architecture of SQLite
  • Atomic Commit In SQLite
  • Automatic Undo/Redo With SQLite
  • Benefits of SQLite As A File Format
  • Benefits of using WITHOUT ROWID
  • Building a DLL
  • Building the amalgamation
  • Change in Default Page Size in SQLite Version 3.12.0
  • Clustered Indexes and the WITHOUT ROWID Optimization
  • Compile loadable extensions
  • Compile-time Options
  • Compiling the CLI
  • Compiling the TCL interface
  • Configurable edit distances
  • Constraint Conflict Resolution in SQLite
  • Custom Builds Of SQLite
  • Database corruption caused by inconsistent use of 8+3 filenames
  • Deterministic SQL Functions
  • Distinctive Features Of SQLite
  • editdist3
  • EXPLAIN QUERY PLAN
  • Extended error code
  • Features Of SQLite
  • File Format Changes in SQLite
  • Full-Featured SQL
  • High Reliability
  • Hints for Debugging SQLite
  • How SQLite Is Tested
  • How To Compile SQLite
  • How To Download Canonical SQLite Source Code
  • Imposter Tables
  • In-Memory Databases
  • in-memory shared cache database
  • in-memory shared-cache
  • Indexes On Expressions
  • Internal Versus External BLOBs
  • Isolation In SQLite
  • List of current bytecodes
  • Long Term Support
  • Maintaining Private Branches Of SQLite
  • Many Small Queries Are Efficient In SQLite
  • Master journal
  • Measuring and Reducing CPU Usage in SQLite
  • Memory-Mapped I/O
  • microoptimizations
  • Mutation test script
  • NULL Handling in SQLite
  • Partial Indexes
  • Persistent loadable extensions
  • Powersafe Overwrite
  • Primary versus extended result codes
  • Programming Loadable Extensions
  • Release History Of SQLite
  • relfootprint
  • Result and Error Codes
  • Row Values
  • Rowid Tables
  • Run-Time Loadable Extensions
  • shims
  • Split amalgamation
  • SQL Features That SQLite Does Not Implement
  • SQLAR smaller than ZIP
  • sqldiff.exe: Database Difference Utility
  • SQLite As An Application File Format
  • SQLite Autoincrement
  • SQLite Backup API
  • SQLite Changes From Version 3.4.2 To 3.5.0
  • SQLite Changes From Version 3.5.9 To 3.6.0
  • SQLite Database Speed Comparison
  • SQLite File IO Specification
  • SQLite Frequently Asked Questions
  • SQLite In 5 Minutes Or Less
  • SQLite is a Self Contained System
  • SQLite Is Serverless
  • SQLite Is Transactional
  • SQLite Library Footprint
  • SQLite Shared-Cache Mode
  • SQLite Unlock-Notify API
  • SQLite Version 3 Overview
  • SQLite: Single File Database
  • Statement journal
  • subprograms
  • Temporary databases
  • Temporary directory search algorithm
  • Temporary Files Used By SQLite
  • TH3
  • The CSV Virtual Table
  • The dbhash.exe Utility Program
  • The DBSTAT Virtual Table
  • The Error And Warning Log
  • The generate_series Table-Valued Function
  • The OS Backend (VFS) To SQLite
  • The Spellfix1 Virtual Table
  • The SQLite Amalgamation
  • The SQLite Bytecode Engine
  • The sqlite3_analyzer.exe Utility Program
  • The Virtual Database Engine of SQLite
  • Things That Can Go Wrong
  • Torn page
  • Uniform Resource Identifiers
  • Using SQLite In Multi-Threaded Applications
  • Version Numbers in SQLite
  • What If OpenDocument Used SQLite?
  • When to use WITHOUT ROWID
  • Why Is SQLite Coded In C
  • Zero-Configuration

    • C Interface

  • 64-Bit Integer Types
  • A Handle To An Open BLOB
  • An Introduction To The SQLite C/C++ Interface
  • Application Defined Page Cache
  • Attempt To Free Heap Memory
  • Authorizer Action Codes
  • Authorizer Return Codes
  • Automatically Load Statically Linked Extensions
  • Binding Values To Prepared Statements
  • C/C++ Interface For SQLite Version 3
  • C/C++ Interface For SQLite Version 3 (old)
  • Cancel Automatic Extension Loading
  • Checkpoint a database
  • Checkpoint a database
  • Checkpoint Mode Values
  • Close A BLOB Handle
  • Closing A Database Connection
  • Collation Needed Callbacks
  • Column Names In A Result Set
  • Commit And Rollback Notification Callbacks
  • Compare the ages of two snapshot handles
  • Compile-Time Authorization Callbacks
  • Compile-Time Library Version Numbers
  • Compiling An SQL Statement
  • Configuration Options
  • Configure an auto-checkpoint
  • Configure database connections
  • Configuring The SQLite Library
  • Conflict resolution modes
  • Constants Defining Special Destructor Behavior
  • Convenience Routines For Running Queries
  • Copy And Free SQL Values
  • Core URI query parameters
  • Count The Number Of Rows Modified
  • Create Or Redefine SQL Functions
  • Custom Page Cache Object
  • Custom Page Cache Object
  • Data Change Notification Callbacks
  • Database Connection Configuration Options
  • Database Connection For Functions
  • Database Connection Handle
  • Database Connection Status
  • Database Snapshot
  • Declare The Schema Of A Virtual Table
  • Declared Datatype Of A Query Result
  • Define New Collating Sequences
  • Deprecated Functions
  • Deprecated Soft Heap Limit Interface
  • Destroy A Prepared Statement Object
  • Destroy a snapshot
  • Determine if a database is read-only
  • Determine If A Prepared Statement Has Been Reset
  • Determine If An SQL Statement Is Complete
  • Determine If An SQL Statement Writes The Database
  • Determine The Virtual Table Conflict Policy
  • Device Characteristics
  • Dynamically Typed Value Object
  • Enable Or Disable Extended Result Codes
  • Enable Or Disable Extension Loading
  • Enable Or Disable Shared Pager Cache
  • Error Codes And Messages
  • Error Logging Interface
  • Evaluate An SQL Statement
  • Experimental Interfaces
  • Extended Result Codes
  • Extract Metadata About A Column Of A Table
  • File Locking Levels
  • Find The Database Handle Of A Prepared Statement
  • Find the next prepared statement
  • Finding The Subtype Of SQL Values
  • Flags For File Open Operations
  • Flags for the xAccess VFS method
  • Flags for the xShmLock VFS method
  • Flush caches to disk mid-transaction
  • Formatted String Printing Functions
  • Free Memory Used By A Database Connection
  • Function Auxiliary Data
  • Function Flags
  • Fundamental Datatypes
  • Impose A Limit On Heap Size
  • Index Of A Parameter With A Given Name
  • Initialize The SQLite Library
  • Interrupt A Long-Running Query
  • Introduction
  • Last Insert Rowid
  • List Of SQLite Constants
  • List Of SQLite Functions
  • List Of SQLite Objects
  • Load An Extension
  • Loadable Extension Thunk
  • Low-Level Control Of Database Files
  • Low-level system error code
  • Maximum xShmLock index
  • Memory Allocation Routines
  • Memory Allocation Subsystem
  • Memory Allocator Statistics
  • Move a BLOB Handle to a New Row
  • Mutex Handle
  • Mutex Methods Object
  • Mutex Types
  • Mutex Verification Routines
  • Mutexes
  • Name Of A Host Parameter
  • Name Of The Folder Holding Database Files
  • Name Of The Folder Holding Temporary Files
  • Number Of Columns In A Result Set
  • Number of columns in a result set
  • Number Of SQL Parameters
  • Obtain Aggregate Function Context
  • Obtain Values For URI Parameters
  • Obtaining SQL Values
  • One-Step Query Execution Interface
  • Online Backup API
  • Online Backup Object
  • Open A BLOB For Incremental I/O
  • Opening A New Database Connection
  • OS Interface File Virtual Methods Object
  • OS Interface Object
  • OS Interface Open File Handle
  • Overload A Function For A Virtual Table
  • Prepared Statement Object
  • Prepared Statement Scan Status
  • Prepared Statement Scan Status Opcodes
  • Prepared Statement Status
  • Pseudo-Random Number Generator
  • Query Progress Callbacks
  • Read Data From A BLOB Incrementally
  • Record A Database Snapshot
  • Recover snapshots from a wal file
  • Register A Callback To Handle SQLITE_BUSY Errors
  • Register A Virtual Table Implementation
  • Reset A Prepared Statement Object
  • Reset All Bindings On A Prepared Statement
  • Reset Automatic Extension Loading
  • Result Codes
  • Result Values From A Query
  • Retrieve the mutex for a database connection
  • Retrieving Statement SQL
  • Return The Filename For A Database Connection
  • Return The Size Of An Open BLOB
  • Run-Time Library Compilation Options Diagnostics
  • Run-Time Library Version Numbers
  • Run-Time Limit Categories
  • Run-time Limits
  • Set A Busy Timeout
  • Set the Last Insert Rowid value
  • Setting The Result Of An SQL Function
  • Setting The Subtype Of An SQL Function
  • Source Of Data In A Query Result
  • SQL Function Context Object
  • SQL Trace Event Codes
  • SQL Trace Hook
  • SQLite Runtime Status
  • sqlite3_backup_finish()
  • sqlite3_backup_init()
  • sqlite3_backup_pagecount()
  • sqlite3_backup_remaining()
  • sqlite3_backup_step()
  • sqlite3_vfs.xAccess
  • sqlite3_vfs.xOpen
  • 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_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_SQLLOG
  • SQLITE_CONFIG_STMTJRNL_SPILL
  • SQLITE_CONFIG_URI
  • SQLITE_CONFIG_WIN32_HEAPSIZE
  • SQLITE_DBSTATUS_CACHE_HIT
  • SQLITE_DBSTATUS_CACHE_MISS
  • 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_FCNTL_BUSYHANDLER
  • SQLITE_FCNTL_CHUNK_SIZE
  • SQLITE_FCNTL_COMMIT_PHASETWO
  • SQLITE_FCNTL_FILE_POINTER
  • SQLITE_FCNTL_HAS_MOVED
  • SQLITE_FCNTL_JOURNAL_POINTER
  • SQLITE_FCNTL_LOCKSTATE
  • SQLITE_FCNTL_MMAP_SIZE
  • SQLITE_FCNTL_OVERWRITE
  • SQLITE_FCNTL_PERSIST_WAL
  • SQLITE_FCNTL_POWERSAFE_OVERWRITE
  • SQLITE_FCNTL_PRAGMA
  • SQLITE_FCNTL_RBU
  • SQLITE_FCNTL_SIZE_HINT
  • 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_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_SCANSTAT_EST
  • SQLITE_SCANSTAT_EXPLAIN
  • SQLITE_SCANSTAT_NAME
  • SQLITE_SCANSTAT_NLOOP
  • SQLITE_SCANSTAT_NVISIT
  • SQLITE_SCANSTAT_SELECTID
  • 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_FULLSCAN_STEP
  • SQLITE_STMTSTATUS_SORT
  • SQLITE_STMTSTATUS_VM_STEP
  • SQLITE_TRACE_CLOSE
  • SQLITE_TRACE_PROFILE
  • SQLITE_TRACE_ROW
  • SQLITE_TRACE_STMT
  • Standard File Control Opcodes
  • Start a read transaction on an historical snapshot
  • Status Parameters
  • Status Parameters for database connections
  • Status Parameters for prepared statements
  • String Comparison
  • String Globbing
  • String LIKE Matching
  • Suspend Execution For A Short Time
  • Synchronization Type Flags
  • Test For Auto-Commit Mode
  • Test To See If The Library Is Threadsafe
  • Testing Interface
  • Testing Interface Operation Codes
  • Text Encodings
  • The C language interface to SQLite Version 2
  • The Carray() Table-Valued Function
  • The pre-update hook
  • Total Number Of Rows Modified
  • Tracing And Profiling Functions
  • Unlock Notification
  • URI filename examples
  • URI filenames in sqlite3_open()
  • User Data For Functions
  • Virtual File System Objects
  • Virtual Table Configuration Options
  • Virtual Table Constraint Operator Codes
  • Virtual Table Cursor Object
  • Virtual Table Indexing Information
  • Virtual Table Instance Object
  • Virtual Table Interface Configuration
  • Virtual Table Object
  • Virtual Table Scan Flags
  • Write Data Into A BLOB Incrementally
  • Write-Ahead Log Commit Hook
  • xCachesize() page cache method
  • xCreate() page cache methods
  • 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 Scan-Status Counters

    • C Interface: Session Module

  • Add A Changeset To A Changegroup
  • Advance A Changeset Iterator
  • Apply A Changeset To A Database
  • Attach A Table To A Session Object
  • Changegroup Handle
  • Changeset Iterator Handle
  • Concatenate Two Changeset Objects
  • Constants Passed To The Conflict Handler
  • Constants Returned By The Conflict Handler
  • Create A New Changegroup Object
  • Create A New Session Object
  • Create An Iterator To Traverse A Changeset
  • Delete A Changegroup Object
  • Delete A Session Object
  • Determine The Number Of Foreign Key Constraint Violations
  • Enable Or Disable A Session Object
  • Finalize A Changeset Iterator
  • Generate A Changeset From A Session Object
  • Generate A Patchset From A Session Object
  • Invert A Changeset
  • List Of SQLite Constants
  • List Of SQLite Functions
  • List Of SQLite Objects
  • Load The Difference Between Tables Into A Session
  • Obtain A Composite Changeset From A Changegroup
  • Obtain Conflicting Row Values From A Changeset Iterator
  • Obtain new.* Values From A Changeset Iterator
  • Obtain old.* Values From A Changeset Iterator
  • Obtain The Current Operation From A Changeset Iterator
  • Obtain The Primary Key Definition Of A Table
  • Session Object Handle
  • Set a table filter on a Session Object
  • Set Or Clear the Indirect Change Flag
  • SQLite Session Module C/C++ Interface
  • Streaming Versions of API functions
  • Test if a changeset has recorded any changes
  • The Session Extension

    • Write-Ahead Logging

  • Advantages of WAL-mode
  • Avoiding large WAL files
  • checkpoint
  • read-only WAL databases
  • WAL backwards compatibility
  • WAL concurrency
  • WAL without shared memory
  • WAL-mode read blocking
  • Write-Ahead Logging

    • Datatypes

  • affinity
  • Affinity Of Expressions
  • BINARY collating function
  • Boolean datatype
  • Comparison affinity rules
  • Comparison expressions
  • Datatypes In SQLite version 2
  • Datatypes In SQLite Version 3
  • Date and time datatype
  • How collation is determined
  • Rules for determining column affinity
  • Rules for determining column affinity in VIEWs
  • Storage class

    • Database File Format

  • Application ID
  • B*-Trees
  • Cell format summary
  • Cell payload
  • Change counter
  • Database File Format
  • Database File Format
  • Database header
  • free-page list
  • in-header database size
  • Internal index
  • Overflow page
  • Record format
  • Rollback journal format
  • Schema format
  • Serial type
  • sqlite_master
  • sqlite_sequence
  • sqlite_stat1
  • sqlite_stat2
  • sqlite_stat3
  • sqlite_stat4
  • Text encoding
  • Usable size
  • variable-length integer
  • version-valid-for number
  • WAL checksum algorithm
  • WAL format
  • WAL read algorithm
  • wal-index

    • PRAGMA Statements

  • application_id pragma
  • automatic_index pragma
  • auto_vacuum 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
  • database_list pragma
  • data_store_directory pragma
  • data_version pragma
  • default_cache_size pragma
  • defer_foreign_keys pragma
  • empty_result_callbacks pragma
  • Encoding pragma
  • foreign_keys pragma
  • foreign_key_check pragma
  • foreign_key_list pragma
  • freelist_count pragma
  • Fullfsync pragma
  • full_column_names 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_file_format pragma
  • locking_mode pragma
  • max_page_count pragma
  • mmap_size pragma
  • Optimize pragma
  • page_count pragma
  • page_size pragma
  • parser_trace pragma
  • PRAGMA
  • PRAGMA function
  • 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 statements supported by SQLite
  • PRAGMA stats
  • PRAGMA synchronous
  • PRAGMA table_info
  • PRAGMA temp_store
  • PRAGMA temp_store_directory
  • PRAGMA threads
  • PRAGMA user_version
  • PRAGMA vdbe_addoptrace
  • PRAGMA vdbe_debug
  • PRAGMA vdbe_listing
  • PRAGMA vdbe_trace
  • PRAGMA wal_autocheckpoint
  • PRAGMA wal_checkpoint
  • PRAGMA writable_schema

    • Tcl Interface

  • Authorizer method
  • Backup method
  • Busy method
  • Cache method
  • Changes method
  • Close method
  • Collate method
  • collation_needed method
  • commit_hook method
  • Complete method
  • Copy method
  • enable_load_extension method
  • Errorcode method
  • Eval method
  • Exists method
  • Function method
  • Incrblob method
  • last_insert_rowid method
  • Nullvalue method
  • Onecolumn method
  • Profile method
  • Progress method
  • Restore method
  • rollback_hook method
  • Status method
  • TCL interface timeout method
  • TCL interface total_changes method
  • TCL interface trace 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 variable substitution
  • The Tcl interface to the SQLite library

    • Query Planner

  • Automatic indexing
  • Block sorting
  • Covering index
  • CROSS JOIN
  • Flattening optimization
  • Hazards of upgrading to the NGQP
  • Join order
  • LIKE optimization
  • Manual Control Of Query Plans Using SQLITE_STAT Tables
  • Or optimization
  • or-connected-terms
  • Query planner checklist
  • Query planner stability guarantee
  • Query Planning
  • Range query optimization
  • skip-scan
  • sorting
  • Sorting subsets of the result
  • strategies
  • The Fossil NGQP Upgrade Case Study
  • The Next-Generation Query Planner
  • The SQLite Query Optimizer Overview

    • Dynamic Memory Allocation

  • built-in memory allocators
  • Debugging memory allocator
  • Default memory allocator
  • Dynamic Memory Allocation In SQLite
  • Experimental memory allocators
  • lookaside
  • Memory statistics
  • Pagecache memory allocator
  • Robson proof
  • Scratch memory allocator
  • Win32 native memory allocator
  • zero-malloc memory allocator

    • How To Corrupt

  • cfgerrors*
  • Database filename aliasing
  • Deleting a hot journal
  • Filesystem corruption
  • How To Corrupt An SQLite Database File
  • Unlink corruption

    • Foreign Key Constraints

  • Child key
  • Foreign key actions
  • Foreign key constraints are enabled
  • SQLite Foreign Key Support

    • Virtual Table Mechanism

  • colUsed field
  • Eponymous virtual table
  • eponymous-only virtual table
  • Hidden column
  • sqlite3_module.xBegin
  • sqlite3_module.xBestIndex
  • sqlite3_module.xClose
  • sqlite3_module.xColumn
  • sqlite3_module.xCommit
  • sqlite3_module.xConnect
  • sqlite3_module.xCreate
  • sqlite3_module.xDisconnect
  • sqlite3_module.xEof
  • sqlite3_module.xFilter
  • sqlite3_module.xFindFunction
  • sqlite3_module.xNext
  • sqlite3_module.xOpen
  • sqlite3_module.xRename
  • sqlite3_module.xRollback
  • sqlite3_module.xRowid
  • sqlite3_module.xSavepoint
  • sqlite3_module.xSync
  • sqlite3_module.xUpdate
  • table-valued function
  • The Virtual Table Mechanism Of SQLite
  • WITHOUT ROWID virtual tables
  • xDestroy

    • R*Tree Module

  • Custom r-tree queries
  • integer-valued r-trees
  • sqlite3_rtree_query_callback
  • The SQLite R*Tree Module

    • Locking and Concurrency

  • ext3 barrier problem
  • File Locking And Concurrency In SQLite Version 3
  • File locking states
  • Hot journal
  • How To Corrupt Your Database Files
  • Rollback journal
  • Writer starvation

    • Limits

  • Implementation Limits For SQLite
  • 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

    • JSON

  • json
  • json_array
  • json_array_length
  • json_each
  • json_extract
  • json_group_array
  • json_group_object
  • json_insert
  • json_object
  • json_patch
  • json_quote
  • json_remove
  • json_replace
  • json_set
  • json_tree
  • json_type
  • json_valid
  • The JSON1 Extension

    • RBU Extension

  • RBU Database Contents
  • RBU Database Tables
  • RBU FTS3/4 Tables
  • RBU Update
  • RBU Vacuum
  • Sqldiff --rbu
  • The RBU Extension

    • Syntax Diagrams

  • SQLite Syntax: alter-table-stmt
  • SQLite Syntax: analyze-stmt
  • SQLite Syntax: attach-stmt
  • SQLite Syntax: begin-stmt
  • SQLite Syntax: column-constraint
  • SQLite Syntax: column-def
  • SQLite Syntax: column-name-list
  • SQLite Syntax: comment-syntax
  • SQLite Syntax: commit-stmt
  • SQLite Syntax: common-table-expression
  • SQLite Syntax: compound-operator
  • SQLite Syntax: compound-select-stmt
  • SQLite Syntax: conflict-clause
  • SQLite Syntax: create-index-stmt
  • SQLite Syntax: create-table-stmt
  • SQLite Syntax: create-trigger-stmt
  • SQLite Syntax: create-view-stmt
  • SQLite Syntax: create-virtual-table-stmt
  • SQLite Syntax: cte-table-name
  • SQLite Syntax: delete-stmt
  • SQLite Syntax: delete-stmt-limited
  • SQLite Syntax: detach-stmt
  • SQLite Syntax: drop-index-stmt
  • SQLite Syntax: drop-table-stmt
  • SQLite Syntax: drop-trigger-stmt
  • SQLite Syntax: drop-view-stmt
  • SQLite Syntax: expr
  • SQLite Syntax: factored-select-stmt
  • SQLite Syntax: foreign-key-clause
  • SQLite Syntax: indexed-column
  • SQLite Syntax: insert-stmt
  • SQLite Syntax: join-clause
  • SQLite Syntax: join-constraint
  • SQLite Syntax: join-operator
  • SQLite Syntax: literal-value
  • SQLite Syntax: numeric-literal
  • SQLite Syntax: ordering-term
  • SQLite Syntax: pragma-stmt
  • SQLite Syntax: pragma-value
  • SQLite Syntax: qualified-table-name
  • SQLite Syntax: raise-function
  • SQLite Syntax: recursive-cte
  • SQLite Syntax: reindex-stmt
  • SQLite Syntax: release-stmt
  • SQLite Syntax: result-column
  • SQLite Syntax: rollback-stmt
  • SQLite Syntax: savepoint-stmt
  • SQLite Syntax: select-core
  • SQLite Syntax: select-stmt
  • SQLite Syntax: signed-number
  • SQLite Syntax: simple-select-stmt
  • SQLite Syntax: sql-stmt
  • SQLite Syntax: sql-stmt-list
  • SQLite Syntax: table-constraint
  • SQLite Syntax: table-or-subquery
  • SQLite Syntax: type-name
  • SQLite Syntax: update-stmt
  • SQLite Syntax: update-stmt-limited
  • SQLite Syntax: vacuum-stmt
  • SQLite Syntax: with-clause
  • Syntax Diagrams For SQLite

    • Index

  • index

    • Copyright©2021 w3cschool编程狮 闽ICP备15016281号-3 闽公网安备35020302033924号