Small. Fast. Reliable.
Choose any three.
Home
Menu
About
Documentation
Download
License
Support
Purchase
Search
About
Documentation
Download
Support
Purchase
Search Documentation
Search Changelog
34to35.html
→ 34to35
35to36.html
→ 35to36
aff_short.html
→ affshort {file-format benefits}
affcase1.html
→ {OpenOffice case study} {What If OpenOffice Used SQLite}
affcase1.html#smaller
→ {SQLite Archive smaller than ZIP}
amalgamation.html
→ {SQLite amalgamation source file} amalgamation {the amalgamation}
amalgamation.html#amal32k
→ {split amalgamation}
amalgamation.html#amalgtarball
→ {precompiled amalgamation tarballs}
appfileformat.html
→ {Application File Format} appformat {application file format} {application file-format}
appfunc.html
→ {application-defined SQL function} {application-defined SQL functions} {custom SQL function} {custom SQL functions}
appfunc.html#sec
→ {application-defined function attacks}
assert.html
→ {The Use Of assert In SQLite}
asyncvfs.html
→ {asynchronous I/O backend} {asynchronous VFS}
atomiccommit.html
→ {Atomic Commit} {atomic commit}
atomiccommit.html#sect_9_0
→ {Things That Can Go Wrong}
autoinc.html
→ AUTOINCREMENT
backup.html
→ {Using the SQLite Online Backup API} {backup API}
bindptr.html
→ {pointer passing interface} {pointer passing interfaces} {pointer value}
bindptr.html#ptrleak
→ {pointer leak} {pointer leaks}
bindptr.html#ptrtyp
→ {pointer types}
books.html
→ {books about SQLite}
bytecodevtab.html
→ bcvtab {bytecode and tables_used virtual tables} {bytecode virtual table} {tables_used virtual table}
c3ref/aggregate_context.html
→ sqlite3_aggregate_context
c3ref/aggregate_count.html
→ sqlite3_aggregate_count sqlite3_expired sqlite3_global_recover sqlite3_memory_alarm sqlite3_thread_cleanup sqlite3_transfer_bindings
c3ref/api_routines.html
→ sqlite3_api_routines
c3ref/auto_extension.html
→ sqlite3_auto_extension
c3ref/autovacuum_pages.html
→ sqlite3_autovacuum_pages
c3ref/backup.html
→ sqlite3_backup
c3ref/backup_finish.html#sqlite3backupfinish
→ sqlite3_backup_finish
c3ref/backup_finish.html#sqlite3backupinit
→ sqlite3_backup_init
c3ref/backup_finish.html#sqlite3backuppagecount
→ sqlite3_backup_pagecount
c3ref/backup_finish.html#sqlite3backupremaining
→ sqlite3_backup_remaining
c3ref/backup_finish.html#sqlite3backupstep
→ sqlite3_backup_step
c3ref/bind_blob.html
→ {SQL parameter} {SQL parameters} {host parameter} {host parameter name} {host parameters} {parameter binding} sqlite3_bind_blob sqlite3_bind_blob64 sqlite3_bind_double sqlite3_bind_int sqlite3_bind_int64 sqlite3_bind_null sqlite3_bind_pointer sqlite3_bind_text sqlite3_bind_text16 sqlite3_bind_text64 sqlite3_bind_value sqlite3_bind_zeroblob sqlite3_bind_zeroblob64
c3ref/bind_blob.html#byteorderdeterminationrules
→ {byte-order determination rules}
c3ref/bind_parameter_count.html
→ sqlite3_bind_parameter_count
c3ref/bind_parameter_index.html
→ sqlite3_bind_parameter_index
c3ref/bind_parameter_name.html
→ sqlite3_bind_parameter_name
c3ref/blob.html
→ {BLOB handle} {BLOB handles} sqlite3_blob
c3ref/blob_bytes.html
→ sqlite3_blob_bytes
c3ref/blob_close.html
→ sqlite3_blob_close
c3ref/blob_open.html
→ sqlite3_blob_open
c3ref/blob_read.html
→ sqlite3_blob_read
c3ref/blob_reopen.html
→ sqlite3_blob_reopen
c3ref/blob_write.html
→ sqlite3_blob_write
c3ref/busy_handler.html
→ {busy handler} {busy-handler callback} sqlite3_busy_handler
c3ref/busy_timeout.html
→ sqlite3_busy_timeout
c3ref/c_abort.html
→ {result code definitions}
c3ref/c_abort_rollback.html
→ SQLITE_IOERR_IN_PAGE SQLITE_NOTICE_RBU SQLITE_OK_SYMLINK {extended result code definitions}
c3ref/c_access_exists.html
→ SQLITE_ACCESS_EXISTS SQLITE_ACCESS_READ SQLITE_ACCESS_READWRITE
c3ref/c_alter_table.html
→ SQLITE_ALTER_TABLE SQLITE_ANALYZE SQLITE_ATTACH SQLITE_COPY 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_DELETE SQLITE_DETACH 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_FUNCTION SQLITE_INSERT SQLITE_PRAGMA SQLITE_READ SQLITE_RECURSIVE SQLITE_REINDEX SQLITE_SAVEPOINT SQLITE_SELECT SQLITE_TRANSACTION SQLITE_UPDATE
c3ref/c_any.html
→ SQLITE_ANY SQLITE_UTF16 SQLITE_UTF16BE SQLITE_UTF16LE SQLITE_UTF16_ALIGNED SQLITE_UTF8
c3ref/c_blob.html
→ SQLITE_BLOB SQLITE_FLOAT SQLITE_INTEGER SQLITE_NULL SQLITE_TEXT
c3ref/c_checkpoint_full.html
→ SQLITE_CHECKPOINT_FULL SQLITE_CHECKPOINT_PASSIVE SQLITE_CHECKPOINT_RESTART SQLITE_CHECKPOINT_TRUNCATE {checkpoint mode}
c3ref/c_config_covering_index_scan.html
→ {configuration option}
c3ref/c_config_covering_index_scan.html#sqliteconfigcoveringindexscan
→ SQLITE_CONFIG_COVERING_INDEX_SCAN
c3ref/c_config_covering_index_scan.html#sqliteconfiggetmalloc
→ SQLITE_CONFIG_GETMALLOC
c3ref/c_config_covering_index_scan.html#sqliteconfiggetmutex
→ SQLITE_CONFIG_GETMUTEX
c3ref/c_config_covering_index_scan.html#sqliteconfiggetpcache
→ SQLITE_CONFIG_GETPCACHE
c3ref/c_config_covering_index_scan.html#sqliteconfiggetpcache2
→ SQLITE_CONFIG_GETPCACHE2
c3ref/c_config_covering_index_scan.html#sqliteconfigheap
→ SQLITE_CONFIG_HEAP
c3ref/c_config_covering_index_scan.html#sqliteconfiglog
→ SQLITE_CONFIG_LOG
c3ref/c_config_covering_index_scan.html#sqliteconfiglookaside
→ SQLITE_CONFIG_LOOKASIDE
c3ref/c_config_covering_index_scan.html#sqliteconfigmalloc
→ SQLITE_CONFIG_MALLOC
c3ref/c_config_covering_index_scan.html#sqliteconfigmemdbmaxsize
→ SQLITE_CONFIG_MEMDB_MAXSIZE
c3ref/c_config_covering_index_scan.html#sqliteconfigmemstatus
→ SQLITE_CONFIG_MEMSTATUS
c3ref/c_config_covering_index_scan.html#sqliteconfigmmapsize
→ SQLITE_CONFIG_MMAP_SIZE
c3ref/c_config_covering_index_scan.html#sqliteconfigmultithread
→ SQLITE_CONFIG_MULTITHREAD
c3ref/c_config_covering_index_scan.html#sqliteconfigmutex
→ SQLITE_CONFIG_MUTEX
c3ref/c_config_covering_index_scan.html#sqliteconfigpagecache
→ SQLITE_CONFIG_PAGECACHE
c3ref/c_config_covering_index_scan.html#sqliteconfigpcache
→ SQLITE_CONFIG_PCACHE
c3ref/c_config_covering_index_scan.html#sqliteconfigpcache2
→ SQLITE_CONFIG_PCACHE2
c3ref/c_config_covering_index_scan.html#sqliteconfigpcachehdrsz
→ SQLITE_CONFIG_PCACHE_HDRSZ
c3ref/c_config_covering_index_scan.html#sqliteconfigpmasz
→ SQLITE_CONFIG_PMASZ
c3ref/c_config_covering_index_scan.html#sqliteconfigscratch
→ SQLITE_CONFIG_SCRATCH
c3ref/c_config_covering_index_scan.html#sqliteconfigserialized
→ SQLITE_CONFIG_SERIALIZED
c3ref/c_config_covering_index_scan.html#sqliteconfigsinglethread
→ SQLITE_CONFIG_SINGLETHREAD
c3ref/c_config_covering_index_scan.html#sqliteconfigsmallmalloc
→ SQLITE_CONFIG_SMALL_MALLOC
c3ref/c_config_covering_index_scan.html#sqliteconfigsorterrefsize
→ SQLITE_CONFIG_SORTERREF_SIZE
c3ref/c_config_covering_index_scan.html#sqliteconfigsqllog
→ SQLITE_CONFIG_SQLLOG
c3ref/c_config_covering_index_scan.html#sqliteconfigstmtjrnlspill
→ SQLITE_CONFIG_STMTJRNL_SPILL
c3ref/c_config_covering_index_scan.html#sqliteconfiguri
→ SQLITE_CONFIG_URI
c3ref/c_config_covering_index_scan.html#sqliteconfigwin32heapsize
→ SQLITE_CONFIG_WIN32_HEAPSIZE
c3ref/c_dbconfig_defensive.html
→ SQLITE_DBCONFIG_MAX
c3ref/c_dbconfig_defensive.html#sqlitedbconfigdefensive
→ SQLITE_DBCONFIG_DEFENSIVE
c3ref/c_dbconfig_defensive.html#sqlitedbconfigdqsddl
→ SQLITE_DBCONFIG_DQS_DDL
c3ref/c_dbconfig_defensive.html#sqlitedbconfigdqsdml
→ SQLITE_DBCONFIG_DQS_DML
c3ref/c_dbconfig_defensive.html#sqlitedbconfigenablefkey
→ SQLITE_DBCONFIG_ENABLE_FKEY
c3ref/c_dbconfig_defensive.html#sqlitedbconfigenablefts3tokenizer
→ SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
c3ref/c_dbconfig_defensive.html#sqlitedbconfigenableloadextension
→ SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION
c3ref/c_dbconfig_defensive.html#sqlitedbconfigenableqpsg
→ SQLITE_DBCONFIG_ENABLE_QPSG
c3ref/c_dbconfig_defensive.html#sqlitedbconfigenabletrigger
→ SQLITE_DBCONFIG_ENABLE_TRIGGER
c3ref/c_dbconfig_defensive.html#sqlitedbconfigenableview
→ SQLITE_DBCONFIG_ENABLE_VIEW
c3ref/c_dbconfig_defensive.html#sqlitedbconfiglegacyaltertable
→ SQLITE_DBCONFIG_LEGACY_ALTER_TABLE
c3ref/c_dbconfig_defensive.html#sqlitedbconfiglegacyfileformat
→ SQLITE_DBCONFIG_LEGACY_FILE_FORMAT
c3ref/c_dbconfig_defensive.html#sqlitedbconfiglookaside
→ SQLITE_DBCONFIG_LOOKASIDE
c3ref/c_dbconfig_defensive.html#sqlitedbconfigmaindbname
→ SQLITE_DBCONFIG_MAINDBNAME
c3ref/c_dbconfig_defensive.html#sqlitedbconfignockptonclose
→ SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE
c3ref/c_dbconfig_defensive.html#sqlitedbconfigresetdatabase
→ SQLITE_DBCONFIG_RESET_DATABASE
c3ref/c_dbconfig_defensive.html#sqlitedbconfigreversescanorder
→ SQLITE_DBCONFIG_REVERSE_SCANORDER
c3ref/c_dbconfig_defensive.html#sqlitedbconfigstmtscanstatus
→ SQLITE_DBCONFIG_STMT_SCANSTATUS
c3ref/c_dbconfig_defensive.html#sqlitedbconfigtriggereqp
→ SQLITE_DBCONFIG_TRIGGER_EQP
c3ref/c_dbconfig_defensive.html#sqlitedbconfigtrustedschema
→ SQLITE_DBCONFIG_TRUSTED_SCHEMA
c3ref/c_dbconfig_defensive.html#sqlitedbconfigwritableschema
→ SQLITE_DBCONFIG_WRITABLE_SCHEMA
c3ref/c_dbstatus_options.html
→ {SQLITE_DBSTATUS options} SQLITE_DBSTATUS_MAX
c3ref/c_dbstatus_options.html#sqlitedbstatuscachehit
→ SQLITE_DBSTATUS_CACHE_HIT
c3ref/c_dbstatus_options.html#sqlitedbstatuscachemiss
→ SQLITE_DBSTATUS_CACHE_MISS
c3ref/c_dbstatus_options.html#sqlitedbstatuscachespill
→ SQLITE_DBSTATUS_CACHE_SPILL
c3ref/c_dbstatus_options.html#sqlitedbstatuscacheused
→ SQLITE_DBSTATUS_CACHE_USED
c3ref/c_dbstatus_options.html#sqlitedbstatuscacheusedshared
→ SQLITE_DBSTATUS_CACHE_USED_SHARED
c3ref/c_dbstatus_options.html#sqlitedbstatuscachewrite
→ SQLITE_DBSTATUS_CACHE_WRITE
c3ref/c_dbstatus_options.html#sqlitedbstatusdeferredfks
→ SQLITE_DBSTATUS_DEFERRED_FKS
c3ref/c_dbstatus_options.html#sqlitedbstatuslookasidehit
→ SQLITE_DBSTATUS_LOOKASIDE_HIT
c3ref/c_dbstatus_options.html#sqlitedbstatuslookasidemissfull
→ SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL
c3ref/c_dbstatus_options.html#sqlitedbstatuslookasidemisssize
→ SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE
c3ref/c_dbstatus_options.html#sqlitedbstatuslookasideused
→ SQLITE_DBSTATUS_LOOKASIDE_USED
c3ref/c_dbstatus_options.html#sqlitedbstatusschemaused
→ SQLITE_DBSTATUS_SCHEMA_USED
c3ref/c_dbstatus_options.html#sqlitedbstatusstmtused
→ SQLITE_DBSTATUS_STMT_USED
c3ref/c_deny.html
→ SQLITE_DENY SQLITE_IGNORE
c3ref/c_deserialize_freeonclose.html
→ SQLITE_DESERIALIZE_FREEONCLOSE SQLITE_DESERIALIZE_READONLY SQLITE_DESERIALIZE_RESIZEABLE
c3ref/c_deterministic.html#sqlitedeterministic
→ SQLITE_DETERMINISTIC
c3ref/c_deterministic.html#sqlitedirectonly
→ SQLITE_DIRECTONLY
c3ref/c_deterministic.html#sqliteinnocuous
→ SQLITE_INNOCUOUS
c3ref/c_deterministic.html#sqliteresultsubtype
→ SQLITE_RESULT_SUBTYPE
c3ref/c_deterministic.html#sqlitesubtype
→ SQLITE_SUBTYPE
c3ref/c_fail.html
→ SQLITE_FAIL SQLITE_REPLACE SQLITE_ROLLBACK {conflict resolution mode}
c3ref/c_fcntl_begin_atomic_write.html
→ SQLITE_FCNTL_GET_LOCKPROXYFILE SQLITE_FCNTL_LAST_ERRNO SQLITE_FCNTL_PDB SQLITE_FCNTL_RESERVE_BYTES SQLITE_FCNTL_SET_LOCKPROXYFILE {file control opcode} {file control opcodes}
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlbeginatomicwrite
→ SQLITE_FCNTL_BEGIN_ATOMIC_WRITE
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlbusyhandler
→ SQLITE_FCNTL_BUSYHANDLER
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlchunksize
→ SQLITE_FCNTL_CHUNK_SIZE
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlckptdone
→ SQLITE_FCNTL_CKPT_DONE
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlckptstart
→ SQLITE_FCNTL_CKPT_START
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlcksmfile
→ SQLITE_FCNTL_CKSM_FILE
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlcommitatomicwrite
→ SQLITE_FCNTL_COMMIT_ATOMIC_WRITE
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlcommitphasetwo
→ SQLITE_FCNTL_COMMIT_PHASETWO
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntldataversion
→ SQLITE_FCNTL_DATA_VERSION
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlexternalreader
→ SQLITE_FCNTL_EXTERNAL_READER
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlfilepointer
→ SQLITE_FCNTL_FILE_POINTER
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlhasmoved
→ SQLITE_FCNTL_HAS_MOVED
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntljournalpointer
→ SQLITE_FCNTL_JOURNAL_POINTER
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntllockstate
→ SQLITE_FCNTL_LOCKSTATE
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntllocktimeout
→ SQLITE_FCNTL_LOCK_TIMEOUT
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlmmapsize
→ SQLITE_FCNTL_MMAP_SIZE
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntloverwrite
→ SQLITE_FCNTL_OVERWRITE
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlpersistwal
→ SQLITE_FCNTL_PERSIST_WAL
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlpowersafeoverwrite
→ SQLITE_FCNTL_POWERSAFE_OVERWRITE
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlpragma
→ SQLITE_FCNTL_PRAGMA
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlrbu
→ SQLITE_FCNTL_RBU
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlresetcache
→ SQLITE_FCNTL_RESET_CACHE
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlrollbackatomicwrite
→ SQLITE_FCNTL_ROLLBACK_ATOMIC_WRITE
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlsizehint
→ SQLITE_FCNTL_SIZE_HINT
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlsizelimit
→ SQLITE_FCNTL_SIZE_LIMIT
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlsync
→ SQLITE_FCNTL_SYNC
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlsyncomitted
→ SQLITE_FCNTL_SYNC_OMITTED
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntltempfilename
→ SQLITE_FCNTL_TEMPFILENAME
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntltrace
→ SQLITE_FCNTL_TRACE
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlvfsname
→ SQLITE_FCNTL_VFSNAME
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlvfspointer
→ SQLITE_FCNTL_VFS_POINTER
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlwalblock
→ SQLITE_FCNTL_WAL_BLOCK
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlwin32avretry
→ SQLITE_FCNTL_WIN32_AV_RETRY
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlwin32gethandle
→ SQLITE_FCNTL_WIN32_GET_HANDLE
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlwin32sethandle
→ SQLITE_FCNTL_WIN32_SET_HANDLE
c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlzipvfs
→ SQLITE_FCNTL_ZIPVFS
c3ref/c_index_constraint_eq.html
→ 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
c3ref/c_index_scan_unique.html
→ SQLITE_INDEX_SCAN_UNIQUE
c3ref/c_iocap_atomic.html
→ 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
c3ref/c_limit_attached.html
→ {limit categories} {limit category}
c3ref/c_limit_attached.html#sqlitelimitattached
→ SQLITE_LIMIT_ATTACHED
c3ref/c_limit_attached.html#sqlitelimitcolumn
→ SQLITE_LIMIT_COLUMN
c3ref/c_limit_attached.html#sqlitelimitcompoundselect
→ SQLITE_LIMIT_COMPOUND_SELECT
c3ref/c_limit_attached.html#sqlitelimitexprdepth
→ SQLITE_LIMIT_EXPR_DEPTH
c3ref/c_limit_attached.html#sqlitelimitfunctionarg
→ SQLITE_LIMIT_FUNCTION_ARG
c3ref/c_limit_attached.html#sqlitelimitlength
→ SQLITE_LIMIT_LENGTH
c3ref/c_limit_attached.html#sqlitelimitlikepatternlength
→ SQLITE_LIMIT_LIKE_PATTERN_LENGTH
c3ref/c_limit_attached.html#sqlitelimitsqllength
→ SQLITE_LIMIT_SQL_LENGTH
c3ref/c_limit_attached.html#sqlitelimittriggerdepth
→ SQLITE_LIMIT_TRIGGER_DEPTH
c3ref/c_limit_attached.html#sqlitelimitvariablenumber
→ SQLITE_LIMIT_VARIABLE_NUMBER
c3ref/c_limit_attached.html#sqlitelimitvdbeop
→ SQLITE_LIMIT_VDBE_OP
c3ref/c_limit_attached.html#sqlitelimitworkerthreads
→ SQLITE_LIMIT_WORKER_THREADS
c3ref/c_lock_exclusive.html
→ SQLITE_LOCK_EXCLUSIVE SQLITE_LOCK_NONE SQLITE_LOCK_PENDING SQLITE_LOCK_RESERVED SQLITE_LOCK_SHARED
c3ref/c_mutex_fast.html
→ 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
c3ref/c_open_autoproxy.html
→ 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
c3ref/c_prepare_normalize.html#sqlitepreparenormalize
→ SQLITE_PREPARE_NORMALIZE
c3ref/c_prepare_normalize.html#sqlitepreparenovtab
→ SQLITE_PREPARE_NO_VTAB
c3ref/c_prepare_normalize.html#sqlitepreparepersistent
→ SQLITE_PREPARE_PERSISTENT
c3ref/c_scanstat_complex.html
→ SQLITE_SCANSTAT_COMPLEX {scan status flags}
c3ref/c_scanstat_est.html
→ {scanstatus options}
c3ref/c_scanstat_est.html#sqlitescanstatest
→ SQLITE_SCANSTAT_EST
c3ref/c_scanstat_est.html#sqlitescanstatexplain
→ SQLITE_SCANSTAT_EXPLAIN
c3ref/c_scanstat_est.html#sqlitescanstatname
→ SQLITE_SCANSTAT_NAME
c3ref/c_scanstat_est.html#sqlitescanstatncycle
→ SQLITE_SCANSTAT_NCYCLE
c3ref/c_scanstat_est.html#sqlitescanstatnloop
→ SQLITE_SCANSTAT_NLOOP
c3ref/c_scanstat_est.html#sqlitescanstatnvisit
→ SQLITE_SCANSTAT_NVISIT
c3ref/c_scanstat_est.html#sqlitescanstatparentid
→ SQLITE_SCANSTAT_PARENTID
c3ref/c_scanstat_est.html#sqlitescanstatselectid
→ SQLITE_SCANSTAT_SELECTID
c3ref/c_serialize_nocopy.html
→ SQLITE_SERIALIZE_NOCOPY
c3ref/c_shm_exclusive.html
→ SQLITE_SHM_EXCLUSIVE SQLITE_SHM_LOCK SQLITE_SHM_SHARED SQLITE_SHM_UNLOCK
c3ref/c_shm_nlock.html
→ SQLITE_SHM_NLOCK
c3ref/c_source_id.html
→ SQLITE_SOURCE_ID SQLITE_VERSION SQLITE_VERSION_NUMBER
c3ref/c_static.html
→ SQLITE_STATIC SQLITE_TRANSIENT
c3ref/c_status_malloc_count.html
→ {status parameters}
c3ref/c_status_malloc_count.html#sqlitestatusmalloccount
→ SQLITE_STATUS_MALLOC_COUNT
c3ref/c_status_malloc_count.html#sqlitestatusmallocsize
→ SQLITE_STATUS_MALLOC_SIZE
c3ref/c_status_malloc_count.html#sqlitestatusmemoryused
→ SQLITE_STATUS_MEMORY_USED
c3ref/c_status_malloc_count.html#sqlitestatuspagecacheoverflow
→ SQLITE_STATUS_PAGECACHE_OVERFLOW
c3ref/c_status_malloc_count.html#sqlitestatuspagecachesize
→ SQLITE_STATUS_PAGECACHE_SIZE
c3ref/c_status_malloc_count.html#sqlitestatuspagecacheused
→ SQLITE_STATUS_PAGECACHE_USED
c3ref/c_status_malloc_count.html#sqlitestatusparserstack
→ SQLITE_STATUS_PARSER_STACK
c3ref/c_status_malloc_count.html#sqlitestatusscratchoverflow
→ SQLITE_STATUS_SCRATCH_OVERFLOW
c3ref/c_status_malloc_count.html#sqlitestatusscratchsize
→ SQLITE_STATUS_SCRATCH_SIZE
c3ref/c_status_malloc_count.html#sqlitestatusscratchused
→ SQLITE_STATUS_SCRATCH_USED
c3ref/c_stmtstatus_counter.html
→ {SQLITE_STMTSTATUS counter} {SQLITE_STMTSTATUS counters} SQLITE_STMTSTATUS_FILTER_HIT
c3ref/c_stmtstatus_counter.html#sqlitestmtstatusautoindex
→ SQLITE_STMTSTATUS_AUTOINDEX
c3ref/c_stmtstatus_counter.html#sqlitestmtstatusfilterhit
→ {SQLITE_STMTSTATUS_FILTER HIT}
c3ref/c_stmtstatus_counter.html#sqlitestmtstatusfiltermiss
→ SQLITE_STMTSTATUS_FILTER_MISS
c3ref/c_stmtstatus_counter.html#sqlitestmtstatusfullscanstep
→ SQLITE_STMTSTATUS_FULLSCAN_STEP
c3ref/c_stmtstatus_counter.html#sqlitestmtstatusmemused
→ SQLITE_STMTSTATUS_MEMUSED
c3ref/c_stmtstatus_counter.html#sqlitestmtstatusreprepare
→ SQLITE_STMTSTATUS_REPREPARE
c3ref/c_stmtstatus_counter.html#sqlitestmtstatusrun
→ SQLITE_STMTSTATUS_RUN
c3ref/c_stmtstatus_counter.html#sqlitestmtstatussort
→ SQLITE_STMTSTATUS_SORT
c3ref/c_stmtstatus_counter.html#sqlitestmtstatusvmstep
→ SQLITE_STMTSTATUS_VM_STEP
c3ref/c_sync_dataonly.html
→ SQLITE_SYNC_DATAONLY SQLITE_SYNC_FULL SQLITE_SYNC_NORMAL
c3ref/c_testctrl_always.html
→ 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_JSON_SELFCHECK 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
c3ref/c_trace.html
→ SQLITE_TRACE
c3ref/c_trace.html#sqlitetraceclose
→ SQLITE_TRACE_CLOSE
c3ref/c_trace.html#sqlitetraceprofile
→ SQLITE_TRACE_PROFILE
c3ref/c_trace.html#sqlitetracerow
→ SQLITE_TRACE_ROW
c3ref/c_trace.html#sqlitetracestmt
→ SQLITE_TRACE_STMT
c3ref/c_txn_none.html
→ {transaction state}
c3ref/c_txn_none.html#sqlitetxnnone
→ SQLITE_TXN_NONE
c3ref/c_txn_none.html#sqlitetxnread
→ SQLITE_TXN_READ
c3ref/c_txn_none.html#sqlitetxnwrite
→ SQLITE_TXN_WRITE
c3ref/c_vtab_constraint_support.html
→ {virtual table configuration option} {virtual table configuration options}
c3ref/c_vtab_constraint_support.html#sqlitevtabconstraintsupport
→ SQLITE_VTAB_CONSTRAINT_SUPPORT
c3ref/c_vtab_constraint_support.html#sqlitevtabdirectonly
→ SQLITE_VTAB_DIRECTONLY
c3ref/c_vtab_constraint_support.html#sqlitevtabinnocuous
→ SQLITE_VTAB_INNOCUOUS
c3ref/c_vtab_constraint_support.html#sqlitevtabusesallschemas
→ SQLITE_VTAB_USES_ALL_SCHEMAS
c3ref/c_win32_data_directory_type.html
→ SQLITE_WIN32_DATA_DIRECTORY_TYPE SQLITE_WIN32_TEMP_DIRECTORY_TYPE
c3ref/cancel_auto_extension.html
→ sqlite3_cancel_auto_extension
c3ref/changes.html
→ sqlite3_changes sqlite3_changes64
c3ref/clear_bindings.html
→ sqlite3_clear_bindings
c3ref/close.html
→ sqlite3_close sqlite3_close_v2
c3ref/collation_needed.html
→ sqlite3_collation_needed sqlite3_collation_needed16
c3ref/column_blob.html
→ {column access functions} sqlite3_column_blob sqlite3_column_bytes sqlite3_column_bytes16 sqlite3_column_double sqlite3_column_int sqlite3_column_int64 sqlite3_column_text sqlite3_column_text16 sqlite3_column_type sqlite3_column_value
c3ref/column_count.html
→ sqlite3_column_count
c3ref/column_database_name.html
→ sqlite3_column_database_name sqlite3_column_database_name16 sqlite3_column_origin_name sqlite3_column_origin_name16 sqlite3_column_table_name sqlite3_column_table_name16
c3ref/column_decltype.html
→ sqlite3_column_decltype sqlite3_column_decltype16
c3ref/column_name.html
→ sqlite3_column_name sqlite3_column_name16
c3ref/commit_hook.html
→ sqlite3_commit_hook sqlite3_rollback_hook
c3ref/compileoption_get.html
→ sqlite3_compileoption_get sqlite3_compileoption_used
c3ref/complete.html
→ sqlite3_complete sqlite3_complete16
c3ref/config.html
→ sqlite3_config
c3ref/context.html
→ sqlite3_context
c3ref/context_db_handle.html
→ sqlite3_context_db_handle
c3ref/create_collation.html
→ sqlite3_create_collation sqlite3_create_collation16 sqlite3_create_collation_v2
c3ref/create_filename.html
→ sqlite3_create_filename sqlite3_free_filename
c3ref/create_function.html
→ {function creation routines} sqlite3_create_function sqlite3_create_function16 sqlite3_create_function_v2 sqlite3_create_window_function
c3ref/create_module.html
→ sqlite3_create_module sqlite3_create_module_v2
c3ref/data_count.html
→ sqlite3_data_count
c3ref/data_directory.html
→ sqlite3_data_directory
c3ref/database_file_object.html
→ sqlite3_database_file_object
c3ref/db_cacheflush.html
→ sqlite3_db_cacheflush
c3ref/db_config.html
→ sqlite3_db_config
c3ref/db_filename.html
→ sqlite3_db_filename
c3ref/db_handle.html
→ sqlite3_db_handle
c3ref/db_mutex.html
→ sqlite3_db_mutex
c3ref/db_name.html
→ sqlite3_db_name
c3ref/db_readonly.html
→ sqlite3_db_readonly
c3ref/db_release_memory.html
→ sqlite3_db_release_memory
c3ref/db_status.html
→ sqlite3_db_status
c3ref/declare_vtab.html
→ sqlite3_declare_vtab
c3ref/deserialize.html
→ sqlite3_deserialize
c3ref/drop_modules.html
→ sqlite3_drop_modules
c3ref/enable_load_extension.html
→ sqlite3_enable_load_extension
c3ref/enable_shared_cache.html
→ sqlite3_enable_shared_cache
c3ref/errcode.html
→ sqlite3_errcode sqlite3_errmsg sqlite3_errmsg16 sqlite3_error_offset sqlite3_errstr sqlite3_extended_errcode
c3ref/exec.html
→ sqlite3_exec
c3ref/expanded_sql.html
→ sqlite3_expanded_sql sqlite3_normalized_sql sqlite3_sql
c3ref/experimental.html
→ deprecated experimental
c3ref/extended_result_codes.html
→ sqlite3_extended_result_codes
c3ref/file.html
→ sqlite3_file
c3ref/file_control.html
→ {file control} sqlite3_file_control
c3ref/filename.html
→ sqlite3_filename
c3ref/filename_database.html
→ sqlite3_filename_database sqlite3_filename_journal sqlite3_filename_wal
c3ref/finalize.html
→ sqlite3_finalize
c3ref/free.html
→ sqlite3_free sqlite3_malloc sqlite3_malloc64 sqlite3_msize sqlite3_realloc sqlite3_realloc64
c3ref/free_table.html
→ sqlite3_free_table sqlite3_get_table
c3ref/funclist.html
→ {C-API function list} capi3ref_funclist
c3ref/get_autocommit.html
→ {autocommit mode} sqlite3_get_autocommit
c3ref/get_auxdata.html
→ sqlite3_get_auxdata sqlite3_set_auxdata
c3ref/get_clientdata.html
→ sqlite3_get_clientdata sqlite3_set_clientdata
c3ref/hard_heap_limit64.html
→ sqlite3_hard_heap_limit64 sqlite3_soft_heap_limit64
c3ref/index_info.html
→ sqlite3_index_info
c3ref/initialize.html
→ sqlite3_initialize sqlite3_os_end sqlite3_os_init sqlite3_shutdown
c3ref/int64.html
→ sqlite3_int64 sqlite3_uint64 sqlite_int64 sqlite_uint64
c3ref/interrupt.html
→ sqlite3_interrupt sqlite3_is_interrupted
c3ref/intro.html
→ {C-language Interface} capi3ref
c3ref/io_methods.html
→ sqlite3_io_methods
c3ref/keyword_check.html
→ sqlite3_keyword_check sqlite3_keyword_count sqlite3_keyword_name
c3ref/last_insert_rowid.html
→ sqlite3_last_insert_rowid
c3ref/libversion.html
→ sqlite3_libversion sqlite3_libversion_number sqlite3_sourceid sqlite3_version
c3ref/limit.html
→ sqlite3_limit
c3ref/load_extension.html
→ sqlite3_load_extension
c3ref/log.html
→ sqlite3_log
c3ref/mem_methods.html
→ sqlite3_mem_methods
c3ref/memory_highwater.html
→ sqlite3_memory_highwater sqlite3_memory_used
c3ref/module.html
→ sqlite3_module {virtual table module}
c3ref/mprintf.html
→ sqlite3_mprintf sqlite3_snprintf sqlite3_vmprintf sqlite3_vsnprintf
c3ref/mutex.html
→ sqlite3_mutex
c3ref/mutex_alloc.html
→ sqlite3_mutex_alloc sqlite3_mutex_enter sqlite3_mutex_free sqlite3_mutex_leave sqlite3_mutex_try
c3ref/mutex_held.html
→ sqlite3_mutex_held sqlite3_mutex_notheld
c3ref/mutex_methods.html
→ sqlite3_mutex_methods
c3ref/next_stmt.html
→ sqlite3_next_stmt
c3ref/open.html
→ sqlite3_open sqlite3_open16 sqlite3_open_v2
c3ref/open.html#coreuriqueryparameters
→ {core URI query parameters}
c3ref/open.html#openexrescode
→ OPEN_EXRESCODE
c3ref/open.html#opennofollow
→ OPEN_NOFOLLOW
c3ref/open.html#urifilenameexamples
→ {URI filename examples}
c3ref/open.html#urifilenamesinsqlite3open
→ {URI filenames in sqlite3_open}
c3ref/overload_function.html
→ sqlite3_overload_function
c3ref/pcache.html
→ sqlite3_pcache
c3ref/pcache_methods2.html
→ {page cache} sqlite3_pcache_methods2
c3ref/pcache_methods2.html#thexcachesizepagecachemethod
→ {the xCachesize page cache method}
c3ref/pcache_methods2.html#thexcreatepagecachemethods
→ {the xCreate page cache methods}
c3ref/pcache_methods2.html#thexdestroypagecachemethod
→ {the xDestroy page cache method}
c3ref/pcache_methods2.html#thexfetchpagecachemethods
→ {the xFetch page cache methods}
c3ref/pcache_methods2.html#thexinitpagecachemethod
→ {the xInit page cache method}
c3ref/pcache_methods2.html#thexpagecountpagecachemethods
→ {the xPagecount page cache methods}
c3ref/pcache_methods2.html#thexrekeypagecachemethods
→ {the xRekey page cache methods}
c3ref/pcache_methods2.html#thexshrinkpagecachemethod
→ {the xShrink page cache method}
c3ref/pcache_methods2.html#thexshutdownpagecachemethod
→ {the xShutdown page cache method}
c3ref/pcache_methods2.html#thexunpinpagecachemethod
→ {the xUnpin page cache method}
c3ref/pcache_page.html
→ sqlite3_pcache_page
c3ref/prepare.html
→ {SQL statement compiler} sqlite3_prepare sqlite3_prepare16 sqlite3_prepare16_v2 sqlite3_prepare16_v3 sqlite3_prepare_v2 sqlite3_prepare_v3
c3ref/preupdate_blobwrite.html
→ sqlite3_preupdate_blobwrite sqlite3_preupdate_count sqlite3_preupdate_depth sqlite3_preupdate_hook sqlite3_preupdate_new sqlite3_preupdate_old
c3ref/profile.html
→ sqlite3_profile sqlite3_trace
c3ref/progress_handler.html
→ sqlite3_progress_handler
c3ref/randomness.html
→ sqlite3_randomness
c3ref/release_memory.html
→ sqlite3_release_memory
c3ref/reset.html
→ sqlite3_reset
c3ref/reset_auto_extension.html
→ sqlite3_reset_auto_extension
c3ref/result_blob.html
→ 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_text sqlite3_result_text16 sqlite3_result_text16be sqlite3_result_text16le sqlite3_result_text64 sqlite3_result_value sqlite3_result_zeroblob sqlite3_result_zeroblob64
c3ref/result_subtype.html
→ sqlite3_result_subtype
c3ref/serialize.html
→ sqlite3_serialize
c3ref/set_authorizer.html
→ {authorizer callback} sqlite3_set_authorizer
c3ref/set_last_insert_rowid.html
→ sqlite3_set_last_insert_rowid
c3ref/sleep.html
→ sqlite3_sleep
c3ref/snapshot.html
→ snapshot sqlite3_snapshot
c3ref/snapshot_cmp.html
→ sqlite3_snapshot_cmp
c3ref/snapshot_free.html
→ sqlite3_snapshot_free
c3ref/snapshot_get.html
→ sqlite3_snapshot_get
c3ref/snapshot_open.html
→ sqlite3_snapshot_open
c3ref/snapshot_recover.html
→ sqlite3_snapshot_recover
c3ref/soft_heap_limit.html
→ sqlite3_soft_heap_limit
c3ref/sqlite3.html
→ {database connection} {database connections} sqlite3
c3ref/status.html
→ sqlite3_status sqlite3_status64
c3ref/step.html
→ sqlite3_step
c3ref/stmt.html
→ {prepared statement} {prepared statements} sqlite3_stmt
c3ref/stmt_busy.html
→ sqlite3_stmt_busy
c3ref/stmt_explain.html
→ sqlite3_stmt_explain
c3ref/stmt_isexplain.html
→ sqlite3_stmt_isexplain
c3ref/stmt_readonly.html
→ sqlite3_stmt_readonly
c3ref/stmt_scanstatus.html
→ sqlite3_stmt_scanstatus sqlite3_stmt_scanstatus_v2
c3ref/stmt_scanstatus_reset.html
→ sqlite3_stmt_scanstatus_reset
c3ref/stmt_status.html
→ sqlite3_stmt_status
c3ref/str.html
→ {dynamic string} sqlite3_str
c3ref/str_append.html
→ sqlite3_str_append sqlite3_str_appendall sqlite3_str_appendchar sqlite3_str_appendf sqlite3_str_reset sqlite3_str_vappendf
c3ref/str_errcode.html
→ sqlite3_str_errcode sqlite3_str_length sqlite3_str_value
c3ref/str_finish.html
→ sqlite3_str_finish
c3ref/str_new.html
→ sqlite3_str_new
c3ref/strglob.html
→ sqlite3_strglob
c3ref/stricmp.html
→ sqlite3_stricmp sqlite3_strnicmp
c3ref/strlike.html
→ sqlite3_strlike
c3ref/system_errno.html
→ sqlite3_system_errno
c3ref/table_column_metadata.html
→ sqlite3_table_column_metadata
c3ref/temp_directory.html
→ sqlite3_temp_directory
c3ref/test_control.html
→ sqlite3_test_control
c3ref/threadsafe.html
→ sqlite3_threadsafe
c3ref/total_changes.html
→ sqlite3_total_changes sqlite3_total_changes64
c3ref/trace_v2.html
→ sqlite3_trace_v2
c3ref/txn_state.html
→ sqlite3_txn_state
c3ref/unlock_notify.html
→ sqlite3_unlock_notify
c3ref/update_hook.html
→ sqlite3_update_hook
c3ref/uri_boolean.html
→ sqlite3_uri_boolean sqlite3_uri_int64 sqlite3_uri_key sqlite3_uri_parameter
c3ref/user_data.html
→ sqlite3_user_data
c3ref/value.html
→ {protected sqlite3_value} sqlite3_value {unprotected sqlite3_value}
c3ref/value_blob.html
→ sqlite3_value_blob sqlite3_value_bytes sqlite3_value_bytes16 sqlite3_value_double sqlite3_value_frombind sqlite3_value_int sqlite3_value_int64 sqlite3_value_nochange sqlite3_value_numeric_type sqlite3_value_pointer sqlite3_value_text sqlite3_value_text16 sqlite3_value_text16be sqlite3_value_text16le sqlite3_value_type
c3ref/value_dup.html
→ sqlite3_value_dup sqlite3_value_free
c3ref/value_encoding.html
→ sqlite3_value_encoding
c3ref/value_subtype.html
→ sqlite3_value_subtype
c3ref/vfs.html
→ sqlite3_vfs
c3ref/vfs.html#sqlite3vfsxaccess
→ sqlite3_vfs.xAccess
c3ref/vfs.html#sqlite3vfsxopen
→ sqlite3_vfs.xOpen
c3ref/vfs_find.html
→ sqlite3_vfs_find sqlite3_vfs_register sqlite3_vfs_unregister
c3ref/vtab.html
→ sqlite3_vtab
c3ref/vtab_collation.html
→ sqlite3_vtab_collation
c3ref/vtab_config.html
→ sqlite3_vtab_config
c3ref/vtab_cursor.html
→ sqlite3_vtab_cursor {virtual table cursor}
c3ref/vtab_distinct.html
→ sqlite3_vtab_distinct
c3ref/vtab_in.html
→ sqlite3_vtab_in
c3ref/vtab_in_first.html
→ sqlite3_vtab_in_first sqlite3_vtab_in_next
c3ref/vtab_nochange.html
→ sqlite3_vtab_nochange
c3ref/vtab_on_conflict.html
→ sqlite3_vtab_on_conflict
c3ref/vtab_rhs_value.html
→ sqlite3_vtab_rhs_value
c3ref/wal_autocheckpoint.html
→ sqlite3_wal_autocheckpoint
c3ref/wal_checkpoint.html
→ sqlite3_wal_checkpoint
c3ref/wal_checkpoint_v2.html
→ sqlite3_wal_checkpoint_v2
c3ref/wal_hook.html
→ sqlite3_wal_hook
c3ref/win32_set_directory.html
→ sqlite3_win32_set_directory sqlite3_win32_set_directory16 sqlite3_win32_set_directory8
carray.html
→ carray {carray table-valued function}
carray.html#onearg
→ {single-argument carray} sqlite3_carray_bind
changes.html
→ {complete list of SQLite releases} {release history}
chronology.html
→ chronology {prior releases}
cintro.html
→ cintro
cksumvfs.html
→ {checksum VFS} {checksum VFS shim} cksumvfs
cli.html
→ CLI {Command Line Interface} {command-line interface} {command-line shell} sqlite3.exe {sqlite3.exe command-line shell}
cli.html#arinsup
→ {--insert option} {--update option}
cli.html#base64
→ {base64 SQL function}
cli.html#base85
→ {base85 SQL function}
cli.html#clmnr
→ {Columnar output modes} {columnar output modes}
cli.html#clopts
→ {command-line options}
cli.html#csv
→ .import {.import command} {CSV import}
cli.html#csvout
→ {CSV export}
cli.html#dotcmd
→ dot-commands
cli.html#dotconn
→ .connection
cli.html#dotdatabases
→ .databases {.databases command}
cli.html#dotexcel
→ .excel
cli.html#dotload
→ {.load command}
cli.html#dotmode
→ .mode {output mode}
cli.html#dotmodequote
→ {.mode quote}
cli.html#dotopen
→ .open {.open command}
cli.html#dotoutput
→ .once .output
cli.html#dotread
→ .read
cli.html#dschema
→ .schema
cli.html#dtables
→ .tables
cli.html#dump
→ .dump
cli.html#editfunc
→ {edit SQL function}
cli.html#exexcel*
→ {export to excel}
cli.html#expert
→ {.expert command}
cli.html#extsv*
→ {export to TSV}
cli.html#fileio
→ {file I/O functions}
cli.html#fullschema
→ .fullschema {the .fullschema dot-command}
cli.html#param
→ {.parameter command}
cli.html#qbox
→ qbox {qbox output mode}
cli.html#recover
→ {.recover dot-command}
cli.html#safemode
→ {--safe command-line option} {safe command-line option}
cli.html#selftest
→ {.selftest dot-command}
cli.html#sha3sum
→ {.sha3sum dot-command}
cli.html#sqlar
→ {.archive command}
cli.html#testing_mode
→ {--unsafe-testing command-line option} {unsafe-testing command-line option}
cli.html#wrap1
→ {wrapping text}
cli.html#zipdb
→ {ZIP file as database}
codeofconduct.html
→ {Code of Conduct}
codeofethics.html
→ {Code of Ethics} {Code of Ethics of the Project Founder}
compile.html
→ {compile-time options}
compile.html#4_byte_aligned_malloc
→ -DSQLITE_4_BYTE_ALIGNED_MALLOC SQLITE_4_BYTE_ALIGNED_MALLOC
compile.html#allow_covering_index_scan
→ -DSQLITE_ALLOW_COVERING_INDEX_SCAN SQLITE_ALLOW_COVERING_INDEX_SCAN
compile.html#allow_uri_authority
→ -DSQLITE_ALLOW_URI_AUTHORITY SQLITE_ALLOW_URI_AUTHORITY
compile.html#api
→ -DSQLITE_API SQLITE_API
compile.html#apicall
→ -DSQLITE_APICALL SQLITE_APICALL
compile.html#byteorder
→ -DSQLITE_BYTEORDER SQLITE_BYTEORDER
compile.html#callback
→ -DSQLITE_CALLBACK SQLITE_CALLBACK
compile.html#case_sensitive_like
→ -DSQLITE_CASE_SENSITIVE_LIKE SQLITE_CASE_SENSITIVE_LIKE
compile.html#cdecl
→ -DSQLITE_CDECL SQLITE_CDECL
compile.html#debug
→ -DSQLITE_DEBUG SQLITE_DEBUG
compile.html#default_automatic_index
→ -DSQLITE_DEFAULT_AUTOMATIC_INDEX SQLITE_DEFAULT_AUTOMATIC_INDEX
compile.html#default_autovacuum
→ -DSQLITE_DEFAULT_AUTOVACUUM SQLITE_DEFAULT_AUTOVACUUM
compile.html#default_cache_size
→ -DSQLITE_DEFAULT_CACHE_SIZE SQLITE_DEFAULT_CACHE_SIZE
compile.html#default_file_format
→ -DSQLITE_DEFAULT_FILE_FORMAT SQLITE_DEFAULT_FILE_FORMAT
compile.html#default_file_permissions
→ -DSQLITE_DEFAULT_FILE_PERMISSIONS SQLITE_DEFAULT_FILE_PERMISSIONS
compile.html#default_foreign_keys
→ -DSQLITE_DEFAULT_FOREIGN_KEYS SQLITE_DEFAULT_FOREIGN_KEYS
compile.html#default_journal_size_limit
→ -DSQLITE_DEFAULT_JOURNAL_SIZE_LIMIT SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT
compile.html#default_locking_mode
→ -DSQLITE_DEFAULT_LOCKING_MODE SQLITE_DEFAULT_LOCKING_MODE
compile.html#default_lookaside
→ -DSQLITE_DEFAULT_LOOKASIDE SQLITE_DEFAULT_LOOKASIDE
compile.html#default_memstatus
→ -DSQLITE_DEFAULT_MEMSTATUS SQLITE_DEFAULT_MEMSTATUS
compile.html#default_mmap_size
→ -DSQLITE_DEFAULT_MMAP_SIZE SQLITE_DEFAULT_MMAP_SIZE
compile.html#default_page_size
→ -DSQLITE_DEFAULT_PAGE_SIZE SQLITE_DEFAULT_PAGE_SIZE
compile.html#default_pcache_initsz
→ -DSQLITE_DEFAULT_PCACHE_INITSZ SQLITE_DEFAULT_PCACHE_INITSZ
compile.html#default_synchronous
→ -DSQLITE_DEFAULT_SYNCHRONOUS SQLITE_DEFAULT_SYNCHRONOUS
compile.html#default_wal_autocheckpoint
→ -DSQLITE_DEFAULT_WAL_AUTOCHECKPOINT SQLITE_DEFAULT_WAL_AUTOCHECKPOINT
compile.html#default_wal_synchronous
→ -DSQLITE_DEFAULT_WAL_SYNCHRONOUS SQLITE_DEFAULT_WAL_SYNCHRONOUS
compile.html#default_worker_threads
→ -DSQLITE_DEFAULT_WORKER_THREADS SQLITE_DEFAULT_WORKER_THREADS
compile.html#direct_overflow_read
→ -DSQLITE_DIRECT_OVERFLOW_READ SQLITE_DIRECT_OVERFLOW_READ
compile.html#disable_dirsync
→ -DSQLITE_DISABLE_DIRSYNC SQLITE_DISABLE_DIRSYNC
compile.html#disable_fts3_unicode
→ -DSQLITE_DISABLE_FTS3_UNICODE SQLITE_DISABLE_FTS3_UNICODE
compile.html#disable_fts4_deferred
→ -DSQLITE_DISABLE_FTS4_DEFERRED SQLITE_DISABLE_FTS4_DEFERRED
compile.html#disable_intrinsic
→ -DSQLITE_DISABLE_INTRINSIC SQLITE_DISABLE_INTRINSIC
compile.html#disable_lfs
→ -DSQLITE_DISABLE_LFS SQLITE_DISABLE_LFS
compile.html#disable_pagecache_overflow_stats
→ -DSQLITE_DISABLE_PAGECACHE_OVERFLOW_STATS SQLITE_DISABLE_PAGECACHE_OVERFLOW_STATS
compile.html#dqs
→ -DSQLITE_DQS SQLITE_DQS
compile.html#enable_8_3_names
→ -DSQLITE_ENABLE_8_3_NAMES SQLITE_ENABLE_8_3_NAMES
compile.html#enable_api_armor
→ -DSQLITE_ENABLE_API_ARMOR SQLITE_ENABLE_API_ARMOR
compile.html#enable_atomic_write
→ -DSQLITE_ENABLE_ATOMIC_WRITE SQLITE_ENABLE_ATOMIC_WRITE
compile.html#enable_batch_atomic_write
→ -DSQLITE_ENABLE_BATCH_ATOMIC_WRITE SQLITE_ENABLE_BATCH_ATOMIC_WRITE
compile.html#enable_bytecode_vtab
→ -DSQLITE_ENABLE_BYTECODE_VTAB SQLITE_ENABLE_BYTECODE_VTAB
compile.html#enable_column_metadata
→ -DSQLITE_ENABLE_COLUMN_METADATA SQLITE_ENABLE_COLUMN_METADATA
compile.html#enable_dbpage_vtab
→ -DSQLITE_ENABLE_DBPAGE_VTAB SQLITE_ENABLE_DBPAGE_VTAB
compile.html#enable_dbstat_vtab
→ -DSQLITE_ENABLE_DBSTAT_VTAB SQLITE_ENABLE_DBSTAT_VTAB
compile.html#enable_deserialize
→ -DSQLITE_ENABLE_DESERIALIZE SQLITE_ENABLE_DESERIALIZE
compile.html#enable_explain_comments
→ -DSQLITE_ENABLE_EXPLAIN_COMMENTS SQLITE_ENABLE_EXPLAIN_COMMENTS
compile.html#enable_fts3
→ -DSQLITE_ENABLE_FTS3 SQLITE_ENABLE_FTS3
compile.html#enable_fts3_parenthesis
→ -DSQLITE_ENABLE_FTS3_PARENTHESIS SQLITE_ENABLE_FTS3_PARENTHESIS
compile.html#enable_fts3_tokenizer
→ -DSQLITE_ENABLE_FTS3_TOKENIZER SQLITE_ENABLE_FTS3_TOKENIZER
compile.html#enable_fts4
→ -DSQLITE_ENABLE_FTS4 SQLITE_ENABLE_FTS4
compile.html#enable_fts5
→ -DSQLITE_ENABLE_FTS5 SQLITE_ENABLE_FTS5
compile.html#enable_geopoly
→ -DSQLITE_ENABLE_GEOPOLY SQLITE_ENABLE_GEOPOLY
compile.html#enable_hidden_columns
→ -DSQLITE_ENABLE_HIDDEN_COLUMNS SQLITE_ENABLE_HIDDEN_COLUMNS
compile.html#enable_icu
→ -DSQLITE_ENABLE_ICU SQLITE_ENABLE_ICU
compile.html#enable_iotrace
→ -DSQLITE_ENABLE_IOTRACE SQLITE_ENABLE_IOTRACE
compile.html#enable_json1
→ -DSQLITE_ENABLE_JSON1 SQLITE_ENABLE_JSON1
compile.html#enable_locking_style
→ -DSQLITE_ENABLE_LOCKING_STYLE SQLITE_ENABLE_LOCKING_STYLE
compile.html#enable_math_functions
→ -DSQLITE_ENABLE_MATH_FUNCTIONS SQLITE_ENABLE_MATH_FUNCTIONS
compile.html#enable_memory_management
→ -DSQLITE_ENABLE_MEMORY_MANAGEMENT SQLITE_ENABLE_MEMORY_MANAGEMENT
compile.html#enable_memsys3
→ -DSQLITE_ENABLE_MEMSYS3 SQLITE_ENABLE_MEMSYS3
compile.html#enable_memsys5
→ -DSQLITE_ENABLE_MEMSYS5 SQLITE_ENABLE_MEMSYS5
compile.html#enable_normalize
→ -DSQLITE_ENABLE_NORMALIZE SQLITE_ENABLE_NORMALIZE
compile.html#enable_null_trim
→ -DSQLITE_ENABLE_NULL_TRIM SQLITE_ENABLE_NULL_TRIM
compile.html#enable_offset_sql_func
→ -DSQLITE_ENABLE_OFFSET_SQL_FUNC SQLITE_ENABLE_OFFSET_SQL_FUNC
compile.html#enable_preupdate_hook
→ -DSQLITE_ENABLE_PREUPDATE_HOOK SQLITE_ENABLE_PREUPDATE_HOOK
compile.html#enable_qpsg
→ -DSQLITE_ENABLE_QPSG SQLITE_ENABLE_QPSG
compile.html#enable_rbu
→ -DSQLITE_ENABLE_RBU SQLITE_ENABLE_RBU
compile.html#enable_rtree
→ -DSQLITE_ENABLE_RTREE SQLITE_ENABLE_RTREE
compile.html#enable_session
→ -DSQLITE_ENABLE_SESSION SQLITE_ENABLE_SESSION
compile.html#enable_snapshot
→ -DSQLITE_ENABLE_SNAPSHOT SQLITE_ENABLE_SNAPSHOT
compile.html#enable_sorter_references
→ -DSQLITE_ENABLE_SORTER_REFERENCES SQLITE_ENABLE_SORTER_REFERENCES
compile.html#enable_sqllog
→ -DSQLITE_ENABLE_SQLLOG SQLITE_ENABLE_SQLLOG
compile.html#enable_stat2
→ -DSQLITE_ENABLE_STAT2 SQLITE_ENABLE_STAT2
compile.html#enable_stat3
→ -DSQLITE_ENABLE_STAT3 SQLITE_ENABLE_STAT3
compile.html#enable_stat4
→ -DSQLITE_ENABLE_STAT4 SQLITE_ENABLE_STAT4
compile.html#enable_stmt_scanstatus
→ -DSQLITE_ENABLE_STMT_SCANSTATUS SQLITE_ENABLE_STMT_SCANSTATUS
compile.html#enable_stmtvtab
→ -DSQLITE_ENABLE_STMTVTAB SQLITE_ENABLE_STMTVTAB
compile.html#enable_tree_explain
→ -DSQLITE_ENABLE_TREE_EXPLAIN SQLITE_ENABLE_TREE_EXPLAIN
compile.html#enable_unknown_sql_function
→ -DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTION SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION
compile.html#enable_unlock_notify
→ -DSQLITE_ENABLE_UNLOCK_NOTIFY SQLITE_ENABLE_UNLOCK_NOTIFY
compile.html#enable_update_delete_limit
→ -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT SQLITE_ENABLE_UPDATE_DELETE_LIMIT
compile.html#extern
→ -DSQLITE_EXTERN SQLITE_EXTERN
compile.html#extra_durable
→ -DSQLITE_EXTRA_DURABLE SQLITE_EXTRA_DURABLE
compile.html#fdatasync
→ -DHAVE_FDATASYNC HAVE_FDATASYNC
compile.html#fts3_max_expr_depth
→ -DSQLITE_FTS3_MAX_EXPR_DEPTH SQLITE_FTS3_MAX_EXPR_DEPTH
compile.html#gmtime_r
→ -DHAVE_GMTIME_R HAVE_GMTIME_R
compile.html#have_isnan
→ -DSQLITE_HAVE_ISNAN SQLITE_HAVE_ISNAN
compile.html#have_zlib
→ -DSQLITE_HAVE_ZLIB SQLITE_HAVE_ZLIB
compile.html#introspection_pragmas
→ -DSQLITE_INTROSPECTION_PRAGMAS SQLITE_INTROSPECTION_PRAGMAS
compile.html#isnan
→ -DHAVE_ISNAN HAVE_ISNAN
compile.html#json_max_depth
→ -DSQLITE_JSON_MAX_DEPTH SQLITE_JSON_MAX_DEPTH
compile.html#like_doesnt_match_blobs
→ -DSQLITE_LIKE_DOESNT_MATCH_BLOBS SQLITE_LIKE_DOESNT_MATCH_BLOBS
compile.html#localtime_r
→ -DHAVE_LOCALTIME_R HAVE_LOCALTIME_R
compile.html#localtime_s
→ -DHAVE_LOCALTIME_S HAVE_LOCALTIME_S
compile.html#malloc_usable_size
→ -DHAVE_MALLOC_USABLE_SIZE HAVE_MALLOC_USABLE_SIZE
compile.html#max_allocation_size
→ -DSQLITE_MAX_ALLOCATION_SIZE SQLITE_MAX_ALLOCATION_SIZE
compile.html#max_memory
→ -DSQLITE_MAX_MEMORY SQLITE_MAX_MEMORY
compile.html#max_mmap_size
→ -DSQLITE_MAX_MMAP_SIZE SQLITE_MAX_MMAP_SIZE
compile.html#max_schema_retry
→ -DSQLITE_MAX_SCHEMA_RETRY SQLITE_MAX_SCHEMA_RETRY
compile.html#max_worker_threads
→ -DSQLITE_MAX_WORKER_THREADS SQLITE_MAX_WORKER_THREADS
compile.html#memdb_default_maxsize
→ -DSQLITE_MEMDB_DEFAULT_MAXSIZE SQLITE_MEMDB_DEFAULT_MAXSIZE
compile.html#memdebug
→ -DSQLITE_MEMDEBUG SQLITE_MEMDEBUG
compile.html#minimum_file_descriptor
→ -DSQLITE_MINIMUM_FILE_DESCRIPTOR SQLITE_MINIMUM_FILE_DESCRIPTOR
compile.html#omit_altertable
→ -DSQLITE_OMIT_ALTERTABLE SQLITE_OMIT_ALTERTABLE
compile.html#omit_analyze
→ -DSQLITE_OMIT_ANALYZE SQLITE_OMIT_ANALYZE
compile.html#omit_attach
→ -DSQLITE_OMIT_ATTACH SQLITE_OMIT_ATTACH
compile.html#omit_authorization
→ -DSQLITE_OMIT_AUTHORIZATION SQLITE_OMIT_AUTHORIZATION
compile.html#omit_autoincrement
→ -DSQLITE_OMIT_AUTOINCREMENT SQLITE_OMIT_AUTOINCREMENT
compile.html#omit_autoinit
→ -DSQLITE_OMIT_AUTOINIT SQLITE_OMIT_AUTOINIT
compile.html#omit_automatic_index
→ -DSQLITE_OMIT_AUTOMATIC_INDEX SQLITE_OMIT_AUTOMATIC_INDEX
compile.html#omit_autoreset
→ -DSQLITE_OMIT_AUTORESET SQLITE_OMIT_AUTORESET
compile.html#omit_autovacuum
→ -DSQLITE_OMIT_AUTOVACUUM SQLITE_OMIT_AUTOVACUUM
compile.html#omit_between_optimization
→ -DSQLITE_OMIT_BETWEEN_OPTIMIZATION SQLITE_OMIT_BETWEEN_OPTIMIZATION
compile.html#omit_blob_literal
→ -DSQLITE_OMIT_BLOB_LITERAL SQLITE_OMIT_BLOB_LITERAL
compile.html#omit_btreecount
→ -DSQLITE_OMIT_BTREECOUNT SQLITE_OMIT_BTREECOUNT
compile.html#omit_builtin_test
→ -DSQLITE_OMIT_BUILTIN_TEST SQLITE_OMIT_BUILTIN_TEST
compile.html#omit_case_sensitive_like_pragma
→ -DSQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA SQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA
compile.html#omit_cast
→ -DSQLITE_OMIT_CAST SQLITE_OMIT_CAST
compile.html#omit_check
→ -DSQLITE_OMIT_CHECK SQLITE_OMIT_CHECK
compile.html#omit_compileoption_diags
→ -DSQLITE_OMIT_COMPILEOPTION_DIAGS SQLITE_OMIT_COMPILEOPTION_DIAGS
compile.html#omit_complete
→ -DSQLITE_OMIT_COMPLETE SQLITE_OMIT_COMPLETE
compile.html#omit_compound_select
→ -DSQLITE_OMIT_COMPOUND_SELECT SQLITE_OMIT_COMPOUND_SELECT
compile.html#omit_cte
→ -DSQLITE_OMIT_CTE SQLITE_OMIT_CTE
compile.html#omit_datetime_funcs
→ -DSQLITE_OMIT_DATETIME_FUNCS SQLITE_OMIT_DATETIME_FUNCS
compile.html#omit_decltype
→ -DSQLITE_OMIT_DECLTYPE SQLITE_OMIT_DECLTYPE
compile.html#omit_deprecated
→ -DSQLITE_OMIT_DEPRECATED SQLITE_OMIT_DEPRECATED
compile.html#omit_deserialize
→ -DSQLITE_OMIT_DESERIALIZE SQLITE_OMIT_DESERIALIZE
compile.html#omit_diskio
→ -DSQLITE_OMIT_DISKIO SQLITE_OMIT_DISKIO
compile.html#omit_explain
→ -DSQLITE_OMIT_EXPLAIN SQLITE_OMIT_EXPLAIN
compile.html#omit_flag_pragmas
→ -DSQLITE_OMIT_FLAG_PRAGMAS SQLITE_OMIT_FLAG_PRAGMAS
compile.html#omit_floating_point
→ -DSQLITE_OMIT_FLOATING_POINT SQLITE_OMIT_FLOATING_POINT
compile.html#omit_foreign_key
→ -DSQLITE_OMIT_FOREIGN_KEY SQLITE_OMIT_FOREIGN_KEY
compile.html#omit_generated_columns
→ -DSQLITE_OMIT_GENERATED_COLUMNS SQLITE_OMIT_GENERATED_COLUMNS
compile.html#omit_get_table
→ -DSQLITE_OMIT_GET_TABLE SQLITE_OMIT_GET_TABLE
compile.html#omit_hex_integer
→ -DSQLITE_OMIT_HEX_INTEGER SQLITE_OMIT_HEX_INTEGER
compile.html#omit_incrblob
→ -DSQLITE_OMIT_INCRBLOB SQLITE_OMIT_INCRBLOB
compile.html#omit_integrity_check
→ -DSQLITE_OMIT_INTEGRITY_CHECK SQLITE_OMIT_INTEGRITY_CHECK
compile.html#omit_introspection_pragmas
→ -DSQLITE_OMIT_INTROSPECTION_PRAGMAS SQLITE_OMIT_INTROSPECTION_PRAGMAS
compile.html#omit_json
→ -DSQLITE_OMIT_JSON SQLITE_OMIT_JSON
compile.html#omit_like_optimization
→ -DSQLITE_OMIT_LIKE_OPTIMIZATION SQLITE_OMIT_LIKE_OPTIMIZATION
compile.html#omit_load_extension
→ -DSQLITE_OMIT_LOAD_EXTENSION SQLITE_OMIT_LOAD_EXTENSION
compile.html#omit_localtime
→ -DSQLITE_OMIT_LOCALTIME SQLITE_OMIT_LOCALTIME
compile.html#omit_lookaside
→ -DSQLITE_OMIT_LOOKASIDE SQLITE_OMIT_LOOKASIDE
compile.html#omit_memorydb
→ -DSQLITE_OMIT_MEMORYDB SQLITE_OMIT_MEMORYDB
compile.html#omit_or_optimization
→ -DSQLITE_OMIT_OR_OPTIMIZATION SQLITE_OMIT_OR_OPTIMIZATION
compile.html#omit_pager_pragmas
→ -DSQLITE_OMIT_PAGER_PRAGMAS SQLITE_OMIT_PAGER_PRAGMAS
compile.html#omit_pragma
→ -DSQLITE_OMIT_PRAGMA SQLITE_OMIT_PRAGMA
compile.html#omit_progress_callback
→ -DSQLITE_OMIT_PROGRESS_CALLBACK SQLITE_OMIT_PROGRESS_CALLBACK
compile.html#omit_quickbalance
→ -DSQLITE_OMIT_QUICKBALANCE SQLITE_OMIT_QUICKBALANCE
compile.html#omit_reindex
→ -DSQLITE_OMIT_REINDEX SQLITE_OMIT_REINDEX
compile.html#omit_schema_pragmas
→ -DSQLITE_OMIT_SCHEMA_PRAGMAS SQLITE_OMIT_SCHEMA_PRAGMAS
compile.html#omit_schema_version_pragmas
→ -DSQLITE_OMIT_SCHEMA_VERSION_PRAGMAS SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS
compile.html#omit_shared_cache
→ -DSQLITE_OMIT_SHARED_CACHE SQLITE_OMIT_SHARED_CACHE
compile.html#omit_subquery
→ -DSQLITE_OMIT_SUBQUERY SQLITE_OMIT_SUBQUERY
compile.html#omit_tcl_variable
→ -DSQLITE_OMIT_TCL_VARIABLE SQLITE_OMIT_TCL_VARIABLE
compile.html#omit_tempdb
→ -DSQLITE_OMIT_TEMPDB SQLITE_OMIT_TEMPDB
compile.html#omit_trace
→ -DSQLITE_OMIT_TRACE SQLITE_OMIT_TRACE
compile.html#omit_trigger
→ -DSQLITE_OMIT_TRIGGER SQLITE_OMIT_TRIGGER
compile.html#omit_truncate_optimization
→ -DSQLITE_OMIT_TRUNCATE_OPTIMIZATION SQLITE_OMIT_TRUNCATE_OPTIMIZATION
compile.html#omit_utf16
→ -DSQLITE_OMIT_UTF16 SQLITE_OMIT_UTF16
compile.html#omit_vacuum
→ -DSQLITE_OMIT_VACUUM SQLITE_OMIT_VACUUM
compile.html#omit_view
→ -DSQLITE_OMIT_VIEW SQLITE_OMIT_VIEW
compile.html#omit_virtualtable
→ -DSQLITE_OMIT_VIRTUALTABLE SQLITE_OMIT_VIRTUALTABLE
compile.html#omit_wal
→ -DSQLITE_OMIT_WAL SQLITE_OMIT_WAL
compile.html#omit_windowfunc
→ -DSQLITE_OMIT_WINDOWFUNC SQLITE_OMIT_WINDOWFUNC
compile.html#omit_wsd
→ -DSQLITE_OMIT_WSD SQLITE_OMIT_WSD
compile.html#omit_xfer_opt
→ -DSQLITE_OMIT_XFER_OPT SQLITE_OMIT_XFER_OPT
compile.html#omitfeatures
→ omitfeatures
compile.html#os_other
→ -DSQLITE_OS_OTHER SQLITE_OS_OTHER
compile.html#powersafe_overwrite
→ -DSQLITE_POWERSAFE_OVERWRITE SQLITE_POWERSAFE_OVERWRITE
compile.html#printf_precision_limit
→ -DSQLITE_PRINTF_PRECISION_LIMIT SQLITE_PRINTF_PRECISION_LIMIT
compile.html#query_planner_limit
→ -DSQLITE_QUERY_PLANNER_LIMIT SQLITE_QUERY_PLANNER_LIMIT
compile.html#query_planner_limit_incr
→ -DSQLITE_QUERY_PLANNER_LIMIT_INCR SQLITE_QUERY_PLANNER_LIMIT_INCR
compile.html#rcmd
→ {recommended compile-time option} {recommended compile-time options}
compile.html#reverse_unordered_selects
→ -DSQLITE_REVERSE_UNORDERED_SELECTS SQLITE_REVERSE_UNORDERED_SELECTS
compile.html#rtree_int_only
→ -DSQLITE_RTREE_INT_ONLY SQLITE_RTREE_INT_ONLY
compile.html#secure_delete
→ -DSQLITE_SECURE_DELETE SQLITE_SECURE_DELETE
compile.html#sorter_pmasz
→ -DSQLITE_SORTER_PMASZ SQLITE_SORTER_PMASZ
compile.html#soundex
→ -DSQLITE_SOUNDEX SQLITE_SOUNDEX
compile.html#sqlite_config_h
→ -DHAVE_SQLITE_CONFIG_H HAVE_SQLITE_CONFIG_H
compile.html#stdcall
→ -DSQLITE_STDCALL SQLITE_STDCALL
compile.html#stmtjrnl_spill
→ -DSQLITE_STMTJRNL_SPILL SQLITE_STMTJRNL_SPILL
compile.html#strchrnul
→ -DHAVE_STRCHRNUL HAVE_STRCHRNUL
compile.html#strict_subtype
→ -DSQLITE_STRICT_SUBTYPE SQLITE_STRICT_SUBTYPE
compile.html#sysapi
→ -DSQLITE_SYSAPI SQLITE_SYSAPI
compile.html#tclapi
→ -DSQLITE_TCLAPI SQLITE_TCLAPI
compile.html#temp_store
→ -DSQLITE_TEMP_STORE SQLITE_TEMP_STORE
compile.html#threadsafe
→ -DSQLITE_THREADSAFE SQLITE_THREADSAFE
compile.html#trace_size_limit
→ -DSQLITE_TRACE_SIZE_LIMIT SQLITE_TRACE_SIZE_LIMIT
compile.html#trusted_schema
→ -DSQLITE_TRUSTED_SCHEMA SQLITE_TRUSTED_SCHEMA
compile.html#untestable
→ -DSQLITE_UNTESTABLE SQLITE_UNTESTABLE
compile.html#use_alloca
→ -DSQLITE_USE_ALLOCA SQLITE_USE_ALLOCA
compile.html#use_fcntl_trace
→ -DSQLITE_USE_FCNTL_TRACE SQLITE_USE_FCNTL_TRACE
compile.html#use_seh
→ -DSQLITE_USE_SEH SQLITE_USE_SEH
compile.html#use_uri
→ -DSQLITE_USE_URI SQLITE_USE_URI
compile.html#utime
→ -DHAVE_UTIME HAVE_UTIME
compile.html#win32_heap_create
→ -DSQLITE_WIN32_HEAP_CREATE SQLITE_WIN32_HEAP_CREATE
compile.html#win32_malloc
→ -DSQLITE_WIN32_MALLOC SQLITE_WIN32_MALLOC
compile.html#win32_malloc_validate
→ -DSQLITE_WIN32_MALLOC_VALIDATE SQLITE_WIN32_MALLOC_VALIDATE
compile.html#yystackdepth
→ YYSTACKDEPTH
compile.html#yytrackmaxstackdepth
→ YYTRACKMAXSTACKDEPTH
compile.html#zero_malloc
→ -DSQLITE_ZERO_MALLOC SQLITE_ZERO_MALLOC
completion.html
→ COMPLETION {COMPLETION extension} {COMPLETION table-valued function}
consortium.html
→ {SQLite Consortium}
copyright.html
→ copyright license public-domain
copyright.html#notopencontrib
→ {not open-contributin}
copyright.html#warrantyoftitle
→ {Warranty of Title}
cpu.html
→ {CPU cycles used} {CPU performance measurement}
cpu.html#microopt
→ microoptimizations
crew.html
→ Hipp Kennedy crew
crew.html#dan
→ {Dan Kennedy}
csv.html
→ {CSV virtual table} csv
custombuild.html
→ {custom builds} {porting SQLite}
cves.html
→ CVEs {reported vulnerabilities} vulnerabilities
cves.html#cvetab
→ {recent CVEs}
datatype3.html
→ datatype {dynamic typing} {flexible type system}
datatype3.html#affcompoundview
→ {affinity in compound VIEWs}
datatype3.html#affinity
→ affinities affinity {column affinity} {type affinity}
datatype3.html#affname
→ {rules for determining column affinity}
datatype3.html#affview
→ {rules for determining column affinity in VIEWs}
datatype3.html#boolean
→ {boolean datatype}
datatype3.html#collation
→ BINARY {BINARY collating function} NOCASE {NOCASE collating function} RTRIM {RTRIM collating function} {collating function} {collating sequence} {collating sequences} collation
datatype3.html#colrules
→ {how collation is determined}
datatype3.html#compaff
→ {comparison affinity rules}
datatype3.html#comparisons
→ {comparison expressions}
datatype3.html#datetime
→ {date and time datatype}
datatype3.html#expraff
→ {Affinity Of Expressions} {expression affinity}
datatype3.html#sortorder
→ {sort order}
datatype3.html#storageclasses
→ {storage class}
dbhash.html
→ dbhash dbhash.exe
dbpage.html
→ {SQLITE_DBPAGE virtual table} sqlite_dbpage {the SQLITE_DBPAGE extension}
dbstat.html
→ {DBSTAT virtual table} dbstat {dbstat virtual table}
dbstat.html#dbstatagg
→ {DBSTAT aggregated mode}
debugging.html
→ dbghints {debugging hints}
deterministic.html
→ {deterministic SQL functions} {deterministic function} {deterministic functions} {non-deterministic functions}
deterministic.html#dtexception
→ {date/time special case}
doclist.html
→ {alphabetical listing of documents} doclist
docs.html
→ {categorical listing of SQLite documents} {documents by category}
download.html
→ {TEA tarball} {amalgamation tarball} {download page}
download.html#encoding
→ {build product names}
download.html#srctree
→ {SQLite source code repositories} {code repositories}
eqp.html
→ {EXPLAIN QUERY PLAN} {explain query plan}
eqp.html#or-opt
→ eqp-or-opt
errlog.html
→ errlog {error log}
expridx.html
→ {Indexes On Expressions} {expression index} {expression indexes} {indexed expression} {indexed expressions} {indexes on expressions}
fasterthanfs.html
→ {35 Faster Than The Filesystem} {faster than the filesystem}
fileformat2.html
→ {SQLite database file format} {file format} {on-disk format} {second edition file format document}
fileformat2.html##sqltab
→ {table data format}
fileformat2.html#appid
→ {Application ID}
fileformat2.html#btree
→ B-Trees B-tree
fileformat2.html#btypes
→ {index b-tree} {table b-tree}
fileformat2.html#cell_payload
→ {cell payload}
fileformat2.html#cellformat
→ {cell format summary}
fileformat2.html#chngctr
→ {change counter}
fileformat2.html#database_header
→ {database header}
fileformat2.html#enc
→ {text encoding}
fileformat2.html#ffschema
→ {schema storage}
fileformat2.html#filesize
→ {in-header database size}
fileformat2.html#freelist
→ {free-page list} freelist
fileformat2.html#hotjrnl
→ {hot journal} {hot journal files}
fileformat2.html#intschema
→ {internal index} {internal indexes} {internal schema object} {internal schema objects} {internal table} {internal tables}
fileformat2.html#lockbyte
→ {lock-byte page}
fileformat2.html#ovflpgs
→ {overflow page} {overflow pages}
fileformat2.html#record_format
→ {record format}
fileformat2.html#resbyte
→ {reserve bytes}
fileformat2.html#rollbackjournal
→ {rollback journal format}
fileformat2.html#schemaformat
→ {schema format} {schema format number}
fileformat2.html#seqtab
→ sqlite_sequence
fileformat2.html#serialtype
→ {serial type} {serial types}
fileformat2.html#stat1tab
→ SQLITE_STAT1 sqlite_stat1
fileformat2.html#stat2tab
→ sqlite_stat2
fileformat2.html#stat3tab
→ SQLITE_STAT3 sqlite_stat3
fileformat2.html#stat4tab
→ SQLITE_STAT4 sqlite_stat4
fileformat2.html#usable_size
→ {usable size}
fileformat2.html#validfor
→ {version-valid-for number}
fileformat2.html#varint
→ {variable-length integer} varint
fileformat2.html#vnums
→ {file format version numbers}
fileformat2.html#walcksm
→ {WAL checksum algorithm}
fileformat2.html#walformat
→ {WAL file format} {WAL format}
fileformat2.html#walread
→ {WAL read algorithm}
fileformat2.html#walreset
→ {WAL reset} {reset the WAL}
flextypegood.html
→ {Flexible typing is a feature} {appreciate the freedom}
floatingpoint.html#decext
→ {decimal extension}
floatingpoint.html#fpapprox
→ {IEEE 754 floating point values are approximations}
floatingpoint.html#ieee754
→ {ieee754 function}
floatingpoint.html#ieee754b
→ {ieee754_from_blob function} {ieee754_to_blob function}
floatingpoint.html#ieee754ext
→ {ieee754 extension}
floatingpoint.html#ieee754m
→ {ieee754_exponent function} {ieee754_mantissa function}
footprint.html
→ footprint {library size} relfootprint
foreignkeys.html
→ {FOREIGN KEY constraints} {foreign key constraint} {foreign key constraints}
foreignkeys.html#fk_actions
→ {foreign key actions}
foreignkeys.html#fk_enable
→ {foreign key constraints are enabled}
foreignkeys.html#parentchild
→ {child key} {child table} {parent key} {parent table}
fts3.html
→ FTS3 fts3 {full-text search}
fts3.html#*cmds
→ {FTS4 commands}
fts3.html#*fts4automergecmd
→ {FTS4 automerge command} {automerge command}
fts3.html#*fts4compression
→ {compressed FTS4 content}
fts3.html#*fts4content
→ {FTS4 content option}
fts3.html#*fts4ickcmd
→ {FTS4 integrity-check command}
fts3.html#*fts4languageid
→ {FTS4 languageid option} languageid
fts3.html#*fts4mergecmd
→ {FTS4 merge command} {merge command}
fts3.html#*fts4optcmd
→ {FTS4 optimize command} {optimize command}
fts3.html#*fts4rebuidcmd
→ {FTS4 rebuild command} {rebuild command}
fts3.html#*shadowtab
→ {FTS shadow tables}
fts3.html#_contentless_fts4_tables_
→ {contentless fts4 tables}
fts3.html#_external_content_fts4_tables_
→ {external content fts4 tables}
fts3.html#_set_operations_using_the_enhanced_query_syntax
→ {enhanced query syntax}
fts3.html#appendix_a
→ {search application tips}
fts3.html#commands
→ commands
fts3.html#compiling_and_enabling_fts3_and_fts4
→ {compile fts}
fts3.html#data_structures
→ {segment btree}
fts3.html#f3tknzr
→ fts3_tokenizer
fts3.html#f4alid
→ {fts4aux languageid column}
fts3.html#fts3tok
→ fts3tokenize {fts3tokenize virtual table}
fts3.html#fts4
→ FTS4
fts3.html#fts4_options
→ {FTS4 options}
fts3.html#fts4aux
→ fts4aux
fts3.html#fts4matchinfo
→ {FTS4 matchinfo option}
fts3.html#fts4notindexed
→ {FTS4 notindexed option}
fts3.html#fts4order
→ {FTS4 order option}
fts3.html#fts4prefix
→ {FTS4 prefix option}
fts3.html#full_text_index_queries
→ {FTS MATCH}
fts3.html#hiddencol
→ {FTS hidden column}
fts3.html#limitations
→ bugs
fts3.html#matchinfo
→ matchinfo
fts3.html#matchinfo-b
→ {matchinfo b flag}
fts3.html#matchinfo-x
→ {matchinfo x flag}
fts3.html#matchinfo-y
→ {matchinfo y flag}
fts3.html#near
→ {NEAR queries}
fts3.html#offsets
→ offsets
fts3.html#phrase
→ {phrase queries}
fts3.html#shadow_tables
→ shadowtabs
fts3.html#simple_fts_queries
→ {simple fts queries}
fts3.html#snippet
→ {FTS auxiliary functions} snippet
fts3.html#termprefix
→ {prefix queries} {prefix query}
fts3.html#the_compress_and_uncompress_options
→ {fts4 compress option}
fts3.html#the_content_option_
→ {fts4 content option}
fts3.html#the_languageid_option
→ {fts4 languageid option}
fts3.html#the_matchinfo_option
→ {fts4 matchinfo option}
fts3.html#the_notindexed_option
→ {fts4 notindexed option}
fts3.html#the_prefix_option
→ {fts4 prefix option}
fts3.html#tokenizer
→ tokenizer
fts3.html#unicode61
→ unicode61
fts5.html
→ FTS5 fts5
fts5.html#_auxiliary_functions_
→ {FTS5 auxiliary functions}
fts5.html#_custom_auxiliary_functions_api_reference_
→ {custom auxiliary functions}
fts5.html#_summary_of_technical_differences_
→ {fts5 technical differences}
fts5.html#appendix_a
→ {comparison with fts4}
fts5.html#carrotq
→ {FTS5 initial token}
fts5.html#clssdeltab
→ contentless-delete
fts5.html#compiling_and_using_fts5
→ {FTS5 building}
fts5.html#contentless_delete_tables
→ {FTS5 contentless-delete tables}
fts5.html#contentless_tables
→ {FTS5 contentless tables}
fts5.html#custom_auxiliary_functions
→ {FTS5 custom auxiliary functions}
fts5.html#custom_tokenizers
→ {custom tokenizers}
fts5.html#extending_fts5
→ {Extending FTS5}
fts5.html#external_content_and_contentless_tables
→ {FTS5 content option}
fts5.html#external_content_table_pitfalls
→ {FTS5 external content pitfalls}
fts5.html#external_content_tables
→ {FTS5 external content tables}
fts5.html#fts5_boolean_operators
→ {FTS5 boolean operators}
fts5.html#fts5_column_filters
→ {FTS5 column filters}
fts5.html#fts5_initial_token_queries
→ {FTS5 initial token queries}
fts5.html#fts5_near_queries
→ {FTS5 NEAR queries}
fts5.html#fts5_phrases
→ {FTS5 Phrases}
fts5.html#fts5_prefix_queries
→ {FTS5 prefix queries}
fts5.html#fts5_strings
→ {FTS5 Strings}
fts5.html#fts5_table_creation_and_initialization
→ {FTS5 CREATE TABLE Options}
fts5.html#fts5shadowtables
→ {fts5 shadow tables}
fts5.html#full_text_query_syntax
→ {FTS5 query syntax}
fts5.html#prefix_indexes
→ {FTS5 prefix indexes}
fts5.html#sorting_by_auxiliary_function_results
→ {auxiliary function mapping}
fts5.html#the_automerge_configuration_option
→ {FTS5 automerge option}
fts5.html#the_bm25_function
→ {FTS5 bm25}
fts5.html#the_columnsize_option
→ {FTS5 columnsize option}
fts5.html#the_delete_all_command
→ {FTS5 delete-all command}
fts5.html#the_delete_command
→ {FTS5 delete command}
fts5.html#the_deletemerge_configuration_option
→ deletemerge
fts5.html#the_detail_option
→ {FTS5 detail option}
fts5.html#the_fts5vocab_virtual_table_module
→ fts5vocab
fts5.html#the_highlight_function
→ {FTS5 highlight}
fts5.html#the_merge_command
→ {FTS5 merge command}
fts5.html#the_optimize_command
→ {FTS5 optimize command}
fts5.html#the_pgsz_configuration_option
→ {FTS5 pgsz option}
fts5.html#the_rank_configuration_option
→ {FTS5 rank configuration option}
fts5.html#the_rebuild_command
→ {FTS5 rebuild command}
fts5.html#the_secure_delete_configuration_option
→ {FTS5 secure-delete command}
fts5.html#the_snippet_function
→ {FTS5 snippet}
fts5.html#the_tokendata_option
→ {FTS5 tokendata option}
fts5.html#the_unindexed_column_option
→ unindexed
fts5.html#the_usermerge_configuration_option
→ {FTS5 usermerge option}
fts5.html#tokenizers
→ {FTS5 tokenizers}
fts5.html#trigramidx
→ {trigram indexes} {trigram tokenizer}
fullsql.html
→ {Full-featured SQL} {full-featured SQL}
gencol.html
→ {Generated columns} {computed columns} {generated column} {generated columns}
geopoly.html
→ GEOPOLY {Geopoly extension} {Geopoly module} geopoly
geopoly.html#ccw
→ geopoly_ccw
geopoly.html#garea
→ geopoly_area
geopoly.html#gbbox
→ geopoly_bbox geopoly_group_bbox
geopoly.html#gblob
→ geopoly_blob
geopoly.html#gjson
→ geopoly_json
geopoly.html#goverlap
→ geopoly_overlap
geopoly.html#gpoint
→ geopoly_contains_point
geopoly.html#gsvg
→ geopoly_svg
geopoly.html#gwithin
→ geopoly_within
geopoly.html#regpoly
→ geopoly_regular
geopoly.html#xform
→ geopoly_xform
getthecode.html
→ {canonical source code} {get the canonical source code}
getthecode.html#clone
→ {clone the entire repository}
hirely.html
→ high-reliability
howitworks.html
→ {How SQL Works} {How SQLite Works}
howtocompile.html
→ {How To Compile SQLite} {how to compile}
howtocompile.html#amal
→ {building the amalgamation}
howtocompile.html#cli
→ {compiling the CLI}
howtocompile.html#dll
→ {building a DLL}
howtocompile.html#tcl
→ {compiling the TCL interface}
howtocorrupt.html
→ {how to corrupt}
howtocorrupt.html#alias
→ {database filename aliasing}
howtocorrupt.html#cfgerr
→ cfgerrors
howtocorrupt.html#delhotjrnl
→ {deleting a hot journal}
howtocorrupt.html#fscorruption
→ {filesystem corruption}
howtocorrupt.html#roguejrnl
→ {separating a database from its journal}
howtocorrupt.html#stalefd
→ {stale file descriptor}
howtocorrupt.html#svptbug
→ {SAVEPOINT bug}
howtocorrupt.html#unlink
→ {unlink corruption} {unlinked database files}
imposter.html
→ {imposter tables}
imposter.html#dotimposter
→ {.imposter dot-command}
inmemorydb.html
→ {in-memory database} {in-memory databases} memory
inmemorydb.html#sharedmemdb
→ {in-memory shared cache database}
inmemorydb.html#temp_db
→ {temporary databases} {temporary tables}
intern-v-extern-blob.html
→ {BLOB I/O performance} {Internal Versus External BLOBs}
invalidutf.html
→ {invalid UTF}
isolation.html
→ isolation
json1.html
→ {JSON SQL functions} json1 {the json1 extension}
json1.html#jarray
→ json_array {json_array SQL function}
json1.html#jarrayb
→ jsonb_array {jsonb_array SQL function}
json1.html#jarraylen
→ json_array_length {json_array_length SQL function}
json1.html#jblobbug
→ {JSON BLOB input bug}
json1.html#jeach
→ json_each {json_each table-valued function}
json1.html#jerr
→ json_error_position {json_error_position SQL function}
json1.html#jex
→ json_extract {json_extract SQL function}
json1.html#jexb
→ jsonb_extract {jsonb_extract SQL function}
json1.html#jgrouparray
→ json_group_array {json_group_array SQL function}
json1.html#jgrouparrayb
→ jsonb_group_array {jsonb_group_array SQL function}
json1.html#jgroupobject
→ json_group_object {json_group_object SQL function}
json1.html#jgroupobjectb
→ {aggregate JSON SQL functions} jsonb_group_object {jsonb_group_object SQL function}
json1.html#jins
→ json_insert {json_insert SQL function}
json1.html#jinsb
→ jsonb_insert {jsonb_insert SQL function}
json1.html#jmini
→ json {json SQL function}
json1.html#jminib
→ jsonb {jsonb SQL function}
json1.html#jobj
→ json_object {json_object SQL function}
json1.html#jobjb
→ jsonb_object {jsonb_object SQL function}
json1.html#jpatch
→ json_patch {json_patch SQL function}
json1.html#jpatchb
→ jsonb_patch {jsonb_patch SQL function}
json1.html#jptr
→ {the - and - operators} {the - operator}
json1.html#jquote
→ json_quote {json_quote SQL function}
json1.html#jrepl
→ json_replace {json_replace SQL function}
json1.html#jreplb
→ jsonb_replace {jsonb_replace SQL function}
json1.html#jrm
→ json_remove {json_remove SQL function}
json1.html#jrmb
→ jsonb_remove {jsonb_remove SQL function}
json1.html#jset
→ json_set {json_set SQL function}
json1.html#jsetb
→ jsonb_set {jsonb_set SQL function}
json1.html#json5
→ JSON5 {JSON5 extensions}
json1.html#jsonbx
→ JSONB
json1.html#jsonpath
→ {JSON function path arguments} {JSON paths}
json1.html#jtree
→ json_tree {json_tree table-valued function}
json1.html#jtype
→ json_type {json_type SQL function}
json1.html#jvalid
→ json_valid {json_valid SQL function}
json1.html#varg
→ {value argument}
keyword_index.html
→ {keyword index}
lang_aggfunc.html
→ {Aggregate Functions} {Aggregate functions} aggfunc {aggregate SQL functions} {aggregate functions}
lang_aggfunc.html#aggfilter
→ {FILTER clause on aggregate functions}
lang_aggfunc.html#aggorderby
→ {ORDER BY clause in aggregate functions}
lang_aggfunc.html#avg
→ avg {avg aggregate function}
lang_aggfunc.html#count
→ count {count aggregate function}
lang_aggfunc.html#group_concat
→ group_concat {group_concat aggregate function} string_agg {string_agg aggregate function}
lang_aggfunc.html#max_agg
→ {max aggregate function} max_agg
lang_aggfunc.html#min_agg
→ {min aggregate function} min_agg
lang_aggfunc.html#sumunc
→ sum {sum aggregate function} sumFunc total {total aggregate function}
lang_altertable.html
→ ALTER {ALTER TABLE} altertable
lang_altertable.html#altertabaddcol
→ {ALTER TABLE ADD COLUMN} {add column}
lang_altertable.html#altertabdropcol
→ {ALTER TABLE DROP COLUMN} {drop column}
lang_altertable.html#altertableishard
→ {why ALTER TABLE is so difficult}
lang_altertable.html#altertabmvcol
→ {ALTER TABLE RENAME COLUMN} {rename column}
lang_altertable.html#altertabrename
→ {ALTER TABLE RENAME} {ALTER TABLE RENAME documentation} {rename table}
lang_altertable.html#otheralter
→ {generalized ALTER TABLE procedure}
lang_analyze.html
→ ANALYZE analyze
lang_analyze.html#approx
→ {approximate ANALYZE}
lang_analyze.html#autoanalyze
→ {automatically running ANALYZE}
lang_analyze.html#req
→ {recommended ANALYZE usage pattern}
lang_attach.html
→ ATTACH {ATTACH DATABASE} attach attached
lang_comment.html
→ comment comments
lang_conflict.html
→ {ON CONFLICT} {ON CONFLICT clause} {ON CONFLICT clauses} conflict {conflict clause} {conflict resolution algorithm}
lang_corefunc.html
→ {Core Functions} {Scalar Functions} corefunc {scalar functions}
lang_corefunc.html#abs
→ abs {abs SQL function}
lang_corefunc.html#changes
→ changes {changes SQL function}
lang_corefunc.html#char
→ char {char SQL function}
lang_corefunc.html#coalesce
→ coalesce {coalesce SQL function}
lang_corefunc.html#concat
→ concat {concat SQL function}
lang_corefunc.html#concat_ws
→ concat_ws {concat_ws SQL function}
lang_corefunc.html#format
→ format {format SQL function}
lang_corefunc.html#glob
→ glob {glob SQL function}
lang_corefunc.html#hex
→ hex {hex SQL function}
lang_corefunc.html#ifnull
→ ifnull {ifnull SQL function}
lang_corefunc.html#iif
→ iif {iif SQL function}
lang_corefunc.html#instr
→ instr {instr SQL function}
lang_corefunc.html#last_insert_rowid
→ last_insert_rowid {last_insert_rowid SQL function}
lang_corefunc.html#length
→ length {length SQL function}
lang_corefunc.html#like
→ like {like SQL function}
lang_corefunc.html#likelihood
→ likelihood {likelihood SQL function}
lang_corefunc.html#likely
→ likely {likely SQL function}
lang_corefunc.html#load_extension
→ load_extension {load_extension SQL function}
lang_corefunc.html#lower
→ lower {lower SQL function}
lang_corefunc.html#ltrim
→ ltrim {ltrim SQL function}
lang_corefunc.html#max_scalar
→ max {max SQL function} max_scalar
lang_corefunc.html#min_scalar
→ min {min SQL function} min_scalar
lang_corefunc.html#nullif
→ nullif {nullif SQL function}
lang_corefunc.html#octet_length
→ octet_length {octet_length SQL function}
lang_corefunc.html#printf
→ printf {printf SQL function}
lang_corefunc.html#quote
→ quote {quote SQL function}
lang_corefunc.html#random
→ random {random SQL function}
lang_corefunc.html#randomblob
→ randomblob {randomblob SQL function}
lang_corefunc.html#replace
→ replace {replace SQL function}
lang_corefunc.html#round
→ round {round SQL function}
lang_corefunc.html#rtrim
→ rtrim {rtrim SQL function}
lang_corefunc.html#sign
→ sign {sign SQL function}
lang_corefunc.html#soundex
→ soundex {soundex SQL function}
lang_corefunc.html#sqlite_compileoption_get
→ sqlite_compileoption_get {sqlite_compileoption_get SQL function}
lang_corefunc.html#sqlite_compileoption_used
→ sqlite_compileoption_used {sqlite_compileoption_used SQL function}
lang_corefunc.html#sqlite_offset
→ sqlite_offset {sqlite_offset SQL function}
lang_corefunc.html#sqlite_source_id
→ sqlite_source_id {sqlite_source_id SQL function}
lang_corefunc.html#sqlite_version
→ sqlite_version {sqlite_version SQL function}
lang_corefunc.html#substr
→ substr {substr SQL function}
lang_corefunc.html#total_changes
→ total_changes {total_changes SQL function}
lang_corefunc.html#trim
→ trim {trim SQL function}
lang_corefunc.html#typeof
→ typeof {typeof SQL function}
lang_corefunc.html#unhex
→ unhex {unhex SQL function}
lang_corefunc.html#unicode
→ unicode {unicode SQL function}
lang_corefunc.html#unlikely
→ unlikely {unlikely SQL function}
lang_corefunc.html#upper
→ upper {upper SQL function}
lang_corefunc.html#zeroblob
→ zeroblob {zeroblob SQL function}
lang_createindex.html
→ {CREATE INDEX} Indexes createindex
lang_createindex.html#collidx
→ COLLATE
lang_createindex.html#descidx
→ DESC {descending index} {descending indexes} {descending indices}
lang_createindex.html#uniqueidx
→ {unique index}
lang_createtable.html
→ {CREATE TABLE} createtable
lang_createtable.html#ckconst
→ CHECK {CHECK constraint} {CHECK constraints}
lang_createtable.html#collateclause
→ {COLLATE clause} {COLLATE clauses} {COLLATE constraint}
lang_createtable.html#createtabas
→ {CREATE TABLE AS}
lang_createtable.html#dfltval
→ {DEFAULT clauses} {default column value} {default value}
lang_createtable.html#notnullconst
→ {NOT NULL} {NOT NULL constraint} {NOT NULL constraints}
lang_createtable.html#primkeyconst
→ {PRIMARY KEY} {PRIMARY KEY constraint}
lang_createtable.html#rowid
→ {INTEGER PRIMARY KEY} ROWID rowid
lang_createtable.html#tablecoldef
→ {column definition} {column definitions}
lang_createtable.html#uniqueconst
→ UNIQUE {UNIQUE constraint} {UNIQUE constraints} {unique constraint}
lang_createtrigger.html
→ {CREATE TRIGGER} {UPDATE trigger} createtrigger trigger triggers
lang_createtrigger.html#instead_of_trigger
→ {INSTEAD OF} {INSTEAD OF trigger}
lang_createtrigger.html#raise
→ {RAISE function}
lang_createtrigger.html#temptrig
→ {TEMP triggers on non-TEMP tables}
lang_createtrigger.html#undef_before
→ {undefined BEFORE trigger behavior}
lang_createview.html
→ {CREATE VIEW} VIEW createview view views
lang_createvtab.html
→ {CREATE VIRTUAL TABLE} createvtab
lang_datefunc.html
→ {Date And Time Functions} {date and time functions} datefunc
lang_datefunc.html#automod
→ {auto modifier}
lang_datefunc.html#dtmods
→ {date/time modifiers} modifiers
lang_datefunc.html#dttm
→ date {date SQL function} datetime {datetime SQL function} time {time SQL function}
lang_datefunc.html#jdmod
→ {julianday modifier}
lang_datefunc.html#jlndy
→ julianday {julianday SQL function}
lang_datefunc.html#localtime
→ {localtime modifier} {utc modifier}
lang_datefunc.html#strftm
→ strftime {strftime SQL function}
lang_datefunc.html#subsec
→ {subsec modifier} {subsecond modifier}
lang_datefunc.html#tmdif
→ timediff {timediff SQL function}
lang_datefunc.html#tmshf
→ {time shift modifiers}
lang_datefunc.html#uepch
→ unixepoch {unixepoch SQL function} {unixepoch function}
lang_delete.html
→ DELETE DELETEs delete
lang_delete.html#truncateopt
→ {truncate optimization}
lang_detach.html
→ DETACH {DETACH DATABASE} detach
lang_dropindex.html
→ {DROP INDEX} dropindex
lang_droptable.html
→ {DROP TABLE} droptable
lang_droptrigger.html
→ {DROP TRIGGER} droptrigger
lang_dropview.html
→ {DROP VIEW} dropview
lang_explain.html
→ EXPLAIN explain
lang_expr.html
→ expression {expression syntax} langexpr
lang_expr.html#*funcinexpr
→ {functions within expressions}
lang_expr.html#between
→ BETWEEN
lang_expr.html#binaryops
→ {binary operators}
lang_expr.html#booleanexpr
→ {boolean expression}
lang_expr.html#case
→ {CASE expression}
lang_expr.html#castexpr
→ CAST {CAST expression} {CAST operator} cast
lang_expr.html#collateop
→ {COLLATE operator}
lang_expr.html#cosub
→ {correlated subqueries}
lang_expr.html#exists_op
→ {EXISTS operator} {NOT EXISTS operator}
lang_expr.html#extract
→ extract
lang_expr.html#glob
→ GLOB
lang_expr.html#hexint
→ {hexadecimal integer literals} {hexadecimal integers}
lang_expr.html#in_op
→ {IN operator} {NOT IN operator}
lang_expr.html#isdf
→ {IS DISTINCT FROM} {IS NOT DISTINCT FROM}
lang_expr.html#isisnot
→ {IS NOT operator} {IS operator}
lang_expr.html#like
→ ESCAPE LIKE
lang_expr.html#litvalue
→ {literal value}
lang_expr.html#match
→ MATCH
lang_expr.html#regexp
→ REGEXP
lang_expr.html#subq
→ Subqueries
lang_expr.html#varparam
→ {bound parameter} {bound parameters} parameter parameters
lang_indexedby.html
→ {INDEXED BY} {NOT INDEXED} langindexedby
lang_insert.html
→ INSERT INSERTs insert
lang_keywords.html
→ {SQL keyword} {SQL keywords} {SQLite Keywords} keywords langkeywords
lang_mathfunc.html
→ {Math Functions} {built-in SQL math functions} {math functions} mathfunc
lang_mathfunc.html#acos
→ acos {acos SQL function}
lang_mathfunc.html#acosh
→ acosh {acosh SQL function}
lang_mathfunc.html#asin
→ asin {asin SQL function}
lang_mathfunc.html#asinh
→ asinh {asinh SQL function}
lang_mathfunc.html#atan
→ atan {atan SQL function}
lang_mathfunc.html#atan2
→ atan2 {atan2 SQL function}
lang_mathfunc.html#atanh
→ atanh {atanh SQL function}
lang_mathfunc.html#ceil
→ ceil ceiling
lang_mathfunc.html#cos
→ cos {cos SQL function}
lang_mathfunc.html#cosh
→ cosh {cosh SQL function}
lang_mathfunc.html#degrees
→ degrees {degrees SQL function}
lang_mathfunc.html#exp
→ exp {exp SQL function}
lang_mathfunc.html#floor
→ floor {floor SQL function}
lang_mathfunc.html#ln
→ ln {ln SQL function}
lang_mathfunc.html#log
→ log log10
lang_mathfunc.html#log2
→ log2 {log2 SQL function}
lang_mathfunc.html#mod
→ mod {mod SQL function}
lang_mathfunc.html#pi
→ pi {pi SQL function}
lang_mathfunc.html#pow
→ pow {pow SQL function}
lang_mathfunc.html#radians
→ radians {radians SQL function}
lang_mathfunc.html#sin
→ sin {sin SQL function}
lang_mathfunc.html#sinh
→ sinh {sinh SQL function}
lang_mathfunc.html#sqrt
→ sqrt {sqrt SQL function}
lang_mathfunc.html#tan
→ tan {tan SQL function}
lang_mathfunc.html#tanh
→ tanh {tanh SQL function}
lang_mathfunc.html#trunc
→ trunc {trunc SQL function}
lang_naming.html
→ naming {object resolution}
lang_reindex.html
→ REINDEX reindex
lang_replace.html
→ REPLACE langreplace
lang_returning.html
→ RETURNING {RETURNING clause} returning
lang_savepoint.html
→ RELEASE SAVEPOINT savepoint
lang_select.html
→ SELECT {SELECT query} {SELECT statement} select
lang_select.html#bareagg
→ {bare aggregate terms}
lang_select.html#compound
→ {compound SELECT} {compound SELECTs} {compound query} {compound select}
lang_select.html#crossjoin
→ {treats the CROSS JOIN operator specially}
lang_select.html#distinct
→ DISTINCT
lang_select.html#fromclause
→ {FROM clause}
lang_select.html#fulljoin
→ {FULL JOIN} {FULL OUTER JOIN}
lang_select.html#limitoffset
→ LIMIT OFFSET
lang_select.html#nonstd
→ {non-standard SELECT syntax}
lang_select.html#nullslast
→ {NULLS FIRST} {NULLS LAST}
lang_select.html#orderby
→ {ORDER BY} {order by}
lang_select.html#resultset
→ {GROUP BY} {GROUP BY clause} HAVING {HAVING clause} {result-set expressions}
lang_select.html#rjoin
→ {RIGHT JOIN} {RIGHT and FULL OUTER JOIN}
lang_select.html#simpleselect
→ {simple SELECT}
lang_select.html#tabfunc1
→ {table-valued functions in the FROM clause}
lang_select.html#values
→ VALUES {VALUES clause}
lang_select.html#whereclause
→ {WHERE clause}
lang_transaction.html
→ BEGIN COMMIT ROLLBACK transaction
lang_transaction.html#immediate
→ {BEGIN EXCLUSIVE} {BEGIN IMMEDIATE}
lang_update.html
→ UPDATE UPDATEs langupdate
lang_update.html#upfrom
→ {UPDATE FROM}
lang_upsert.html
→ UPSERT upsert {upsert clause}
lang_upsert.html#parseambig
→ {UPSERT parsing ambiguity}
lang_vacuum.html
→ VACUUM langvacuum vacuum
lang_vacuum.html#howvacuumworks
→ {how vacuum works}
lang_vacuum.html#vacuuminto
→ {VACUUM INTO}
lang_with.html
→ WITH {WITH clause} {common table expressions} with
lang_with.html#mandelbrot
→ {compute the Mandelbrot set}
lang_with.html#mathint
→ MATERIALIZED {NOT MATERIALIZED} {materialization hints}
lang_with.html#ordinarycte
→ {ordinary common table expressions}
lang_with.html#rcex3
→ {queries against graphs}
lang_with.html#recursivecte
→ {recursive common table expression} {recursive common table expressions} {recursive query}
lang_with.html#sudoku
→ {solve Sudoku puzzles}
lemon.html
→ Lemon {Lemon LALR parser generator} {Lemon parser generator}
limits.html
→ limits
limits.html#max_attached
→ SQLITE_MAX_ATTACHED
limits.html#max_column
→ SQLITE_MAX_COLUMN
limits.html#max_compound_select
→ SQLITE_MAX_COMPOUND_SELECT
limits.html#max_expr_depth
→ SQLITE_MAX_EXPR_DEPTH
limits.html#max_function_arg
→ SQLITE_MAX_FUNCTION_ARG
limits.html#max_length
→ SQLITE_MAX_LENGTH
limits.html#max_like_pattern_length
→ SQLITE_MAX_LIKE_PATTERN_LENGTH
limits.html#max_page_count
→ SQLITE_MAX_PAGE_COUNT
limits.html#max_sql_length
→ SQLITE_MAX_SQL_LENGTH
limits.html#max_trigger_depth
→ SQLITE_MAX_TRIGGER_DEPTH
limits.html#max_variable_number
→ SQLITE_MAX_VARIABLE_NUMBER
loadext.html
→ {Run-Time Loadable Extensions} {SQLite extension} {SQLite extensions} {extension loading} {loadable extension} {loadable extensions} loadext
loadext.html#build
→ {Compiling Loadable Extensions} {compile loadable extensions}
loadext.html#persist
→ {persistent loadable extensions}
loadext.html#statext
→ {statically linked extensions}
loadext.html#write
→ {Programming Loadable Extensions}
lockingv3.html
→ {file locking and concurrency control}
lockingv3.html#excl_lock
→ EXCLUSIVE {EXCLUSIVE lock} {exclusive lock}
lockingv3.html#ext3-barrier-problem
→ {the ext3 barrier problem}
lockingv3.html#how_to_corrupt
→ {How To Corrupt Your Database Files}
lockingv3.html#locking
→ {file locking states}
lockingv3.html#pending_lock
→ PENDING {PENDING lock} {pending lock}
lockingv3.html#reserved_lock
→ RESERVED {RESERVED lock} {reserved lock}
lockingv3.html#rollback
→ {rollback journal}
lockingv3.html#shared_lock
→ SHARED {SHARED lock} {shared lock}
lockingv3.html#writer_starvation
→ {writer starvation}
locrsf.html
→ {recommended by the US Library of Congress} {recommended storage format}
lts.html
→ {long term support}
malloc.html
→ {memory allocation}
malloc.html#altalloc
→ {built-in memory allocators}
malloc.html#defaultalloc
→ {default memory allocator}
malloc.html#lookaside
→ lookaside {lookaside buffer} {lookaside memory} {lookaside memory allocator}
malloc.html#memdebug
→ {debugging memory allocator} memsys2
malloc.html#memstatus
→ {memory statistics}
malloc.html#memsys5
→ memsys5 {zero-malloc memory allocator}
malloc.html#memsysx
→ {experimental memory allocators}
malloc.html#nofrag
→ {Robson proof}
malloc.html#pagecache
→ {pagecache memory allocator}
malloc.html#win32heap
→ {Win32 native memory allocator}
memstat.html
→ {SQLITE_MEMSTAT virtual table} sqlite_memstat {the SQLITE_MEMSTAT extension}
mmap.html
→ {memory-mapped I/O} mmap
mostdeployed.html
→ {most used} {most widely deployed} {most widely used}
np1queryprob.html
→ {about 200 SQL statements per webpage}
nulinstr.html
→ {NUL characters in strings}
opcode.html
→ VDBE bytecode {bytecode engine} bytecodes opcodes {virtual machine} {virtual machine instructions}
opcode.html#codes
→ {list of current bytecodes} {opcode definitions}
opcode.html#subprog
→ subprograms
optoverview.html
→ {SQLite query planner} optimizer {query planner}
optoverview.html#autoindex
→ {Automatic indexing} {automatic indexes} {automatic indexing}
optoverview.html#constprop
→ {constant-propagation optimization}
optoverview.html#coroutines
→ co-routines {subquery co-routines}
optoverview.html#crossjoin
→ {CROSS JOIN} {Manual Control Of Query Plans Using CROSS JOIN}
optoverview.html#flattening
→ flattened {flattening optimization} {query flattener}
optoverview.html#hashjoin
→ {hash join}
optoverview.html#leftjoinreduction
→ {LEFT JOIN strength reduction optimization} {OUTER JOIN strength reduction} {OUTER JOIN strength reduction optimization}
optoverview.html#like_opt
→ {LIKE optimization}
optoverview.html#manctrl
→ {Manual Control Of Query Plans Using SQLITE_STAT Tables}
optoverview.html#minmax
→ {min/max optimization}
optoverview.html#omitnoopjoin
→ {omit-left-join optimization} {omit-outer-join optimization}
optoverview.html#or_opt
→ {OR optimization} {or optimization}
optoverview.html#partsort
→ {sorting subsets of the result}
optoverview.html#pushdown
→ {push-down optimization}
optoverview.html#rangequery
→ {range query optimization}
optoverview.html#skipscan
→ skip-scan {skip-scan optimization}
optoverview.html#table_order
→ {join order}
optoverview.html#uplus
→ upluscontrol
partialindex.html
→ {partial index} {partial indexes} {partial indices}
pgszchng2016.html
→ {increase in the default page size} {version 3.12.0 page size change}
pragma.html#pragfunc
→ {PRAGMA function} {PRAGMA functions}
pragma.html#pragma_analysis_limit
→ {PRAGMA analysis_limit} analysis_limit {analysis_limit pragma}
pragma.html#pragma_application_id
→ {PRAGMA application_id} application_id {application_id pragma}
pragma.html#pragma_auto_vacuum
→ {PRAGMA auto_vacuum} auto_vacuum {auto_vacuum pragma}
pragma.html#pragma_automatic_index
→ {PRAGMA automatic_index} automatic_index {automatic_index pragma}
pragma.html#pragma_busy_timeout
→ {PRAGMA busy_timeout} busy_timeout {busy_timeout pragma}
pragma.html#pragma_cache_size
→ {PRAGMA cache_size} cache_size {cache_size pragma}
pragma.html#pragma_cache_spill
→ {PRAGMA cache_spill} cache_spill {cache_spill pragma}
pragma.html#pragma_case_sensitive_like
→ {PRAGMA case_sensitive_like} case_sensitive_like {case_sensitive_like pragma}
pragma.html#pragma_cell_size_check
→ {PRAGMA cell_size_check} cell_size_check {cell_size_check pragma}
pragma.html#pragma_checkpoint_fullfsync
→ {PRAGMA checkpoint_fullfsync} checkpoint_fullfsync {checkpoint_fullfsync pragma}
pragma.html#pragma_collation_list
→ {PRAGMA collation_list} collation_list {collation_list pragma}
pragma.html#pragma_compile_options
→ {PRAGMA compile_options} compile_options {compile_options pragma}
pragma.html#pragma_count_changes
→ {PRAGMA count_changes} count_changes {count_changes pragma}
pragma.html#pragma_data_store_directory
→ {PRAGMA data_store_directory} data_store_directory {data_store_directory pragma}
pragma.html#pragma_data_version
→ {PRAGMA data_version} data_version {data_version pragma}
pragma.html#pragma_database_list
→ {PRAGMA database_list} database_list {database_list pragma}
pragma.html#pragma_default_cache_size
→ {PRAGMA default_cache_size} default_cache_size {default_cache_size pragma}
pragma.html#pragma_defer_foreign_keys
→ {PRAGMA defer_foreign_keys} defer_foreign_keys {defer_foreign_keys pragma}
pragma.html#pragma_empty_result_callbacks
→ {PRAGMA empty_result_callbacks} empty_result_callbacks {empty_result_callbacks pragma}
pragma.html#pragma_encoding
→ {PRAGMA encoding} encoding {encoding pragma}
pragma.html#pragma_foreign_key_check
→ {PRAGMA foreign_key_check} foreign_key_check {foreign_key_check pragma}
pragma.html#pragma_foreign_key_list
→ {PRAGMA foreign_key_list} foreign_key_list {foreign_key_list pragma}
pragma.html#pragma_foreign_keys
→ {PRAGMA foreign_keys} foreign_keys {foreign_keys pragma}
pragma.html#pragma_freelist_count
→ {PRAGMA freelist_count} freelist_count {freelist_count pragma}
pragma.html#pragma_full_column_names
→ {PRAGMA full_column_names} full_column_names {full_column_names pragma}
pragma.html#pragma_fullfsync
→ {PRAGMA fullfsync} fullfsync {fullfsync pragma}
pragma.html#pragma_function_list
→ {PRAGMA function_list} function_list {function_list pragma}
pragma.html#pragma_hard_heap_limit
→ {PRAGMA hard_heap_limit} hard_heap_limit {hard_heap_limit pragma}
pragma.html#pragma_ignore_check_constraints
→ {PRAGMA ignore_check_constraints} ignore_check_constraints {ignore_check_constraints pragma}
pragma.html#pragma_incremental_vacuum
→ {PRAGMA incremental_vacuum} incremental_vacuum {incremental_vacuum pragma}
pragma.html#pragma_index_info
→ {PRAGMA index_info} index_info {index_info pragma}
pragma.html#pragma_index_list
→ {PRAGMA index_list} index_list {index_list pragma}
pragma.html#pragma_index_xinfo
→ {PRAGMA index_xinfo} index_xinfo {index_xinfo pragma}
pragma.html#pragma_integrity_check
→ {PRAGMA integrity_check} integrity_check {integrity_check pragma}
pragma.html#pragma_journal_mode
→ {PRAGMA journal_mode} journal_mode {journal_mode pragma} {persistent journal mode}
pragma.html#pragma_journal_size_limit
→ {PRAGMA journal_size_limit} journal_size_limit {journal_size_limit pragma}
pragma.html#pragma_legacy_alter_table
→ {PRAGMA legacy_alter_table} legacy_alter_table {legacy_alter_table pragma}
pragma.html#pragma_legacy_file_format
→ {PRAGMA legacy_file_format} legacy_file_format {legacy_file_format pragma}
pragma.html#pragma_locking_mode
→ {EXCLUSIVE locking mode} {PRAGMA locking_mode} {exclusive locking mode} locking_mode {locking_mode pragma}
pragma.html#pragma_max_page_count
→ {PRAGMA max_page_count} max_page_count {max_page_count pragma}
pragma.html#pragma_mmap_size
→ {PRAGMA mmap_size} mmap_size {mmap_size pragma}
pragma.html#pragma_module_list
→ {PRAGMA module_list} module_list {module_list pragma}
pragma.html#pragma_optimize
→ {PRAGMA optimize} optimize {optimize pragma}
pragma.html#pragma_page_count
→ {PRAGMA page_count} page_count {page_count pragma}
pragma.html#pragma_page_size
→ {PRAGMA page_size} page_size {page_size pragma}
pragma.html#pragma_parser_trace
→ {PRAGMA parser_trace} parser_trace {parser_trace pragma}
pragma.html#pragma_pragma_list
→ {PRAGMA pragma_list} pragma_list {pragma_list pragma}
pragma.html#pragma_query_only
→ {PRAGMA query_only} query_only {query_only pragma}
pragma.html#pragma_quick_check
→ {PRAGMA quick_check} quick_check {quick_check pragma}
pragma.html#pragma_read_uncommitted
→ {PRAGMA read_uncommitted} read_uncommitted {read_uncommitted pragma}
pragma.html#pragma_recursive_triggers
→ {PRAGMA recursive_triggers} recursive_triggers {recursive_triggers pragma}
pragma.html#pragma_reverse_unordered_selects
→ {PRAGMA reverse_unordered_selects} reverse_unordered_selects {reverse_unordered_selects pragma}
pragma.html#pragma_schema_version
→ {PRAGMA schema_version} schema_version {schema_version pragma}
pragma.html#pragma_secure_delete
→ {PRAGMA secure_delete} secure_delete {secure_delete pragma}
pragma.html#pragma_short_column_names
→ {PRAGMA short_column_names} short_column_names {short_column_names pragma}
pragma.html#pragma_shrink_memory
→ {PRAGMA shrink_memory} shrink_memory {shrink_memory pragma}
pragma.html#pragma_soft_heap_limit
→ {PRAGMA soft_heap_limit} soft_heap_limit {soft_heap_limit pragma}
pragma.html#pragma_stats
→ {PRAGMA stats} stats {stats pragma}
pragma.html#pragma_synchronous
→ {PRAGMA synchronous} synchronous {synchronous pragma}
pragma.html#pragma_table_info
→ {PRAGMA table_info} table_info {table_info pragma}
pragma.html#pragma_table_list
→ {PRAGMA table_list} table_list {table_list pragma}
pragma.html#pragma_table_xinfo
→ {PRAGMA table_xinfo} table_xinfo {table_xinfo pragma}
pragma.html#pragma_temp_store
→ {PRAGMA temp_store} temp_store {temp_store pragma}
pragma.html#pragma_temp_store_directory
→ {PRAGMA temp_store_directory} temp_store_directory {temp_store_directory pragma}
pragma.html#pragma_threads
→ {PRAGMA threads} threads {threads pragma}
pragma.html#pragma_trusted_schema
→ {PRAGMA trusted_schema} trusted_schema {trusted_schema pragma}
pragma.html#pragma_user_version
→ {PRAGMA user_version} user_version {user_version pragma}
pragma.html#pragma_vdbe_addoptrace
→ {PRAGMA vdbe_addoptrace} vdbe_addoptrace {vdbe_addoptrace pragma}
pragma.html#pragma_vdbe_debug
→ {PRAGMA vdbe_debug} vdbe_debug {vdbe_debug pragma}
pragma.html#pragma_vdbe_listing
→ {PRAGMA vdbe_listing} vdbe_listing {vdbe_listing pragma}
pragma.html#pragma_vdbe_trace
→ {PRAGMA vdbe_trace} vdbe_trace {vdbe_trace pragma}
pragma.html#pragma_wal_autocheckpoint
→ {PRAGMA wal_autocheckpoint} wal_autocheckpoint {wal_autocheckpoint pragma}
pragma.html#pragma_wal_checkpoint
→ {PRAGMA wal_checkpoint} wal_checkpoint {wal_checkpoint pragma}
pragma.html#pragma_writable_schema
→ {PRAGMA writable_schema} writable_schema {writable_schema pragma}
pragma.html#syntax
→ PRAGMA
pragma.html#toc
→ {pragma list}
printf.html
→ {built-in printf}
printf.html#comma
→ {comma option}
printf.html#percentq
→ Q q
printf.html#percentw
→ w
printf.html#percentz
→ z
privatebranch.html
→ {private branches}
prosupport.html
→ {professional support}
psow.html
→ PSOW {powersafe overwrite}
psow.html#tornpage
→ {torn page}
queryplanner-ng.html
→ NGQP {Next Generation Query Planner} {next generation query planner}
queryplanner-ng.html#fossilcasestudy
→ {The Fossil NGQP Upgrade Case Study}
queryplanner-ng.html#hazards
→ {hazards of upgrading to the NGQP}
queryplanner-ng.html#howtofix
→ {query planner checklist}
queryplanner-ng.html#qpstab
→ QPSG {query planner stability guarantee}
queryplanner.html
→ indexing {indexing tutorial}
queryplanner.html#covidx
→ {covering index} {covering indexes} {covering indices}
queryplanner.html#or_in_where
→ or-connected-terms
queryplanner.html#partialsort
→ {block sorting} {partial sorting by index}
queryplanner.html#searching
→ strategies
queryplanner.html#sorting
→ sorting
quickstart.html
→ {Quick Start Guide} quickstart
quirks.html
→ Quirks
quirks.html#dblquote
→ {double-quoted string literal} {double-quoted string misfeature}
rbu.html
→ RBU {RBU extension}
rbu.html#database_contents
→ {RBU Database Contents}
rbu.html#database_tables
→ {RBU Database Tables}
rbu.html#fts4_tables
→ {RBU FTS3/4 Tables}
rbu.html#rbu_updates
→ {RBU Update}
rbu.html#rbu_vacuum
→ {RBU Vacuum}
rbu.html#sqldiff
→ {sqldiff --rbu}
recovery.html
→ {recovery extension}
releaselog/3_0_0.html
→ {Version 3.0.0} {version 3.0.0}
releaselog/3_0_1.html
→ {Version 3.0.1} {version 3.0.1}
releaselog/3_0_2.html
→ {Version 3.0.2} {version 3.0.2}
releaselog/3_0_3.html
→ {Version 3.0.3} {version 3.0.3}
releaselog/3_0_4.html
→ {Version 3.0.4} {version 3.0.4}
releaselog/3_0_5.html
→ {Version 3.0.5} {version 3.0.5}
releaselog/3_0_6.html
→ {Version 3.0.6} {version 3.0.6}
releaselog/3_0_7.html
→ {Version 3.0.7} {version 3.0.7}
releaselog/3_0_8.html
→ {Version 3.0.8} {version 3.0.8}
releaselog/3_10_0.html
→ {Version 3.10.0} {version 3.10.0}
releaselog/3_10_1.html
→ {Version 3.10.1} {version 3.10.1}
releaselog/3_10_2.html
→ {Version 3.10.2} {version 3.10.2}
releaselog/3_11_0.html
→ {Version 3.11.0} {version 3.11.0}
releaselog/3_11_1.html
→ {Version 3.11.1} {version 3.11.1}
releaselog/3_12_0.html
→ {Version 3.12.0} {version 3.12.0}
releaselog/3_12_1.html
→ {Version 3.12.1} {version 3.12.1}
releaselog/3_12_2.html
→ {Version 3.12.2} {version 3.12.2}
releaselog/3_13_0.html
→ {Version 3.13.0} {Version 3.13.0.0} {version 3.13.0} {version 3.13.0.0}
releaselog/3_14.html
→ {Version 3.14} {Version 3.14.0} {version 3.14} {version 3.14.0}
releaselog/3_14_1.html
→ {Version 3.14.1} {version 3.14.1}
releaselog/3_14_2.html
→ {Version 3.14.2} {version 3.14.2}
releaselog/3_15_0.html
→ {Version 3.15.0} {version 3.15.0}
releaselog/3_15_1.html
→ {Version 3.15.1} {version 3.15.1}
releaselog/3_15_2.html
→ {Version 3.15.2} {version 3.15.2}
releaselog/3_16_0.html
→ {Version 3.16.0} {version 3.16.0}
releaselog/3_16_1.html
→ {Version 3.16.1} {version 3.16.1}
releaselog/3_16_2.html
→ {Version 3.16.2} {version 3.16.2}
releaselog/3_17_0.html
→ {Version 3.17.0} {version 3.17.0}
releaselog/3_18_0.html
→ {Version 3.18.0} {version 3.18.0}
releaselog/3_18_1.html
→ {Version 3.18.1} {version 3.18.1}
releaselog/3_18_2.html
→ {Version 3.18.2} {version 3.18.2}
releaselog/3_19_0.html
→ {Version 3.19.0} {version 3.19.0}
releaselog/3_19_1.html
→ {Version 3.19.1} {version 3.19.1}
releaselog/3_19_2.html
→ {Version 3.19.2} {version 3.19.2}
releaselog/3_19_3.html
→ {Version 3.19.3} {version 3.19.3}
releaselog/3_1_0.html
→ {Version 3.1.0} {version 3.1.0}
releaselog/3_1_1.html
→ {Version 3.1.1} {version 3.1.1}
releaselog/3_1_2.html
→ {Version 3.1.2} {version 3.1.2}
releaselog/3_1_3.html
→ {Version 3.1.3} {version 3.1.3}
releaselog/3_1_4.html
→ {Version 3.1.4} {version 3.1.4}
releaselog/3_1_5.html
→ {Version 3.1.5} {version 3.1.5}
releaselog/3_1_6.html
→ {Version 3.1.6} {version 3.1.6}
releaselog/3_20_0.html
→ {Version 3.20.0} {version 3.20.0}
releaselog/3_20_1.html
→ {Version 3.20.1} {version 3.20.1}
releaselog/3_21_0.html
→ {Version 3.21.0} {version 3.21.0}
releaselog/3_22_0.html
→ {Version 3.22.0} {version 3.22.0}
releaselog/3_23_0.html
→ {Version 3.23.0} {Version 3.23.0.0} {version 3.23.0} {version 3.23.0.0}
releaselog/3_23_1.html
→ {Version 3.23.1} {Version 3.23.1.0} {version 3.23.1} {version 3.23.1.0}
releaselog/3_24_0.html
→ {Version 3.24.0} {version 3.24.0}
releaselog/3_25_0.html
→ {Version 3.25.0} {version 3.25.0}
releaselog/3_25_1.html
→ {Version 3.25.1} {version 3.25.1}
releaselog/3_25_2.html
→ {Version 3.25.2} {version 3.25.2}
releaselog/3_25_3.html
→ {Version 3.25.3} {version 3.25.3}
releaselog/3_26_0.html
→ {Version 3.26.0} {version 3.26.0}
releaselog/3_27_0.html
→ {Version 3.27.0} {version 3.27.0}
releaselog/3_27_1.html
→ {Version 3.27.1} {version 3.27.1}
releaselog/3_27_2.html
→ {Version 3.27.2} {version 3.27.2}
releaselog/3_28_0.html
→ {Version 3.28.0} {version 3.28.0}
releaselog/3_29_0.html
→ {Version 3.29.0} {version 3.29.0}
releaselog/3_2_0.html
→ {Version 3.2.0} {version 3.2.0}
releaselog/3_2_1.html
→ {Version 3.2.1} {version 3.2.1}
releaselog/3_2_2.html
→ {Version 3.2.2} {version 3.2.2}
releaselog/3_2_3.html
→ {Version 3.2.3} {version 3.2.3}
releaselog/3_2_4.html
→ {Version 3.2.4} {version 3.2.4}
releaselog/3_2_5.html
→ {Version 3.2.5} {version 3.2.5}
releaselog/3_2_6.html
→ {Version 3.2.6} {version 3.2.6}
releaselog/3_2_7.html
→ {Version 3.2.7} {version 3.2.7}
releaselog/3_2_8.html
→ {Version 3.2.8} {version 3.2.8}
releaselog/3_30_0.html
→ {Version 3.30.0} {version 3.30.0}
releaselog/3_30_1.html
→ {Version 3.30.1} {version 3.30.1}
releaselog/3_31_0.html
→ {Version 3.31.0} {version 3.31.0}
releaselog/3_31_1.html
→ {Version 3.31.1} {version 3.31.1}
releaselog/3_32_0.html
→ {Version 3.32.0} {version 3.32.0}
releaselog/3_32_1.html
→ {Version 3.32.1} {version 3.32.1}
releaselog/3_32_2.html
→ {Version 3.32.2} {version 3.32.2}
releaselog/3_32_3.html
→ {Version 3.32.3} {version 3.32.3}
releaselog/3_33_0.html
→ {Version 3.33.0} {Version 3.33.0.0} {version 3.33.0} {version 3.33.0.0}
releaselog/3_34_0.html
→ {Version 3.34.0} {version 3.34.0}
releaselog/3_34_1.html
→ {Version 3.34.1} {version 3.34.1}
releaselog/3_35_0.html
→ {Version 3.35.0} {version 3.35.0}
releaselog/3_35_1.html
→ {Version 3.35.1} {version 3.35.1}
releaselog/3_35_2.html
→ {Version 3.35.2} {version 3.35.2}
releaselog/3_35_3.html
→ {Version 3.35.3} {version 3.35.3}
releaselog/3_35_4.html
→ {Version 3.35.4} {version 3.35.4}
releaselog/3_35_5.html
→ {Version 3.35.5} {version 3.35.5}
releaselog/3_36_0.html
→ {Version 3.36.0} {version 3.36.0}
releaselog/3_37_0.html
→ {Version 3.37.0} {version 3.37.0}
releaselog/3_37_1.html
→ {Version 3.37.1} {version 3.37.1}
releaselog/3_37_2.html
→ {Version 3.37.2} {version 3.37.2}
releaselog/3_38_0.html
→ {Version 3.38.0} {version 3.38.0}
releaselog/3_38_1.html
→ {Version 3.38.1} {version 3.38.1}
releaselog/3_38_2.html
→ {Version 3.38.2} {version 3.38.2}
releaselog/3_38_3.html
→ {Version 3.38.3} {version 3.38.3}
releaselog/3_38_4.html
→ {Version 3.38.4} {version 3.38.4}
releaselog/3_38_5.html
→ {Version 3.38.5} {version 3.38.5}
releaselog/3_39_0.html
→ {Version 3.39.0} {version 3.39.0}
releaselog/3_39_1.html
→ {Version 3.39.1} {version 3.39.1}
releaselog/3_39_2.html
→ {Version 3.39.2} {version 3.39.2}
releaselog/3_39_3.html
→ {Version 3.39.3} {version 3.39.3}
releaselog/3_39_4.html
→ {Version 3.39.4} {version 3.39.4}
releaselog/3_3_0.html
→ {Version 3.3.0} {Version 3.3.0.0} {version 3.3.0} {version 3.3.0.0}
releaselog/3_3_1.html
→ {Version 3.3.1} {Version 3.3.1.0} {version 3.3.1} {version 3.3.1.0}
releaselog/3_3_10.html
→ {Version 3.3.10} {Version 3.3.10.0} {version 3.3.10} {version 3.3.10.0}
releaselog/3_3_11.html
→ {Version 3.3.11} {Version 3.3.11.0} {version 3.3.11} {version 3.3.11.0}
releaselog/3_3_12.html
→ {Version 3.3.12} {Version 3.3.12.0} {version 3.3.12} {version 3.3.12.0}
releaselog/3_3_13.html
→ {Version 3.3.13} {Version 3.3.13.0} {version 3.3.13} {version 3.3.13.0}
releaselog/3_3_14.html
→ {Version 3.3.14} {Version 3.3.14.0} {version 3.3.14} {version 3.3.14.0}
releaselog/3_3_15.html
→ {Version 3.3.15} {Version 3.3.15.0} {version 3.3.15} {version 3.3.15.0}
releaselog/3_3_16.html
→ {Version 3.3.16} {Version 3.3.16.0} {version 3.3.16} {version 3.3.16.0}
releaselog/3_3_17.html
→ {Version 3.3.17} {Version 3.3.17.0} {version 3.3.17} {version 3.3.17.0}
releaselog/3_3_2.html
→ {Version 3.3.2} {Version 3.3.2.0} {version 3.3.2} {version 3.3.2.0}
releaselog/3_3_3.html
→ {Version 3.3.3} {Version 3.3.3.0} {version 3.3.3} {version 3.3.3.0}
releaselog/3_3_4.html
→ {Version 3.3.4} {Version 3.3.4.0} {version 3.3.4} {version 3.3.4.0}
releaselog/3_3_5.html
→ {Version 3.3.5} {Version 3.3.5.0} {version 3.3.5} {version 3.3.5.0}
releaselog/3_3_6.html
→ {Version 3.3.6} {Version 3.3.6.0} {version 3.3.6} {version 3.3.6.0}
releaselog/3_3_7.html
→ {Version 3.3.7} {Version 3.3.7.0} {version 3.3.7} {version 3.3.7.0}
releaselog/3_3_8.html
→ {Version 3.3.8} {Version 3.3.8.0} {version 3.3.8} {version 3.3.8.0}
releaselog/3_3_9.html
→ {Version 3.3.9} {Version 3.3.9.0} {version 3.3.9} {version 3.3.9.0}
releaselog/3_40_0.html
→ {Version 3.40.0} {version 3.40.0}
releaselog/3_40_1.html
→ {Version 3.40.1} {version 3.40.1}
releaselog/3_41_0.html
→ {Version 3.41.0} {version 3.41.0}
releaselog/3_41_1.html
→ {Version 3.41.1} {version 3.41.1}
releaselog/3_41_2.html
→ {Version 3.41.2} {version 3.41.2}
releaselog/3_42_0.html
→ {Version 3.42.0} {version 3.42.0}
releaselog/3_43_0.html
→ {Version 3.43.0} {Version 3.43.0.0} {version 3.43.0} {version 3.43.0.0}
releaselog/3_43_1.html
→ {Version 3.43.1} {Version 3.43.1.0} {version 3.43.1} {version 3.43.1.0}
releaselog/3_43_2.html
→ {Version 3.43.2} {Version 3.43.2.0} {version 3.43.2} {version 3.43.2.0}
releaselog/3_44_0.html
→ {Version 3.44.0} {version 3.44.0}
releaselog/3_44_1.html
→ {Version 3.44.1} {version 3.44.1}
releaselog/3_44_2.html
→ {Version 3.44.2} {version 3.44.2}
releaselog/3_45_0.html
→ {Version 3.45.0} {version 3.45.0}
releaselog/3_45_1.html
→ {Version 3.45.1} {version 3.45.1}
releaselog/3_4_0.html
→ {Version 3.4.0} {version 3.4.0}
releaselog/3_4_1.html
→ {Version 3.4.1} {version 3.4.1}
releaselog/3_4_2.html
→ {Version 3.4.2} {version 3.4.2}
releaselog/3_5_0.html
→ {Version 3.5.0} {version 3.5.0}
releaselog/3_5_1.html
→ {Version 3.5.1} {version 3.5.1}
releaselog/3_5_2.html
→ {Version 3.5.2} {version 3.5.2}
releaselog/3_5_3.html
→ {Version 3.5.3} {version 3.5.3}
releaselog/3_5_4.html
→ {Version 3.5.4} {version 3.5.4}
releaselog/3_5_5.html
→ {Version 3.5.5} {version 3.5.5}
releaselog/3_5_6.html
→ {Version 3.5.6} {version 3.5.6}
releaselog/3_5_7.html
→ {Version 3.5.7} {version 3.5.7}
releaselog/3_5_8.html
→ {Version 3.5.8} {version 3.5.8}
releaselog/3_5_9.html
→ {Version 3.5.9} {version 3.5.9}
releaselog/3_6_0.html
→ {Version 3.6.0} {version 3.6.0}
releaselog/3_6_1.html
→ {Version 3.6.1} {version 3.6.1}
releaselog/3_6_10.html
→ {Version 3.6.10} {version 3.6.10}
releaselog/3_6_11.html
→ {Version 3.6.11} {version 3.6.11}
releaselog/3_6_12.html
→ {Version 3.6.12} {version 3.6.12}
releaselog/3_6_13.html
→ {Version 3.6.13} {version 3.6.13}
releaselog/3_6_14.html
→ {Version 3.6.14} {version 3.6.14}
releaselog/3_6_14_1.html
→ {Version 3.6.14.1} {version 3.6.14.1}
releaselog/3_6_14_2.html
→ {Version 3.6.14.2} {version 3.6.14.2}
releaselog/3_6_15.html
→ {Version 3.6.15} {version 3.6.15}
releaselog/3_6_16.html
→ {Version 3.6.16} {version 3.6.16}
releaselog/3_6_16_1.html
→ {Version 3.6.16.1} {version 3.6.16.1}
releaselog/3_6_17.html
→ {Version 3.6.17} {version 3.6.17}
releaselog/3_6_18.html
→ {Version 3.6.18} {version 3.6.18}
releaselog/3_6_19.html
→ {Version 3.6.19} {version 3.6.19}
releaselog/3_6_2.html
→ {Version 3.6.2} {version 3.6.2}
releaselog/3_6_20.html
→ {Version 3.6.20} {version 3.6.20}
releaselog/3_6_21.html
→ {Version 3.6.21} {version 3.6.21}
releaselog/3_6_22.html
→ {Version 3.6.22} {version 3.6.22}
releaselog/3_6_23.html
→ {Version 3.6.23} {version 3.6.23}
releaselog/3_6_23_1.html
→ {Version 3.6.23.1} {Version 3.6.23.1.0} {version 3.6.23.1} {version 3.6.23.1.0}
releaselog/3_6_3.html
→ {Version 3.6.3} {version 3.6.3}
releaselog/3_6_4.html
→ {Version 3.6.4} {version 3.6.4}
releaselog/3_6_5.html
→ {Version 3.6.5} {version 3.6.5}
releaselog/3_6_6.html
→ {Version 3.6.6} {version 3.6.6}
releaselog/3_6_6_1.html
→ {Version 3.6.6.1} {version 3.6.6.1}
releaselog/3_6_6_2.html
→ {Version 3.6.6.2} {version 3.6.6.2}
releaselog/3_6_7.html
→ {Version 3.6.7} {version 3.6.7}
releaselog/3_6_8.html
→ {Version 3.6.8} {version 3.6.8}
releaselog/3_6_9.html
→ {Version 3.6.9} {version 3.6.9}
releaselog/3_7_0.html
→ {Version 3.7.0} {version 3.7.0}
releaselog/3_7_0_1.html
→ {Version 3.7.0.1} {version 3.7.0.1}
releaselog/3_7_1.html
→ {Version 3.7.1} {version 3.7.1}
releaselog/3_7_10.html
→ {Version 3.7.10} {version 3.7.10}
releaselog/3_7_11.html
→ {Version 3.7.11} {version 3.7.11}
releaselog/3_7_12.html
→ {Version 3.7.12} {version 3.7.12}
releaselog/3_7_12_1.html
→ {Version 3.7.12.1} {version 3.7.12.1}
releaselog/3_7_13.html
→ {Version 3.7.13} {version 3.7.13}
releaselog/3_7_14.html
→ {Version 3.7.14} {version 3.7.14}
releaselog/3_7_14_1.html
→ {Version 3.7.14.1} {version 3.7.14.1}
releaselog/3_7_15.html
→ {Version 3.7.15} {version 3.7.15}
releaselog/3_7_15_1.html
→ {Version 3.7.15.1} {version 3.7.15.1}
releaselog/3_7_15_2.html
→ {Version 3.7.15.2} {version 3.7.15.2}
releaselog/3_7_16.html
→ {Version 3.7.16} {version 3.7.16}
releaselog/3_7_16_1.html
→ {Version 3.7.16.1} {version 3.7.16.1}
releaselog/3_7_16_2.html
→ {Version 3.7.16.2} {version 3.7.16.2}
releaselog/3_7_17.html
→ {Version 3.7.17} {version 3.7.17}
releaselog/3_7_2.html
→ {Version 3.7.2} {version 3.7.2}
releaselog/3_7_3.html
→ {Version 3.7.3} {version 3.7.3}
releaselog/3_7_4.html
→ {Version 3.7.4} {version 3.7.4}
releaselog/3_7_5.html
→ {Version 3.7.5} {version 3.7.5}
releaselog/3_7_6.html
→ {Version 3.7.6} {version 3.7.6}
releaselog/3_7_6_1.html
→ {Version 3.7.6.1} {version 3.7.6.1}
releaselog/3_7_6_2.html
→ {Version 3.7.6.2} {version 3.7.6.2}
releaselog/3_7_6_3.html
→ {Version 3.7.6.3} {version 3.7.6.3}
releaselog/3_7_7.html
→ {Version 3.7.7} {version 3.7.7}
releaselog/3_7_7_1.html
→ {Version 3.7.7.1} {version 3.7.7.1}
releaselog/3_7_8.html
→ {Version 3.7.8} {version 3.7.8}
releaselog/3_7_9.html
→ {Version 3.7.9} {version 3.7.9}
releaselog/3_8_0.html
→ {Version 3.8.0} {version 3.8.0}
releaselog/3_8_0_1.html
→ {Version 3.8.0.1} {version 3.8.0.1}
releaselog/3_8_0_2.html
→ {Version 3.8.0.2} {version 3.8.0.2}
releaselog/3_8_1.html
→ {Version 3.8.1} {version 3.8.1}
releaselog/3_8_10.html
→ {Version 3.8.10} {version 3.8.10}
releaselog/3_8_10_1.html
→ {Version 3.8.10.1} {version 3.8.10.1}
releaselog/3_8_10_2.html
→ {Version 3.8.10.2} {version 3.8.10.2}
releaselog/3_8_11.html
→ {Version 3.8.11} {version 3.8.11}
releaselog/3_8_11_1.html
→ {Version 3.8.11.1} {version 3.8.11.1}
releaselog/3_8_2.html
→ {Version 3.8.2} {version 3.8.2}
releaselog/3_8_3.html
→ {Version 3.8.3} {version 3.8.3}
releaselog/3_8_3_1.html
→ {Version 3.8.3.1} {Version 3.8.3.1.0} {version 3.8.3.1} {version 3.8.3.1.0}
releaselog/3_8_4.html
→ {Version 3.8.4} {version 3.8.4}
releaselog/3_8_4_1.html
→ {Version 3.8.4.1} {version 3.8.4.1}
releaselog/3_8_4_2.html
→ {Version 3.8.4.2} {version 3.8.4.2}
releaselog/3_8_4_3.html
→ {Version 3.8.4.3} {version 3.8.4.3}
releaselog/3_8_5.html
→ {Version 3.8.5} {version 3.8.5}
releaselog/3_8_6.html
→ {Version 3.8.6} {version 3.8.6}
releaselog/3_8_7.html
→ {Version 3.8.7} {version 3.8.7}
releaselog/3_8_7_1.html
→ {Version 3.8.7.1} {version 3.8.7.1}
releaselog/3_8_7_2.html
→ {Version 3.8.7.2} {version 3.8.7.2}
releaselog/3_8_7_3.html
→ {Version 3.8.7.3} {version 3.8.7.3}
releaselog/3_8_7_4.html
→ {Version 3.8.7.4} {version 3.8.7.4}
releaselog/3_8_8.html
→ {Version 3.8.8} {version 3.8.8}
releaselog/3_8_8_1.html
→ {Version 3.8.8.1} {version 3.8.8.1}
releaselog/3_8_8_2.html
→ {Version 3.8.8.2} {version 3.8.8.2}
releaselog/3_8_8_3.html
→ {Version 3.8.8.3} {version 3.8.8.3}
releaselog/3_8_9.html
→ {Version 3.8.9} {version 3.8.9}
releaselog/3_9_0.html
→ {Version 3.9.0} {version 3.9.0}
releaselog/3_9_1.html
→ {Version 3.9.1} {version 3.9.1}
releaselog/3_9_2.html
→ {Version 3.9.2} {version 3.9.2}
releaselog/3_9_3.html
→ {Version 3.9.3} {version 3.9.3}
requirements.html
→ requirements
rescode.html
→ {error code} {error codes} {result code} {result codes}
rescode.html#abort
→ SQLITE_ABORT
rescode.html#abort_rollback
→ SQLITE_ABORT_ROLLBACK
rescode.html#auth
→ SQLITE_AUTH
rescode.html#auth_user
→ SQLITE_AUTH_USER
rescode.html#busy
→ SQLITE_BUSY
rescode.html#busy_recovery
→ SQLITE_BUSY_RECOVERY
rescode.html#busy_snapshot
→ SQLITE_BUSY_SNAPSHOT
rescode.html#busy_timeout
→ SQLITE_BUSY_TIMEOUT
rescode.html#cantopen
→ SQLITE_CANTOPEN
rescode.html#cantopen_convpath
→ SQLITE_CANTOPEN_CONVPATH
rescode.html#cantopen_dirtywal
→ SQLITE_CANTOPEN_DIRTYWAL
rescode.html#cantopen_fullpath
→ SQLITE_CANTOPEN_FULLPATH
rescode.html#cantopen_isdir
→ SQLITE_CANTOPEN_ISDIR
rescode.html#cantopen_notempdir
→ SQLITE_CANTOPEN_NOTEMPDIR
rescode.html#cantopen_symlink
→ SQLITE_CANTOPEN_SYMLINK
rescode.html#constraint
→ SQLITE_CONSTRAINT
rescode.html#constraint_check
→ SQLITE_CONSTRAINT_CHECK
rescode.html#constraint_commithook
→ SQLITE_CONSTRAINT_COMMITHOOK
rescode.html#constraint_datatype
→ SQLITE_CONSTRAINT_DATATYPE
rescode.html#constraint_foreignkey
→ SQLITE_CONSTRAINT_FOREIGNKEY
rescode.html#constraint_function
→ SQLITE_CONSTRAINT_FUNCTION
rescode.html#constraint_notnull
→ SQLITE_CONSTRAINT_NOTNULL
rescode.html#constraint_pinned
→ SQLITE_CONSTRAINT_PINNED
rescode.html#constraint_primarykey
→ SQLITE_CONSTRAINT_PRIMARYKEY
rescode.html#constraint_rowid
→ SQLITE_CONSTRAINT_ROWID
rescode.html#constraint_trigger
→ SQLITE_CONSTRAINT_TRIGGER
rescode.html#constraint_unique
→ SQLITE_CONSTRAINT_UNIQUE
rescode.html#constraint_vtab
→ SQLITE_CONSTRAINT_VTAB
rescode.html#corrupt
→ SQLITE_CORRUPT
rescode.html#corrupt_index
→ SQLITE_CORRUPT_INDEX
rescode.html#corrupt_sequence
→ SQLITE_CORRUPT_SEQUENCE
rescode.html#corrupt_vtab
→ SQLITE_CORRUPT_VTAB
rescode.html#done
→ SQLITE_DONE
rescode.html#empty
→ SQLITE_EMPTY
rescode.html#error
→ SQLITE_ERROR
rescode.html#error_missing_collseq
→ SQLITE_ERROR_MISSING_COLLSEQ
rescode.html#error_retry
→ SQLITE_ERROR_RETRY
rescode.html#error_snapshot
→ SQLITE_ERROR_SNAPSHOT
rescode.html#extrc
→ {extended error code} {extended error codes} {extended result code} {extended result codes}
rescode.html#format
→ SQLITE_FORMAT
rescode.html#full
→ SQLITE_FULL
rescode.html#internal
→ SQLITE_INTERNAL
rescode.html#interrupt
→ SQLITE_INTERRUPT
rescode.html#ioerr
→ SQLITE_IOERR
rescode.html#ioerr_access
→ SQLITE_IOERR_ACCESS
rescode.html#ioerr_auth
→ SQLITE_IOERR_AUTH
rescode.html#ioerr_begin_atomic
→ SQLITE_IOERR_BEGIN_ATOMIC
rescode.html#ioerr_blocked
→ SQLITE_IOERR_BLOCKED
rescode.html#ioerr_checkreservedlock
→ SQLITE_IOERR_CHECKRESERVEDLOCK
rescode.html#ioerr_close
→ SQLITE_IOERR_CLOSE
rescode.html#ioerr_commit_atomic
→ SQLITE_IOERR_COMMIT_ATOMIC
rescode.html#ioerr_convpath
→ SQLITE_IOERR_CONVPATH
rescode.html#ioerr_corruptfs
→ SQLITE_IOERR_CORRUPTFS
rescode.html#ioerr_data
→ SQLITE_IOERR_DATA
rescode.html#ioerr_delete
→ SQLITE_IOERR_DELETE
rescode.html#ioerr_delete_noent
→ SQLITE_IOERR_DELETE_NOENT
rescode.html#ioerr_dir_close
→ SQLITE_IOERR_DIR_CLOSE
rescode.html#ioerr_dir_fsync
→ SQLITE_IOERR_DIR_FSYNC
rescode.html#ioerr_fstat
→ SQLITE_IOERR_FSTAT
rescode.html#ioerr_fsync
→ SQLITE_IOERR_FSYNC
rescode.html#ioerr_gettemppath
→ SQLITE_IOERR_GETTEMPPATH
rescode.html#ioerr_lock
→ SQLITE_IOERR_LOCK
rescode.html#ioerr_mmap
→ SQLITE_IOERR_MMAP
rescode.html#ioerr_nomem
→ SQLITE_IOERR_NOMEM
rescode.html#ioerr_rdlock
→ SQLITE_IOERR_RDLOCK
rescode.html#ioerr_read
→ SQLITE_IOERR_READ
rescode.html#ioerr_rollback_atomic
→ SQLITE_IOERR_ROLLBACK_ATOMIC
rescode.html#ioerr_seek
→ SQLITE_IOERR_SEEK
rescode.html#ioerr_shmlock
→ SQLITE_IOERR_SHMLOCK
rescode.html#ioerr_shmmap
→ SQLITE_IOERR_SHMMAP
rescode.html#ioerr_shmopen
→ SQLITE_IOERR_SHMOPEN
rescode.html#ioerr_shmsize
→ SQLITE_IOERR_SHMSIZE
rescode.html#ioerr_short_read
→ SQLITE_IOERR_SHORT_READ
rescode.html#ioerr_truncate
→ SQLITE_IOERR_TRUNCATE
rescode.html#ioerr_unlock
→ SQLITE_IOERR_UNLOCK
rescode.html#ioerr_vnode
→ SQLITE_IOERR_VNODE
rescode.html#ioerr_write
→ SQLITE_IOERR_WRITE
rescode.html#locked
→ SQLITE_LOCKED
rescode.html#locked_sharedcache
→ SQLITE_LOCKED_SHAREDCACHE
rescode.html#locked_vtab
→ SQLITE_LOCKED_VTAB
rescode.html#mismatch
→ SQLITE_MISMATCH
rescode.html#misuse
→ SQLITE_MISUSE
rescode.html#nolfs
→ SQLITE_NOLFS
rescode.html#nomem
→ SQLITE_NOMEM
rescode.html#notadb
→ SQLITE_NOTADB
rescode.html#notfound
→ SQLITE_NOTFOUND
rescode.html#notice
→ SQLITE_NOTICE
rescode.html#notice_recover_rollback
→ SQLITE_NOTICE_RECOVER_ROLLBACK
rescode.html#notice_recover_wal
→ SQLITE_NOTICE_RECOVER_WAL
rescode.html#ok
→ SQLITE_OK
rescode.html#ok_load_permanently
→ SQLITE_OK_LOAD_PERMANENTLY
rescode.html#perm
→ SQLITE_PERM
rescode.html#protocol
→ SQLITE_PROTOCOL
rescode.html#pve
→ ext-v-prim {primary versus extended result codes}
rescode.html#range
→ SQLITE_RANGE
rescode.html#readonly
→ SQLITE_READONLY
rescode.html#readonly_cantinit
→ SQLITE_READONLY_CANTINIT
rescode.html#readonly_cantlock
→ SQLITE_READONLY_CANTLOCK
rescode.html#readonly_dbmoved
→ SQLITE_READONLY_DBMOVED
rescode.html#readonly_directory
→ SQLITE_READONLY_DIRECTORY
rescode.html#readonly_recovery
→ SQLITE_READONLY_RECOVERY
rescode.html#readonly_rollback
→ SQLITE_READONLY_ROLLBACK
rescode.html#row
→ SQLITE_ROW
rescode.html#schema
→ SQLITE_SCHEMA
rescode.html#toobig
→ SQLITE_TOOBIG
rescode.html#warning
→ SQLITE_WARNING
rescode.html#warning_autoindex
→ SQLITE_WARNING_AUTOINDEX
rowidtable.html
→ {rowid table} {rowid tables}
rowvalue.html
→ {row value} {row values} rowvalue vectors
rowvalue.html#rvinop
→ {row value IN operator}
rtree.html
→ {R-Tree extension} R-Trees RTREE rtree
rtree.html#auxcol
→ {auxiliary columns} {auxiliary columns in r-tree tables}
rtree.html#customquery
→ {custom r-tree queries}
rtree.html#intrtree
→ {integer-valued r-trees}
rtree.html#readwrite
→ {reading and writing an rtree at the same time}
rtree.html#rtreecheck
→ rtreecheck
rtree.html#xquery
→ sqlite3_rtree_query_callback {xQueryFunc RTree callback}
rtree.html#xshadow
→ {rtree shadow tables}
schematab.html
→ {sqlite_master table} sqlite_schema {sqlite_schema table} sqlite_temp_schema
security.html
→ {attack resistance} {defense against dark arts} {defense against the dark arts} security
security.html#baddb
→ {untrusted database files}
selfcontained.html
→ low-dependency self-contained
series.html
→ generate_series series
serverless.html
→ embedded serverless
session/c_changeset_abort.html
→ SQLITE_CHANGESET_ABORT SQLITE_CHANGESET_OMIT SQLITE_CHANGESET_REPLACE
session/c_changeset_conflict.html
→ SQLITE_CHANGESET_CONFLICT SQLITE_CHANGESET_CONSTRAINT SQLITE_CHANGESET_DATA SQLITE_CHANGESET_FOREIGN_KEY SQLITE_CHANGESET_NOTFOUND
session/c_changesetapply_fknoaction.html
→ SQLITE_CHANGESETAPPLY_FKNOACTION SQLITE_CHANGESETAPPLY_IGNORENOOP SQLITE_CHANGESETAPPLY_INVERT SQLITE_CHANGESETAPPLY_NOSAVEPOINT
session/c_changesetstart_invert.html
→ SQLITE_CHANGESETSTART_INVERT
session/c_session_config_strmsize.html
→ SQLITE_SESSION_CONFIG_STRMSIZE
session/c_session_objconfig_rowid.html
→ SQLITE_SESSION_OBJCONFIG_ROWID SQLITE_SESSION_OBJCONFIG_SIZE
session/changegroup.html
→ sqlite3_changegroup
session/changeset_iter.html
→ sqlite3_changeset_iter
session/funclist.html
→ {Session Module C-API function list} session_funclist
session/intro.html
→ {Session Extension C-language Interface} session-capi
session/rebaser.html
→ sqlite3_rebaser
session/session.html
→ sqlite3_session
session/sqlite3changegroup_add.html
→ sqlite3changegroup_add
session/sqlite3changegroup_add_strm.html
→ sqlite3changegroup_add_strm sqlite3changegroup_output_strm sqlite3changeset_apply_strm sqlite3changeset_apply_v2_strm sqlite3changeset_concat_strm sqlite3changeset_invert_strm sqlite3changeset_start_strm sqlite3changeset_start_v2_strm sqlite3rebaser_rebase_strm sqlite3session_changeset_strm sqlite3session_patchset_strm
session/sqlite3changegroup_delete.html
→ sqlite3changegroup_delete
session/sqlite3changegroup_new.html
→ sqlite3changegroup_new
session/sqlite3changegroup_output.html
→ sqlite3changegroup_output
session/sqlite3changegroup_schema.html
→ sqlite3changegroup_schema
session/sqlite3changeset_apply.html
→ sqlite3changeset_apply sqlite3changeset_apply_v2
session/sqlite3changeset_concat.html
→ sqlite3changeset_concat
session/sqlite3changeset_conflict.html
→ sqlite3changeset_conflict
session/sqlite3changeset_finalize.html
→ sqlite3changeset_finalize
session/sqlite3changeset_fk_conflicts.html
→ sqlite3changeset_fk_conflicts
session/sqlite3changeset_invert.html
→ sqlite3changeset_invert
session/sqlite3changeset_new.html
→ sqlite3changeset_new
session/sqlite3changeset_next.html
→ sqlite3changeset_next
session/sqlite3changeset_old.html
→ sqlite3changeset_old
session/sqlite3changeset_op.html
→ sqlite3changeset_op
session/sqlite3changeset_pk.html
→ sqlite3changeset_pk
session/sqlite3changeset_start.html
→ sqlite3changeset_start sqlite3changeset_start_v2
session/sqlite3changeset_upgrade.html
→ sqlite3changeset_upgrade
session/sqlite3rebaser_configure.html
→ sqlite3rebaser_configure
session/sqlite3rebaser_create.html
→ sqlite3rebaser_create
session/sqlite3rebaser_delete.html
→ sqlite3rebaser_delete
session/sqlite3rebaser_rebase.html
→ sqlite3rebaser_rebase
session/sqlite3session_attach.html
→ sqlite3session_attach
session/sqlite3session_changeset.html
→ sqlite3session_changeset
session/sqlite3session_changeset_size.html
→ sqlite3session_changeset_size
session/sqlite3session_config.html
→ sqlite3session_config
session/sqlite3session_create.html
→ sqlite3session_create
session/sqlite3session_delete.html
→ sqlite3session_delete
session/sqlite3session_diff.html
→ sqlite3session_diff
session/sqlite3session_enable.html
→ sqlite3session_enable
session/sqlite3session_indirect.html
→ sqlite3session_indirect
session/sqlite3session_isempty.html
→ sqlite3session_isempty
session/sqlite3session_memory_used.html
→ sqlite3session_memory_used
session/sqlite3session_object_config.html
→ sqlite3session_object_config
session/sqlite3session_patchset.html
→ sqlite3session_patchset
session/sqlite3session_table_filter.html
→ sqlite3session_table_filter
sessionintro.html
→ session {session extension}
sessionintro.html#changeset
→ changeset changesets patchset patchsets
sharedcache.html
→ {SQLite Shared-Cache Mode} {shared cache} {shared cache mode}
sharedcache.html#dontuse
→ {use of shared cache mode is discouraged}
sharedcache.html#inmemsharedcache
→ {in-memory shared-cache}
shortnames.html
→ {short filenames}
shortnames.html#db83corrupt
→ {database corruption caused by inconsistent use of 83 filenames}
sitemap.html
→ {permuted index}
spellfix1.html
→ spellfix1
spellfix1.html#configeditdist
→ {configurable edit distances}
spellfix1.html#editdist3
→ editdist3
sqlanalyze.html
→ sqlite3_analyzer sqlite3_analyzer.exe
sqlar.html
→ {SQL Archive} SQLAR {SQLite Archive} {SQLite Archive files} {SQLite Archive format}
sqlar.html#cltools
→ {managing SQLite Archives from the command-line}
sqlar.html#dbasobj
→ {database as container object} {database as object}
sqldiff.html
→ sqldiff sqldiff.exe
stmt.html
→ {SQLITE_STMT virtual table} sqlite_stmt {the SQLITE_STMT extension}
stricttables.html
→ STRICT {STRICT table} {STRICT tables} {strict type checking}
support.html#fx
→ forum
support.html#mailinglists
→ {mailing lists}
swarmvtab.html#advanced_usage
→ advanced
swarmvtab.html#compiling_and_using_swarmvtab
→ compilation
swarmvtab.html#component_table_context_values
→ {swarmvtab context}
swarmvtab.html#overview
→ swarmvtab
swarmvtab.html#sql_parameters
→ {sql parameters}
swarmvtab.html#the_maxopen_parameter
→ {maxopen parameter}
swarmvtab.html#the_missing_callback
→ {missing callback}
swarmvtab.html#the_openclose_callback
→ {openclose callback}
syntax/aggregate-function-invocation.html
→ aggregate-function-invocation {aggregate-function-invocation syntax diagram}
syntax/alter-table-stmt.html
→ alter-table-stmt {alter-table-stmt syntax diagram}
syntax/analyze-stmt.html
→ analyze-stmt {analyze-stmt syntax diagram}
syntax/attach-stmt.html
→ attach-stmt {attach-stmt syntax diagram}
syntax/begin-stmt.html
→ begin-stmt {begin-stmt syntax diagram}
syntax/column-constraint.html
→ column-constraint {column-constraint syntax diagram}
syntax/column-def.html
→ column-def {column-def syntax diagram}
syntax/column-name-list.html
→ column-name-list {column-name-list syntax diagram}
syntax/comment-syntax.html
→ comment-syntax {comment-syntax syntax diagram}
syntax/commit-stmt.html
→ commit-stmt {commit-stmt syntax diagram}
syntax/common-table-expression.html
→ common-table-expression {common-table-expression syntax diagram}
syntax/compound-operator.html
→ compound-operator {compound-operator syntax diagram}
syntax/compound-select-stmt.html
→ compound-select-stmt {compound-select-stmt syntax diagram}
syntax/conflict-clause.html
→ conflict-clause {conflict-clause syntax diagram}
syntax/create-index-stmt.html
→ create-index-stmt {create-index-stmt syntax diagram}
syntax/create-table-stmt.html
→ create-table-stmt {create-table-stmt syntax diagram}
syntax/create-trigger-stmt.html
→ create-trigger-stmt {create-trigger-stmt syntax diagram}
syntax/create-view-stmt.html
→ create-view-stmt {create-view-stmt syntax diagram}
syntax/create-virtual-table-stmt.html
→ create-virtual-table-stmt {create-virtual-table-stmt syntax diagram}
syntax/cte-table-name.html
→ cte-table-name {cte-table-name syntax diagram}
syntax/delete-stmt-limited.html
→ delete-stmt-limited {delete-stmt-limited syntax diagram}
syntax/delete-stmt.html
→ delete-stmt {delete-stmt syntax diagram}
syntax/detach-stmt.html
→ detach-stmt {detach-stmt syntax diagram}
syntax/drop-index-stmt.html
→ drop-index-stmt {drop-index-stmt syntax diagram}
syntax/drop-table-stmt.html
→ drop-table-stmt {drop-table-stmt syntax diagram}
syntax/drop-trigger-stmt.html
→ drop-trigger-stmt {drop-trigger-stmt syntax diagram}
syntax/drop-view-stmt.html
→ drop-view-stmt {drop-view-stmt syntax diagram}
syntax/expr.html
→ expr {expr syntax diagram}
syntax/factored-select-stmt.html
→ factored-select-stmt {factored-select-stmt syntax diagram}
syntax/filter-clause.html
→ filter-clause {filter-clause syntax diagram}
syntax/foreign-key-clause.html
→ foreign-key-clause {foreign-key-clause syntax diagram}
syntax/frame-spec.html
→ frame-spec {frame-spec syntax diagram}
syntax/function-arguments.html
→ function-arguments {function-arguments syntax diagram}
syntax/indexed-column.html
→ indexed-column {indexed-column syntax diagram}
syntax/insert-stmt.html
→ insert-stmt {insert-stmt syntax diagram}
syntax/join-clause.html
→ join-clause {join-clause syntax diagram}
syntax/join-constraint.html
→ join-constraint {join-constraint syntax diagram}
syntax/join-operator.html
→ join-operator {join-operator syntax diagram}
syntax/literal-value.html
→ literal-value {literal-value syntax diagram}
syntax/numeric-literal.html
→ numeric-literal {numeric-literal syntax diagram}
syntax/ordering-term.html
→ ordering-term {ordering-term syntax diagram}
syntax/over-clause.html
→ over-clause {over-clause syntax diagram}
syntax/pragma-stmt.html
→ pragma-stmt {pragma-stmt syntax diagram}
syntax/pragma-value.html
→ pragma-value {pragma-value syntax diagram}
syntax/qualified-table-name.html
→ qualified-table-name {qualified-table-name syntax diagram}
syntax/raise-function.html
→ raise-function {raise-function syntax diagram}
syntax/recursive-cte.html
→ recursive-cte {recursive-cte syntax diagram}
syntax/reindex-stmt.html
→ reindex-stmt {reindex-stmt syntax diagram}
syntax/release-stmt.html
→ release-stmt {release-stmt syntax diagram}
syntax/result-column.html
→ result-column {result-column syntax diagram}
syntax/returning-clause.html
→ returning-clause {returning-clause syntax diagram}
syntax/rollback-stmt.html
→ rollback-stmt {rollback-stmt syntax diagram}
syntax/savepoint-stmt.html
→ savepoint-stmt {savepoint-stmt syntax diagram}
syntax/select-core.html
→ select-core {select-core syntax diagram}
syntax/select-stmt.html
→ select-stmt {select-stmt syntax diagram}
syntax/signed-number.html
→ signed-number {signed-number syntax diagram}
syntax/simple-function-invocation.html
→ simple-function-invocation {simple-function-invocation syntax diagram}
syntax/simple-select-stmt.html
→ simple-select-stmt {simple-select-stmt syntax diagram}
syntax/sql-stmt-list.html
→ sql-stmt-list {sql-stmt-list syntax diagram}
syntax/sql-stmt.html
→ sql-stmt {sql-stmt syntax diagram}
syntax/table-constraint.html
→ table-constraint {table-constraint syntax diagram}
syntax/table-options.html
→ table-options {table-options syntax diagram}
syntax/table-or-subquery.html
→ table-or-subquery {table-or-subquery syntax diagram}
syntax/type-name.html
→ type-name {type-name syntax diagram}
syntax/update-stmt-limited.html
→ update-stmt-limited {update-stmt-limited syntax diagram}
syntax/update-stmt.html
→ update-stmt {update-stmt syntax diagram}
syntax/upsert-clause.html
→ upsert-clause {upsert-clause syntax diagram}
syntax/vacuum-stmt.html
→ vacuum-stmt {vacuum-stmt syntax diagram}
syntax/window-defn.html
→ window-defn {window-defn syntax diagram}
syntax/window-function-invocation.html
→ window-function-invocation {window-function-invocation syntax diagram}
syntax/with-clause.html
→ with-clause {with-clause syntax diagram}
syntaxdiagrams.html
→ {syntax diagrams}
tclsqlite.html
→ {TCL Interface} {Tcl extension}
tclsqlite.html#authorizer
→ {TCL interface authorizer method} {authorizer method}
tclsqlite.html#backup
→ {TCL interface backup method} {backup method}
tclsqlite.html#bind_fallback
→ {TCL interface bind_fallback method} {bind_fallback method}
tclsqlite.html#busy
→ {TCL interface busy method} {busy method}
tclsqlite.html#cache
→ {TCL interface cache method} {cache method}
tclsqlite.html#changes
→ {TCL interface changes method} {changes method}
tclsqlite.html#close
→ {TCL interface close method} {close method}
tclsqlite.html#collate
→ {TCL interface collate method} {collate method}
tclsqlite.html#collation_needed
→ {TCL interface collation_needed method} {collation_needed method}
tclsqlite.html#commit_hook
→ {TCL interface commit_hook method} {commit_hook method}
tclsqlite.html#complete
→ {TCL interface complete method} {complete method}
tclsqlite.html#config
→ {TCL interface config method} {config method}
tclsqlite.html#copy
→ {TCL interface copy method} {copy method}
tclsqlite.html#deserialize
→ {TCL interface deserialize method} {deserialize method}
tclsqlite.html#enable_load_extension
→ {TCL interface enable_load_extension method} {enable_load_extension method}
tclsqlite.html#errorcode
→ {TCL interface errorcode method} {errorcode method}
tclsqlite.html#eval
→ {TCL interface eval method} {eval method}
tclsqlite.html#exists
→ {TCL interface exists method} {exists method}
tclsqlite.html#function
→ {TCL interface function method} {function method}
tclsqlite.html#incrblob
→ {TCL interface incrblob method} {incrblob method}
tclsqlite.html#interrupt
→ {TCL interface interrupt method} {interrupt method}
tclsqlite.html#last_insert_rowid
→ {TCL interface last_insert_rowid method} {last_insert_rowid method}
tclsqlite.html#nullvalue
→ {TCL interface nullvalue method} {nullvalue method}
tclsqlite.html#onecolumn
→ {TCL interface onecolumn method} {onecolumn method}
tclsqlite.html#preupdate
→ {TCL interface preupdate method} {preupdate method}
tclsqlite.html#profile
→ {TCL interface profile method} {profile method}
tclsqlite.html#progress
→ {TCL interface progress method} {progress method}
tclsqlite.html#restore
→ {TCL interface restore method} {restore method}
tclsqlite.html#rollback_hook
→ {TCL interface rollback_hook method} {rollback_hook method}
tclsqlite.html#serialize
→ {TCL interface serialize method} {serialize method}
tclsqlite.html#status
→ {TCL interface status method} {status method}
tclsqlite.html#timeout
→ {TCL interface timeout method} {timeout method}
tclsqlite.html#total_changes
→ {TCL interface total_changes method} {total_changes method}
tclsqlite.html#trace
→ {TCL interface trace method} {trace method}
tclsqlite.html#trace_v2
→ {TCL interface trace_v2 method} {trace_v2 method}
tclsqlite.html#transaction
→ {TCL interface transaction method} {transaction method}
tclsqlite.html#unlock_notify
→ {TCL interface unlock_notify method} {unlock_notify method}
tclsqlite.html#update_hook
→ {TCL interface update_hook method} {update_hook method}
tclsqlite.html#varsubst
→ {TCL variable substitution}
tclsqlite.html#version
→ {TCL interface version method} {version method}
tclsqlite.html#wal_hook
→ {TCL interface wal_hook method} {wal_hook method}
tempfiles.html
→ {temporary disk files}
tempfiles.html#stmtjrnl
→ {Statement journals} {statement journal} {statement journals}
tempfiles.html#superjrnl
→ {master journal} super-journal
tempfiles.html#tempdir
→ {temporary directory search algorithm}
tempfiles.html#tempstore
→ tempstore
testing.html
→ {test suite} tested testing
testing.html#3pfuzz
→ {3rd-party fuzzers}
testing.html#aflfuzz
→ AFL {American Fuzzy Lop fuzzer}
testing.html#cklist
→ checklist {release testing checklists}
testing.html#coverage
→ {test coverage}
testing.html#dbsqlfuzz
→ dbsqlfuzz jfuzz
testing.html#defcode
→ {defensive code}
testing.html#fuzzcheck
→ fuzzcheck
testing.html#fuzztesting
→ {SQL fuzzing} {fuzz testing}
testing.html#harnesses
→ {test harness} {three test harnesses}
testing.html#mcdc
→ MC/DC {MC/DC testing}
testing.html#mutationtests
→ {mutation testing}
testing.html#ossfuzz
→ {OSS Fuzz}
testing.html#slt
→ SLT {SQL Logic Tests}
testing.html#tcl
→ {TCL test suite}
testing.html#tension
→ {coverage testing vs. fuzz testing}
testing.html#testcase
→ {testcase macros}
th3.html
→ TH3
th3.html#muttest
→ {mutation test script}
threadsafe.html
→ {threading mode}
transactional.html
→ ACID power-safe {power-safe transactions} transactional
uintcseq.html
→ UINT {UINT collating sequence}
undoredo.html
→ {automated undo/redo stack} undo/redo undoredo
unionvtab.html
→ {UNION virtual table} union-vtab unionvtab
unlock_notify.html
→ {Using the SQLite Unlock Notification Feature}
uri.html
→ URI {URI filename} {URI filenames} {Uniform Resource Identifier}
uri.html#coreqp
→ {URI query parameters} coreqp {query parameters with special meaning to SQLite} {standard query parameters}
uri.html#uricache
→ {cache query parameter}
uri.html#uriimmutable
→ {immutable query parameter}
uri.html#urimode
→ {mode query parameter}
uri.html#urimodeof
→ modeof {modeof query parameter}
uri.html#urinolock
→ {nolock query parameter}
uri.html#uripsow
→ {psow query parameter}
uri.html#urivfs
→ {vfs query parameter}
useovernet.html
→ {how to corrupt a database} {network filesystem use}
versionnumbers.html
→ {version numbering conventions}
vfs.html
→ {OS backend} VFS VFSes
vfs.html#shim
→ {VFS shim} {VFS shims} shims
vtab.html
→ {virtual table} {virtual tables}
vtab.html#colUsed
→ {colUsed field}
vtab.html#customvtab
→ {custom virtual tables}
vtab.html#epoonlyvtab
→ {eponymous-only virtual table} {eponymous-only virtual tables}
vtab.html#epovtab
→ {eponymous virtual table} {eponymous virtual tables}
vtab.html#hiddencol
→ {hidden column} {hidden columns}
vtab.html#obc
→ orderByConsumed
vtab.html#sqlite3_module.xDestroy
→ xDestroy
vtab.html#tabfunc2
→ {table-valued function} {table-valued functions}
vtab.html#worid
→ {WITHOUT ROWID virtual table} {WITHOUT ROWID virtual tables}
vtab.html#xBegin
→ sqlite3_module.xBegin xBegin
vtab.html#xbestindex
→ sqlite3_module.xBestIndex xBestIndex
vtab.html#xclose
→ sqlite3_module.xClose
vtab.html#xcolumn
→ sqlite3_module.xColumn xColumn
vtab.html#xcommit
→ sqlite3_module.xCommit xCommit
vtab.html#xconnect
→ sqlite3_module.xConnect xConnect
vtab.html#xcreate
→ sqlite3_module.xCreate xCreate
vtab.html#xdisconnect
→ sqlite3_module.xDisconnect xDisconnect
vtab.html#xeof
→ sqlite3_module.xEof xEof
vtab.html#xfilter
→ sqlite3_module.xFilter xFilter
vtab.html#xfindfunction
→ sqlite3_module.xFindFunction xFindFunction
vtab.html#xintegrity
→ sqlite3_module.xIntegrity xIntegrity {xIntegrity method}
vtab.html#xnext
→ sqlite3_module.xNext xNext
vtab.html#xopen
→ sqlite3_module.xOpen
vtab.html#xrename
→ sqlite3_module.xRename xRename
vtab.html#xrollback
→ sqlite3_module.xRollback xRollback
vtab.html#xrowid
→ sqlite3_module.xRowid xRowid
vtab.html#xsavepoint
→ sqlite3_module.xSavepoint xRelease xRollbackTo xSavepoint
vtab.html#xshadowname
→ {shadow table} {shadow tables} sqlite3_module.xShadowName xShadowName
vtab.html#xsync
→ sqlite3_module.xSync
vtab.html#xupdate
→ sqlite3_module.xUpdate xUpdate
vtablist.html
→ {list of virtual tables} {virtual table list}
wal.html
→ WAL {WAL mode} {write-ahead log}
wal.html#advantages
→ {advantages of WAL-mode}
wal.html#bigwal
→ {avoiding large WAL files} {large WAL files}
wal.html#bkwrds
→ {WAL backwards compatibility}
wal.html#busy
→ {WAL-mode read blocking}
wal.html#ckpt
→ checkpoint checkpointed checkpointing
wal.html#concurrency
→ {WAL concurrency}
wal.html#noshm
→ {WAL without shared memory}
wal.html#readonly
→ {read-only WAL databases}
wal.html#walfile
→ {WAL file}
walformat.html
→ {WAL-mode File Format}
walformat.html#locks
→ {WAL-mode locks}
walformat.html#mxframe
→ mxFrame
walformat.html#nbackfill
→ nBackfill
walformat.html#recovery
→ {WAL-mode crash recovery} recovery
walformat.html#shm
→ {shm file} wal-index
walformat.html#walidxfmt
→ {WAL-index File Format} {WAL-index format}
whentouse.html
→ {Appropriate Uses For SQLite}
whentouse.html#container
→ {data container}
whentouse.html#dbcklst
→ {decision checklist}
whentouse.html#serversidedb
→ {server-side database}
whentouse.html#website
→ {using SQLite for websites}
whentouse.html#wireproto
→ {data transfer format}
windowfunctions.html
→ {Window functions} {window function} {window functions}
windowfunctions.html#aggwinfunc
→ {aggregate window functions}
windowfunctions.html#biwinfunc
→ {builtin window functions}
windowfunctions.html#builtins
→ {built-in window functions} built-ins
windowfunctions.html#exprrange
→ {RANGE n FOLLOWING} {RANGE n PRECEDING}
windowfunctions.html#frameboundary
→ {frame boundary}
windowfunctions.html#framespec
→ {frame specification} frames
windowfunctions.html#frametype
→ {frame type}
windowfunctions.html#grouptype
→ {GROUPS frames}
windowfunctions.html#ptxn
→ partition
windowfunctions.html#rangetype
→ {RANGE frames}
windowfunctions.html#udfwinfunc
→ {application-defined window functions} {user-defined window functions}
windowfunctions.html#wchaining
→ {window chaining}
windowfunctions.html#wexcls
→ {EXCLUDE clause} {exclude clause}
withoutrowid.html
→ {Clustered indexes} {WITHOUT ROWID} {WITHOUT rowid}
withoutrowid.html#bene
→ {benefits of using WITHOUT ROWID}
withoutrowid.html#wtu
→ {when to use WITHOUT ROWID}
zeroconf.html
→ zero-configuration
zipfile.html
→ {Zipfile virtual table} zipfile
zipfile.html#adding_entries_to_a_zip_archive
→ {Adding to Zip}
This page last modified on
2023-03-31 19:57:15
UTC