Small. Fast. Reliable.
Choose any three.

About Documentation Download License Support Purchase |

- 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 - {SQLAR smaller than ZIP}
- amalgamation.html - amalgamation {the amalgamation}
- amalgamation.html#amal32k - {split amalgamation}
- appfileformat.html - {Application File Format} appformat {application file format} {application file-format}
- 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}
- books.html - {books about SQLite}
- btreemodule.html - {btree design}
- 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/auto_extension.html - sqlite3_auto_extension
- 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_text sqlite3_bind_text16 sqlite3_bind_text64 sqlite3_bind_value sqlite3_bind_zeroblob sqlite3_bind_zeroblob64
- 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_AUTH_USER SQLITE_IOERR_AUTH SQLITE_IOERR_VNODE {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#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#sqliteconfigsqllog - SQLITE_CONFIG_SQLLOG
- 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_enable_fkey.html - SQLITE_DBCONFIG_ENABLE_FKEY SQLITE_DBCONFIG_ENABLE_TRIGGER SQLITE_DBCONFIG_LOOKASIDE
- 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#sqlitedbstatuscacheused - SQLITE_DBSTATUS_CACHE_USED
- 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_deterministic.html - SQLITE_DETERMINISTIC
- c3ref/c_fail.html - SQLITE_FAIL SQLITE_REPLACE SQLITE_ROLLBACK {conflict resolution mode}
- c3ref/c_fcntl_busyhandler.html - SQLITE_FCNTL_GET_LOCKPROXYFILE SQLITE_FCNTL_LAST_ERRNO SQLITE_FCNTL_SET_LOCKPROXYFILE {file control opcode} {file control opcodes}
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlbusyhandler - SQLITE_FCNTL_BUSYHANDLER
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlchunksize - SQLITE_FCNTL_CHUNK_SIZE
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlcommitphasetwo - SQLITE_FCNTL_COMMIT_PHASETWO
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlfilepointer - SQLITE_FCNTL_FILE_POINTER
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlhasmoved - SQLITE_FCNTL_HAS_MOVED
- c3ref/c_fcntl_busyhandler.html#sqlitefcntllockstate - SQLITE_FCNTL_LOCKSTATE
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlmmapsize - SQLITE_FCNTL_MMAP_SIZE
- c3ref/c_fcntl_busyhandler.html#sqlitefcntloverwrite - SQLITE_FCNTL_OVERWRITE
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlpersistwal - SQLITE_FCNTL_PERSIST_WAL
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlpowersafeoverwrite - SQLITE_FCNTL_POWERSAFE_OVERWRITE
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlpragma - SQLITE_FCNTL_PRAGMA
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlrbu - SQLITE_FCNTL_RBU
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlsizehint - SQLITE_FCNTL_SIZE_HINT
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlsync - SQLITE_FCNTL_SYNC
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlsyncomitted - SQLITE_FCNTL_SYNC_OMITTED
- c3ref/c_fcntl_busyhandler.html#sqlitefcntltempfilename - SQLITE_FCNTL_TEMPFILENAME
- c3ref/c_fcntl_busyhandler.html#sqlitefcntltrace - SQLITE_FCNTL_TRACE
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlvfsname - SQLITE_FCNTL_VFSNAME
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlvfspointer - SQLITE_FCNTL_VFS_POINTER
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlwalblock - SQLITE_FCNTL_WAL_BLOCK
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlwin32avretry - SQLITE_FCNTL_WIN32_AV_RETRY
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlwin32sethandle - SQLITE_FCNTL_WIN32_SET_HANDLE
- c3ref/c_fcntl_busyhandler.html#sqlitefcntlzipvfs - SQLITE_FCNTL_ZIPVFS
- c3ref/c_index_constraint_eq.html - SQLITE_INDEX_CONSTRAINT_EQ SQLITE_INDEX_CONSTRAINT_GE SQLITE_INDEX_CONSTRAINT_GLOB SQLITE_INDEX_CONSTRAINT_GT SQLITE_INDEX_CONSTRAINT_LE SQLITE_INDEX_CONSTRAINT_LIKE SQLITE_INDEX_CONSTRAINT_LT SQLITE_INDEX_CONSTRAINT_MATCH 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_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_MASTER 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_FULLMUTEX SQLITE_OPEN_MAIN_DB SQLITE_OPEN_MAIN_JOURNAL SQLITE_OPEN_MASTER_JOURNAL SQLITE_OPEN_MEMORY SQLITE_OPEN_NOMUTEX SQLITE_OPEN_PRIVATECACHE SQLITE_OPEN_READONLY SQLITE_OPEN_READWRITE SQLITE_OPEN_SHAREDCACHE SQLITE_OPEN_SUBJOURNAL SQLITE_OPEN_TEMP_DB SQLITE_OPEN_TEMP_JOURNAL SQLITE_OPEN_TRANSIENT_DB SQLITE_OPEN_URI SQLITE_OPEN_WAL
- 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#sqlitescanstatnloop - SQLITE_SCANSTAT_NLOOP
- c3ref/c_scanstat_est.html#sqlitescanstatnvisit - SQLITE_SCANSTAT_NVISIT
- c3ref/c_scanstat_est.html#sqlitescanstatselectid - SQLITE_SCANSTAT_SELECTID
- 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}
- c3ref/c_stmtstatus_counter.html#sqlitestmtstatusautoindex - SQLITE_STMTSTATUS_AUTOINDEX
- c3ref/c_stmtstatus_counter.html#sqlitestmtstatusfullscanstep - SQLITE_STMTSTATUS_FULLSCAN_STEP
- 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_FAULT_INSTALL SQLITE_TESTCTRL_FIRST SQLITE_TESTCTRL_IMPOSTER SQLITE_TESTCTRL_ISINIT SQLITE_TESTCTRL_ISKEYWORD SQLITE_TESTCTRL_LAST SQLITE_TESTCTRL_LOCALTIME_FAULT SQLITE_TESTCTRL_NEVER_CORRUPT SQLITE_TESTCTRL_OPTIMIZATIONS SQLITE_TESTCTRL_PENDING_BYTE SQLITE_TESTCTRL_PRNG_RESET SQLITE_TESTCTRL_PRNG_RESTORE SQLITE_TESTCTRL_PRNG_SAVE SQLITE_TESTCTRL_RESERVE SQLITE_TESTCTRL_SCRATCHMALLOC SQLITE_TESTCTRL_SORTER_MMAP SQLITE_TESTCTRL_VDBE_COVERAGE
- c3ref/c_vtab_constraint_support.html - SQLITE_VTAB_CONSTRAINT_SUPPORT
- c3ref/cancel_auto_extension.html - sqlite3_cancel_auto_extension
- c3ref/changes.html - sqlite3_changes
- 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_function.html - {application-defined SQL function} {application-defined SQL functions} {function creation routines} sqlite3_create_function sqlite3_create_function16 sqlite3_create_function_v2
- 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/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_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/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_errstr sqlite3_extended_errcode
- c3ref/exec.html - sqlite3_exec
- c3ref/experimental.html - deprecated experimental
- c3ref/extended_result_codes.html - sqlite3_extended_result_codes
- c3ref/file.html - sqlite3_file
- c3ref/file_control.html - sqlite3_file_control
- 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/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
- c3ref/intro.html - {C-language Interface} capi3ref
- c3ref/io_methods.html - sqlite3_io_methods
- 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#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_prepare_v2
- 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_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/set_authorizer.html - sqlite3_set_authorizer
- c3ref/sleep.html - sqlite3_sleep
- c3ref/snapshot.html - snapshot sqlite3_snapshot
- c3ref/snapshot_free.html - sqlite3_snapshot_free
- c3ref/snapshot_get.html - sqlite3_snapshot_get
- c3ref/snapshot_open.html - sqlite3_snapshot_open
- c3ref/soft_heap_limit.html - sqlite3_soft_heap_limit
- c3ref/soft_heap_limit64.html - sqlite3_soft_heap_limit64
- c3ref/sql.html - sqlite3_sql
- 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_readonly.html - sqlite3_stmt_readonly
- c3ref/stmt_scanstatus.html - sqlite3_stmt_scanstatus
- c3ref/stmt_scanstatus_reset.html - sqlite3_stmt_scanstatus_reset
- c3ref/stmt_status.html - sqlite3_stmt_status
- c3ref/strglob.html - sqlite3_strglob
- c3ref/stricmp.html - sqlite3_stricmp sqlite3_strnicmp
- c3ref/strlike.html - sqlite3_strlike
- 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
- 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_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_int sqlite3_value_int64 sqlite3_value_numeric_type 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_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_config.html - sqlite3_vtab_config
- c3ref/vtab_cursor.html - sqlite3_vtab_cursor {virtual table cursor}
- c3ref/vtab_on_conflict.html - sqlite3_vtab_on_conflict
- 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
- changes.html - {complete list of SQLite releases} {release history}
- chronology.html - chronology
- cintro.html - cintro
- cli.html - CLI {Command Line Interface} {command-line interface} {command-line shell}
- cli.html#csv - {CSV import}
- cli.html#csvout - {CSV export}
- cli.html#dotcmd - dot-commands
- cli.html#explain - {explain dot-command}
- cli.html#fileio - {file I/O functions}
- cli.html#fullschema - .fullschema {the .fullschema dot-command}
- 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#case_sensitive_like - -DSQLITE_CASE_SENSITIVE_LIKE SQLITE_CASE_SENSITIVE_LIKE
- 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_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_wal_autocheckpoint - -DSQLITE_DEFAULT_WAL_AUTOCHECKPOINT SQLITE_DEFAULT_WAL_AUTOCHECKPOINT
- 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_lfs - -DSQLITE_DISABLE_LFS SQLITE_DISABLE_LFS
- 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_column_metadata - -DSQLITE_ENABLE_COLUMN_METADATA SQLITE_ENABLE_COLUMN_METADATA
- compile.html#enable_dbstat_vtab - -DSQLITE_ENABLE_DBSTAT_VTAB SQLITE_ENABLE_DBSTAT_VTAB
- 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_fts4 - -DSQLITE_ENABLE_FTS4 SQLITE_ENABLE_FTS4
- compile.html#enable_fts5 - -DSQLITE_ENABLE_FTS5 SQLITE_ENABLE_FTS5
- 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_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_rbu - -DSQLITE_ENABLE_RBU SQLITE_ENABLE_RBU
- compile.html#enable_rtree - -DSQLITE_ENABLE_RTREE SQLITE_ENABLE_RTREE
- 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_tree_explain - -DSQLITE_ENABLE_TREE_EXPLAIN SQLITE_ENABLE_TREE_EXPLAIN
- 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#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#isnan - -DHAVE_ISNAN HAVE_ISNAN
- 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_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#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_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_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_get_table - -DSQLITE_OMIT_GET_TABLE SQLITE_OMIT_GET_TABLE
- 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_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_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#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#strchrnul - -DHAVE_STRCHRNUL HAVE_STRCHRNUL
- 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#use_fcntl_trace - -DSQLITE_USE_FCNTL_TRACE SQLITE_USE_FCNTL_TRACE
- compile.html#use_uri - -DSQLITE_USE_URI SQLITE_USE_URI
- compile.html#usleep - -DHAVE_USLEEP HAVE_USLEEP
- 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
- consortium.html - {SQLite Consortium}
- custombuild.html - {custom builds} {porting SQLite}
- datatype3.html - datatype {dynamic typing}
- datatype3.html#affinity - affinities affinity {column affinity} {type affinity}
- datatype3.html#affname - {rules for determining column affinity}
- 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#compaff - {comparison affinity rules}
- datatype3.html#comparisons - {comparison expressions}
- datatype3.html#datetime - {date and time datatype}
- datatype3.html#expraff - {expression affinity}
- datatype3.html#storageclasses - {storage class}
- dbstat.html - dbstat {dbstat virtual table}
- doclist.html - {alphabetical listing of SQLite documents} doclist
- docs.html - {categorical listing of SQLite documents}
- 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}
- errlog.html - errlog {error log}
- expridx.html - {Indexes On Expressions} {indexes on expressions}
- fileformat2.html - {file format} {second edition file format document}
- fileformat2.html#appid - {Application ID}
- fileformat2.html#btree - B-Trees
- 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#filesize - {in-header database size}
- fileformat2.html#freelist - {free-page list} freelist
- fileformat2.html#intschema - {internal index} {internal indexes} {internal schema object} {internal schema objects} {internal table} {internal tables}
- fileformat2.html#ovflpgs - {overflow page} {overflow pages}
- fileformat2.html#record_format - {record format}
- 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#sqlite_master - sqlite_master {sqlite_master table}
- 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#walcksm - {WAL checksum algorithm}
- fileformat2.html#walformat - {WAL format}
- fileformat2.html#walindexformat - {WAL-index format} wal-index
- fileformat2.html#walread - {WAL read algorithm}
- fileio.html - {file I/O}
- footprint.html - footprint {library size}
- footprint.html#relfootprint - 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} {shadow tables}
- fts3.html#appendix_a - {search application tips}
- fts3.html#commands - commands
- 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#hiddencol - {FTS hidden column}
- 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#section_1_4 - {simple fts queries}
- fts3.html#section_2 - {compile fts}
- fts3.html#section_3 - {FTS MATCH}
- fts3.html#section_3_1 - {enhanced query syntax}
- fts3.html#section_6_1 - {fts4 compress option}
- fts3.html#section_6_2 - {fts4 content option}
- fts3.html#section_6_2_1 - {contentless fts4 tables}
- fts3.html#section_6_2_2 - {external content fts4 tables}
- fts3.html#section_6_3 - {fts4 languageid option}
- fts3.html#section_6_4 - {fts4 matchinfo option}
- fts3.html#section_6_5 - {fts4 notindexed option}
- fts3.html#section_6_6 - {fts4 prefix option}
- fts3.html#section_9 - {segment btree}
- fts3.html#section_9_1 - shadowtabs
- fts3.html#snippet - {FTS auxiliary functions} snippet
- fts3.html#termprefix - {prefix queries} {prefix query}
- fts3.html#tokenizer - tokenizer
- fts3.html#unicode61 - unicode61
- fts5.html - FTS5 fts5
- fts5.html#appendix_a - {comparison with fts4}
- fts5.html#notoc6 - {fts5 technical differences}
- fts5.html#section_2 - {FTS5 building}
- fts5.html#section_3 - {FTS5 query syntax}
- fts5.html#section_4 - {FTS5 CREATE TABLE Options}
- fts5.html#section_4_1 - unindexed
- fts5.html#section_4_2 - {FTS5 prefix indexes}
- fts5.html#section_4_3 - {FTS5 tokenizers}
- fts5.html#section_4_4 - {FTS5 content option}
- fts5.html#section_4_4_1 - {FTS5 contentless tables}
- fts5.html#section_4_4_2 - {FTS5 external content tables}
- fts5.html#section_4_5 - {FTS5 columnsize option}
- fts5.html#section_5 - {FTS5 auxiliary functions}
- fts5.html#section_5_1_1 - {FTS5 bm25}
- fts5.html#section_5_1_2 - {FTS5 highlight}
- fts5.html#section_5_1_3 - {FTS5 snippet}
- fts5.html#section_5_2 - {auxiliary function mapping}
- fts5.html#section_6_1 - {FTS5 automerge option}
- fts5.html#section_6_10 - {FTS5 rebuild command}
- fts5.html#section_6_3 - {FTS5 delete command}
- fts5.html#section_6_4 - {FTS5 delete-all command}
- fts5.html#section_6_6 - {FTS5 merge command}
- fts5.html#section_6_7 - {FTS5 optimize command}
- fts5.html#section_6_8 - {FTS5 pgsz option}
- fts5.html#section_6_9 - {FTS5 rank configuration option}
- fts5.html#section_7 - {Extending FTS5}
- fts5.html#section_7_1 - {custom tokenizers}
- fts5.html#section_7_2 - {FTS5 custom auxiliary functions}
- fts5.html#section_7_2_1 - {custom auxiliary functions}
- getthecode.html - {canonical source code} {get the canonical source code}
- getthecode.html#clone - {clone the entire repository}
- 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#delhotjrnl - {deleting a hot journal}
- howtocorrupt.html#fscorruption - {filesystem corruption}
- howtocorrupt.html#unlink - {unlink corruption} {unlinked database files}
- 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}
- isolation.html - isolation
- json1.html - {JSON SQL functions} json1 {the json1 extension}
- json1.html#jarray - json_array {json_array SQL function}
- json1.html#jarraylen - json_array_length {json_array_length SQL function}
- json1.html#jeach - json_each {json_each table-valued function}
- json1.html#jex - json_extract {json_extract SQL function}
- json1.html#jgrouparray - json_group_array {json_group_array SQL function}
- json1.html#jgroupobject - json_group_object {json_group_object SQL function}
- json1.html#jins - json_insert {json_insert SQL function}
- json1.html#jmini - json {json SQL function}
- json1.html#jobj - json_object {json_object SQL function}
- json1.html#jrepl - json_replace {json_replace SQL function}
- json1.html#jrm - json_remove {json_remove SQL function}
- json1.html#jset - json_set {json_set SQL function}
- 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}
- keyword_index.html - {keyword index}
- lang_aggfunc.html - {Aggregate Functions} aggfunc
- lang_aggfunc.html#avg - avg {avg aggregate function}
- lang_aggfunc.html#count - count {count aggregate function}
- lang_aggfunc.html#groupconcat - group_concat {group_concat aggregate function}
- lang_aggfunc.html#maxggunc - agg_max {max aggregate function} maxAggFunc
- lang_aggfunc.html#minggunc - agg_min {min aggregate function} minAggFunc
- lang_aggfunc.html#sumunc - sum {sum aggregate function} sumFunc total {total aggregate function}
- lang_altertable.html - ALTER {ALTER TABLE}
- lang_analyze.html - ANALYZE
- lang_attach.html - ATTACH {ATTACH DATABASE} attached
- lang_comment.html - comment comments
- lang_conflict.html - {ON CONFLICT} {ON CONFLICT clause} {conflict clause}
- lang_corefunc.html - {Core Functions} corefunc
- 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#glob - glob {glob SQL function}
- lang_corefunc.html#hex - hex {hex SQL function}
- lang_corefunc.html#ifnull - ifnull {ifnull 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#maxoreunc - max {max SQL function} maxCoreFunc
- lang_corefunc.html#minoreunc - min {min SQL function} minCoreFunc
- lang_corefunc.html#nullif - nullif {nullif 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#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_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#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}
- lang_createindex.html#descidx - {descending index} {descending indexes} {descending indices}
- lang_createindex.html#uniqueidx - {unique index}
- lang_createtable.html - {CREATE TABLE}
- lang_createtable.html#ckconst - CHECK {CHECK constraint} {CHECK constraints}
- lang_createtable.html#constraints - constraints
- lang_createtable.html#createtabas - {CREATE TABLE AS}
- lang_createtable.html#dfltval - {default column value} {default value}
- lang_createtable.html#notnullconst - {NOT NULL} {NOT NULL constraint}
- 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 constraint}
- lang_createtrigger.html - {CREATE TRIGGER}
- 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 view views
- lang_createvtab.html - {CREATE VIRTUAL TABLE}
- lang_datefunc.html - {Date And Time Functions} {date SQL function} {date and time functions} datefunc {datetime SQL function} {julianday SQL function} {strftime SQL function} {time SQL function}
- lang_datefunc.html#localtime - {localtime modifier} {utc modifier}
- lang_delete.html - DELETE DELETEs
- lang_delete.html#truncateopt - {truncate optimization}
- lang_detach.html - DETACH {DETACH DATABASE}
- lang_dropindex.html - {DROP INDEX}
- lang_droptable.html - {DROP TABLE}
- lang_droptrigger.html - {DROP TRIGGER}
- lang_dropview.html - {DROP VIEW}
- lang_explain.html - EXPLAIN
- lang_expr.html - expression {expression syntax}
- 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#glob - GLOB
- lang_expr.html#hexint - {hexadecimal integer literals} {hexadecimal integers}
- lang_expr.html#in_op - {EXISTS operator} {IN operator} {NOT EXISTS operator} {NOT IN operator}
- 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#varparam - {bound parameter} {bound parameters} parameter parameters
- lang_indexedby.html - {INDEXED BY} {NOT INDEXED}
- lang_insert.html - INSERT INSERTs
- lang_keywords.html - {SQL keyword} {SQL keywords} {SQLite Keywords}
- lang_naming.html - {Database Object Name Resolution} {object resolution}
- lang_reindex.html - REINDEX
- lang_replace.html - REPLACE
- lang_savepoint.html - RELEASE SAVEPOINT
- lang_select.html - SELECT query
- 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#limitoffset - LIMIT OFFSET
- lang_select.html#orderby - {ORDER BY} {order by}
- lang_select.html#resultset - {GROUP BY} {result-set expressions}
- 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 {BEGIN TRANSACTION} COMMIT ROLLBACK
- lang_transaction.html#immediate - {BEGIN EXCLUSIVE} {BEGIN IMMEDIATE}
- lang_update.html - UPDATE UPDATEs
- lang_vacuum.html - VACUUM
- lang_with.html - WITH {WITH clause} {common table expressions}
- lang_with.html#mandelbrot - {compute the Mandelbrot set}
- lang_with.html#ordinarycte - {ordinary common table expressions}
- lang_with.html#recursivecte - {recursive common table expressions} {recursive query}
- lang_with.html#sudoku - {solve Sudoku puzzles}
- 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#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#hotjrnl - {hot journal}
- 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}
- malloc.html - {memory allocation}
- malloc.html#altalloc - {built-in memory allocators}
- malloc.html#defaultalloc - {default memory allocator}
- malloc.html#lookaside - {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#scratch - {scratch memory allocator}
- malloc.html#win32heap - {Win32 native memory allocator}
- mmap.html - {memory-mapped I/O} mmap
- mostdeployed.html - {most widely deployed}
- opcode.html - VDBE opcodes {virtual machine} {virtual machine instructions}
- optoverview.html - {SQLite query planner} optimizer {query planner}
- optoverview.html#autoindex - {Automatic indexing} {automatic indexing}
- optoverview.html#crossjoin - {CROSS JOIN} {Manual Control Of Query Plans Using CROSS JOIN}
- optoverview.html#flattening - {flattening optimization}
- optoverview.html#like_opt - {LIKE optimization}
- optoverview.html#manctrl - {Manual Control Of Query Plans Using SQLITE_STAT Tables}
- optoverview.html#or_opt - {OR optimization} {or optimization}
- optoverview.html#partsort - {sorting subsets of the result}
- 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}
- 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_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}
- pragma.html#pragma_journal_size_limit - {PRAGMA journal_size_limit} journal_size_limit {journal_size_limit pragma}
- pragma.html#pragma_legacy_file_format - {PRAGMA legacy_file_format} legacy_file_format {legacy_file_format pragma}
- pragma.html#pragma_locking_mode - {PRAGMA 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_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_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} {PRAGMA user_version} schema_version {schema_version pragma} user_version {user_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_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_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}
- privatebranch.html - {private branches}
- 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 - {query planner stability guarantee}
- queryplanner.html - indexing {indexing tutorial}
- queryplanner.html#covidx - {covering index} {covering indices}
- queryplanner.html#or_in_where - or-connected-terms
- queryplanner.html#partialsort - {partial sorting by index}
- queryplanner.html#searching - strategies
- queryplanner.html#sorting - sorting
- quickstart.html - {Quick Start Guide} quickstart
- 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#sqldiff - {sqldiff --rbu}
- 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_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_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_3_0.html - {Version 3.3.0} {version 3.3.0}
- releaselog/3_3_1.html - {Version 3.3.1} {version 3.3.1}
- releaselog/3_3_10.html - {Version 3.3.10} {version 3.3.10}
- releaselog/3_3_11.html - {Version 3.3.11} {version 3.3.11}
- releaselog/3_3_12.html - {Version 3.3.12} {version 3.3.12}
- releaselog/3_3_13.html - {Version 3.3.13} {version 3.3.13}
- releaselog/3_3_14.html - {Version 3.3.14} {version 3.3.14}
- releaselog/3_3_15.html - {Version 3.3.15} {version 3.3.15}
- releaselog/3_3_16.html - {Version 3.3.16} {version 3.3.16}
- releaselog/3_3_17.html - {Version 3.3.17} {version 3.3.17}
- releaselog/3_3_2.html - {Version 3.3.2} {version 3.3.2}
- releaselog/3_3_3.html - {Version 3.3.3} {version 3.3.3}
- releaselog/3_3_4.html - {Version 3.3.4} {version 3.3.4}
- releaselog/3_3_5.html - {Version 3.3.5} {version 3.3.5}
- releaselog/3_3_6.html - {Version 3.3.6} {version 3.3.6}
- releaselog/3_3_7.html - {Version 3.3.7} {version 3.3.7}
- releaselog/3_3_8.html - {Version 3.3.8} {version 3.3.8}
- releaselog/3_3_9.html - {Version 3.3.9} {version 3.3.9}
- 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}
- 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}
- 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}
- 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#busy - SQLITE_BUSY
- rescode.html#busy_recovery - SQLITE_BUSY_RECOVERY
- rescode.html#busy_snapshot - SQLITE_BUSY_SNAPSHOT
- rescode.html#cantopen - SQLITE_CANTOPEN
- rescode.html#cantopen_convpath - SQLITE_CANTOPEN_CONVPATH
- rescode.html#cantopen_fullpath - SQLITE_CANTOPEN_FULLPATH
- rescode.html#cantopen_isdir - SQLITE_CANTOPEN_ISDIR
- rescode.html#cantopen_notempdir - SQLITE_CANTOPEN_NOTEMPDIR
- rescode.html#constraint - SQLITE_CONSTRAINT
- rescode.html#constraint_check - SQLITE_CONSTRAINT_CHECK
- rescode.html#constraint_commithook - SQLITE_CONSTRAINT_COMMITHOOK
- rescode.html#constraint_foreignkey - SQLITE_CONSTRAINT_FOREIGNKEY
- rescode.html#constraint_function - SQLITE_CONSTRAINT_FUNCTION
- rescode.html#constraint_notnull - SQLITE_CONSTRAINT_NOTNULL
- 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_vtab - SQLITE_CORRUPT_VTAB
- rescode.html#done - SQLITE_DONE
- rescode.html#empty - SQLITE_EMPTY
- rescode.html#error - SQLITE_ERROR
- 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_blocked - SQLITE_IOERR_BLOCKED
- rescode.html#ioerr_checkreservedlock - SQLITE_IOERR_CHECKRESERVEDLOCK
- rescode.html#ioerr_close - SQLITE_IOERR_CLOSE
- rescode.html#ioerr_convpath - SQLITE_IOERR_CONVPATH
- 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_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_write - SQLITE_IOERR_WRITE
- rescode.html#locked - SQLITE_LOCKED
- rescode.html#locked_sharedcache - SQLITE_LOCKED_SHAREDCACHE
- 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#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_cantlock - SQLITE_READONLY_CANTLOCK
- rescode.html#readonly_dbmoved - SQLITE_READONLY_DBMOVED
- 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
- rtree.html - {R-Tree extension} R-Trees RTREE rtree
- rtree.html#customquery - {custom r-tree queries}
- rtree.html#intrtree - {integer-valued r-trees}
- rtree.html#xquery - sqlite3_rtree_query_callback {xQueryFunc RTree callback}
- session/funclist.html - {Session Module C-API function list} session_funclist
- session/intro.html - {Session Module C-language Interface} session
- sharedcache.html - {SQLite Shared-Cache Mode} {shared cache} {shared cache mode}
- 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#pindex - {permuted index}
- spellfix1.html - spellfix1
- spellfix1.html#editdist3 - editdist3
- sqldiff.html - sqldiff sqldiff.exe
- support.html#mailinglists - {mailing lists}
- support.html#prosupport - {professional support}
- 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/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/foreign-key-clause.html - foreign-key-clause {foreign-key-clause 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/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/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-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-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/vacuum-stmt.html - vacuum-stmt {vacuum-stmt 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#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#copy - {TCL interface copy method} {copy 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#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#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#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#transaction - {TCL interface transaction method} {transaction 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#tempstore - tempstore
- testing.html - {test suite} tested testing
- testing.html#aflfuzz - {American Fuzzy Lop fuzzer}
- testing.html#coverage - {test coverage}
- 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#slt - SLT {SQL Logic Tests}
- testing.html#tcl - {TCL test suite}
- testing.html#testcase - {testcase macros}
- th3.html - TH3
- threadsafe.html - {threading mode}
- undoredo.html - {automated undo/redo stack} undo/redo undoredo
- 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#urinolock - {nolock query parameter}
- uri.html#uripsow - {psow query parameter}
- uri.html#urivfs - {vfs query parameter}
- versionnumbers.html - {version numbering conventions}
- vfs.html - {OS backend} VFS VFSes
- vfs.html#shim - {VFS shims} shims
- vtab.html - {virtual table} {virtual tables}
- vtab.html#colUsed - {colUsed field}
- vtab.html#epoonlyvtab - {eponymous-only virtual table}
- vtab.html#epovtab - {eponymous virtual table} {eponymous virtual tables}
- vtab.html#hiddencol - {hidden column} {hidden columns}
- vtab.html#sqlite3_module.xDestroy - xDestroy
- vtab.html#tabfunc2 - {table-valued function} {table-valued functions}
- 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#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#xsync - sqlite3_module.xSync
- vtab.html#xupdate - sqlite3_module.xUpdate xUpdate
- wal.html - WAL {WAL mode} {write-ahead log}
- wal.html#bigwal - {avoiding large WAL files} {large WAL files}
- wal.html#bkwrds - {WAL backwards compatibility}
- 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}
- whentouse.html#dbcklst - {decision checklist}
- whentouse.html#serversidedb - {server-side database}
- withoutrowid.html - {WITHOUT ROWID} {WITHOUT rowid}
- withoutrowid.html#bene - {benefits of using WITHOUT ROWID}
- withoutrowid.html#wtu - {when to use WITHOUT ROWID}