René's URL Explorer Experiment


Title: Release History Of SQLite

direct link

Domain: sqlite.org

Nonetext/html; charset=UTF-8

Links:

https://sqlite.org/index.html
Homehttps://sqlite.org/index.html
Menujavascript:void(0)
Abouthttps://sqlite.org/about.html
Documentationhttps://sqlite.org/docs.html
Downloadhttps://sqlite.org/download.html
Licensehttps://sqlite.org/copyright.html
Supporthttps://sqlite.org/support.html
Purchasehttps://sqlite.org/prosupport.html
Searchjavascript:void(0)
Abouthttps://sqlite.org/about.html
Documentationhttps://sqlite.org/docs.html
Downloadhttps://sqlite.org/download.html
Supporthttps://sqlite.org/support.html
Purchasehttps://sqlite.org/prosupport.html
https://sqlite.org/src/timelinehttps://sqlite.org/src/timeline
https://sqlite.org/src/timeline?t=releasehttps://sqlite.org/src/timeline?t=release
chronologyhttps://sqlite.org/chronology.html
fts5vocabhttps://sqlite.org/fts5.html#the_fts5vocab_virtual_table_module
jsonb_each()https://sqlite.org/json1.html#jbeach
jsonb_tree()https://sqlite.org/json1.html#jbtree
JSONBhttps://sqlite.org/json1.html#jsonbx
carrayhttps://sqlite.org/carray.html
percentilehttps://sqlite.org/percentile.html
the amalgamationhttps://sqlite.org/amalgamation.html
-DSQLITE_ENABLE_CARRAYhttps://sqlite.org/compile.html#enable_carray
-DSQLITE_ENABLE_PERCENTILEhttps://sqlite.org/compile.html#enable_percentile
TCL Interfacehttps://sqlite.org/tclsqlite.html
CLIhttps://sqlite.org/cli.html
imposter tableshttps://sqlite.org/imposter.html
VACUUMhttps://sqlite.org/lang_vacuum.html
.open commandhttps://sqlite.org/cli.html#dotopen
PRAGMA wal_checkpoint=NOOP;https://sqlite.org/pragma.html#pragma_wal_checkpoint
SQLITE_CHECKPOINT_NOOPhttps://sqlite.org/c3ref/c_checkpoint_full.html
sqlite3_wal_checkpoint_v2()https://sqlite.org/c3ref/wal_checkpoint_v2.html
sqlite3_set_errmsg()https://sqlite.org/c3ref/set_errmsg.html
sqlite3_db_status64()https://sqlite.org/c3ref/db_status.html
sqlite3_db_status()https://sqlite.org/c3ref/db_status.html
SQLITE_DBSTATUS_TEMPBUF_SPILLhttps://sqlite.org/c3ref/c_dbstatus_options.html
sqlite3_db_status()https://sqlite.org/c3ref/db_status.html
sqlite3_db_status64()https://sqlite.org/c3ref/db_status.html
session extensionhttps://sqlite.org/sessionintro.html
sqlite3changeset_apply_v3()https://sqlite.org/session/sqlite3changeset_apply.html
built-in printf()https://sqlite.org/printf.html
format() SQL functionhttps://sqlite.org/lang_corefunc.html#format
FTS5https://sqlite.org/fts5.html
breaking Posix advisory locks using close()https://sqlite.org/howtocorrupt.html#posix_close_bug
Forum post f4878de3ehttps://sqlite.org/forum/forumpost/f4878de3e7dd4764
concat_ws()https://sqlite.org/lang_corefunc.html#concat_ws
Forum post 52503ac21dhttps://sqlite.org/forum/forumpost/52503ac21d
Forum post b490f726dbhttps://sqlite.org/forum/forumpost/b490f726db
jsonb_set()https://sqlite.org/json1.html#jsetb
-DSQLITE_DEFAULT_MEMSTATUS=0https://sqlite.org/compile.html#default_memstatus
sqlite3_rsynchttps://sqlite.org/rsync.html
flattenedhttps://sqlite.org/optoverview.html#flattening
sqlite3_setlk_timeout()https://sqlite.org/c3ref/setlk_timeout.html
sqlite3_setlk_timeout()https://sqlite.org/c3ref/setlk_timeout.html
sqlite3_busy_timeout()https://sqlite.org/c3ref/busy_timeout.html
SQLITE_DBCONFIG_ENABLE_COMMENTShttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigenablecomments
previous releasehttps://sqlite.org/changes.html#version_3_49_0
sqlite_schemahttps://sqlite.org/schematab.html
unistr()https://sqlite.org/lang_corefunc.html#unistr
unistr_quote()https://sqlite.org/lang_corefunc.html#unistr_quote
%Q and %q conversionshttps://sqlite.org/printf.html#percentq
built-in printf()https://sqlite.org/printf.html
sqlite3_mprintf()https://sqlite.org/c3ref/mprintf.html
format() SQL functionhttps://sqlite.org/lang_corefunc.html#format
alternate-form-1 flaghttps://sqlite.org/printf.html#alt1
control charactershttps://sqlite.org/cli.html#ctrlchr
unistr()https://sqlite.org/lang_corefunc.html#unistr
control charactershttps://sqlite.org/cli.html#ctrlchr
.dump commandhttps://sqlite.org/cli.html#dump
unistr()https://sqlite.org/lang_corefunc.html#unistr
".schema --indent" commandhttps://sqlite.org/cli.html#dschema
sqlite3_rsynchttps://sqlite.org/rsync.html
json_group_object(LABEL,VALUE)https://sqlite.org/json1.html#jgroupobject
jsonb_set()https://sqlite.org/json1.html#jsetb
jsonb_replace()https://sqlite.org/json1.html#jreplb
JSONBhttps://sqlite.org/json1.html#jsonbx
version 3.40.0 change loghttps://sqlite.org/changes.html#version_3_40_0
concat_ws()https://sqlite.org/lang_corefunc.html#concat_ws
version 3.44.0https://sqlite.org/changes.html#version_3_44_0
SQLITE_DBCONFIG_LOOKASIDEhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfiglookaside
query plannerhttps://sqlite.org/optoverview.html
query-time indexhttps://sqlite.org/optoverview.html#autoindex
WITHOUT ROWIDhttps://sqlite.org/withoutrowid.html
star-queryhttps://sqlite.org/queryplanner-ng.html#starq
iif() SQL functionhttps://sqlite.org/lang_corefunc.html#iif
session extensionhttps://sqlite.org/sessionintro.html
generated columnshttps://sqlite.org/gencol.html
CLIhttps://sqlite.org/cli.html
sqlite3_db_config()https://sqlite.org/c3ref/db_config.html
SQLITE_DBCONFIG_ENABLE_ATTACH_CREATEhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigenableattachcreate
SQLITE_DBCONFIG_ENABLE_ATTACH_WRITEhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigenableattachwrite
SQLITE_DBCONFIG_ENABLE_COMMENTShttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigenablecomments
Autotoolshttps://en.wikipedia.org/wiki/GNU_Autotools
Autosetuphttps://msteveb.github.io/autosetup/
precompiled amalgamation tarballhttps://sqlite.org/amalgamation.html#amalgtarball
canonical source codehttps://sqlite.org/amalg-v-canon.html#canon
TEAhttps://www.tcl-lang.org/doc/tea/TEAOverview.html
canonical sourceshttps://sqlite.org/amalg-v-canon.html#canon
canonical sourceshttps://sqlite.org/amalg-v-canon.html#canon
Autosetuphttps://msteveb.github.io/autosetup/
GNU Autoconfhttps://www.gnu.org/software/autoconf/
TCLhttps://en.wikipedia.org/wiki/Tcl
sqlite3_analyzerhttps://sqlite.org/sqlanalyze.html
EXPLAIN QUERY PLANhttps://sqlite.org/eqp.html
covering indexeshttps://sqlite.org/queryplanner.html#covidx
iif() SQL functionhttps://sqlite.org/lang_corefunc.html#iif
if()https://sqlite.org/lang_corefunc.html#iif
iif()https://sqlite.org/lang_corefunc.html#iif
CLIhttps://sqlite.org/cli.html
SQLITE_IOCAP_SUBPAGE_READhttps://sqlite.org/c3ref/c_iocap_atomic.html
sqlite3_io_methodshttps://sqlite.org/c3ref/io_methods.html
SQLITE_PREPARE_DONT_LOGhttps://sqlite.org/c3ref/c_prepare_dont_log.html#sqlitepreparedontlog
sqlite3_prepare_v3()https://sqlite.org/c3ref/prepare.html
error loghttps://sqlite.org/errlog.html
SQLITE_LIMIT_LENGTHhttps://sqlite.org/c3ref/c_limit_attached.html#sqlitelimitlength
SQLITE_FCNTL_NULL_IOhttps://sqlite.org/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlnullio
insttokenhttps://sqlite.org/fts5.html#the_insttoken_configuration_option
fts5_insttoken()https://sqlite.org/fts5.html#the_fts5_insttoken_function
maximum number of arguments to an SQL functionhttps://sqlite.org/limits.html#max_function_arg
forum thread 569a7209179a7f5ehttps://sqlite.org/forum/forumpost/569a7209179a7f5e
SQLITE_IOCAP_SUBPAGE_READhttps://sqlite.org/c3ref/c_iocap_atomic.html
RAISE functionhttps://sqlite.org/lang_createtrigger.html#raise
the ->> operatorhttps://sqlite.org/json1.html#jptr
unix-dotfile VFShttps://sqlite.org/vfs.html#standard_unix_vfses
group_concat() aggregate functionhttps://sqlite.org/lang_aggfunc.html#group_concat
generate_series()https://sqlite.org/series.html
IN operatorhttps://sqlite.org/lang_expr.html#in_op
predicate push-downhttps://sqlite.org/optoverview.html#pushdown
IN operatorhttps://sqlite.org/lang_expr.html#in_op
automatic indexeshttps://sqlite.org/optoverview.html#autoindex
subtypehttps://sqlite.org/c3ref/value_subtype.html
sqlite3_rsynchttps://sqlite.org/rsync.html
median()https://sqlite.org/lang_aggfunc.html#median
percentile()https://sqlite.org/lang_aggfunc.html#percentile
percentile_cont()https://sqlite.org/lang_aggfunc.html#percentile_cont
percentile_disc()https://sqlite.org/lang_aggfunc.html#percentile_disc
CLIhttps://sqlite.org/cli.html
.www dot-commandhttps://sqlite.org/cli.html#dotwww
CLIhttps://sqlite.org/cli.html
sqlite3_analyzerhttps://sqlite.org/sqlanalyze.html
sqldiffhttps://sqlite.org/sqldiff.html
sqlite_dbpagehttps://sqlite.org/dbpage.html
INSERThttps://sqlite.org/lang_insert.html
Dekker's algorithmhttps://csclub.uwaterloo.ca/~pbarfuss/dekker1971.pdf
TCL Interfacehttps://sqlite.org/tclsqlite.html
tokenize= argumentshttps://sqlite.org/fts5.html#tokenizers
FTS5https://sqlite.org/fts5.html
Forum post 171bcc2bcdhttps://sqlite.org/forum/forumpost/171bcc2bcd
covering indexhttps://sqlite.org/queryplanner.html#covidx
sqlite3_prepare()https://sqlite.org/c3ref/prepare.html
Forum post e60e4c295d22f8cehttps://sqlite.org/forum/forumpost/e60e4c295d22f8ce
VALUES clausehttps://sqlite.org/lang_select.html#values
SQLITE_LIMIT_COMPOUND_SELECThttps://sqlite.org/c3ref/c_limit_attached.html#sqlitelimitcompoundselect
double-quoted string literalshttps://sqlite.org/quirks.html#dblquote
window functionhttps://sqlite.org/windowfunctions.html
group_concat()https://sqlite.org/lang_aggfunc.html#group_concat
FTS5 secure-delete modehttps://sqlite.org/fts5.html#the_secure_delete_configuration_option
ALTER TABLEhttps://sqlite.org/lang_altertable.html
SQLITE_ERRORhttps://sqlite.org/rescode.html#error
SQLITE_INTERNALhttps://sqlite.org/rescode.html#internal
PRAGMA optimizehttps://sqlite.org/pragma.html#pragma_optimize
simpler to usehttps://sqlite.org/lang_analyze.html#pragopt
analysis limithttps://sqlite.org/pragma.html#pragma_analysis_limit
date and time functionshttps://sqlite.org/lang_datefunc.html
strftime() SQL functionhttps://sqlite.org/lang_datefunc.html#strftm
ambiguous dateshttps://sqlite.org/lang_datefunc.html#dtambg
'utc' and 'localtime' modifiershttps://sqlite.org/lang_datefunc.html#localtime
numeric literalshttps://sqlite.org/lang_expr.html#litvalue
json_pretty()https://sqlite.org/json1.html#jpretty
WHERE-clause push-down optimizationhttps://sqlite.org/optoverview.html#pushdown
the -> and ->> operatorshttps://sqlite.org/json1.html#jptr
version 3.24.0https://sqlite.org/changes.html#version_3_24_0
UPDATE triggerhttps://sqlite.org/lang_createtrigger.html
UPSERThttps://sqlite.org/lang_upsert.html
Forum post 284955a3cd454a15https://sqlite.org/forum/forumpost/284955a3cd454a15
sum()https://sqlite.org/lang_aggfunc.html#sumunc
Forum post 23b8688ef4https://sqlite.org/forum/forumpost/23b8688ef4
timelinehttps://sqlite.org/src/timeline?from=version-3.45.2&to=version-3.45.3&to2=branch-3.45
UPSERThttps://sqlite.org/lang_upsert.html
version 3.35.0https://sqlite.org/changes.html#version_3_35_0
Forum thread 919c6579c8https://sqlite.org/forum/forumpost/919c6579c8
version 3.35.0https://sqlite.org/changes.html#version_3_35_0
Forum thread 440f2a2f17https://sqlite.org/forum/forumpost/440f2a2f17
timelinehttps://sqlite.org/src/timeline?from=version-3.45.1&to=version-3.45.2&to2=branch-3.45
JSON BLOB input bughttps://sqlite.org/json1.html#jblobbug
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
version 3.44.0https://sqlite.org/changes.html#version_3_44_0
JSONBhttps://sqlite.org/json1.html#jsonbx
jfuzzhttps://sqlite.org/testing.html#dbsqlfuzz
memory-mapped databasehttps://sqlite.org/pragma.html#pragma_mmap_size
bytecode enginehttps://sqlite.org/opcode.html
SQLITE_RESULT_SUBTYPEhttps://sqlite.org/c3ref/c_deterministic.html#sqliteresultsubtype
application-defined SQL functionshttps://sqlite.org/appfunc.html
sqlite3_result_subtype()https://sqlite.org/c3ref/result_subtype.html
-DSQLITE_STRICT_SUBTYPE=1https://sqlite.org/compile.html#strict_subtype
SQLITE_RESULT_SUBTYPEhttps://sqlite.org/c3ref/c_deterministic.html#sqliteresultsubtype
sqlite3_result_subtype()https://sqlite.org/c3ref/result_subtype.html
-DSQLITE_STRICT_SUBTYPE=1https://sqlite.org/compile.html#strict_subtype
JSON SQL functionshttps://sqlite.org/json1.html
JSONBhttps://sqlite.org/json1.html#jsonbx
json_valid()https://sqlite.org/json1.html#jvalid
FTS5 tokendata optionhttps://sqlite.org/fts5.html#the_tokendata_option
FTS5https://sqlite.org/fts5.html
SQLITE_DIRECT_OVERFLOW_READhttps://sqlite.org/compile.html#direct_overflow_read
Forum post 2568d1f6e6https://sqlite.org/forum/forumpost/2568d1f6e6
ANALYZEhttps://sqlite.org/lang_analyze.html
Forum post 6f0958b03bhttps://sqlite.org/forum/forumpost/6f0958b03b
SQLITE_MAX_PAGE_COUNThttps://sqlite.org/limits.html#max_page_count
CLIhttps://sqlite.org/cli.html
CLIhttps://sqlite.org/cli.html
CLIhttps://sqlite.org/cli.html
Aggregate functionshttps://sqlite.org/lang_aggfunc.html
string_agg()https://sqlite.org/lang_aggfunc.html#group_concat
json_group_array()https://sqlite.org/json1.html#jgrouparray
concat()https://sqlite.org/lang_corefunc.html#concat
concat_ws()https://sqlite.org/lang_corefunc.html#concat_ws
string_agg()https://sqlite.org/lang_aggfunc.html#group_concat
strftime() SQL functionhttps://sqlite.org/lang_datefunc.html#strftm
sqlite3_get_clientdata()https://sqlite.org/c3ref/get_clientdata.html
sqlite3_set_clientdata()https://sqlite.org/c3ref/get_clientdata.html
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
virtual tableshttps://sqlite.org/vtab.html
xIntegrity methodhttps://sqlite.org/vtab.html#xintegrity
FTS3https://sqlite.org/fts3.html
FTS4https://sqlite.org/fts3.html#fts4
FTS5https://sqlite.org/fts5.html
RTREEhttps://sqlite.org/rtree.html
GEOPOLYhttps://sqlite.org/geopoly.html
SQLITE_DBCONFIG_DEFENSIVEhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigdefensive
PRAGMA writable_schemahttps://sqlite.org/pragma.html#pragma_writable_schema
FTS3https://sqlite.org/fts3.html
FTS4https://sqlite.org/fts3.html#fts4
FTS5https://sqlite.org/fts5.html
RTREEhttps://sqlite.org/rtree.html
GEOPOLYhttps://sqlite.org/geopoly.html
SQLITE_VTAB_INNOCUOUShttps://sqlite.org/c3ref/c_vtab_constraint_support.html#sqlitevtabinnocuous
PRAGMA case_sensitive_likehttps://sqlite.org/pragma.html#pragma_case_sensitive_like
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
SQLITE_USE_SEHhttps://sqlite.org/compile.html#use_seh
SQLITE_OMIT_SEHhttps://sqlite.org/compile.html#omit_seh
version 3.40.0https://sqlite.org/changes.html#version_3_40_0
CLIhttps://sqlite.org/cli.html
CLIhttps://sqlite.org/cli.html
sum()https://sqlite.org/lang_aggfunc.html#sumunc
avg()https://sqlite.org/lang_aggfunc.html#avg
total()https://sqlite.org/lang_aggfunc.html#sumunc
json_array_length()https://sqlite.org/json1.html#jarraylen
json_remove()https://sqlite.org/json1.html#jrm
Contentless-Delete FTS5 Indexeshttps://sqlite.org/fts5.html#clssdeltab
FTS5https://sqlite.org/fts5.html
date and time functionshttps://sqlite.org/lang_datefunc.html
time shift modifiershttps://sqlite.org/lang_datefunc.html#tmshf
timediff() SQL functionhttps://sqlite.org/lang_datefunc.html#tmdif
octet_length(X)https://sqlite.org/lang_corefunc.html#octet_length
sqlite3_stmt_explain()https://sqlite.org/c3ref/stmt_explain.html
OUTER JOIN strength reductionhttps://sqlite.org/optoverview.html#leftjoinreduction
OUTER JOIN strength reductionhttps://sqlite.org/optoverview.html#leftjoinreduction
decimal extensionhttps://sqlite.org/floatingpoint.html#decext
JSON processinghttps://sqlite.org/json1.html
canonical source codehttps://sqlite.org/amalg-v-canon.html#canon
precompiled amalgamation tarballshttps://sqlite.org/amalgamation.html#amalgtarball
SQLITE_USE_SEHhttps://sqlite.org/compile.html#use_seh
shm filehttps://sqlite.org/walformat.html#shm
WAL modehttps://sqlite.org/wal.html
VFShttps://sqlite.org/vfs.html
FTS5 secure-delete commandhttps://sqlite.org/fts5.html#the_secure_delete_configuration_option
JSON SQL functionshttps://sqlite.org/json1.html
JSON5 extensionshttps://sqlite.org/json1.html#json5
SQLITE_CONFIG_LOGhttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfiglog
SQLITE_CONFIG_PCACHE_HDRSZhttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfigpcachehdrsz
sqlite3_config()https://sqlite.org/c3ref/config.html
sqlite3_initialize()https://sqlite.org/c3ref/initialize.html
sqlite3_db_config()https://sqlite.org/c3ref/db_config.html
SQLITE_DBCONFIG_STMT_SCANSTATUShttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigstmtscanstatus
SQLITE_DBCONFIG_REVERSE_SCANORDERhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigreversescanorder
WHERE-clause push-down optimizationhttps://sqlite.org/optoverview.html#pushdown
CLIhttps://sqlite.org/cli.html
application-defined SQL functionshttps://sqlite.org/appfunc.html
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
session extensionhttps://sqlite.org/sessionintro.html
subsecond modifierhttps://sqlite.org/lang_datefunc.html#subsec
date and time functionshttps://sqlite.org/lang_datefunc.html
sqlite3_sleep()https://sqlite.org/c3ref/sleep.html
built-in printf()https://sqlite.org/printf.html
comma optionhttps://sqlite.org/printf.html#comma
SQLITE_ENABLE_STAT4https://sqlite.org/compile.html#enable_stat4
CLIhttps://sqlite.org/cli.html
sqlite3_error_offset()https://sqlite.org/c3ref/errcode.html
recovery extensionhttps://sqlite.org/recovery.html
FTS3https://sqlite.org/fts3.html
sqlite3_error_offset()https://sqlite.org/c3ref/errcode.html
generated columnshttps://sqlite.org/gencol.html
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
timeline of changeshttps://sqlite.org/src/timeline?from=version-3.41.0&to=version-3.41.1
indexed expressionshttps://sqlite.org/expridx.html
covering indexhttps://sqlite.org/queryplanner.html#covidx
co-routineshttps://sqlite.org/optoverview.html#coroutines
json_tree()https://sqlite.org/json1.html#jtree
json_each()https://sqlite.org/json1.html#jeach
indexed expressionshttps://sqlite.org/expridx.html
constant-propagation optimizationhttps://sqlite.org/optoverview.html#constprop
forum thread 0a539c7https://sqlite.org/forum/forumpost/0a539c76db3b9e29
unhex()https://sqlite.org/lang_corefunc.html#unhex
CLIhttps://sqlite.org/cli.html
sqlite3_stmt_scanstatus_v2()https://sqlite.org/c3ref/stmt_scanstatus.html
SQLITE_ENABLE_STMT_SCANSTATUShttps://sqlite.org/compile.html#enable_stmt_scanstatus
sqlite3_deserialize()https://sqlite.org/c3ref/deserialize.html
CLIhttps://sqlite.org/cli.html
EXPLAIN QUERY PLANhttps://sqlite.org/eqp.html
sqlite3_stmt_scanstatus_v2()https://sqlite.org/c3ref/stmt_scanstatus.html
SQLITE_ENABLE_STMT_SCANSTATUShttps://sqlite.org/compile.html#enable_stmt_scanstatus
double-quoted string misfeaturehttps://sqlite.org/quirks.html#dblquote
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
carray table-valued functionhttps://sqlite.org/carray.html
sqlite3_is_interrupted()https://sqlite.org/c3ref/interrupt.html
sqlite3_prepare()https://sqlite.org/c3ref/prepare.html
progress handler callbackhttps://sqlite.org/c3ref/progress_handler.html
sqlite3_interrupt()https://sqlite.org/c3ref/interrupt.html
sqlite3_vtab_in_first()https://sqlite.org/c3ref/vtab_in_first.html
sqlite3_vtab_in_next()https://sqlite.org/c3ref/vtab_in_first.html
sqlite3_vtab_in()https://sqlite.org/c3ref/vtab_in.html
SQLITE_FCNTL_RESET_CACHEhttps://sqlite.org/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlresetcache
sqlite3_file_control()https://sqlite.org/c3ref/file_control.html
amalgamationhttps://sqlite.org/amalgamation.html
recovery extensionhttps://sqlite.org/recovery.html
--safe command-line optionhttps://sqlite.org/cli.html#safemode
CLIhttps://sqlite.org/cli.html
memsys5https://sqlite.org/malloc.html#memsys5
SQLite to WASMhttps://sqlite.org/wasm
recovery extensionhttps://sqlite.org/recovery.html
covering indexeshttps://sqlite.org/queryplanner.html#covidx
expression indexeshttps://sqlite.org/expridx.html
sqlite3_filenamehttps://sqlite.org/c3ref/filename.html
sqlite3_value_encoding()https://sqlite.org/c3ref/value_encoding.html
SQLITE_DBCONFIG_DEFENSIVEhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigdefensive
schema_versionhttps://sqlite.org/pragma.html#pragma_schema_version
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
WITHOUT ROWIDhttps://sqlite.org/withoutrowid.html
VACUUM INTOhttps://sqlite.org/lang_vacuum.html#vacuuminto
PRAGMA synchronoushttps://sqlite.org/pragma.html#pragma_synchronous
sqlite3_strglob()https://sqlite.org/c3ref/strglob.html
sqlite3_strlike()https://sqlite.org/c3ref/strlike.html
SQLITE_MAX_ALLOCATION_SIZEhttps://sqlite.org/compile.html#max_allocation_size
application-defined page cachehttps://sqlite.org/c3ref/pcache_methods2.html
SQLITE_DBCONFIG_DEFENSIVEhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigdefensive
CREATE TRIGGERhttps://sqlite.org/lang_createtrigger.html
shadow tableshttps://sqlite.org/vtab.html#xshadowname
sqlite3_set_auxdata()https://sqlite.org/c3ref/get_auxdata.html
ICU Extensionhttps://sqlite.org/src/dir/ext/icu
forum thread 9b9e4716c0d7bbd1https://sqlite.org/forum/forumpost/9b9e4716c0d7bbd1
PRAGMA temp_store_directoryhttps://sqlite.org/pragma.html#pragma_temp_store_directory
PRAGMA data_store_directoryhttps://sqlite.org/pragma.html#pragma_data_store_directory
forum post 719a11e1314d1c70https://sqlite.org/forum/forumpost/719a11e1314d1c70
timelinehttps://sqlite.org/src/timeline?p=version-3.39.3&bt=version-3.39.2
forum post 3607259d3chttps://sqlite.org/forum/forumpost/3607259d3c
forum post 174afeae5734d42dhttps://sqlite.org/forum/forumpost/174afeae5734d42d
ALTER TABLE RENAMEhttps://sqlite.org/lang_altertable.html#altertabrename
sqlite3_limithttps://sqlite.org/c3ref/limit.html
SQLITE_LIMIT_SQL_LENGTHhttps://sqlite.org/c3ref/c_limit_attached.html#sqlitelimitsqllength
FTS3https://sqlite.org/fts3.html
SQLITE_ENABLE_FTS3_PARENTHESIShttps://sqlite.org/compile.html#enable_fts3_parenthesis
SQLITE_DEBUGhttps://sqlite.org/compile.html#debug
SQLITE_OMIT_WINDOWFUNChttps://sqlite.org/compile.html#omit_windowfunc
REGEXPhttps://sqlite.org/lang_expr.html#regexp
sqlite_stmthttps://sqlite.org/stmt.html
RIGHT and FULL OUTER JOINhttps://sqlite.org/lang_select.html#rjoin
IS NOT DISTINCT FROMhttps://sqlite.org/lang_expr.html#isdf
IS DISTINCT FROMhttps://sqlite.org/lang_expr.html#isdf
sqlite3_vtab_distinct()https://sqlite.org/c3ref/vtab_distinct.html
sqlite3_db_name()https://sqlite.org/c3ref/db_name.html
SQLITE_OPEN_NOFOLLOWhttps://sqlite.org/c3ref/c_open_autoproxy.html
sqlite3_open_v2()https://sqlite.org/c3ref/open.html
HAVING clausehttps://sqlite.org/lang_select.html#resultset
SELECT statementhttps://sqlite.org/lang_select.html
GROUP BY clausehttps://sqlite.org/lang_select.html#resultset
microoptimizationshttps://sqlite.org/cpu.html#microopt
a blunderhttps://sqlite.org/news.html#2022_05_06
CLIhttps://sqlite.org/cli.html
Forum thread 2482b32700384a0fhttps://sqlite.org/forum/forumpost/2482b32700384a0f
timelinehttps://sqlite.org/src/timeline?p=branch-3.38&bt=version-3.38.3
Forum thread 0d3200f4f3bcd3a3https://sqlite.org/forum/forumpost/0d3200f4f3bcd3a3
timelinehttps://sqlite.org/src/timeline?p=version-3.38.3&bt=version-3.38.2
forum thread 031e262a89b6a9d2https://sqlite.org/forum/forumpost/031e262a89b6a9d2
timelinehttps://sqlite.org/src/timeline?p=version-3.38.2&bt=version-3.38.1
localtime modifierhttps://sqlite.org/lang_datefunc.html#localtime
date and time functionshttps://sqlite.org/lang_datefunc.html
sqlite_offset SQL functionhttps://sqlite.org/lang_corefunc.html#sqlite_offset
row value IN operatorhttps://sqlite.org/rowvalue.html#rvinop
virtual tableshttps://sqlite.org/vtab.html
source code timelinehttps://sqlite.org/src/timeline?p=version-3.38.1&bt=version-3.38.0
the -> and ->> operatorshttps://sqlite.org/json1.html#jptr
-DSQLITE_ENABLE_JSON1https://sqlite.org/compile.html#enable_json1
-DSQLITE_OMIT_JSONhttps://sqlite.org/compile.html#omit_json
date and time functionshttps://sqlite.org/lang_datefunc.html
unixepoch() functionhttps://sqlite.org/lang_datefunc.html#uepch
auto modifierhttps://sqlite.org/lang_datefunc.html#automod
julianday modifierhttps://sqlite.org/lang_datefunc.html#jdmod
printf() SQL functionhttps://sqlite.org/lang_corefunc.html#printf
format()https://sqlite.org/lang_corefunc.html#format
sqlite3_error_offset()https://sqlite.org/c3ref/errcode.html
virtual tableshttps://sqlite.org/vtab.html
sqlite3_vtab_distinct()https://sqlite.org/c3ref/vtab_distinct.html
sqlite3_vtab_rhs_value()https://sqlite.org/c3ref/vtab_rhs_value.html
SQLITE_INDEX_CONSTRAINT_LIMIThttps://sqlite.org/c3ref/c_index_constraint_eq.html
SQLITE_INDEX_CONSTRAINT_OFFSEThttps://sqlite.org/c3ref/c_index_constraint_eq.html
sqlite3_vtab_in()https://sqlite.org/c3ref/vtab_in.html
IN operatorhttps://sqlite.org/lang_expr.html#in_op
CLIhttps://sqlite.org/cli.html
Columnar output modeshttps://sqlite.org/cli.html#clmnr
columnar output modeshttps://sqlite.org/cli.html#clmnr
.mode qboxhttps://sqlite.org/cli.html#qbox
.import commandhttps://sqlite.org/cli.html#csv
sqlite3_error_offset()https://sqlite.org/c3ref/errcode.html
ALTER TABLEhttps://sqlite.org/lang_altertable.html
sqlite_schema tablehttps://sqlite.org/schematab.html
PRAGMA writable_schema=ONhttps://sqlite.org/pragma.html#pragma_writable_schema
a bughttps://sqlite.org/forum/forumpost/b03d86f9516cb3a2
version 3.35.0https://sqlite.org/changes.html#version_3_35_0
can cause database corruptionhttps://sqlite.org/howtocorrupt.html#svptbug
SAVEPOINThttps://sqlite.org/lang_savepoint.html
PRAGMA temp_store=MEMORYhttps://sqlite.org/pragma.html#pragma_temp_store
Check-in 73c2b50211d3ae26https://sqlite.org/src/info/73c2b50211d3ae26
bytecodehttps://sqlite.org/opcode.html
Check-in 5232c9777fe4fb13https://sqlite.org/src/info/5232c9777fe4fb13
UPSERThttps://sqlite.org/lang_upsert.html
version 3.35.0https://sqlite.org/changes.html#version_3_35_0
FTS5https://sqlite.org/fts5.html
CLIhttps://sqlite.org/cli.html
STRICT tableshttps://sqlite.org/stricttables.html
CHECK constrainthttps://sqlite.org/lang_createtable.html#ckconst
generated columnhttps://sqlite.org/gencol.html
NOT NULL constrainthttps://sqlite.org/lang_createtable.html#notnullconst
ALTER TABLE ADD COLUMNhttps://sqlite.org/lang_altertable.html#altertabaddcol
PRAGMA table_listhttps://sqlite.org/pragma.html#pragma_table_list
CLIhttps://sqlite.org/cli.html
.connectionhttps://sqlite.org/cli.html#dotconn
--safe command-line optionhttps://sqlite.org/cli.html#safemode
dot-commandshttps://sqlite.org/cli.html#dotcmd
sqlite3_autovacuum_pages()https://sqlite.org/c3ref/autovacuum_pages.html
sqlite3_deserialize()https://sqlite.org/c3ref/deserialize.html
generate_serieshttps://sqlite.org/series.html
sqlite3_changes64()https://sqlite.org/c3ref/changes.html
sqlite3_total_changes64()https://sqlite.org/c3ref/total_changes.html
SQLITE_OPEN_EXRESCODEhttps://sqlite.org/c3ref/c_open_autoproxy.html
sqlite3_open_v2()https://sqlite.org/c3ref/open.html
EXPLAIN QUERY PLANhttps://sqlite.org/eqp.html
rowidhttps://sqlite.org/lang_createtable.html#rowid
sqlite3_deserialize()https://sqlite.org/c3ref/deserialize.html
sqlite3_serialize()https://sqlite.org/c3ref/serialize.html
-DSQLITE_OMIT_DESERIALIZEhttps://sqlite.org/compile.html#omit_deserialize
SQLite 3.35.0 change loghttps://sqlite.org/changes.html#version_3_35_0
constant-propagation optimizationhttps://sqlite.org/optoverview.html#constprop
REGEXP extensionhttps://sqlite.org/src/file/ext/misc/regexp.c
CLIhttps://sqlite.org/cli.html
de7db14784a08053https://sqlite.org/src/info/de7db14784a08053
RETURNINGhttps://sqlite.org/lang_returning.html
132994c8b1063bfbhttps://sqlite.org/src/info/132994c8b1063bfb
RETURNINGhttps://sqlite.org/lang_returning.html
push-down optimizationhttps://sqlite.org/optoverview.html#pushdown
bytecode enginehttps://sqlite.org/opcode.html
ticket bb8a9fd4a9b7fce5https://sqlite.org/src/info/bb8a9fd4a9b7fce5
common table expressionshttps://sqlite.org/lang_with.html
VFShttps://sqlite.org/vfs.html
"box" output modehttps://sqlite.org/cli.html#dotmode
CLIhttps://sqlite.org/cli.html
PRAGMA incremental_vacuumhttps://sqlite.org/pragma.html#pragma_incremental_vacuum
Forum post afbbcb5b72https://sqlite.org/forum/forumpost/afbbcb5b72
Forum post aa5a0431c99ehttps://sqlite.org/forum/forumpost/aa5a0431c99e631
SELECT statement syntax diagramhttps://sqlite.org/syntax/select-stmt.html
Forum post 9ed02582fehttps://sqlite.org/forum/forumpost/9ed02582fe
Forum post 58540ce22dcdhttps://sqlite.org/forum/forumpost/58540ce22dcd5fdcd
xBestIndexhttps://sqlite.org/vtab.html#xbestindex
wholenumber virtual tablehttps://sqlite.org/src/file/ext/misc/wholenumber.c
Forum post b52a020ce4https://sqlite.org/forum/forumpost/b52a020ce4
appendvfs.chttps://sqlite.org/src/file/ext/misc/appendvfs.c
non-deterministic functionshttps://sqlite.org/deterministic.html
2c6c8689fb5f3d2fhttps://sqlite.org/src/info/2c6c8689fb5f3d2f
sqldiffhttps://sqlite.org/sqldiff.html
virtual tablehttps://sqlite.org/vtab.html
forum thread 140a67d3d2https://sqlite.org/forum/forumpost/140a67d3d2
a bughttps://sqlite.org/src/info/1c24a659e6d7f3a1
.dumphttps://sqlite.org/cli.html#dump
CLIhttps://sqlite.org/cli.html
built-in SQL math functions()https://sqlite.org/lang_mathfunc.html
-DSQLITE_ENABLE_MATH_FUNCTIONShttps://sqlite.org/compile.html#enable_math_functions
ALTER TABLE DROP COLUMNhttps://sqlite.org/lang_altertable.html#altertabdropcol
UPSERThttps://sqlite.org/lang_upsert.html
RETURNINGhttps://sqlite.org/lang_returning.html
DELETEhttps://sqlite.org/lang_delete.html
INSERThttps://sqlite.org/lang_insert.html
UPDATEhttps://sqlite.org/lang_update.html
VACUUMhttps://sqlite.org/lang_vacuum.html
MATERIALIZEDhttps://sqlite.org/lang_with.html#mathint
NOT MATERIALIZEDhttps://sqlite.org/lang_with.html#mathint
common table expressionshttps://sqlite.org/lang_with.html
SQLITE_DBCONFIG_ENABLE_TRIGGERhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigenabletrigger
SQLITE_DBCONFIG_ENABLE_VIEWhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigenableview
min/max optimizationhttps://sqlite.org/optoverview.html#minmax
flattenedhttps://sqlite.org/optoverview.html#flattening
pushed downhttps://sqlite.org/optoverview.html#pushdown
CLIhttps://sqlite.org/cli.html
bug in the IN-operator optimizationhttps://sqlite.org/src/info/ee51301f316c09e9
LIKE operatorhttps://sqlite.org/lang_expr.html#like
sqlite3_txn_state()https://sqlite.org/c3ref/txn_state.html
recursive common table expressionshttps://sqlite.org/lang_with.html#recursivecte
queries against graphshttps://sqlite.org/lang_with.html#rcex3
CHECK constrainthttps://sqlite.org/lang_createtable.html#ckconst
CLIhttps://sqlite.org/cli.html
.readhttps://sqlite.org/cli.html#dotread
.dumphttps://sqlite.org/cli.html#dump
.schemahttps://sqlite.org/cli.html#dschema
.importhttps://sqlite.org/cli.html#csv
generate_series(START,END,STEP)https://sqlite.org/series.html
.databaseshttps://sqlite.org/cli.html#dotdatabases
sqlite3_db_readonly()https://sqlite.org/c3ref/db_readonly.html
sqlite3_txn_state()https://sqlite.org/c3ref/txn_state.html
.mode tabshttps://sqlite.org/cli.html#dotmode
BEGIN IMMEDIATEhttps://sqlite.org/lang_transaction.html#immediate
BEGIN EXCLUSIVEhttps://sqlite.org/lang_transaction.html#immediate
FTS5https://sqlite.org/fts5.html
trigram indexeshttps://sqlite.org/fts5.html#trigramidx
WAL modehttps://sqlite.org/wal.html
carray() table-valued functionhttps://sqlite.org/carray.html
sqlite3_carray_bind()https://sqlite.org/c3ref/carray_bind.html
substr() SQL functionhttps://sqlite.org/lang_corefunc.html#substr
syntax diagramshttps://sqlite.org/syntaxdiagrams.html
Pikchrhttps://pikchr.org/
UPDATE FROMhttps://sqlite.org/lang_update.html#upfrom
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
decimal extensionhttps://sqlite.org/floatingpoint.html#decext
ieee754 extensionhttps://sqlite.org/floatingpoint.html#ieee754ext
CLIhttps://sqlite.org/cli.html
output modeshttps://sqlite.org/cli.html#dotmode
decimal extensionhttps://sqlite.org/floatingpoint.html#decext
ieee754 extensionhttps://sqlite.org/floatingpoint.html#ieee754ext
INDEXED BYhttps://sqlite.org/lang_indexedby.html
sqlite_stat1https://sqlite.org/fileformat2.html#stat1tab
WAL modehttps://sqlite.org/wal.html
shm filehttps://sqlite.org/walformat.html#shm
SQLITE_PROTOCOLhttps://sqlite.org/rescode.html#protocol
8f157e8010b22af0https://sqlite.org/src/info/8f157e8010b22af0
9fb26d37cefaba40https://sqlite.org/src/info/9fb26d37cefaba40
e367f31901ea8700https://sqlite.org/src/info/e367f31901ea8700
b706351ce2ecf59ahttps://sqlite.org/src/info/b706351ce2ecf59a
7c6d876f84e6e7e2https://sqlite.org/src/info/7c6d876f84e6e7e2
c8d3b9f0a750a529https://sqlite.org/src/info/c8d3b9f0a750a529
COMMIThttps://sqlite.org/lang_transaction.html
810dc8038872e212https://sqlite.org/src/info/810dc8038872e212
approximate ANALYZEhttps://sqlite.org/lang_analyze.html#approx
PRAGMA analysis_limithttps://sqlite.org/pragma.html#pragma_analysis_limit
bytecode virtual tablehttps://sqlite.org/bytecodevtab.html
checksum VFS shimhttps://sqlite.org/cksumvfs.html
iif() SQL functionhttps://sqlite.org/lang_corefunc.html#iif
column affinityhttps://sqlite.org/datatype3.html#affinity
CHECK constraintshttps://sqlite.org/lang_createtable.html#ckconst
86ba67afafded936https://sqlite.org/src/info/86ba67afafded936
sqlite3_create_filename()https://sqlite.org/c3ref/create_filename.html
sqlite3_free_filename()https://sqlite.org/c3ref/create_filename.html
sqlite3_database_file_object()https://sqlite.org/c3ref/database_file_object.html
VFS shimhttps://sqlite.org/vfs.html#shim
default upper boundhttps://sqlite.org/limits.html#max_variable_number
parametershttps://sqlite.org/lang_expr.html#varparam
UINT collating sequencehttps://sqlite.org/uintcseq.html
loadable extensionhttps://sqlite.org/loadext.html
CLIhttps://sqlite.org/cli.html
.importhttps://sqlite.org/cli.html#csv
.dumphttps://sqlite.org/cli.html#dump
.excelhttps://sqlite.org/cli.html#dotexcel
.outputhttps://sqlite.org/cli.html#dotoutput
.oncehttps://sqlite.org/cli.html#dotoutput
UINT collating sequencehttps://sqlite.org/uintcseq.html
ESCAPEhttps://sqlite.org/lang_expr.html#like
LIKEhttps://sqlite.org/lang_expr.html#like
sqlite3_stmt_isexplain()https://sqlite.org/c3ref/stmt_isexplain.html
sqlite3_value_frombind()https://sqlite.org/c3ref/value_blob.html
run-time loadable extensionshttps://sqlite.org/loadext.html
generated columnshttps://sqlite.org/gencol.html
sqlite3_hard_heap_limit64()https://sqlite.org/c3ref/hard_heap_limit64.html
PRAGMA hard_heap_limithttps://sqlite.org/pragma.html#pragma_hard_heap_limit
function_list pragmahttps://sqlite.org/pragma.html#pragma_function_list
SQLITE_DETERMINISTIChttps://sqlite.org/c3ref/c_deterministic.html#sqlitedeterministic
SQLITE_DIRECTONLYhttps://sqlite.org/c3ref/c_deterministic.html#sqlitedirectonly
SQLITE_INNOCUOUShttps://sqlite.org/c3ref/c_deterministic.html#sqliteinnocuous
SQLITE_SUBTYPEhttps://sqlite.org/c3ref/c_deterministic.html#sqlitesubtype
aggregated modehttps://sqlite.org/dbstat.html#dbstatagg
DBSTAT virtual tablehttps://sqlite.org/dbstat.html
SQLITE_OPEN_NOFOLLOWhttps://sqlite.org/c3ref/open.html#opennofollow
sqlite3_open_v2()https://sqlite.org/c3ref/open.html
JSON function path argumentshttps://sqlite.org/json1.html#jsonpath
SQLITE_DBCONFIG_TRUSTED_SCHEMAhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigtrustedschema
trusted_schema pragmahttps://sqlite.org/pragma.html#pragma_trusted_schema
-DSQLITE_TRUSTED_SCHEMAhttps://sqlite.org/compile.html#trusted_schema
sqlite3_filename_database()https://sqlite.org/c3ref/filename_database.html
sqlite3_filename_journal()https://sqlite.org/c3ref/filename_database.html
sqlite3_filename_wal()https://sqlite.org/c3ref/filename_database.html
sqlite3_uri_key()https://sqlite.org/c3ref/uri_boolean.html
sqlite3_uri_parameter()https://sqlite.org/c3ref/uri_boolean.html
application-defined SQL functionshttps://sqlite.org/appfunc.html
SQLITE_INNOCUOUShttps://sqlite.org/c3ref/c_deterministic.html#sqliteinnocuous
SQLITE_DIRECTONLYhttps://sqlite.org/c3ref/c_deterministic.html#sqlitedirectonly
sqlite3_vtab_config()https://sqlite.org/c3ref/vtab_config.html
xConnecthttps://sqlite.org/vtab.html#xconnect
SQLITE_VTAB_INNOCUOUShttps://sqlite.org/c3ref/c_vtab_constraint_support.html#sqlitevtabinnocuous
SQLITE_VTAB_DIRECTONLYhttps://sqlite.org/c3ref/c_vtab_constraint_support.html#sqlitevtabdirectonly
sqlite3_interrupt()https://sqlite.org/c3ref/interrupt.html
uuid.chttps://sqlite.org/src/file/ext/misc/uuid.c
lookaside memory allocatorhttps://sqlite.org/malloc.html#lookaside
legacy_file_format pragmahttps://sqlite.org/pragma.html#pragma_legacy_file_format
SQLITE_DBCONFIG_LEGACY_FILE_FORMAThttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfiglegacyfileformat
sqlite3_db_config()https://sqlite.org/c3ref/db_config.html
VACUUMhttps://sqlite.org/lang_vacuum.html
6484e6ce678fffabhttps://sqlite.org/src/info/6484e6ce678fffab
query flattenerhttps://sqlite.org/optoverview.html#flattening
FILTER clause on aggregate functionshttps://sqlite.org/lang_aggfunc.html#aggfilter
1079ad19993d13fahttps://sqlite.org/src/info/1079ad19993d13fa
FILTER clause on aggregate functionshttps://sqlite.org/lang_aggfunc.html#aggfilter
NULLS FIRSThttps://sqlite.org/lang_select.html#nullslast
NULLS LASThttps://sqlite.org/lang_select.html#nullslast
ORDER BYhttps://sqlite.org/lang_select.html#orderby
index_infohttps://sqlite.org/pragma.html#pragma_index_info
index_xinfohttps://sqlite.org/pragma.html#pragma_index_xinfo
WITHOUT ROWIDhttps://sqlite.org/withoutrowid.html
sqlite3_drop_modules()https://sqlite.org/c3ref/drop_modules.html
.recover dot-commandhttps://sqlite.org/cli.html#recover
CLIhttps://sqlite.org/cli.html
RBUhttps://sqlite.org/rbu.html
indexes on expressionshttps://sqlite.org/expridx.html
sqlite_master tablehttps://sqlite.org/schematab.html
writable_schemahttps://sqlite.org/pragma.html#pragma_writable_schema
PRAGMA function_listhttps://sqlite.org/pragma.html#pragma_function_list
PRAGMA module_listhttps://sqlite.org/pragma.html#pragma_module_list
PRAGMA pragma_listhttps://sqlite.org/pragma.html#pragma_pragma_list
-DSQLITE_OMIT_INTROSPECTION_PRAGMAShttps://sqlite.org/compile.html#omit_introspection_pragmas
SQLITE_DBCONFIG_ENABLE_VIEWhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigenableview
sqlite3_db_config()https://sqlite.org/c3ref/db_config.html
TCL Interfacehttps://sqlite.org/tclsqlite.html
config methodhttps://sqlite.org/tclsqlite.html#config
SQLITE_DBCONFIG_ENABLE_VIEWhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigenableview
sqlite3_db_config()https://sqlite.org/c3ref/db_config.html
SQLITE_DIRECTONLYhttps://sqlite.org/c3ref/c_deterministic.html#sqlitedirectonly
application-defined SQL functionshttps://sqlite.org/appfunc.html
SQLITE_ENABLE_STAT3https://sqlite.org/compile.html#enable_stat3
SQLITE_DBCONFIG_DQS_DMLhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigdqsdml
SQLITE_DBCONFIG_DQS_DDLhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigdqsddl
sqlite3_db_config()https://sqlite.org/c3ref/db_config.html
double-quoted string literalhttps://sqlite.org/quirks.html#dblquote
-DSQLITE_DQS=0https://sqlite.org/compile.html#dqs
-DSQLITE_DQS=0https://sqlite.org/compile.html#dqs
recommended compile-time optionhttps://sqlite.org/compile.html#rcmd
query plannerhttps://sqlite.org/optoverview.html
LIKE optimizationhttps://sqlite.org/optoverview.html#like_opt
sqlite_dbdatahttps://sqlite.org/src/file/ext/misc/dbdata.c
round()https://sqlite.org/lang_corefunc.html#round
CLIhttps://sqlite.org/cli.html
window functionshttps://sqlite.org/windowfunctions.html
EXCLUDE clausehttps://sqlite.org/windowfunctions.html#wexcls
window chaininghttps://sqlite.org/windowfunctions.html#wchaining
GROUPS frameshttps://sqlite.org/windowfunctions.html#grouptype
PRECEDINGhttps://sqlite.org/windowfunctions.html#exprrange
FOLLOWINGhttps://sqlite.org/windowfunctions.html#exprrange
frameshttps://sqlite.org/windowfunctions.html#framespec
sqlite3_stmt_isexplain(S)https://sqlite.org/c3ref/stmt_isexplain.html
prepared statementhttps://sqlite.org/c3ref/stmt.html
EXPLAINhttps://sqlite.org/lang_explain.html
VACUUM INTOhttps://sqlite.org/lang_vacuum.html#vacuuminto
LIKE optimizationhttps://sqlite.org/optoverview.html#like_opt
PRAGMA case_sensitive_likehttps://sqlite.org/pragma.html#pragma_case_sensitive_like
partial indexhttps://sqlite.org/partialindex.html
TCL Interfacehttps://sqlite.org/tclsqlite.html
function methodhttps://sqlite.org/tclsqlite.html#function
bind_fallback methodhttps://sqlite.org/tclsqlite.html#bind_fallback
CLIhttps://sqlite.org/cli.html
bound parametershttps://sqlite.org/lang_expr.html#varparam
.parameter commandhttps://sqlite.org/cli.html#param
readfile()https://sqlite.org/cli.html#fileio
writefile()https://sqlite.org/cli.html#fileio
--update optionhttps://sqlite.org/cli.html#arinsup
.archive commandhttps://sqlite.org/cli.html#sqlar
fossildelta.chttps://sqlite.org/src/file/ext/misc/fossildelta.c
Fossil DVCS file delta formathttps://fossil-scm.org/fossil/doc/trunk/www/delta_format.wiki
RBU extensionhttps://sqlite.org/rbu.html
SQLITE_DBCONFIG_WRITABLE_SCHEMAhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigwritableschema
sqlite3_db_config()https://sqlite.org/c3ref/db_config.html
PRAGMA writable_schemahttps://sqlite.org/pragma.html#pragma_writable_schema
sqlite3_value_frombind()https://sqlite.org/c3ref/value_blob.html
bound parameterhttps://sqlite.org/lang_expr.html#varparam
fts3_tokenizer()https://sqlite.org/fts3.html#f3tknzr
fts3_tokenizer()https://sqlite.org/fts3.html#f3tknzr
sqlite3_db_confighttps://sqlite.org/c3ref/db_config.html
SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZERhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigenablefts3tokenizer
bound parameterhttps://sqlite.org/lang_expr.html#varparam
fts3_tokenizer()https://sqlite.org/fts3.html#f3tknzr
sqlite3_db_confighttps://sqlite.org/c3ref/db_config.html
SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZERhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigenablefts3tokenizer
bound parameterhttps://sqlite.org/lang_expr.html#varparam
Fossil DVCShttps://fossil-scm.org/
https://sqlite.org/srchttps://sqlite.org/src
https://github.com/sqlite/sqlitehttps://github.com/sqlite/sqlite
df46dfb631f75694https://sqlite.org/src/info/df46dfb631f75694
window functionhttps://sqlite.org/windowfunctions.html
4feb3159c6bc3f7e33959https://sqlite.org/src/info/4feb3159c6bc3f7e33959
OR optimizationhttps://sqlite.org/optoverview.html#or_opt
expression indexhttps://sqlite.org/expridx.html
4e8e4857d32d401fhttps://sqlite.org/src/info/4e8e4857d32d401f
VACUUM INTOhttps://sqlite.org/lang_vacuum.html#vacuuminto
error loghttps://sqlite.org/errlog.html
double-quoted string literalhttps://sqlite.org/quirks.html#dblquote
sqlite3_normalized_sql()https://sqlite.org/c3ref/expanded_sql.html
sqlite3_prepare_v2()https://sqlite.org/c3ref/prepare.html
sqlite3_prepare_v3()https://sqlite.org/c3ref/prepare.html
sqlite3_prepare_v3()https://sqlite.org/c3ref/prepare.html
SQLITE_PREPARE_NORMALIZEhttps://sqlite.org/c3ref/c_prepare_dont_log.html#sqlitepreparenormalize
sqlite3_normalized_sql()https://sqlite.org/c3ref/expanded_sql.html
FTS3https://sqlite.org/fts3.html
FTS5https://sqlite.org/fts5.html
SQLITE_PREPARE_NO_VTABhttps://sqlite.org/c3ref/c_prepare_dont_log.html#sqlitepreparenovtab
sqlite3_prepare_v3()https://sqlite.org/c3ref/prepare.html
shadow tableshttps://sqlite.org/vtab.html#xshadowname
sqlite3_deserialize()https://sqlite.org/c3ref/deserialize.html
SQLITE_FCNTL_SIZE_LIMIThttps://sqlite.org/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlsizelimit
file-controlhttps://sqlite.org/c3ref/file_control.html
sqlite3_confighttps://sqlite.org/c3ref/config.html
SQLITE_CONFIG_MEMDB_MAXSIZEhttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfigmemdbmaxsize
SQLITE_MEMDB_DEFAULT_MAXSIZEhttps://sqlite.org/compile.html#memdb_default_maxsize
SQLITE_DESERIALIZE_READONLYhttps://sqlite.org/c3ref/c_deserialize_freeonclose.html
TCL Interfacehttps://sqlite.org/tclsqlite.html
CLIhttps://sqlite.org/cli.html
dbtotxthttps://sqlite.org/src/doc/trunk/tool/dbtotxt.md
PRAGMA vdbe_tracehttps://sqlite.org/pragma.html#pragma_vdbe_trace
sqlite3_progress_handler()https://sqlite.org/c3ref/progress_handler.html
1d958d90596593a774https://sqlite.org/src/info/1d958d90596593a774
query flattenerhttps://sqlite.org/optoverview.html#flattening
window functionshttps://sqlite.org/windowfunctions.html
709fcd17810f65f717https://sqlite.org/src/info/f09fcd17810f65f717
OR optimizationhttps://sqlite.org/optoverview.html#or_opt
indexes on expressionshttps://sqlite.org/expridx.html
d96eba87698a428c1dhttps://sqlite.org/src/info/d96eba87698a428c1d
LEFT JOIN strength reduction optimizationhttps://sqlite.org/optoverview.html#leftjoinreduction
5948e09b8c415bc45dhttps://sqlite.org/src/info/5948e09b8c415bc45d
REPLACEhttps://sqlite.org/lang_replace.html
e6f1f2e34dceeb1ed6https://sqlite.org/src/info/e6f1f2e34dceeb1ed6
window functionshttps://sqlite.org/windowfunctions.html
correlated subquerieshttps://sqlite.org/lang_expr.html#cosub
d0866b26f83e9c55e3https://sqlite.org/src/info/d0866b26f83e9c55e3
ALTER TABLE RENAME COLUMNhttps://sqlite.org/lang_altertable.html#altertabmvcol
bc8d94f0fbd633fd9ahttps://sqlite.org/src/info/bc8d94f0fbd633fd9a
zeroblobhttps://sqlite.org/lang_corefunc.html#zeroblob
expression indexhttps://sqlite.org/expridx.html
bb4bdb9f7f654b0bb9https://sqlite.org/src/info/bb4bdb9f7f654b0bb9
UPDATEhttps://sqlite.org/lang_update.html
indexes on expressionshttps://sqlite.org/expridx.html
xBestIndex()https://sqlite.org/vtab.html#xbestindex
virtual tablehttps://sqlite.org/vtab.html
SQLITE_CONSTRAINThttps://sqlite.org/rescode.html#constraint
SQLITE_DBCONFIG_DEFENSIVEhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigdefensive
shadow tableshttps://sqlite.org/vtab.html#xshadowname
SQLITE_DBCONFIG_DEFENSIVEhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigdefensive
PRAGMA legacy_alter_tablehttps://sqlite.org/pragma.html#pragma_legacy_alter_table
ALTER TABLEhttps://sqlite.org/lang_altertable.html
PRAGMA table_xinfohttps://sqlite.org/pragma.html#pragma_table_xinfo
PRAGMA table_infohttps://sqlite.org/pragma.html#pragma_table_info
hidden columnshttps://sqlite.org/vtab.html#hiddencol
explain virtual tablehttps://sqlite.org/src/file/ext/misc/explain.c
sqlite3_prepare()https://sqlite.org/c3ref/prepare.html
sqlite3_normalized_sql()https://sqlite.org/c3ref/expanded_sql.html
table-valued functionshttps://sqlite.org/vtab.html#tabfunc2
CLIhttps://sqlite.org/cli.html
sqlite3_deserialize()https://sqlite.org/c3ref/deserialize.html
geopolyhttps://sqlite.org/geopoly.html
geopoly_regular()https://sqlite.org/geopoly.html#regpoly
geopoly_ccw()https://sqlite.org/geopoly.html#ccw
sessionhttps://sqlite.org/sessionintro.html
SQLITE_CHANGESETAPPLY_INVERThttps://sqlite.org/session/c_changesetapply_fknoaction.html
sqlite3changeset_start_v2()https://sqlite.org/session/sqlite3changeset_start.html
SQLITE_CHANGESETSTART_INVERThttps://sqlite.org/session/c_changesetstart_invert.html
changesetfuzz.chttps://sqlite.org/src/file/ext/session/changesetfuzz.c
window functionshttps://sqlite.org/windowfunctions.html
e8275b415a2f03beehttps://sqlite.org/src/info/e8275b415a2f03bee
69d642332d25aa3b7315a6d385https://sqlite.org/src/info/69d642332d25aa3b7315a6d385
1a84668dcfdebaf12415dhttps://sqlite.org/src/info/1a84668dcfdebaf12415d
65eb38f6e46de8c75e188a17echttps://sqlite.org/src/info/65eb38f6e46de8c75e188a17ec
PRAGMA legacy_alter_table=ONhttps://sqlite.org/pragma.html#pragma_legacy_alter_table
window functionshttps://sqlite.org/windowfunctions.html
b41031ea2b537237https://sqlite.org/src/info/b41031ea2b537237
510cde277783b5fbhttps://sqlite.org/src/info/510cde277783b5fb
window functionshttps://sqlite.org/windowfunctions.html
ALTER TABLEhttps://sqlite.org/lang_altertable.html
triggershttps://sqlite.org/lang_createtrigger.html
viewshttps://sqlite.org/lang_createview.html
VFShttps://sqlite.org/vfs.html
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
command-line shellhttps://sqlite.org/cli.html
SQLITE_FCNTL_DATA_VERSIONhttps://sqlite.org/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntldataversion
Geopoly modulehttps://sqlite.org/geopoly.html
9936b2fa443fec03ff25https://sqlite.org/src/info/9936b2fa443fec03ff25
79cad5e4b2e219dd197242e9ehttps://sqlite.org/src/info/79cad5e4b2e219dd197242e9e
CLIhttps://sqlite.org/cli.html
7be932dfa60a8a6b3b26bcf76https://sqlite.org/src/info/7be932dfa60a8a6b3b26bcf76
c94369cae9b561b1f996d0054bhttps://sqlite.org/src/info/c94369cae9b561b1f996d0054b
UPSERThttps://sqlite.org/lang_upsert.html
auxiliary columns in r-tree tableshttps://sqlite.org/rtree.html#auxcol
sqlite3_keyword_count()https://sqlite.org/c3ref/keyword_check.html
sqlite3_keyword_name()https://sqlite.org/c3ref/keyword_check.html
sqlite3_keyword_check()https://sqlite.org/c3ref/keyword_check.html
sqlite3_strhttps://sqlite.org/c3ref/str.html
ALTER TABLEhttps://sqlite.org/lang_altertable.html
EXPLAIN QUERY PLANhttps://sqlite.org/eqp.html
SQLITE_DBCONFIG_RESET_DATABASEhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigresetdatabase
sqlite3_db_config()https://sqlite.org/c3ref/db_config.html
CLIhttps://sqlite.org/cli.html
EXPLAIN QUERY PLANhttps://sqlite.org/eqp.html
UPDATEhttps://sqlite.org/lang_update.html
UPDATEhttps://sqlite.org/lang_update.html
OR optimizationhttps://sqlite.org/optoverview.html#or_opt
more clearly shownhttps://sqlite.org/eqp.html#or-opt
EXPLAIN QUERY PLANhttps://sqlite.org/eqp.html
automatic indexeshttps://sqlite.org/optoverview.html#autoindex
R-Tree extensionhttps://sqlite.org/rtree.html
expression indexhttps://sqlite.org/expridx.html
7fa8049685b50b5aeb0c2https://sqlite.org/src/info/7fa8049685b50b5aeb0c2
4ba5abf65c5b0f9a96a7ahttps://sqlite.org/src/info/4ba5abf65c5b0f9a96a7a
CSV virtual tablehttps://sqlite.org/csv.html
sqlite_sequencehttps://sqlite.org/fileformat2.html#seqtab
AUTOINCREMENThttps://sqlite.org/autoinc.html
d8dc2b3a58cd5dc2918a1https://sqlite.org/src/info/d8dc2b3a58cd5dc29
json_each()https://sqlite.org/json1.html#jeach
LEFT JOIN strength reduction optimizationhttps://sqlite.org/optoverview.html#leftjoinreduction
1e39b966ae9ee739https://sqlite.org/src/info/1e39b966ae9ee739
fac496b61722daf2https://sqlite.org/src/info/fac496b61722daf2
2b8aed9f7c9e61e8https://sqlite.org/src/info/2b8aed9f7c9e61e8
093420fc0eb7cba7https://sqlite.org/src/info/093420fc0eb7cba7
CLIhttps://sqlite.org/cli.html
eval.chttps://sqlite.org/src/file/ext/misc/eval.c
PRAGMA empty_result_callbacks=ONhttps://sqlite.org/pragma.html#pragma_empty_result_callbacks
generate_serieshttps://sqlite.org/series.html
sqlite3_serialize()https://sqlite.org/c3ref/serialize.html
sqlite3_deserialize()https://sqlite.org/c3ref/deserialize.html
SQLITE_ENABLE_DESERIALIZEhttps://sqlite.org/compile.html#enable_deserialize
SQLITE_DBSTATUS_CACHE_SPILLhttps://sqlite.org/c3ref/c_dbstatus_options.html#sqlitedbstatuscachespill
sqlite3_db_status()https://sqlite.org/c3ref/db_status.html
built-in printfhttps://sqlite.org/printf.html
xColumnhttps://sqlite.org/vtab.html#xcolumn
virtual tablehttps://sqlite.org/vtab.html
sqlite3_result_error()https://sqlite.org/c3ref/result_blob.html
CLIhttps://sqlite.org/cli.html
SQLite Archive fileshttps://sqlite.org/sqlar.html
Zipfile virtual tablehttps://sqlite.org/zipfile.html
sqlite3changeset_apply()https://sqlite.org/session/sqlite3changeset_apply.html
changesethttps://sqlite.org/sessionintro.html#changeset
sqlite3_normalize()https://sqlite.org/src/file/ext/misc/normalize.c
omit-left-join optimizationhttps://sqlite.org/optoverview.html#omitnoopjoin
push-down optimizationhttps://sqlite.org/optoverview.html#pushdown
LEFT JOIN strength reduction optimizationhttps://sqlite.org/optoverview.html#leftjoinreduction
AUTOINCREMENThttps://sqlite.org/autoinc.html
row valuehttps://sqlite.org/rowvalue.html
7310e2fb3d046a5https://sqlite.org/src/info/7310e2fb3d046a5
80177f0c226ff54https://sqlite.org/src/info/80177f0c226ff54
ec32177c99ccac2https://sqlite.org/src/info/ec32177c99ccac2
indexes on expressionshttps://sqlite.org/expridx.html
343634942dd54abhttps://sqlite.org/src/info/343634942dd54ab
d6ec09eccf68cfchttps://sqlite.org/src/info/d6ec09eccf68cfc
row valueshttps://sqlite.org/rowvalue.html
f484b65f3d62305https://sqlite.org/src/info/f484b65f3d62305
36fae083b450e3ahttps://sqlite.org/src/info/36fae083b450e3a
table-valued functionhttps://sqlite.org/vtab.html#tabfunc2
fileio.chttps://sqlite.org/src/file/ext/misc/fileio.c
7ce4e71c1b7251behttps://sqlite.org/src/info/7ce4e71c1b7251be
525deb7a67fbd647https://sqlite.org/src/info/525deb7a67fbd647
ANALYZEhttps://sqlite.org/lang_analyze.html
0249d9aecf69948dhttps://sqlite.org/src/info/0249d9aecf69948d
OSSFuzzhttps://github.com/google/oss-fuzz
27754b74ddf64https://sqlite.org/src/info/27754b74ddf64
parametershttps://sqlite.org/lang_expr.html#varparam
WITH clausehttps://sqlite.org/lang_with.html
b918d4b4e546dhttps://sqlite.org/src/info/b918d4b4e546d
row valuehttps://sqlite.org/rowvalue.html
2df6bbf1b8ca8https://sqlite.org/src/info/2df6bbf1b8ca8
replace() SQL functionhttps://sqlite.org/lang_corefunc.html#replace
fab2c2b07b5d3https://sqlite.org/src/info/fab2c2b07b5d3
d75e67654aa96https://sqlite.org/src/info/d75e67654aa96
823779d31eb09cdahttps://sqlite.org/src/info/823779d31eb09cda
LIKE optimizationhttps://sqlite.org/optoverview.html#like_opt
INTEGER PRIMARY KEYhttps://sqlite.org/lang_createtable.html#rowid
b850dd159918af56https://sqlite.org/src/info/b850dd159918af56
sqlite3_trace_v2()https://sqlite.org/c3ref/trace_v2.html
WAL modehttps://sqlite.org/wal.html
rtreecheck()https://sqlite.org/rtree.html#rtreecheck
R-Tree extensionhttps://sqlite.org/rtree.html
sqlite3_vtab_nochange()https://sqlite.org/c3ref/vtab_nochange.html
sqlite3_value_nochange()https://sqlite.org/c3ref/value_blob.html
sqlite3_vtab_collation()https://sqlite.org/c3ref/vtab_collation.html
"^" initial token syntaxhttps://sqlite.org/fts5.html#carrotq
Zipfile virtual tablehttps://sqlite.org/zipfile.html
ZIP Archivehttps://en.wikipedia.org/wiki/Zip_(file_format)
table-valued functionhttps://sqlite.org/vtab.html#tabfunc2
fileio.chttps://sqlite.org/src/file/ext/misc/fileio.c
sqlite_btreeinfohttps://sqlite.org/src/file/ext/misc/btreeinfo.c
Append VFShttps://sqlite.org/src/file/ext/misc/appendvfs.c
VFS shimhttps://sqlite.org/vfs.html#shim
indexes on expressionshttps://sqlite.org/expridx.html
query flatteninghttps://sqlite.org/optoverview.html#flattening
Lemon parser generatorhttps://sqlite.org/lemon.html
command-line shellhttps://sqlite.org/cli.html
SQLite Archivehttps://sqlite.org/sqlar.html
.archive commandhttps://sqlite.org/cli.html#sqlar
.expert commandhttps://sqlite.org/cli.html#expert
WITHOUT ROWIDhttps://sqlite.org/withoutrowid.html
Zipfile virtual tablehttps://sqlite.org/zipfile.html
edit() SQL functionhttps://sqlite.org/cli.html#editfunc
.excel commandhttps://sqlite.org/cli.html#exexcel*
Append VFShttps://sqlite.org/src/file/ext/misc/appendvfs.c
SQLITE_ENABLE_UPDATE_DELETE_LIMIThttps://sqlite.org/compile.html#enable_update_delete_limit
WITHOUT ROWIDhttps://sqlite.org/withoutrowid.html
sqlite_offset(X)https://sqlite.org/lang_corefunc.html#sqlite_offset
-DSQLITE_ENABLE_OFFSET_SQL_FUNChttps://sqlite.org/compile.html#enable_offset_sql_func
47b2581aa9bfecechttps://sqlite.org/src/info/47b2581aa9bfecec
ef9318757b152e3ahttps://sqlite.org/src/info/ef9318757b152e3a
123c9ba32130a6c9https://sqlite.org/src/info/123c9ba32130a6c9
3b4450072511e621https://sqlite.org/src/info/3b4450072511e621
dc3f932f5a147771https://sqlite.org/src/info/dc3f932f5a147771
aa98619ad08ddcabhttps://sqlite.org/src/info/aa98619ad08ddcab
F2FS filesystemhttps://en.wikipedia.org/wiki/F2FS
SQLITE_ENABLE_BATCH_ATOMIC_WRITEhttps://sqlite.org/compile.html#enable_batch_atomic_write
ATTACHhttps://sqlite.org/lang_attach.html
DETACHhttps://sqlite.org/lang_detach.html
WITHOUT ROWID virtual tableshttps://sqlite.org/vtab.html#worid
PRAGMA checkpoint_fullfsynchttps://sqlite.org/pragma.html#pragma_checkpoint_fullfsync
sqlite3_sourceid()https://sqlite.org/c3ref/libversion.html
CREATE TABLE AShttps://sqlite.org/lang_createtable.html#createtabas
LIKE optimizationhttps://sqlite.org/optoverview.html#like_opt
ESCAPEhttps://sqlite.org/lang_expr.html#like
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
PRAGMA quick_checkhttps://sqlite.org/pragma.html#pragma_quick_check
recordshttps://sqlite.org/fileformat2.html#record_format
co-routineshttps://sqlite.org/optoverview.html#coroutines
query flattenerhttps://sqlite.org/optoverview.html#flattening
xBestIndexhttps://sqlite.org/vtab.html#xbestindex
CSV virtual tablehttps://sqlite.org/csv.html
SQLITE_CONFIG_SMALL_MALLOChttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfigsmallmalloc
swarm virtual tablehttps://sqlite.org/src/file/ext/misc/unionvtab.c
sqlite_dbpage virtual tablehttps://sqlite.org/src/file/src/dbpage.c
amalgamationhttps://sqlite.org/amalgamation.html
-DSQLITE_ENABLE_DBPAGE_VTABhttps://sqlite.org/compile.html#enable_dbpage_vtab
src/shell.chttps://sqlite.org/src/finfo?name=src/shell.c
command-line shellhttps://sqlite.org/cli.html
microoptimizationshttps://sqlite.org/cpu.html#microopt
cb91bf4290c211dhttps://sqlite.org/src/info/cb91bf4290c211d
sqlite3_result_pointer()https://sqlite.org/c3ref/result_blob.html
7486aa54b968e9bhttps://sqlite.org/src/info/7486aa54b968e9b
be436a7f4587ce5https://sqlite.org/src/info/be436a7f4587ce5
e20dd54ab0e4383https://sqlite.org/src/info/e20dd54ab0e4383
aa98619ad08ddcahttps://sqlite.org/src/info/aa98619ad08ddca
PRAGMA reverse_unordered_selectshttps://sqlite.org/pragma.html#pragma_reverse_unordered_selects
cb91bf4290c211dhttps://sqlite.org/src/info/cb91bf4290c211d
b899b6042f97f5https://sqlite.org/src/info/b899b6042f97f5
6ee8cb6ae5https://sqlite.org/src/info/6ee8cb6ae5
04925dee41a21fhttps://sqlite.org/src/info/04925dee41a21f
sqlite3_result_pointer()https://sqlite.org/c3ref/result_blob.html
7486aa54b968e9b5https://sqlite.org/src/info/7486aa54b968e9b5
sqlite3_errmsg()https://sqlite.org/c3ref/errcode.html
pointer passing interfaceshttps://sqlite.org/bindptr.html
pointer passing interfaceshttps://sqlite.org/bindptr.html
Extending FTS5https://sqlite.org/fts5.html#extending_fts5
sqlite3_bind_pointer()https://sqlite.org/c3ref/bind_blob.html
carray(PTR,N)https://sqlite.org/carray.html
sqlite3_bind_pointer()https://sqlite.org/c3ref/bind_blob.html
remember(V,PTR)https://sqlite.org/src/file/ext/misc/remember.c
sqlite3_bind_pointer()https://sqlite.org/c3ref/bind_blob.html
SQLITE_STMT virtual tablehttps://sqlite.org/stmt.html
COMPLETION extensionhttps://sqlite.org/completion.html
UNION virtual tablehttps://sqlite.org/unionvtab.html
date and time functionshttps://sqlite.org/lang_datefunc.html
CHECK constraintshttps://sqlite.org/lang_createtable.html#ckconst
indexes on expressionshttps://sqlite.org/expridx.html
partial indexeshttps://sqlite.org/partialindex.html
More informationhttps://sqlite.org/deterministic.html#dtexception
sqlite3_prepare_v3()https://sqlite.org/c3ref/prepare.html
sqlite3_prepare16_v3()https://sqlite.org/c3ref/prepare.html
SQLITE_PREPARE_PERSISTENThttps://sqlite.org/c3ref/c_prepare_dont_log.html#sqlitepreparepersistent
sqlite3_prepare_v3()https://sqlite.org/c3ref/prepare.html
lookaside memoryhttps://sqlite.org/malloc.html#lookaside
FTS3https://sqlite.org/fts3.html
FTS5https://sqlite.org/fts5.html
R-Tree extensionhttps://sqlite.org/rtree.html
PRAGMA secure_delete=FASThttps://sqlite.org/pragma.html#pragma_secure_delete
free-page listhttps://sqlite.org/fileformat2.html#freelist
command-line shellhttps://sqlite.org/cli.html
COMPLETION extensionhttps://sqlite.org/completion.html
.schemahttps://sqlite.org/cli.html#dschema
.tableshttps://sqlite.org/cli.html#dtables
.importhttps://sqlite.org/cli.html#csv
.dumphttps://sqlite.org/cli.html#dump
replace()https://sqlite.org/lang_corefunc.html#replace
flattening optimizationhttps://sqlite.org/optoverview.html#flattening
virtual tablehttps://sqlite.org/vtab.html
automatic indexeshttps://sqlite.org/optoverview.html#autoindex
SQLITE_STMTSTATUS_REPREPAREhttps://sqlite.org/c3ref/c_stmtstatus_counter.html#sqlitestmtstatusreprepare
SQLITE_STMTSTATUS_RUNhttps://sqlite.org/c3ref/c_stmtstatus_counter.html#sqlitestmtstatusrun
SQLITE_STMTSTATUS_MEMUSEDhttps://sqlite.org/c3ref/c_stmtstatus_counter.html#sqlitestmtstatusmemused
sqlite3_stmt_status()https://sqlite.org/c3ref/stmt_status.html
PRAGMA functionshttps://sqlite.org/pragma.html#pragfunc
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
PRAGMA quick_checkhttps://sqlite.org/pragma.html#pragma_quick_check
PRAGMA foreign_key_checkhttps://sqlite.org/pragma.html#pragma_foreign_key_check
TCL interface eval methodhttps://sqlite.org/tclsqlite.html#eval
sqlite3_analyzer.exehttps://sqlite.org/sqlanalyze.html
SQLITE_DBCONFIG_ENABLE_QPSGhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigenableqpsg
SQLITE_ENABLE_QPSGhttps://sqlite.org/compile.html#enable_qpsg
query planner stability guaranteehttps://sqlite.org/queryplanner-ng.html#qpstab
892fc34f173e99d8https://sqlite.org/src/info/892fc34f173e99d8
CPU cycles usedhttps://sqlite.org/cpu.html
sqlite3_column_name()https://sqlite.org/c3ref/column_name.html
flattening optimizationhttps://sqlite.org/optoverview.html#flattening
de3403bf5aehttps://sqlite.org/src/info/de3403bf5ae
automatic indexeshttps://sqlite.org/optoverview.html#autoindex
IS operatorhttps://sqlite.org/lang_expr.html#isisnot
ce68383bf6abahttps://sqlite.org/src/info/ce68383bf6aba
flattenedhttps://sqlite.org/optoverview.html#flattening
892fc34f173e99d8https://sqlite.org/src/info/892fc34f173e99d8
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
attached databaseshttps://sqlite.org/lang_attach.html
a4e06e75a9ab61a12https://sqlite.org/src/info/a4e06e75a9ab61a12
bc115541132dad136https://sqlite.org/src/info/bc115541132dad136
61fe9745https://sqlite.org/src/info/61fe9745
auto_vacuumhttps://sqlite.org/pragma.html#pragma_auto_vacuum
version 3.16.0https://sqlite.org/changes.html#version_3_16_0
fda22108https://sqlite.org/src/info/fda22108
auto_vacuumhttps://sqlite.org/pragma.html#pragma_auto_vacuum
version 3.16.0https://sqlite.org/changes.html#version_3_16_0
fda22108https://sqlite.org/src/info/fda22108
flattening optimizationhttps://sqlite.org/optoverview.html#flattening
7fde638e94287d2chttps://sqlite.org/src/info/7fde638e94287d2c
flattening optimizationhttps://sqlite.org/optoverview.html#flattening
cad1ab4cb7b0fchttps://sqlite.org/src/info/cad1ab4cb7b0fc
SQLITE_READhttps://sqlite.org/c3ref/c_alter_table.html
authorizer callbackhttps://sqlite.org/c3ref/set_authorizer.html
flattening optimizationhttps://sqlite.org/optoverview.html#flattening
replace()https://sqlite.org/lang_corefunc.html#replace
char()https://sqlite.org/lang_corefunc.html#char
command-line shellhttps://sqlite.org/cli.html
sqlite3_blobhttps://sqlite.org/c3ref/blob.html
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
rowidhttps://sqlite.org/lang_createtable.html#rowid
FTS5https://sqlite.org/fts5.html
column filtershttps://sqlite.org/fts5.html#fts5_column_filters
json_extract()https://sqlite.org/json1.html#jex
anycollseq.chttps://sqlite.org/src/file/ext/misc/anycollseq.c
loadable extensionhttps://sqlite.org/loadext.html
collating sequenceshttps://sqlite.org/datatype3.html#collation
REPLACEhttps://sqlite.org/lang_replace.html
rowidhttps://sqlite.org/lang_createtable.html#rowid
f68dc596c4e6018dhttps://sqlite.org/src/info/f68dc596c4e6018d
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
VACUUMhttps://sqlite.org/lang_vacuum.html
PRAGMA foreign_key_checkhttps://sqlite.org/pragma.html#pragma_foreign_key_check
WITHOUT ROWIDhttps://sqlite.org/withoutrowid.html
61fe9745https://sqlite.org/src/info/61fe9745
b93be8729a895a528e2https://sqlite.org/src/info/b93be8729a895a528e2
6c9b5514077fed34551https://sqlite.org/src/info/6c9b5514077fed34551
981329adeef51011052https://sqlite.org/src/info/981329adeef51011052
PRAGMA optimizehttps://sqlite.org/pragma.html#pragma_optimize
sqlite_source_id()https://sqlite.org/lang_corefunc.html#sqlite_source_id
sqlite3_sourceid()https://sqlite.org/c3ref/libversion.html
SQLITE_SOURCE_IDhttps://sqlite.org/c3ref/c_scm_branch.html
json_patch()https://sqlite.org/json1.html#jpatch
JSON1 extensionhttps://sqlite.org/json1.html
LIKE optimizationhttps://sqlite.org/optoverview.html#like_opt
sqlite3_set_last_insert_rowid()https://sqlite.org/c3ref/set_last_insert_rowid.html
FTS3https://sqlite.org/fts3.html
FTS4https://sqlite.org/fts3.html#fts4
FTS5https://sqlite.org/fts5.html
sqlite3_last_insert_rowid()https://sqlite.org/c3ref/last_insert_rowid.html
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
PRAGMA quick_checkhttps://sqlite.org/pragma.html#pragma_quick_check
CHECK constraintshttps://sqlite.org/lang_createtable.html#ckconst
sqlite3_mprintf()https://sqlite.org/c3ref/mprintf.html
printf SQL functionhttps://sqlite.org/lang_corefunc.html#printf
SQLITE_MAX_MEMORYhttps://sqlite.org/compile.html#max_memory
.sha3sum dot-commandhttps://sqlite.org/cli.html#sha3sum
.selftest dot-commandhttps://sqlite.org/cli.html#selftest
command-line shellhttps://sqlite.org/cli.html
SQLITE_LIMIT_VDBE_OPhttps://sqlite.org/c3ref/c_limit_attached.html#sqlitelimitvdbeop
eb703ba7b50c1a5https://sqlite.org/src/info/eb703ba7b50c1a5
date and time functionshttps://sqlite.org/lang_datefunc.html
6097cb92745327a1https://sqlite.org/src/info/6097cb92745327a1
06796225f59c057chttps://sqlite.org/src/info/06796225f59c057c
RBU extensionhttps://sqlite.org/rbu.html
sqlite3_trace_v2()https://sqlite.org/c3ref/trace_v2.html
R-Tree extensionhttps://sqlite.org/rtree.html
sqlite3_blobhttps://sqlite.org/c3ref/blob.html
SQLITE_DEFAULT_LOOKASIDEhttps://sqlite.org/compile.html#default_lookaside
lookasidehttps://sqlite.org/malloc.html#lookaside
SQLITE_DISABLE_INTRINSIChttps://sqlite.org/compile.html#disable_intrinsic
SQLITE_ENABLE_NULL_TRIMhttps://sqlite.org/compile.html#enable_null_trim
SQLITE_DEFAULT_PCACHE_INITSZhttps://sqlite.org/compile.html#default_pcache_initsz
UPDATEhttps://sqlite.org/lang_update.html
session extensionhttps://sqlite.org/sessionintro.html
WITHOUT ROWIDhttps://sqlite.org/withoutrowid.html
viewshttps://sqlite.org/lang_createview.html
sha1.chttps://sqlite.org/src/file/ext/misc/sha1.c
command-line shellhttps://sqlite.org/cli.html
SQLITE_DIRECT_OVERFLOW_READhttps://sqlite.org/compile.html#direct_overflow_read
WAL modehttps://sqlite.org/wal.html
Lemon parser generatorhttps://sqlite.org/lemon.html
amalgamationhttps://sqlite.org/amalgamation.html
6.5% fewer CPU cycleshttps://sqlite.org/cpu.html
25e335f802ddhttps://sqlite.org/src/info/25e335f802dd
7ffd1ca1d2ad4echttps://sqlite.org/src/info/7ffd1ca1d2ad4ec
sqlite3_blob_reopen()https://sqlite.org/c3ref/blob_reopen.html
e6e962d6b0f06f46ehttps://sqlite.org/src/info/e6e962d6b0f06f46e
REPLACEhttps://sqlite.org/lang_replace.html
WITHOUT ROWIDhttps://sqlite.org/withoutrowid.html
30027b613b4https://sqlite.org/src/info/30027b613b4
sqlite3_value_text()https://sqlite.org/c3ref/value_blob.html
zeroblob()https://sqlite.org/lang_corefunc.html#zeroblob
OSS-Fuzzhttps://github.com/google/oss-fuzz
190c2507https://sqlite.org/src/info/190c2507
sqlite3_column_count()https://sqlite.org/c3ref/column_count.html
PRAGMAhttps://sqlite.org/pragma.html#syntax
row valueshttps://sqlite.org/rowvalue.html
triggershttps://sqlite.org/lang_createtrigger.html
8c9458e7https://sqlite.org/src/info/8c9458e7
CPU performance measurementhttps://sqlite.org/cpu.html
PRAGMA functionshttps://sqlite.org/pragma.html#pragfunc
SQLITE_DBCONFIG_NO_CKPT_ON_CLOSEhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfignockptonclose
sqlite3_db_config()https://sqlite.org/c3ref/db_config.html
date and time functionshttps://sqlite.org/lang_datefunc.html
lookaside memory allocatorhttps://sqlite.org/malloc.html#lookaside
partial indexeshttps://sqlite.org/partialindex.html
sqlite3_interrupt()https://sqlite.org/c3ref/interrupt.html
checkpointhttps://sqlite.org/wal.html#ckpt
LIKEhttps://sqlite.org/lang_expr.html#like
GLOBhttps://sqlite.org/lang_expr.html#glob
SQLITE_FCNTL_WIN32_GET_HANDLEhttps://sqlite.org/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlwin32gethandle
command-line shellhttps://sqlite.org/cli.html
command-line shellhttps://sqlite.org/cli.html
.imposter dot-commandhttps://sqlite.org/imposter.html#dotimposter
command-line shellhttps://sqlite.org/cli.html
remember(V,PTR)https://sqlite.org/src/file/ext/misc/remember.c
loadable extensionhttps://sqlite.org/loadext.html
SQLITE_OMIT_BUILTIN_TESThttps://sqlite.org/compile.html#omit_builtin_test
SQLITE_UNTESTABLEhttps://sqlite.org/compile.html#untestable
2df0107bhttps://sqlite.org/src/info/2df0107b
row valuehttps://sqlite.org/rowvalue.html
2f1b168ab4d4844https://sqlite.org/src/info/2f1b168ab4d4844
instr()https://sqlite.org/lang_corefunc.html#instr
JSON extensionhttps://sqlite.org/json1.html
SQLITE_FCNTL_WIN32_GET_HANDLEhttps://sqlite.org/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlwin32gethandle
VACUUMhttps://sqlite.org/lang_vacuum.html
34a579141b2c5achttps://sqlite.org/src/info/34a579141b2c5ac
row valueshttps://sqlite.org/rowvalue.html
fef4bb4bd9185ec8fhttps://sqlite.org/src/info/fef4bb4bd9185ec8f
row valueshttps://sqlite.org/rowvalue.html
deterministic SQL functionshttps://sqlite.org/deterministic.html
partial indexhttps://sqlite.org/partialindex.html
modeof=filenamehttps://sqlite.org/uri.html#urimodeof
SQLITE_DBCONFIG_MAINDBNAMEhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigmaindbname
VACUUMhttps://sqlite.org/lang_vacuum.html
ATTACH-edhttps://sqlite.org/lang_attach.html
command-line shellhttps://sqlite.org/cli.html
dot-commandshttps://sqlite.org/cli.html#dotcmd
fts5vocabhttps://sqlite.org/fts5.html#the_fts5vocab_virtual_table_module
sqlite3_prepare_v2()https://sqlite.org/c3ref/prepare.html
1ec41379c9c1e400https://sqlite.org/src/info/1ec41379c9c1e400
IN operatorhttps://sqlite.org/lang_expr.html#in_op
0eab1ac759https://sqlite.org/src/info/0eab1ac759
indexes on expressionshttps://sqlite.org/expridx.html
4baa46491212947https://sqlite.org/src/tktview/4baa46491212947
AUTOINCREMENThttps://sqlite.org/autoinc.html
7b3328086a5c116chttps://sqlite.org/src/info/7b3328086a5c116c
559733b09ehttps://sqlite.org/src/info/559733b09e9630fa
96c1454chttps://sqlite.org/src/info/96c1454cbfd9509
sqlite3_trace_v2()https://sqlite.org/c3ref/trace_v2.html
EXPLAINhttps://sqlite.org/lang_explain.html
-DSQLITE_ENABLE_EXPLAIN_COMMENTShttps://sqlite.org/compile.html#enable_explain_comments
command-line shellhttps://sqlite.org/cli.html
199df4168chttps://sqlite.org/src/info/199df4168c
0c4df46116e90f92https://sqlite.org/src/info/0c4df46116e90f92
DELETEhttps://sqlite.org/lang_delete.html
ef360601https://sqlite.org/src/info/ef360601
COMMIThttps://sqlite.org/lang_transaction.html
page cachehttps://sqlite.org/pragma.html#pragma_cache_size
sqldiffhttps://sqlite.org/sqldiff.html
WITHOUT ROWID virtual tableshttps://sqlite.org/vtab.html#worid
OR optimizationhttps://sqlite.org/optoverview.html#or_opt
virtual tableshttps://sqlite.org/vtab.html
LIKEhttps://sqlite.org/lang_expr.html#like
GLOBhttps://sqlite.org/lang_expr.html#glob
REGEXPhttps://sqlite.org/lang_expr.html#regexp
MATCHhttps://sqlite.org/lang_expr.html#match
CSV virtual tablehttps://sqlite.org/csv.html
RFC 4180https://www.ietf.org/rfc/rfc4180.txt
carray() table-valued functionhttps://sqlite.org/carray.html
persistent loadable extensionshttps://sqlite.org/loadext.html#persist
SQLITE_OK_LOAD_PERMANENTLYhttps://sqlite.org/rescode.html#ok_load_permanently
SQLITE_DBSTATUS_CACHE_USED_SHAREDhttps://sqlite.org/c3ref/c_dbstatus_options.html#sqlitedbstatuscacheusedshared
sqlite3_db_status()https://sqlite.org/c3ref/db_status.html
vfsstat.chttps://sqlite.org/src/artifact?ci=trunk&filename=ext/misc/vfsstat.c
eponymous virtual tablehttps://sqlite.org/vtab.html#epovtab
Lemon parser generatorhttps://sqlite.org/lemon.html
PRAGMA compile_optionshttps://sqlite.org/pragma.html#pragma_compile_options
PRAGMA table_infohttps://sqlite.org/pragma.html#pragma_table_info
eponymous virtual tableshttps://sqlite.org/vtab.html#epovtab
partial indexhttps://sqlite.org/partialindex.html
table-valued functionshttps://sqlite.org/vtab.html#tabfunc2
IN operatorhttps://sqlite.org/lang_expr.html#in_op
dbhash.exehttps://sqlite.org/dbhash.html
sqlite3_expanded_sql()https://sqlite.org/c3ref/expanded_sql.html
sqlite3_trace_v2()https://sqlite.org/c3ref/trace_v2.html
sqlite3_trace()https://sqlite.org/c3ref/profile.html
sqlite3_profile()https://sqlite.org/c3ref/profile.html
json_quote()https://sqlite.org/json1.html#jquote
the json1 extensionhttps://sqlite.org/json1.html
authorizer callbackhttps://sqlite.org/c3ref/set_authorizer.html
SQLITE_ENABLE_UNKNOWN_SQL_FUNCTIONhttps://sqlite.org/compile.html#enable_unknown_sql_function
command-line shellhttps://sqlite.org/cli.html
ALTER TABLEhttps://sqlite.org/lang_altertable.html
descending indexeshttps://sqlite.org/lang_createindex.html#descidx
legacy file formathttps://sqlite.org/pragma.html#pragma_legacy_file_format
f68bf68513a1c15fhttps://sqlite.org/src/info/f68bf68513a1c15f
e8d439c77685eca6https://sqlite.org/src/info/e8d439c77685eca6
version 3.12.0https://sqlite.org/changes.html#version_3_12_0
sessionhttps://sqlite.org/sessionintro.html
command-line shellhttps://sqlite.org/cli.html
command-line shellhttps://sqlite.org/cli.html
command-line shellhttps://sqlite.org/cli.html
EXPLAINhttps://sqlite.org/lang_explain.html
EXPLAIN QUERY PLANhttps://sqlite.org/eqp.html
command-line shellhttps://sqlite.org/cli.html
sqlite_stat1https://sqlite.org/fileformat2.html#stat1tab
sqlite3_db_confighttps://sqlite.org/c3ref/db_config.html
SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSIONhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigenableloadextension
sqlite3_load_extension()https://sqlite.org/c3ref/load_extension.html
load_extension()https://sqlite.org/lang_corefunc.html#load_extension
temporary directory search algorithmhttps://sqlite.org/tempfiles.html#tempdir
dc6ebeda9396087https://sqlite.org/src/info/dc6ebeda9396087
rowid tablehttps://sqlite.org/rowidtable.html
INTEGER PRIMARY KEYhttps://sqlite.org/lang_createtable.html#rowid
16c9801ceba49https://sqlite.org/src/info/16c9801ceba49
WHERE-clause push-down optimizationhttps://sqlite.org/optoverview.html#pushdown
f7f8c97e97597https://sqlite.org/src/info/f7f8c97e97597
hot journalhttps://sqlite.org/fileformat2.html#hotjrnl
INTEGER PRIMARY KEYhttps://sqlite.org/lang_createtable.html#rowid
7d7525cb01b68https://sqlite.org/src/info/7d7525cb01b68
version 3.9.0https://sqlite.org/changes.html#version_3_9_0
DELETEhttps://sqlite.org/lang_delete.html
PRAGMA reverse_unordered_selectshttps://sqlite.org/pragma.html#pragma_reverse_unordered_selects
a306e56ff68b8fa5https://sqlite.org/src/info/a306e56ff68b8fa5
virtual tableshttps://sqlite.org/vtab.html
IN operatorhttps://sqlite.org/lang_expr.html#in_op
SAVEPOINThttps://sqlite.org/lang_savepoint.html
7f7f8026eda38https://sqlite.org/src/info/7f7f8026eda38
viewshttps://sqlite.org/lang_createview.html
INTEGER PRIMARY KEYhttps://sqlite.org/lang_createtable.html#rowid
7d7525cb01b68https://sqlite.org/src/info/7d7525cb01b68
version 3.9.0https://sqlite.org/changes.html#version_3_9_0
DELETEhttps://sqlite.org/lang_delete.html
PRAGMA reverse_unordered_selectshttps://sqlite.org/pragma.html#pragma_reverse_unordered_selects
a306e56ff68b8fa5https://sqlite.org/src/info/a306e56ff68b8fa5
virtual tableshttps://sqlite.org/vtab.html
IN operatorhttps://sqlite.org/lang_expr.html#in_op
SAVEPOINThttps://sqlite.org/lang_savepoint.html
7f7f8026eda38https://sqlite.org/src/info/7f7f8026eda38
viewshttps://sqlite.org/lang_createview.html
simple query planner optimizationhttps://sqlite.org/src/info/c648539b52ca28c0
version 3.9.2https://sqlite.org/changes.html#version_3_9_2
SQLITE_DEFAULT_PAGE_SIZEhttps://sqlite.org/compile.html#default_page_size
SQLITE_DEFAULT_CACHE_SIZEhttps://sqlite.org/compile.html#default_cache_size
version 3.12.0 page size changehttps://sqlite.org/pgszchng2016.html
Lemon parser generatorhttps://sqlite.org/lemon.html
master journalhttps://sqlite.org/tempfiles.html#superjrnl
PRAGMA synchronoushttps://sqlite.org/pragma.html#pragma_synchronous
journal_modehttps://sqlite.org/pragma.html#pragma_journal_mode
statement journalhttps://sqlite.org/tempfiles.html#stmtjrnl
SQLITE_STMTJRNL_SPILLhttps://sqlite.org/compile.html#stmtjrnl_spill
sqlite3_confighttps://sqlite.org/c3ref/config.html
SQLITE_CONFIG_STMTJRNL_SPILLhttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfigstmtjrnlspill
virtual tableshttps://sqlite.org/vtab.html
xBestIndexhttps://sqlite.org/vtab.html#xbestindex
virtual tablehttps://sqlite.org/vtab.html
application-defined SQL functionshttps://sqlite.org/appfunc.html
SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZERhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigenablefts3tokenizer
sqlite3_db_config()https://sqlite.org/c3ref/db_config.html
fts3_tokenizer()https://sqlite.org/fts3.html#f3tknzr
sqlite3rbu_bp_progress()https://sqlite.org/src/artifact/d7cc99350?ln=403-443
RBUhttps://sqlite.org/rbu.html
PRAGMA defer_foreign_keys=ONhttps://sqlite.org/pragma.html#pragma_defer_foreign_keys
RESTRICT actionshttps://sqlite.org/foreignkeys.html#fk_actions
sqlite3_system_errno()https://sqlite.org/c3ref/system_errno.html
SQLITE_DEFAULT_SYNCHRONOUShttps://sqlite.org/compile.html#default_synchronous
SQLITE_DEFAULT_WAL_SYNCHRONOUShttps://sqlite.org/compile.html#default_wal_synchronous
SQLITE_DEFAULT_SYNCHRONOUShttps://sqlite.org/compile.html#default_synchronous
SQLITE_EXTRA_DURABLEhttps://sqlite.org/compile.html#extra_durable
command-line shellhttps://sqlite.org/cli.html
sqlite3_set_auxdata()https://sqlite.org/c3ref/get_auxdata.html
dc9b1c91https://sqlite.org/src/info/dc9b1c91
5e3c886796e5512ehttps://sqlite.org/src/info/5e3c886796e5512e
sqlite3_db_readonly()https://sqlite.org/c3ref/db_readonly.html
FTS5https://sqlite.org/fts5.html
FTS5https://sqlite.org/fts5.html
spellfix1https://sqlite.org/spellfix1.html
WAL modehttps://sqlite.org/wal.html
cache_sizehttps://sqlite.org/pragma.html#pragma_cache_size
FTS5 detail optionhttps://sqlite.org/fts5.html#the_detail_option
PRAGMA synchronoushttps://sqlite.org/pragma.html#pragma_synchronous
SQLITE_EXTRA_DURABLEhttps://sqlite.org/compile.html#extra_durable
PRAGMA synchronous=EXTRAhttps://sqlite.org/pragma.html#pragma_synchronous
query plannerhttps://sqlite.org/optoverview.html
covering indexhttps://sqlite.org/queryplanner.html#covidx
OR optimizationhttps://sqlite.org/optoverview.html#or_opt
NOT NULLhttps://sqlite.org/lang_createtable.html#notnullconst
CHECK constraintshttps://sqlite.org/lang_createtable.html#ckconst
UPDATEhttps://sqlite.org/lang_update.html
command-line shellhttps://sqlite.org/cli.html
EXPLAINhttps://sqlite.org/lang_explain.html
dot-commandhttps://sqlite.org/cli.html#dotcmd
SQLITE_ENABLE_EXPLAIN_COMMENTShttps://sqlite.org/compile.html#enable_explain_comments
TCL Interfacehttps://sqlite.org/tclsqlite.html
URI filenameshttps://sqlite.org/uri.html
amalgamation tarballhttps://sqlite.org/download.html#amalgtarball
d06a25c84454ahttps://sqlite.org/src/info/d06a25c84454a
sqlite3_result_subtype()https://sqlite.org/c3ref/result_subtype.html
json1https://sqlite.org/json1.html
f45ac567eaa9f9https://sqlite.org/src/info/f45ac567eaa9f9
ad2559db380abf8https://sqlite.org/src/info/ad2559db380abf8
VFSeshttps://sqlite.org/vfs.html
SQLITE_OMIT_DEPRECATEDhttps://sqlite.org/compile.html#omit_deprecated
fts3_tokenizer()https://sqlite.org/fts3.html#f3tknzr
SQLITE_ENABLE_FTS3_TOKENIZERhttps://sqlite.org/compile.html#enable_fts3_tokenizer
LIKEhttps://sqlite.org/lang_expr.html#like
80369eddd5c94https://sqlite.org/src/info/80369eddd5c94
SQLITE_FCNTL_JOURNAL_POINTERhttps://sqlite.org/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntljournalpointer
block sortinghttps://sqlite.org/queryplanner.html#partialsort
cb3aa0641d9a4https://sqlite.org/src/info/cb3aa0641d9a4
LIKEhttps://sqlite.org/lang_expr.html#like
GLOBhttps://sqlite.org/lang_expr.html#glob
REGEXPhttps://sqlite.org/lang_expr.html#regexp
virtual tableshttps://sqlite.org/vtab.html
colUsed fieldhttps://sqlite.org/vtab.html#colUsed
sqlite3_index_infohttps://sqlite.org/c3ref/index_info.html
sqlite3_module.xBestIndexhttps://sqlite.org/vtab.html#xbestindex
PRAGMA cache_spillhttps://sqlite.org/pragma.html#pragma_cache_spill
sqldiffhttps://sqlite.org/sqldiff.html
sqlite3_db_cacheflush()https://sqlite.org/c3ref/db_cacheflush.html
sqlite3_strlike()https://sqlite.org/c3ref/strlike.html
memory-mapped I/Ohttps://sqlite.org/mmap.html
sqlite3_snapshot_get()https://sqlite.org/c3ref/snapshot_get.html
sqlite3_snapshot_open()https://sqlite.org/c3ref/snapshot_open.html
sqlite3_snapshot_free()https://sqlite.org/c3ref/snapshot_free.html
'utc' modifierhttps://sqlite.org/lang_datefunc.html#localtime
date and time functionshttps://sqlite.org/lang_datefunc.html
json_group_array()https://sqlite.org/json1.html#jgrouparray
json_group_object()https://sqlite.org/json1.html#jgroupobject
jsonhttps://sqlite.org/json1.html#jmini
SQLITE_LIKE_DOESNT_MATCH_BLOBShttps://sqlite.org/compile.html#like_doesnt_match_blobs
(details)https://sqlite.org/src/fdiff?sbs=1&v1=869c95b0fc73026d&v2=232c242a0ccb3d67
command-line shellhttps://sqlite.org/cli.html
dot-commandshttps://sqlite.org/cli.html#dotcmd
cmd.exehttps://en.wikipedia.org/wiki/Cmd.exe
38a97a87a6https://sqlite.org/src/tktview?name=38a97a87a6
common table expressionshttps://sqlite.org/lang_with.html
sqldiffhttps://sqlite.org/sqldiff.html
ac661962a2aeab3c331https://sqlite.org/src/info/ac661962a2aeab3c331
automatic indexinghttps://sqlite.org/optoverview.html#autoindex
8a2adec1https://sqlite.org/src/info/8a2adec1
the json1 extensionhttps://sqlite.org/json1.html
57eec374ae1d0a1dhttps://sqlite.org/src/info/57eec374ae1d0a1d
version numbering conventionshttps://sqlite.org/versionnumbers.html
semantic versioninghttp://semver.org/
the json1 extensionhttps://sqlite.org/json1.html
amalgamationhttps://sqlite.org/amalgamation.html
SQLITE_ENABLE_JSON1https://sqlite.org/compile.html#enable_json1
Full Text Search version 5 (FTS5)https://sqlite.org/fts5.html
amalgamationhttps://sqlite.org/amalgamation.html
SQLITE_ENABLE_FTS5https://sqlite.org/compile.html#enable_fts5
CREATE VIEWhttps://sqlite.org/lang_createview.html
indexes on expressionshttps://sqlite.org/expridx.html
table-valued functionshttps://sqlite.org/vtab.html#tabfunc2
SELECThttps://sqlite.org/lang_select.html
eponymous virtual tableshttps://sqlite.org/vtab.html#epovtab
VIEWhttps://sqlite.org/lang_createview.html
sqlite3_value_subtype()https://sqlite.org/c3ref/value_subtype.html
sqlite3_result_subtype()https://sqlite.org/c3ref/result_subtype.html
the json1 extensionhttps://sqlite.org/json1.html
partial indexeshttps://sqlite.org/partialindex.html
dbstat virtual tablehttps://sqlite.org/dbstat.html
table-valued functionhttps://sqlite.org/vtab.html#tabfunc2
sqlite3_memory_alarm()https://sqlite.org/c3ref/aggregate_count.html
SQLite Encryption Extensionhttps://sqlite.org/see/doc/trunk/www/readme.wiki
VACUUMhttps://sqlite.org/lang_vacuum.html
sqlite3_initialize()https://sqlite.org/c3ref/initialize.html
OR optimizationhttps://sqlite.org/optoverview.html#or_opt
WHERE-clause push-down optimizationhttps://sqlite.org/optoverview.html#pushdown
c2a19d81652f40568chttps://sqlite.org/src/info/c2a19d81652f40568c
PRAGMA cache_sizehttps://sqlite.org/pragma.html#pragma_cache_size
sqlite3_changes()https://sqlite.org/c3ref/changes.html
WITHOUT ROWIDhttps://sqlite.org/withoutrowid.html
RBUhttps://sqlite.org/rbu.html
FTS5https://sqlite.org/fts5.html
sqlite3_value_dup()https://sqlite.org/c3ref/value_dup.html
sqlite3_value_free()https://sqlite.org/c3ref/value_dup.html
spellfix1https://sqlite.org/spellfix1.html
ON CONFLICThttps://sqlite.org/lang_conflict.html
IS operatorhttps://sqlite.org/lang_expr.html#isisnot
automatic indexinghttps://sqlite.org/optoverview.html#autoindex
common table expressionshttps://sqlite.org/lang_with.html
PRAGMA cell_size_checkhttps://sqlite.org/pragma.html#pragma_cell_size_check
matchinfo 'b' flaghttps://sqlite.org/fts3.html#matchinfo-b
matchinfo()https://sqlite.org/fts3.html#matchinfo
FTS3https://sqlite.org/fts3.html
SQLITE_MUTEX_STATIC_VFS1https://sqlite.org/c3ref/c_mutex_fast.html
VFShttps://sqlite.org/vfs.html
sqlite3_profile()https://sqlite.org/c3ref/profile.html
sqlite3_reset()https://sqlite.org/c3ref/reset.html
sqlite3_finalize()https://sqlite.org/c3ref/finalize.html
version 3.8.0https://sqlite.org/changes.html#version_3_8_0
version 3.3.9https://sqlite.org/changes.html#version_3_3_9
cachegrindhttp://valgrind.org/docs/manual/cg-manual.html
speedtest1.chttps://sqlite.org/src/artifact/83f6b3318f7ee
sqlite3_result_zeroblob64()https://sqlite.org/c3ref/result_blob.html
sqlite3_bind_zeroblob64()https://sqlite.org/c3ref/bind_blob.html
CREATE TABLE AShttps://sqlite.org/lang_createtable.html#createtabas
f2ad7de056ab1dc9200https://sqlite.org/src/info/f2ad7de056ab1dc9200
CREATE TABLE AShttps://sqlite.org/lang_createtable.html#createtabas
sqlite_master tablehttps://sqlite.org/schematab.html
873cae2b6e25bhttps://sqlite.org/src/info/873cae2b6e25b
skip-scan optimizationhttps://sqlite.org/optoverview.html#skipscan
OR optimizationhttps://sqlite.org/optoverview.html#or_opt
WITHOUT ROWIDhttps://sqlite.org/withoutrowid.html
8fd39115d8f46https://sqlite.org/src/info/8fd39115d8f46
sqlite3_memory_used()https://sqlite.org/c3ref/memory_highwater.html
sqlite3_memory_highwater()https://sqlite.org/c3ref/memory_highwater.html
version 3.8.7https://sqlite.org/changes.html#version_3_8_7
INSERThttps://sqlite.org/lang_insert.html
34cd55d68e0https://sqlite.org/src/info/34cd55d68e0e6e7c9a0711aab81a2ee3c354b4c0
sqlite3_compileoption_used()https://sqlite.org/c3ref/compileoption_get.html
SQLITE_ENABLE_DBSTAT_VTABhttps://sqlite.org/compile.html#enable_dbstat_vtab
command-line shellhttps://sqlite.org/cli.html
dbstat virtual tablehttps://sqlite.org/dbstat.html
sqldiff.exehttps://sqlite.org/sqldiff.html
matchinfo y flaghttps://sqlite.org/fts3.html#matchinfo-y
matchinfo()https://sqlite.org/fts3.html#matchinfo
FTS3https://sqlite.org/fts3.html
ORDER BYhttps://sqlite.org/lang_select.html#orderby
VACUUMhttps://sqlite.org/lang_vacuum.html
CREATE INDEXhttps://sqlite.org/lang_createindex.html
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
PRAGMA quick_checkhttps://sqlite.org/pragma.html#pragma_quick_check
SQL fuzzinghttps://sqlite.org/testing.html#fuzztesting
examplehttps://sqlite.org/c3ref/context.html
American Fuzzy Lop fuzzerhttps://sqlite.org/testing.html#aflfuzz
testing strategyhttps://sqlite.org/testing.html
command-line shellhttps://sqlite.org/cli.html
dbstat virtual tablehttps://sqlite.org/dbstat.html
SQLITE_ENABLE_DBSTAT_VTABhttps://sqlite.org/compile.html#enable_dbstat_vtab
sqlite3_status64()https://sqlite.org/c3ref/status.html
PRAGMA index_xinfohttps://sqlite.org/pragma.html#pragma_index_xinfo
sqlite3_blob_read()https://sqlite.org/c3ref/blob_read.html
sqlite3_blob_write()https://sqlite.org/c3ref/blob_write.html
SQLITE_OMIT_AUTORESEThttps://sqlite.org/compile.html#omit_autoreset
command-line shellhttps://sqlite.org/cli.html
2326c258d02ead33https://sqlite.org/src/info/2326c258d02ead33
partial indexhttps://sqlite.org/partialindex.html
linenoisehttps://github.com/antirez/linenoise
command-line shellhttps://sqlite.org/cli.html
sqlite3_wal_checkpoint_v2(TRUNCATE)https://sqlite.org/c3ref/wal_checkpoint_v2.html
f97c4637102a3ae72b79https://sqlite.org/src/tktview?name=f97c4637102a3ae72b79
PRAGMA data_versionhttps://sqlite.org/pragma.html#pragma_data_version
SQLITE_CHECKPOINT_TRUNCATEhttps://sqlite.org/c3ref/c_checkpoint_full.html
sqlite3_wal_checkpoint_v2()https://sqlite.org/c3ref/wal_checkpoint_v2.html
PRAGMA wal_checkpointhttps://sqlite.org/pragma.html#pragma_wal_checkpoint
sqlite3_stmt_scanstatus()https://sqlite.org/c3ref/stmt_scanstatus.html
SQLITE_ENABLE_STMT_SCANSTATUShttps://sqlite.org/compile.html#enable_stmt_scanstatus
sqlite3_table_column_metadata()https://sqlite.org/c3ref/table_column_metadata.html
WITHOUT ROWIDhttps://sqlite.org/withoutrowid.html
SQLITE_ENABLE_COLUMN_METADATAhttps://sqlite.org/compile.html#enable_column_metadata
SQLITE_ENABLE_API_ARMORhttps://sqlite.org/compile.html#enable_api_armor
SQLITE_REVERSE_UNORDERED_SELECTShttps://sqlite.org/compile.html#reverse_unordered_selects
SQLITE_SORTER_PMASZhttps://sqlite.org/compile.html#sorter_pmasz
SQLITE_CONFIG_PMASZhttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfigpmasz
SQLITE_CONFIG_PCACHE_HDRSZhttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfigpcachehdrsz
sqlite3_config()https://sqlite.org/c3ref/config.html
SQLITE_CONFIG_PAGECACHEhttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfigpagecache
VALUES clausehttps://sqlite.org/lang_select.html#values
SQLITE_LIMIT_COMPOUND_SELECThttps://sqlite.org/c3ref/c_limit_attached.html#sqlitelimitcompoundselect
eval.chttps://sqlite.org/src/artifact/f971962e92ebb8b0
loadable extensionhttps://sqlite.org/loadext.html
skip-scan optimizationhttps://sqlite.org/optoverview.html#skipscan
automatic indexinghttps://sqlite.org/optoverview.html#autoindex
partial indexhttps://sqlite.org/partialindex.html
6f2222d550f5b0ee7edhttps://sqlite.org/src/info/6f2222d550f5b0ee7ed
c5ea805691bfc4204b1cb9ehttps://sqlite.org/src/info/c5ea805691bfc4204b1cb9e
shared cache modehttps://sqlite.org/sharedcache.html
american fuzzy lophttp://lcamtuf.coredump.cx/afl/
a59ae93ee990a55https://sqlite.org/src/info/a59ae93ee990a55
R-Tree extensionhttps://sqlite.org/rtree.html
likelihood()https://sqlite.org/lang_corefunc.html#likelihood
likely()https://sqlite.org/lang_corefunc.html#likely
unlikely()https://sqlite.org/lang_corefunc.html#unlikely
shared cache modehttps://sqlite.org/sharedcache.html
e4a18565a36884b00edfhttps://sqlite.org/src/info/e4a18565a36884b00edf
6f2222d550f5b0ee7edhttps://sqlite.org/src/info/6f2222d550f5b0ee7ed
ROLLBACKhttps://sqlite.org/lang_transaction.html
SQLITE_ABORThttps://sqlite.org/rescode.html#abort
SQLITE_ABORT_ROLLBACKhttps://sqlite.org/rescode.html#abort_rollback
094d39a4c95ee4https://sqlite.org/src/info/094d39a4c95ee4
db87229497https://sqlite.org/src/info/db87229497
PRAGMA journal_mode=TRUNCATEhttps://sqlite.org/pragma.html#pragma_journal_mode
ALTER TABLE ADD COLUMNhttps://sqlite.org/lang_altertable.html
VIEWhttps://sqlite.org/lang_createview.html
rowidhttps://sqlite.org/lang_createtable.html#rowid
version 3.8.0https://sqlite.org/changes.html#version_3_8_0
cachegrindhttp://valgrind.org/docs/manual/cg-manual.html
speedtest1.chttps://sqlite.org/src/artifact/83f6b3318f7ee
PRAGMA threadshttps://sqlite.org/pragma.html#pragma_threads
SQLITE_DEFAULT_WORKER_THREADShttps://sqlite.org/compile.html#default_worker_threads
skip-scanhttps://sqlite.org/optoverview.html#skipscan
CASThttps://sqlite.org/lang_expr.html#castexpr
sqlite_stat4https://sqlite.org/fileformat2.html#stat4tab
sqlite3_malloc64()https://sqlite.org/c3ref/free.html
sqlite3_realloc64()https://sqlite.org/c3ref/free.html
sqlite3_bind_blob64()https://sqlite.org/c3ref/bind_blob.html
sqlite3_result_blob64()https://sqlite.org/c3ref/result_blob.html
sqlite3_bind_text64()https://sqlite.org/c3ref/bind_blob.html
sqlite3_result_text64()https://sqlite.org/c3ref/result_blob.html
sqlite3_msize()https://sqlite.org/c3ref/free.html
sqlite3_malloc64()https://sqlite.org/c3ref/free.html
SQLITE_LIMIT_WORKER_THREADShttps://sqlite.org/c3ref/c_limit_attached.html#sqlitelimitworkerthreads
sqlite3_limit()https://sqlite.org/c3ref/limit.html
PRAGMA threadshttps://sqlite.org/pragma.html#pragma_threads
spellfix1https://sqlite.org/spellfix1.html
User Authenticationhttps://sqlite.org/src/doc/trunk/ext/userauth/user-auth.txt
partial indexhttps://sqlite.org/partialindex.html
viewhttps://sqlite.org/lang_createview.html
98d973b8f5https://sqlite.org/src/info/98d973b8f5
ba7cbfaedc7e6https://sqlite.org/src/info/ba7cbfaedc7e6
sqlite3_trace()https://sqlite.org/c3ref/profile.html
11d5aa455e0d98f3c1e6a08https://sqlite.org/src/info/11d5aa455e0d98f3c1e6a08
369d57fb8e5ccdff06f1https://sqlite.org/src/info/369d57fb8e5ccdff06f1
command-line shellhttps://sqlite.org/cli.html
SQLITE_DEBUGhttps://sqlite.org/compile.html#debug
command-line shellhttps://sqlite.org/cli.html
hexadecimal integer literalshttps://sqlite.org/lang_expr.html#hexint
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
UNIQUEhttps://sqlite.org/lang_createtable.html#uniqueconst
NOT NULLhttps://sqlite.org/lang_createtable.html#notnullconst
SQLITE_MAX_ATTACHEDhttps://sqlite.org/limits.html#max_attached
WAL modehttps://sqlite.org/wal.html
SQLITE_PROTOCOLhttps://sqlite.org/rescode.html#protocol
likely(X)https://sqlite.org/lang_corefunc.html#likely
unicode61https://sqlite.org/fts3.html#unicode61
FTS4https://sqlite.org/fts3.html#fts4
ANALYZEhttps://sqlite.org/lang_analyze.html
loadable extensionhttps://sqlite.org/loadext.html
fileio.chttps://sqlite.org/src/finfo?name=ext/misc/fileio.c
readfile(X) and writefile(X,Y)https://sqlite.org/cli.html#fileio
command-line shellhttps://sqlite.org/cli.html
.fullschemahttps://sqlite.org/cli.html#fullschema
command-line shellhttps://sqlite.org/cli.html
DISTINCThttps://sqlite.org/lang_select.html#distinct
IN operatorhttps://sqlite.org/lang_expr.html#in_op
IN operatorhttps://sqlite.org/lang_expr.html#in_op
sqlite_stat4https://sqlite.org/fileformat2.html#stat4tab
ANALYZEhttps://sqlite.org/lang_analyze.html
skip-scan optimizationhttps://sqlite.org/optoverview.html#skipscan
VDBEhttps://sqlite.org/opcode.html
CREATE UNIQUE INDEXhttps://sqlite.org/lang_createindex.html
WITHOUT ROWIDhttps://sqlite.org/withoutrowid.html
9a6daf340df99ba93chttps://sqlite.org/src/info/9a6daf340df99ba93c
R-Tree extensionhttps://sqlite.org/rtree.html
IN operatorhttps://sqlite.org/lang_expr.html#in_op
d2889096e7bdeac6https://sqlite.org/src/info/d2889096e7bdeac6
sqlite3_stmt_busy()https://sqlite.org/c3ref/stmt_busy.html
ROLLBACKhttps://sqlite.org/lang_transaction.html
3a88d85f36704eebe1https://sqlite.org/src/info/3a88d85f36704eebe1
command-line shellhttps://sqlite.org/cli.html
column affinityhttps://sqlite.org/datatype3.html#affinity
IN operatorhttps://sqlite.org/lang_expr.html#in_op
9a8b09f8e6https://sqlite.org/src/info/9a8b09f8e6
ANALYZEhttps://sqlite.org/lang_analyze.html
WITHOUT ROWIDhttps://sqlite.org/withoutrowid.html
sqlite_stat4https://sqlite.org/fileformat2.html#stat4tab
b2fa5424e6fcb15https://sqlite.org/src/info/b2fa5424e6fcb15
partial sorting by indexhttps://sqlite.org/queryplanner.html#partialsort
automerge commandhttps://sqlite.org/fts3.html#*fts4automergecmd
FTS4https://sqlite.org/fts3.html#fts4
sqlite3_rtree_query_callback()https://sqlite.org/rtree.html#xquery
R-Tree extensionhttps://sqlite.org/rtree.html
URI query parametershttps://sqlite.org/uri.html#coreqp
OR optimizationhttps://sqlite.org/queryplanner.html#or_in_where
WITHOUT ROWIDhttps://sqlite.org/withoutrowid.html
command-line shellhttps://sqlite.org/cli.html
SQLITE_IOCAP_IMMUTABLEhttps://sqlite.org/c3ref/c_iocap_atomic.html
VFShttps://sqlite.org/vfs.html
SQLITE_TESTCTRL_BYTEORDERhttps://sqlite.org/c3ref/c_testctrl_always.html
07d6a0453dhttps://sqlite.org/src/info/07d6a0453d
e39d032577https://sqlite.org/src/info/e39d032577
a8a0d2996ahttps://sqlite.org/src/info/a8a0d2996a
10fb063b11https://sqlite.org/src/info/10fb063b11
2ea3e9fe63https://sqlite.org/src/info/2ea3e9fe63
264b970c43https://sqlite.org/src/info/264b970c4379fd
b75a9ca6b0https://sqlite.org/src/info/b75a9ca6b0499
55746f9e65https://sqlite.org/src/info/55746f9e65f85
e9654505cfdhttps://sqlite.org/src/info/e9654505cfda9
command-line shellhttps://sqlite.org/cli.html
notindexed columnhttps://sqlite.org/fts3.html#fts4notindexed
sqlite3_db_readonly()https://sqlite.org/c3ref/db_readonly.html
one-character fixhttps://sqlite.org/src/fdiff?sbs=1&v1=7d539cedb1c&v2=ebad891b7494d&smhdr
Ticket 98825a79ce14https://sqlite.org/src/info/98825a79ce1456863
skip-scan optimizationhttps://sqlite.org/optoverview.html#skipscan
SQLITE_TESTCTRL_VDBE_COVERAGEhttps://sqlite.org/c3ref/c_testctrl_always.html
sqlite3_test_control()https://sqlite.org/c3ref/test_control.html
char()https://sqlite.org/lang_corefunc.html#char
zeroblobhttps://sqlite.org/lang_corefunc.html#zeroblob
Ticket [fccbde530a]https://sqlite.org/src/info/fccbde530a
SQLITE_ENABLE_STAT4https://sqlite.org/compile.html#enable_stat4
Ticket [4c86b126f2]https://sqlite.org/src/info/4c86b126f2
Ticket [c34d0557f7]https://sqlite.org/src/info/c34d0557f7
Ticket [8c63ff0eca]https://sqlite.org/src/info/8c63ff0eca
Ticket [65bdeb9739]https://sqlite.org/src/info/65bdeb9739
Ticket [4ef7e3cfca]https://sqlite.org/src/info/4ef7e3cfca
4c86b126f2https://sqlite.org/src/info/4c86b126f2
SQLITE_ENABLE_STAT3https://sqlite.org/compile.html#enable_stat3
SQLITE_ENABLE_STAT4https://sqlite.org/compile.html#enable_stat4
common table expressionshttps://sqlite.org/lang_with.html
WITH clausehttps://sqlite.org/lang_with.html
printf()https://sqlite.org/lang_corefunc.html#printf
SQLITE_DETERMINISTIChttps://sqlite.org/c3ref/c_deterministic.html#sqlitedeterministic
sqlite3_create_function()https://sqlite.org/c3ref/create_function.html
SQLITE_READONLY_DBMOVEDhttps://sqlite.org/rescode.html#readonly_dbmoved
ATTACHhttps://sqlite.org/lang_attach.html
VALUES clausehttps://sqlite.org/lang_select.html#values
SELECThttps://sqlite.org/lang_select.html
sqlite3_randomness(N,P)https://sqlite.org/c3ref/randomness.html
spellfix1https://sqlite.org/spellfix1.html
EXPLAINhttps://sqlite.org/lang_explain.html
Lemon parser generatorhttps://sqlite.org/lemon.html
Lemonhttps://sqlite.org/lemon.html
command-line shellhttps://sqlite.org/cli.html
CAST expressionhttps://sqlite.org/lang_expr.html#castexpr
WITHOUT ROWIDhttps://sqlite.org/withoutrowid.html
skip-scan optimizationhttps://sqlite.org/optoverview.html#skipscan
virtual tablehttps://sqlite.org/vtab.html
sqlite3_index_infohttps://sqlite.org/c3ref/index_info.html
R-Tree extensionhttps://sqlite.org/rtree.html
SQLITE_ENABLE_EXPLAIN_COMMENTShttps://sqlite.org/compile.html#enable_explain_comments
EXPLAINhttps://sqlite.org/lang_explain.html
SQLITE_ENABLE_EXPLAIN_COMMENTShttps://sqlite.org/compile.html#enable_explain_comments
command-line shellhttps://sqlite.org/cli.html
command-line shellhttps://sqlite.org/cli.html
unlikely()https://sqlite.org/lang_corefunc.html#unlikely
likelihood()https://sqlite.org/lang_corefunc.html#likelihood
soft_heap_limit pragmahttps://sqlite.org/pragma.html#pragma_soft_heap_limit
SQLITE_ENABLE_STAT4https://sqlite.org/compile.html#enable_stat4
sqlite_stat1.stathttps://sqlite.org/fileformat2.html#stat1tab
SQLITE_MINIMUM_FILE_DESCRIPTORhttps://sqlite.org/compile.html#minimum_file_descriptor
Date And Time Functionshttps://sqlite.org/lang_datefunc.html
sqlite3_step()https://sqlite.org/c3ref/step.html
FTS4https://sqlite.org/fts3.html#fts4
fts4aux languageid columnhttps://sqlite.org/fts3.html#f4alid
fts4auxhttps://sqlite.org/fts3.html#fts4aux
VACUUMhttps://sqlite.org/lang_vacuum.html
sqlite3_temp_directoryhttps://sqlite.org/c3ref/temp_directory.html
PRAGMA statshttps://sqlite.org/pragma.html#pragma_stats
partial indexhttps://sqlite.org/partialindex.html
a5c8ed66cahttps://sqlite.org/src/info/a5c8ed66ca
partial indexeshttps://sqlite.org/partialindex.html
next generation query plannerhttps://sqlite.org/queryplanner-ng.html
EXPLAIN QUERY PLANhttps://sqlite.org/eqp.html
FTS4 notindexed optionhttps://sqlite.org/fts3.html#fts4notindexed
SQLITE_STMTSTATUS_VM_STEPhttps://sqlite.org/c3ref/c_stmtstatus_counter.html#sqlitestmtstatusvmstep
sqlite3_stmt_status()https://sqlite.org/c3ref/stmt_status.html
cache_spill pragmahttps://sqlite.org/pragma.html#pragma_cache_spill
query_only pragmahttps://sqlite.org/pragma.html#pragma_query_only
defer_foreign_keys pragmahttps://sqlite.org/pragma.html#pragma_defer_foreign_keys
sqlite3_db_statushttps://sqlite.org/c3ref/db_status.html
SQLITE_DBSTATUS_DEFERRED_FKShttps://sqlite.org/c3ref/c_dbstatus_options.html#sqlitedbstatusdeferredfks
loadable extensionhttps://sqlite.org/loadext.html
SQLITE_ALLOW_URI_AUTHORITYhttps://sqlite.org/compile.html#allow_uri_authority
sqlite3_cancel_auto_extension(X)https://sqlite.org/c3ref/cancel_auto_extension.html
SQLITE_DEFAULT_AUTOMATIC_INDEXhttps://sqlite.org/compile.html#default_automatic_index
SQLITE_WARNING_AUTOINDEXhttps://sqlite.org/rescode.html#warning_autoindex
SQLITE_CONFIG_LOGhttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfiglog
SQLITE_FTS3_MAX_EXPR_DEPTHhttps://sqlite.org/compile.html#fts3_max_expr_depth
SQLITE_BUSY_SNAPSHOThttps://sqlite.org/rescode.html#busy_snapshot
application-defined SQL functionshttps://sqlite.org/appfunc.html
command-line shellhttps://sqlite.org/cli.html
unicode61https://sqlite.org/fts3.html#unicode61
FTS4https://sqlite.org/fts3.html#fts4
NGQPhttps://sqlite.org/queryplanner-ng.html
memory-mapped I/Ohttps://sqlite.org/mmap.html
sqlite3_strglob()https://sqlite.org/c3ref/strglob.html
database headerhttps://sqlite.org/fileformat2.html#database_header
Application IDhttps://sqlite.org/fileformat2.html#appid
application file-formathttps://sqlite.org/appfileformat.html
PRAGMA application_idhttps://sqlite.org/pragma.html#pragma_application_id
error loghttps://sqlite.org/errlog.html
unlinked database fileshttps://sqlite.org/howtocorrupt.html#unlink
database filename aliasinghttps://sqlite.org/howtocorrupt.html#alias
error loghttps://sqlite.org/errlog.html
SQLITE_TRACE_SIZE_LIMIThttps://sqlite.org/compile.html#trace_size_limit
SQLITE_MAX_SCHEMA_RETRYhttps://sqlite.org/compile.html#max_schema_retry
extension loadinghttps://sqlite.org/loadext.html
sqlite3_load_extension()https://sqlite.org/c3ref/load_extension.html
FTS3https://sqlite.org/fts3.html
fts4auxhttps://sqlite.org/fts3.html#fts4aux
fts3tokenize virtual tablehttps://sqlite.org/fts3.html#fts3tok
full-text searchhttps://sqlite.org/fts3.html
VFShttps://sqlite.org/vfs.html
shared cache modehttps://sqlite.org/sharedcache.html
database connectionhttps://sqlite.org/c3ref/sqlite3.html
e636a050b7https://sqlite.org/src/info/e636a050b7
2500cdb9be05https://sqlite.org/src/info/2500cdb9be05
ba82a4a41eac1https://sqlite.org/src/info/ba82a4a41eac1
f69b96e3076ehttps://sqlite.org/src/info/f69b96e3076e
command-line shellhttps://sqlite.org/cli.html
PRAGMAhttps://sqlite.org/pragma.html#syntax
sqlite3_trace()https://sqlite.org/c3ref/profile.html
compound queryhttps://sqlite.org/lang_select.html#compound
COLLATE operatorhttps://sqlite.org/lang_expr.html#collateop
6709574d2a8d8https://sqlite.org/src/info/6709574d2a8d8
authorizerhttps://sqlite.org/c3ref/set_authorizer.html
UPDATEhttps://sqlite.org/lang_update.html
0eb70d77cb05bb2272https://sqlite.org/src/info/0eb70d77cb05bb2272
f2369304e4https://sqlite.org/src/info/f2369304e4
collating sequencehttps://sqlite.org/datatype3.html#collation
0fc59f908bhttps://sqlite.org/src/info/0fc59f908b
7ff3120e4fhttps://sqlite.org/src/info/7ff3120e4f
version 3.7.15https://sqlite.org/changes.html#version_3_7_15
a179fe7465https://sqlite.org/src/info/a179fe7465
CAST expressionhttps://sqlite.org/lang_expr.html#castexpr
689137afb6da41https://sqlite.org/src/info/689137afb6da41
FTS3https://sqlite.org/fts3.html
38b1ae018fhttps://sqlite.org/src/info/38b1ae018f
6bfb98dfc0chttps://sqlite.org/src/info/6bfb98dfc0c
PRAGMA foreign_key_checkhttps://sqlite.org/pragma.html#pragma_foreign_key_check
unicode(A)https://sqlite.org/lang_corefunc.html#unicode
char(X1,...,XN)https://sqlite.org/lang_corefunc.html#char
PRAGMA incremental_vacuumhttps://sqlite.org/pragma.html#pragma_incremental_vacuum
PRAGMA table_infohttps://sqlite.org/pragma.html#pragma_table_info
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
RTREEhttps://sqlite.org/rtree.html
command-line shellhttps://sqlite.org/cli.html
command-line shellhttps://sqlite.org/cli.html
PRAGMA vdbe_addoptracehttps://sqlite.org/pragma.html#pragma_vdbe_addoptrace
PRAGMA vdbe_debughttps://sqlite.org/pragma.html#pragma_vdbe_debug
spellfix1https://sqlite.org/spellfix1.html
fc7bd6358fhttps://sqlite.org/src/info/fc7bd6358f
version 3.7.15https://sqlite.org/changes.html#version_3_7_15
598f5f7596b055https://sqlite.org/src/info/598f5f7596b055
version 3.7.15https://sqlite.org/changes.html#version_3_7_15
a7b7803e8d1e869https://sqlite.org/src/info/a7b7803e8d1e869
sqlite3_errstr()https://sqlite.org/c3ref/errcode.html
sqlite3_trace()https://sqlite.org/c3ref/profile.html
SQLITE_SCHEMAhttps://sqlite.org/rescode.html#schema
busy_timeout pragmahttps://sqlite.org/pragma.html#pragma_busy_timeout
instr()https://sqlite.org/lang_corefunc.html#instr
SQLITE_FCNTL_BUSYHANDLERhttps://sqlite.org/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlbusyhandler
VFSeshttps://sqlite.org/vfs.html
shared cache modehttps://sqlite.org/sharedcache.html
backup APIhttps://sqlite.org/backup.html
shared cachehttps://sqlite.org/sharedcache.html
COLLATE operatorhttps://sqlite.org/lang_expr.html#collateop
CHECK constrainthttps://sqlite.org/lang_createtable.html#ckconst
viewhttps://sqlite.org/lang_createview.html
shared cache modehttps://sqlite.org/sharedcache.html
[d02e1406a58ea02d]]https://sqlite.org/src/tktview/d02e1406a58ea02d
VFShttps://sqlite.org/vfs.html
sqlite3_vfs_register()https://sqlite.org/c3ref/vfs_find.html
command-line shellhttps://sqlite.org/cli.html
sqlite3_close_v2()https://sqlite.org/c3ref/close.html
command-line shellhttps://sqlite.org/cli.html
SQLITE_OMIT_FLOATING_POINThttps://sqlite.org/compile.html#omit_floating_point
SQLITE_OMIT_AUTOINIThttps://sqlite.org/compile.html#omit_autoinit
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
PRAGMA quick_checkhttps://sqlite.org/pragma.html#pragma_quick_check
WAL modehttps://sqlite.org/wal.html
SQLITE_DISABLE_FTS4_DEFERREDhttps://sqlite.org/compile.html#disable_fts4_deferred
covering indexhttps://sqlite.org/queryplanner.html#covidx
or optimizationhttps://sqlite.org/optoverview.html#or_opt
In-memory databaseshttps://sqlite.org/inmemorydb.html
URI filenameshttps://sqlite.org/uri.html
shared cachehttps://sqlite.org/sharedcache.html#inmemsharedcache
mode=memoryhttps://sqlite.org/uri.html#coreqp
URI filenameshttps://sqlite.org/uri.html
shared cachehttps://sqlite.org/sharedcache.html
RTREEhttps://sqlite.org/rtree.html
sqlite3_create_module()https://sqlite.org/c3ref/create_module.html
sqlite3_create_module_v2()https://sqlite.org/c3ref/create_module.html
virtual tablehttps://sqlite.org/vtab.html
(ticket c2ad16f997)https://sqlite.org/src/info/c2ad16f997ee9c
SQLITE_DBSTATUS_CACHE_WRITEhttps://sqlite.org/c3ref/c_dbstatus_options.html#sqlitedbstatuscachewrite
sqlite3_db_status()https://sqlite.org/c3ref/db_status.html
typeof()https://sqlite.org/lang_corefunc.html#typeof
length()https://sqlite.org/lang_corefunc.html#length
FTS4 "merge" commandhttps://sqlite.org/fts3.html#*fts4mergecmd
FTS4 "automerge" commandhttps://sqlite.org/fts3.html#*fts4automergecmd
FTS4 "integrity-check" commandhttps://sqlite.org/fts3.html#*fts4ickcmd
CHECKhttps://sqlite.org/lang_createtable.html#ckconst
VFShttps://sqlite.org/vfs.html
SQLITE_RTREE_INT_ONLYhttps://sqlite.org/compile.html#rtree_int_only
R*Tree Extension Modulehttps://sqlite.org/rtree.html
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
RELEASEhttps://sqlite.org/lang_savepoint.html
385a5b56b9https://sqlite.org/src/info/385a5b56b9
2a5629202fhttps://sqlite.org/src/info/2a5629202f
INSERThttps://sqlite.org/lang_insert.html
CREATE VIRTUAL TABLEhttps://sqlite.org/lang_createvtab.html
sqlite3_stricmp()https://sqlite.org/c3ref/stricmp.html
sqlite3_strnicmp()https://sqlite.org/c3ref/stricmp.html
sqlite3_db_readonly()https://sqlite.org/c3ref/db_readonly.html
SQLITE_FCNTL_PRAGMAhttps://sqlite.org/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlpragma
VFShttps://sqlite.org/vfs.html
PRAGMAhttps://sqlite.org/pragma.html#syntax
FTS4 languageid optionhttps://sqlite.org/fts3.html#*fts4languageid
FTS4 content optionhttps://sqlite.org/fts3.html#*fts4content
version 3.7.9https://sqlite.org/changes.html#version_3_7_9
ROLLBACKhttps://sqlite.org/lang_transaction.html
command-line shellhttps://sqlite.org/cli.html
bughttps://sqlite.org/src/info/b7c8682cc1
version 3.7.10https://sqlite.org/changes.html#version_3_7_10
schema format numberhttps://sqlite.org/fileformat2.html#schemaformat
PRAGMA legacy_file_format=ONhttps://sqlite.org/pragma.html#pragma_legacy_file_format
descending indiceshttps://sqlite.org/lang_createindex.html#descidx
SQLITE_CONFIG_PCACHEhttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfigpcache
SQLITE_CONFIG_GETPCACHEhttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfiggetpcache
sqlite3_pcache_methods2https://sqlite.org/c3ref/pcache_methods2.html
SQLITE_CONFIG_PCACHE2https://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfigpcache2
SQLITE_CONFIG_GETPCACHE2https://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfiggetpcache2
powersafe overwritehttps://sqlite.org/psow.html
SQLITE_IOCAP_POWERSAFE_OVERWRITEhttps://sqlite.org/c3ref/c_iocap_atomic.html
SQLITE_POWERSAFE_OVERWRITEhttps://sqlite.org/compile.html#powersafe_overwrite
URI filenameshttps://sqlite.org/uri.html
sqlite3_db_release_memory()https://sqlite.org/c3ref/db_release_memory.html
shrink_memory pragmahttps://sqlite.org/pragma.html#pragma_shrink_memory
sqlite3_db_filename()https://sqlite.org/c3ref/db_filename.html
sqlite3_stmt_busy()https://sqlite.org/c3ref/stmt_busy.html
sqlite3_uri_boolean()https://sqlite.org/c3ref/uri_boolean.html
sqlite3_uri_int64()https://sqlite.org/c3ref/uri_boolean.html
PRAGMA cache_sizehttps://sqlite.org/pragma.html#pragma_cache_size
VFShttps://sqlite.org/vfs.html
VFShttps://sqlite.org/vfs.html
VFShttps://sqlite.org/vfs.html
VFSeshttps://sqlite.org/vfs.html
TCL Interfacehttps://sqlite.org/tclsqlite.html
SQLITE_TESTCTRL_EXPLAIN_STMThttps://sqlite.org/c3ref/c_testctrl_always.html
SQLITE_ENABLE_TREE_EXPLAINhttps://sqlite.org/compile.html#enable_tree_explain
command-line shellhttps://sqlite.org/cli.html
ff5be73deehttps://sqlite.org/src/info/ff5be73dee
7bbfb7d442https://sqlite.org/src/info/7bbfb7d442
ac00f496b7e2https://sqlite.org/src/info/ac0ff496b7e2
FTS4https://sqlite.org/fts3.html#fts4
SQLITE_DBSTATUS_CACHE_HIThttps://sqlite.org/c3ref/c_dbstatus_options.html#sqlitedbstatuscachehit
SQLITE_DBSTATUS_CACHE_MISShttps://sqlite.org/c3ref/c_dbstatus_options.html#sqlitedbstatuscachemiss
sqlite3_db_status()https://sqlite.org/c3ref/db_status.html
SQLITE_ENABLE_STAT2https://sqlite.org/compile.html#enable_stat2
SQLITE_ENABLE_STAT3https://sqlite.org/compile.html#enable_stat3
sqlite3_data_count()https://sqlite.org/c3ref/data_count.html
SQLITE_FCNTL_OVERWRITEhttps://sqlite.org/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntloverwrite
lookaside memory allocatorhttps://sqlite.org/malloc.html#lookaside
SQLITE_DIRECT_OVERFLOW_READhttps://sqlite.org/compile.html#direct_overflow_read
overflow pageshttps://sqlite.org/fileformat2.html#ovflpgs
page cachehttps://sqlite.org/c3ref/pcache_methods2.html
sqlite3_mprintf()https://sqlite.org/c3ref/mprintf.html
ALTER TABLE ... RENAMEhttps://sqlite.org/lang_altertable.html
page_counthttps://sqlite.org/pragma.html#pragma_page_count
quick_checkhttps://sqlite.org/pragma.html#pragma_quick_check
VACUUMhttps://sqlite.org/lang_vacuum.html
count_changes pragmahttps://sqlite.org/pragma.html#pragma_count_changes
virtual tablehttps://sqlite.org/vtab.html
FTS4https://sqlite.org/fts3.html#fts4
droppedhttps://sqlite.org/lang_droptable.html
SAVEPOINThttps://sqlite.org/lang_savepoint.html
CREATE INDEXhttps://sqlite.org/lang_createindex.html
a bughttps://sqlite.org/src/info/25ee812710
PRAGMA case_sensitive_likehttps://sqlite.org/pragma.html#pragma_case_sensitive_like
SQLITE_SCHEMAhttps://sqlite.org/rescode.html#schema
URI filenameshttps://sqlite.org/uri.html
sqlite3_vtab_config()https://sqlite.org/c3ref/vtab_config.html
ON CONFLICThttps://sqlite.org/lang_conflict.html
virtual tableshttps://sqlite.org/vtab.html
xSavepointhttps://sqlite.org/vtab.html#xsavepoint
xReleasehttps://sqlite.org/vtab.html#xsavepoint
xRollbackTohttps://sqlite.org/vtab.html#xsavepoint
virtual tableshttps://sqlite.org/vtab.html
SAVEPOINThttps://sqlite.org/lang_savepoint.html
FTS3/FTS4https://sqlite.org/fts3.html
RTREEhttps://sqlite.org/rtree.html
ON CONFLICThttps://sqlite.org/lang_conflict.html
REPLACEhttps://sqlite.org/lang_replace.html
FTS4 prefix optionhttps://sqlite.org/fts3.html#fts4prefix
FTS4 order optionhttps://sqlite.org/fts3.html#fts4order
WAL-modehttps://sqlite.org/wal.html
short filenameshttps://sqlite.org/shortnames.html
WAL modehttps://sqlite.org/wal.html
cache_sizehttps://sqlite.org/pragma.html#pragma_cache_size
SQLITE_FCNTL_SIZE_HINThttps://sqlite.org/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlsizehint
sqlite3_wal_checkpoint_v2()https://sqlite.org/c3ref/wal_checkpoint_v2.html
wal_checkpoint pragmahttps://sqlite.org/pragma.html#pragma_wal_checkpoint
SQLITE_ENABLE_STAT2https://sqlite.org/compile.html#enable_stat2
sqlite3_finalize()https://sqlite.org/c3ref/finalize.html
VFS objecthttps://sqlite.org/c3ref/vfs.html
SQLITE_MAX_ATTACHEDhttps://sqlite.org/limits.html#max_attached
fts4auxhttps://sqlite.org/fts3.html#fts4aux
compressed FTS4 contenthttps://sqlite.org/fts3.html#*fts4compression
ANALYZEhttps://sqlite.org/lang_analyze.html
sqlite3_vsnprintf()https://sqlite.org/c3ref/mprintf.html
SQLITE_DBSTATUS_LOOKASIDE_HIThttps://sqlite.org/c3ref/c_dbstatus_options.html#sqlitedbstatuslookasidehit
SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZEhttps://sqlite.org/c3ref/c_dbstatus_options.html#sqlitedbstatuslookasidemisssize
SQLITE_DBSTATUS_LOOKASIDE_MISS_FULLhttps://sqlite.org/c3ref/c_dbstatus_options.html#sqlitedbstatuslookasidemissfull
sqlite3_db_status()https://sqlite.org/c3ref/db_status.html
SQLITE_OMIT_AUTORESEThttps://sqlite.org/compile.html#omit_autoreset
SQLITE_DEFAULT_FOREIGN_KEYShttps://sqlite.org/compile.html#default_foreign_keys
sqlite3_stmt_readonly()https://sqlite.org/c3ref/stmt_readonly.html
VACUUMhttps://sqlite.org/lang_vacuum.html
command-line shellhttps://sqlite.org/cli.html
a bughttps://sqlite.org/src/info/5d863f876e
sqlite3_trace()https://sqlite.org/c3ref/profile.html
SQLITE_NOTFOUNDhttps://sqlite.org/rescode.html#notfound
SQLITE_ERRORhttps://sqlite.org/rescode.html#error
SQLITE_FCNTL_SYNC_OMITTEDhttps://sqlite.org/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlsyncomitted
file controlhttps://sqlite.org/c3ref/file_control.html
PRAGMA synchronoushttps://sqlite.org/pragma.html#pragma_synchronous
sqlite3_blob_reopen()https://sqlite.org/c3ref/blob_reopen.html
sqlite3_blobhttps://sqlite.org/c3ref/blob.html
sqlite3_blob_reopen()https://sqlite.org/c3ref/blob_reopen.html
VFSeshttps://sqlite.org/c3ref/vfs.html
WALhttps://sqlite.org/wal.html
PRAGMA locking_modehttps://sqlite.org/pragma.html#pragma_locking_mode
EXPLAIN QUERY PLANhttps://sqlite.org/eqp.html
sqlite3_stmt_readonly()https://sqlite.org/c3ref/stmt_readonly.html
PRAGMA checkpoint_fullfsynchttps://sqlite.org/pragma.html#pragma_checkpoint_fullfsync
SQLITE_FCNTL_FILE_POINTERhttps://sqlite.org/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlfilepointer
sqlite3_file_control()https://sqlite.org/c3ref/file_control.html
FTS4https://sqlite.org/fts3.html#fts4
matchinfo()https://sqlite.org/fts3.html#matchinfo
very obscure bughttps://sqlite.org/src/info/80ba201079
or optimizationhttps://sqlite.org/optoverview.html#or_opt
sqlite3_create_function_v2()https://sqlite.org/c3ref/create_function.html
custom r-tree querieshttps://sqlite.org/rtree.html#customquery
SQLITE_CONFIG_PAGECACHEhttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfigpagecache
sqlite3_soft_heap_limit64()https://sqlite.org/c3ref/hard_heap_limit64.html
SQLITE_ENABLE_MEMORY_MANAGEMENThttps://sqlite.org/compile.html#enable_memory_management
sqlite3_soft_heap_limit64()https://sqlite.org/c3ref/hard_heap_limit64.html
sqlite3_soft_heap_limit()https://sqlite.org/c3ref/soft_heap_limit.html
ANALYZEhttps://sqlite.org/lang_analyze.html
WALhttps://sqlite.org/wal.html
old and very obscure bughttps://sqlite.org/src/info/5e10420e8d
free-page listhttps://sqlite.org/fileformat2.html#freelist
incremental_vacuumhttps://sqlite.org/pragma.html#pragma_incremental_vacuum
SQLITE_DBSTATUS_SCHEMA_USEDhttps://sqlite.org/c3ref/c_dbstatus_options.html#sqlitedbstatusschemaused
SQLITE_DBSTATUS_STMT_USEDhttps://sqlite.org/c3ref/c_dbstatus_options.html#sqlitedbstatusstmtused
sqlite3_db_status()https://sqlite.org/c3ref/db_status.html
LIKE optimizationhttps://sqlite.org/optoverview.html#like_opt
SQLITE_FCNTL_CHUNK_SIZEhttps://sqlite.org/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlchunksize
sqlite3_file_control()https://sqlite.org/c3ref/file_control.html
Ticket [51ae9cad317a1]https://sqlite.org/src/info/51ae9cad317a1
write-ahead logginghttps://sqlite.org/wal.html
SQLITE_DBSTATUS_CACHE_USEDhttps://sqlite.org/c3ref/c_dbstatus_options.html#sqlitedbstatuscacheused
sqlite3_db_status()https://sqlite.org/c3ref/db_status.html
FTS3https://sqlite.org/fts3.html
secure_delete pragmahttps://sqlite.org/pragma.html#pragma_secure_delete
sqlite3_compileoption_used()https://sqlite.org/c3ref/compileoption_get.html
sqlite3_compileoption_get()https://sqlite.org/c3ref/compileoption_get.html
compile_options pragmahttps://sqlite.org/pragma.html#pragma_compile_options
sqlite_compileoption_used()https://sqlite.org/lang_corefunc.html#sqlite_compileoption_used
sqlite_compileoption_get()https://sqlite.org/lang_corefunc.html#sqlite_compileoption_get
sqlite3_log()https://sqlite.org/c3ref/log.html
SQLITE_CONFIG_LOGhttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfiglog
sqlite3_config()https://sqlite.org/c3ref/config.html
Command Line Interfacehttps://sqlite.org/cli.html
FTS3https://sqlite.org/fts3.html
SQLITE_OMIT_FLOATING_POINThttps://sqlite.org/compile.html#omit_floating_point
integrity_check pragmahttps://sqlite.org/pragma.html#pragma_integrity_check
Command Line Interfacehttps://sqlite.org/cli.html
Lemon LALR(1) parser generatorhttps://sqlite.org/lemon.html
FTS3https://sqlite.org/fts3.html
sqlite3_trace()https://sqlite.org/c3ref/profile.html
bound parametershttps://sqlite.org/lang_expr.html#varparam
ifnull()https://sqlite.org/lang_corefunc.html#ifnull
coalesce()https://sqlite.org/lang_corefunc.html#coalesce
substr()https://sqlite.org/lang_corefunc.html#substr
FTS3 documentationhttps://sqlite.org/fts3.html
SQLITE_SECURE_DELETEhttps://sqlite.org/compile.html#secure_delete
truncate optimizationhttps://sqlite.org/lang_delete.html#truncateopt
Command Line Interfacehttps://sqlite.org/cli.html
prepared statementshttps://sqlite.org/c3ref/stmt.html
SQLITE_ENABLE_STAT2https://sqlite.org/compile.html#enable_stat2
the OP_If bughttps://sqlite.org/src/info/6b00e0a34c
foreign key constraintshttps://sqlite.org/foreignkeys.html
foreign_keys pragmahttps://sqlite.org/pragma.html#pragma_foreign_keys
TCL Interfacehttps://sqlite.org/tclsqlite.html
Non-Recursive Engine (NRE)http://www.tcl-lang.org/cgi-bin/tct/tip/322.html
Fossilhttp://www.fossil-scm.org/
SQLITE_ENABLE_STAT2https://sqlite.org/compile.html#enable_stat2
ANALYZEhttps://sqlite.org/lang_analyze.html
PRAGMA recursive_triggershttps://sqlite.org/pragma.html#pragma_recursive_triggers
REPLACE conflict resolutionhttps://sqlite.org/lang_conflict.html
SQLITE_OPEN_SHAREDCACHEhttps://sqlite.org/c3ref/c_open_autoproxy.html
SQLITE_OPEN_PRIVATECACHEhttps://sqlite.org/c3ref/c_open_autoproxy.html
sqlite3_open_v2()https://sqlite.org/c3ref/open.html
shared cache modehttps://sqlite.org/sharedcache.html
SQLITE_SOURCE_IDhttps://sqlite.org/c3ref/c_scm_branch.html
sqlite3_sourceid()https://sqlite.org/c3ref/libversion.html
sqlite_source_id()https://sqlite.org/lang_corefunc.html#sqlite_source_id
[efc02f9779]https://sqlite.org/src/info/efc02f9779
sqlite3_strnicmp()https://sqlite.org/c3ref/stricmp.html
virtual tableshttps://sqlite.org/vtab.html
shared cache modehttps://sqlite.org/sharedcache.html
100% branch test coveragehttps://sqlite.org/testing.html#coverage
sqlite3_create_function()https://sqlite.org/c3ref/create_function.html
SQLITE_MISUSEhttps://sqlite.org/rescode.html#misuse
SQLITE_ERRORhttps://sqlite.org/rescode.html#error
sqlite3_shutdown()https://sqlite.org/c3ref/initialize.html
version 3.6.14https://sqlite.org/changes.html#version_3_6_14
group_concat()https://sqlite.org/lang_aggfunc.html#group_concat
sqlite3_backuphttps://sqlite.org/c3ref/backup.html
asynchronous VFShttps://sqlite.org/asyncvfs.html
virtual tableshttps://sqlite.org/vtab.html
SQLITE_HAVE_ISNANhttps://sqlite.org/compile.html#have_isnan
version 3.6.12https://sqlite.org/changes.html#version_3_6_12
version 3.6.12https://sqlite.org/changes.html#version_3_6_12
incremental_vacuumhttps://sqlite.org/pragma.html#pragma_incremental_vacuum
sqlite3_unlock_notify()https://sqlite.org/c3ref/unlock_notify.html
reverse_unordered_selects pragmahttps://sqlite.org/pragma.html#pragma_reverse_unordered_selects
CLIhttps://sqlite.org/cli.html
hot-backup interfacehttps://sqlite.org/c3ref/backup_finish.html#sqlite3backupinit
CLIhttps://sqlite.org/cli.html
backuphttps://sqlite.org/tclsqlite.html#backup
restorehttps://sqlite.org/tclsqlite.html#restore
syntax bubble diagramshttps://sqlite.org/syntaxdiagrams.html
nested transactionshttps://sqlite.org/lang_savepoint.html
OR-connected constraintshttps://sqlite.org/optoverview.html#or_opt
SQLITE_ENABLE_FTS3_PARENTHESIShttps://sqlite.org/compile.html#enable_fts3_parenthesis
sqlite3_auto_extension()https://sqlite.org/c3ref/auto_extension.html
sqlite3_vfshttps://sqlite.org/c3ref/vfs.html
version 3.6.6https://sqlite.org/changes.html#version_3_6_6
version 3.6.4https://sqlite.org/changes.html#version_3_6_4
memsys5https://sqlite.org/malloc.html#memsys5
application-defined page cachehttps://sqlite.org/c3ref/pcache_methods2.html
journal_mode pragmahttps://sqlite.org/pragma.html#pragma_journal_mode
sqlite3_db_mutex()https://sqlite.org/c3ref/db_mutex.html
SQLITE_OMIT_TRUNCATE_OPTIMIZATIONhttps://sqlite.org/compile.html#omit_truncate_optimization
truncate optimizationhttps://sqlite.org/lang_delete.html#truncateopt
sqlite3_changes()https://sqlite.org/c3ref/changes.html
sqlite3_total_changes()https://sqlite.org/c3ref/total_changes.html
count_changes pragmahttps://sqlite.org/pragma.html#pragma_count_changes
sqlite3_extended_errcode()https://sqlite.org/c3ref/errcode.html
COMMIThttps://sqlite.org/lang_transaction.html
SQLITE_BUSYhttps://sqlite.org/rescode.html#busy
SQLITE_BUSYhttps://sqlite.org/rescode.html#busy
SQLITE_ERRORhttps://sqlite.org/rescode.html#error
ROLLBACKhttps://sqlite.org/lang_transaction.html
experimental memory allocatorshttps://sqlite.org/malloc.html#memsysx
SQLITE_ZERO_MALLOChttps://sqlite.org/compile.html#zero_malloc
DELETEhttps://sqlite.org/lang_delete.html
UPDATEhttps://sqlite.org/lang_update.html
SQLITE_ENABLE_UPDATE_DELETE_LIMIThttps://sqlite.org/compile.html#enable_update_delete_limit
sqlite3_stmt_status()https://sqlite.org/c3ref/stmt_status.html
INDEXED BYhttps://sqlite.org/lang_indexedby.html
PRAGMA journal_modehttps://sqlite.org/pragma.html#pragma_journal_mode
source codehttps://sqlite.org/src/finfo?name=tool/genfkey.c
documentationhttps://sqlite.org/src/finfo?name=tool/genfkey.README
SQLITE_OMIT_TRUNCATE_OPTIMIZATIONhttps://sqlite.org/compile.html#omit_truncate_optimization
SQL language documentationhttps://sqlite.org/lang.html
syntax diagramshttps://sqlite.org/syntaxdiagrams.html
lookaside memory allocatorhttps://sqlite.org/malloc.html#lookaside
SQLITE_CONFIG_LOOKASIDEhttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfiglookaside
sqlite3_config()https://sqlite.org/c3ref/config.html
SQLITE_STATUS_PAGECACHE_SIZEhttps://sqlite.org/c3ref/c_status_malloc_count.html#sqlitestatuspagecachesize
SQLITE_STATUS_SCRATCH_SIZEhttps://sqlite.org/c3ref/c_status_malloc_count.html#sqlitestatusscratchsize
sqlite3_status()https://sqlite.org/c3ref/status.html
SQLITE_CONFIG_PAGECACHEhttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfigpagecache
SQLITE_CONFIG_SCRATCHhttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfigscratch
sqlite3_db_config()https://sqlite.org/c3ref/db_config.html
sqlite3_db_status()https://sqlite.org/c3ref/db_status.html
database connectionhttps://sqlite.org/c3ref/sqlite3.html
virtual file systemhttps://sqlite.org/c3ref/vfs.html
35to36.htmlhttps://sqlite.org/35to36.html
sqlite3_config()https://sqlite.org/c3ref/config.html
SQLITE_CONFIG_MUTEXhttps://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfigmutex
sqlite3_config()https://sqlite.org/c3ref/config.html
sqlite3_status()https://sqlite.org/c3ref/status.html
sqlite3_initialize()https://sqlite.org/c3ref/initialize.html
sqlite3_shutdown()https://sqlite.org/c3ref/initialize.html
SQLITE_OPEN_NOMUTEXhttps://sqlite.org/c3ref/c_open_autoproxy.html
sqlite3_open_v2()https://sqlite.org/c3ref/open.html
PRAGMA page_counthttps://sqlite.org/pragma.html#pragma_page_count
sqlite3_next_stmt()https://sqlite.org/c3ref/next_stmt.html
R*Tree virtual tablehttps://sqlite.org/rtree.html
journal_modehttps://sqlite.org/pragma.html#pragma_journal_mode
Journal mode PERSISThttps://sqlite.org/pragma.html#pragma_journal_mode
exclusive locking modehttps://sqlite.org/pragma.html#pragma_locking_mode
version 3.5.8https://sqlite.org/changes.html#version_3_5_8
sqlite3_mprintf()https://sqlite.org/c3ref/mprintf.html
sqlite3_randomness()https://sqlite.org/c3ref/randomness.html
sqlite3_context_db_handle()https://sqlite.org/c3ref/context_db_handle.html
database connectionhttps://sqlite.org/c3ref/sqlite3.html
sqlite3_limit()https://sqlite.org/c3ref/limit.html
VACUUMhttps://sqlite.org/lang_vacuum.html
sqlite3_result_error_code()https://sqlite.org/c3ref/result_blob.html
ATTACHhttps://sqlite.org/lang_attach.html
ATTACHhttps://sqlite.org/lang_attach.html
VACUUMhttps://sqlite.org/lang_vacuum.html
legacy_file_format pragmahttps://sqlite.org/pragma.html#pragma_legacy_file_format
auto_vacuumhttps://sqlite.org/pragma.html#pragma_auto_vacuum
separate CM systemhttps://sqlite.org/docsrc/
sqlite3_prepare_v2()https://sqlite.org/c3ref/prepare.html
sqlite3_step()https://sqlite.org/c3ref/step.html
SQLITE_MISUSEhttps://sqlite.org/rescode.html#misuse
SQLITE_OMIT_MEMORY_ALLOCATIONhttps://sqlite.org/compile.html#omitfeatures
SQLITE_FULLhttps://sqlite.org/rescode.html#full
SQLITE_FULLhttps://sqlite.org/rescode.html#full
SQLITE_IOERRhttps://sqlite.org/rescode.html#ioerr
34to35.htmlhttps://sqlite.org/34to35.html
sqlite3_release_memory()https://sqlite.org/c3ref/release_memory.html
sqlite3_soft_heap_limit()https://sqlite.org/c3ref/soft_heap_limit.html
sqlite3_enable_shared_cache()https://sqlite.org/c3ref/enable_shared_cache.html
sqlite3_open_v2()https://sqlite.org/c3ref/open.html
auto-vacuum modehttps://sqlite.org/pragma.html#pragma_auto_vacuum
sqlite3_soft_heap_limithttps://sqlite.org/c3ref/soft_heap_limit.html
sqlite3_soft_heap_limithttps://sqlite.org/c3ref/soft_heap_limit.html
GCC bug 32575http://gcc.gnu.org/bugzilla/show_bug.cgi?id=32575
VACUUMhttps://sqlite.org/lang_vacuum.html
TCL language interfacehttps://sqlite.org/tclsqlite.html
PRAGMA freelist_counthttps://sqlite.org/pragma.html#pragma_freelist_count
PRAGMA auto_vacuum=incrementalhttps://sqlite.org/pragma.html#pragma_auto_vacuum
min()/max() optimizationhttps://sqlite.org/optoverview.html#minmax
ICUhttps://icu.unicode.org
SQLITE_BUSYhttps://sqlite.org/rescode.html#busy
upper boundshttps://sqlite.org/limits.html
Incremental BLOB I/Ohttps://sqlite.org/c3ref/blob_open.html
sqlite3_bind_zeroblob()https://sqlite.org/c3ref/bind_blob.html
zeroblob()https://sqlite.org/lang_corefunc.html#zeroblob
Incremental Vacuumhttps://sqlite.org/pragma.html#pragma_incremental_vacuum
International Components for Unicode (ICU)https://icu.unicode.org
sqlite3_column_blob()https://sqlite.org/c3ref/column_blob.html
sqlite3_snprintf()https://sqlite.org/c3ref/mprintf.html
Version 3.3.14https://sqlite.org/changes.html#version_3_3_14
Version 3.3.15https://sqlite.org/changes.html#version_3_3_15
"PRAGMA locking_mode=EXCLUSIVE"https://sqlite.org/pragma.html#pragma_locking_mode
randomblob()https://sqlite.org/lang_corefunc.html#randomblob
hex()https://sqlite.org/lang_corefunc.html#hex
UUIDshttp://en.wikipedia.org/wiki/UUID
PRAGMA count_changeshttps://sqlite.org/pragma.html#pragma_count_changes
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
sqlite3_prepare_v2()https://sqlite.org/c3ref/prepare.html
sqlite3_prepare_v2()https://sqlite.org/c3ref/prepare.html
user_versionhttps://sqlite.org/pragma.html#pragma_user_version
schema_versionhttps://sqlite.org/pragma.html#pragma_schema_version
sqlite3_prepare_v2()https://sqlite.org/c3ref/prepare.html
sqlite3_interrupt()https://sqlite.org/c3ref/interrupt.html
MATCHhttps://sqlite.org/lang_expr.html#match
SQLITE_OMIT_FLOATING_POINThttps://sqlite.org/compile.html#omit_floating_point
SQLITE_OMIT_...https://sqlite.org/compile.html#omitfeatures
More informationhttps://sqlite.org/version3.html
Lemonhttps://sqlite.org/lemon.html
NULL-handling documenthttps://sqlite.org/nulls.html
Lemon parser generatorhttps://sqlite.org/lemon.html
Lemon parser generatorhttps://sqlite.org/lemon.html
VDBE tutorialhttps://sqlite.org/vdbe.html
VDBE tutorialhttps://sqlite.org/vdbe.html
PostgreSQLhttp://www.postgresql.org/

Viewport: width=device-width, initial-scale=1.0


URLs of crawlers that visited me.