APSW
About
Tips
Example/Tour
Installation and customization
Extensions
Best Practice
APSW Module
Connections to a database
Cursors (executing SQL)
Blob Input/Output
Backup
JSON Example/Tour
JSON (Javascript Object Notation)
Full Text Search Example/Tour
Full text search
Unicode Text Handling
Session Example/Tour
Session extension
Virtual Tables
Virtual File System (VFS)
Shell
Various interesting and useful bits of functionality
Async Example/Tour
Concurrency & Async
Exceptions and Errors
Execution and tracing
SQLite extra
DBAPI notes
sqlite3 module differences
Benchmarking
Copyright and License
Change History
Module Index
Index
APSW
Index
Index
_
|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
K
|
L
|
M
|
N
|
O
|
P
|
Q
|
R
|
S
|
T
|
U
|
V
|
W
|
X
|
Y
|
Z
_
__aenter__() (apsw.Backup method)
(apsw.Blob method)
(apsw.Connection method)
__aexit__() (apsw.Backup method)
(apsw.Blob method)
(apsw.Connection method)
__aiter__() (apsw.Cursor method)
__anext__() (apsw.Cursor method)
__call__() (apsw.ext.DataClassRowFactory method)
(apsw.ext.Function method)
(apsw.ext.TypesConverterCursorFactory method)
(apsw.ext.VirtualModuleCallable method)
(apsw.FTS5Tokenizer method)
__enter__() (apsw.Backup method)
(apsw.Blob method)
(apsw.Connection method)
__exit__() (apsw.Backup method)
(apsw.Blob method)
(apsw.Connection method)
__iter__() (apsw.Cursor method)
__next__() (apsw.Cursor method)
A
AbortError
Accessing results by column name (example code)
aclose() (apsw.Backup method)
(apsw.Blob method)
(apsw.Connection method)
(apsw.Cursor method)
(apsw.Session method)
action (apsw.ext.QueryAction attribute)
action_name (apsw.ext.QueryAction attribute)
actions (apsw.ext.QueryDetails attribute)
adapt_value() (apsw.ext.TypesConverterCursorFactory method)
add() (apsw.ChangesetBuilder method)
add_change() (apsw.ChangesetBuilder method)
addr (apsw.ext.VDBEInstruction attribute)
afinish() (apsw.Backup method)
AggregateClass (class in apsw)
AggregateFactory (class in apsw)
AggregateFinal (class in apsw)
AggregateStep (class in apsw)
AggregateT (class in apsw)
allow_missing_dict_bindings() (in module apsw)
analyze_pages() (in module apsw.ext)
AND (class in apsw.fts5query)
AnyIO (class in apsw.aio)
applicable_columns() (in module apsw.fts5query)
application_id (apsw.ext.DatabaseFileInfo attribute)
apply() (apsw.Changeset method)
(in module apsw.bestpractice)
Applying changesets (Session example code)
apsw
module
apsw.aio
module
apsw.bestpractice
module
apsw.ext
module
apsw.fts5
module
apsw.fts5.RegexPreTokenizer (Full text search example code)
apsw.fts5.RegexTokenizer (Full text search example code)
apsw.fts5.SimplifyTokenizer (Full text search example code)
apsw.fts5.UnicodeWordsTokenizer (Full text search example code)
apsw.fts5aux
module
apsw.fts5query
module
apsw.shell
module
apsw.sqlite_extra
module
apsw.unicode
module
apsw_version() (in module apsw)
apswversion
apsw.apsw_version
args (apsw.FTS5Tokenizer attribute)
as_async() (apsw.Connection class method)
async_controller (apsw.Connection attribute)
(in module apsw)
async_cursor_prefetch (in module apsw)
async_run() (apsw.Connection method)
async_run_coro (in module apsw)
async_run_coro() (apsw.aio.AnyIO method)
(apsw.aio.AsyncIO method)
(apsw.aio.Trio method)
AsyncConnection (class in apsw)
AsyncConnectionController (class in apsw)
AsyncIO (class in apsw.aio)
AsyncSession (class in apsw)
attach() (apsw.Session method)
AuthError
authorizer (apsw.Connection attribute)
Authorizer (class in apsw)
Authorizer (control what SQL can do) (example code)
Auto() (in module apsw.aio)
Autocomplete (Full text search example code)
autoimport (Shell command)
autovacuum_pages() (apsw.Connection method)
autovacuum_top_root (apsw.ext.DatabaseFileInfo attribute)
aux_data (apsw.FTS5ExtensionApi attribute)
Auxiliary functions (Full text search example code)
B
Backup (Async example code)
(class in apsw)
backup (Shell command)
Backup an open database (example code)
backup() (apsw.Connection method)
bail (Shell command)
Basics (Async example code)
Begin() (apsw.VTTable method)
Best Practice (example code)
BestIndex() (apsw.VTTable method)
BestIndexObject() (apsw.VTTable method)
Binding (class in apsw)
bindings (apsw.ext.QueryDetails attribute)
Bindings (class in apsw)
Bindings (dict) (example code)
Bindings (sequence) (example code)
bindings_count (apsw.Cursor attribute)
(apsw.ext.QueryDetails attribute)
bindings_names (apsw.Cursor attribute)
(apsw.ext.QueryDetails attribute)
BindingsError
Blob (Async example code)
(class in apsw)
Blob I/O (example code)
blob_open() (apsw.Connection method)
blob_write (apsw.PreUpdate attribute)
blobopen
Connection.blob_open
bm25() (in module apsw.fts5aux)
BusyError
By_Attr (apsw.ext.VTColumnAccess attribute)
By_Index (apsw.ext.VTColumnAccess attribute)
By_Name (apsw.ext.VTColumnAccess attribute)
C
cache_flush() (apsw.Connection method)
cache_stats() (apsw.Connection method)
cacheflush
Connection.cache_flush
Caching (example code)
Cancellation (Async example code)
CantOpenError
carray() (in module apsw)
CArrayBinding (class in apsw)
casefold() (in module apsw.unicode)
category() (in module apsw.unicode)
cd (Shell command)
cells (apsw.ext.PageUsage attribute)
CENTER (apsw.unicode.Justify attribute)
change_cookie (apsw.fts5.Table property)
changes (Shell command)
changes() (apsw.Connection method)
Changeset (class in apsw)
changeset() (apsw.Session method)
changeset_size (apsw.Session attribute)
changeset_stream() (apsw.Session method)
changeset_to_sql() (in module apsw.ext)
ChangesetBuilder (class in apsw)
(Session example code)
ChangesetInput (class in apsw)
check_progress_steps (in module apsw.aio)
Checking APSW and SQLite versions (example code)
checkpoint_sequence_number (apsw.ext.WALFileInfo attribute)
checksum_1 (apsw.ext.WALFileInfo attribute)
checksum_2 (apsw.ext.WALFileInfo attribute)
choices (apsw.fts5.TokenizerArgument attribute)
Cleanup (example code)
(Full text search example code)
(JSON example code)
(Session example code)
close (Shell command)
close() (apsw.aio.AnyIO method)
(apsw.aio.AsyncIO method)
(apsw.aio.Trio method)
(apsw.Backup method)
(apsw.Blob method)
(apsw.ChangesetBuilder method)
(apsw.Connection method)
(apsw.Cursor method)
(apsw.Rebaser method)
(apsw.Session method)
Close() (apsw.VTCursor method)
closest_tokens() (apsw.fts5.Table method)
cmdloop() (apsw.shell.Shell method)
codepoint_name() (in module apsw.unicode)
collation_needed() (apsw.Connection method)
collationneeded
Connection.collation_needed
colour (Shell command)
Column() (apsw.VTCursor method)
column_access (apsw.ext.VirtualModuleCallable attribute)
column_count (apsw.FTS5ExtensionApi attribute)
(apsw.TableChange attribute)
column_locale() (apsw.FTS5ExtensionApi method)
column_metadata() (apsw.Connection method)
column_name (apsw.ext.QueryAction attribute)
column_named() (apsw.fts5.Table method)
column_size (apsw.fts5.MatchInfo attribute)
column_size() (apsw.FTS5ExtensionApi method)
column_text() (apsw.FTS5ExtensionApi method)
column_total_size() (apsw.FTS5ExtensionApi method)
COLUMNFILTER (class in apsw.fts5query)
ColumnNoChange() (apsw.VTCursor method)
columns (apsw.ext.VirtualModuleCallable attribute)
(apsw.fts5.FTS5TableStructure attribute)
(apsw.fts5.Table property)
(apsw.fts5query.COLUMNFILTER attribute)
(apsw.shell.Shell.Row attribute)
columns_indexed (apsw.fts5.Table property)
columnsize (apsw.fts5.FTS5TableStructure attribute)
colUsed (apsw.IndexInfo attribute)
command_delete() (apsw.fts5.Table method)
command_delete_all() (apsw.fts5.Table method)
command_integrity_check() (apsw.fts5.Table method)
command_merge() (apsw.fts5.Table method)
command_optimize() (apsw.fts5.Table method)
command_rebuild() (apsw.fts5.Table method)
comment (apsw.ext.VDBEInstruction attribute)
Commit hook (example code)
Commit() (apsw.VTTable method)
CommitHook (class in apsw)
compile_options (in module apsw)
complete() (apsw.shell.Shell method)
(in module apsw)
complete_command() (apsw.shell.Shell method)
complete_sql() (apsw.shell.Shell method)
concat() (apsw.Changeset method)
concat_stream() (apsw.Changeset method)
config() (apsw.Connection method)
(apsw.fts5.Table method)
(apsw.Session method)
(in module apsw)
config_automerge() (apsw.fts5.Table method)
config_crisismerge() (apsw.fts5.Table method)
config_deletemerge() (apsw.fts5.Table method)
config_insttoken() (apsw.fts5.Table method)
config_pgsz() (apsw.fts5.Table method)
config_rank() (apsw.fts5.Table method)
config_secure_delete() (apsw.fts5.Table method)
config_usermerge() (apsw.fts5.Table method)
configure() (apsw.aio.AnyIO method)
(apsw.aio.AsyncIO method)
(apsw.aio.Trio method)
(apsw.Rebaser method)
conflict (apsw.TableChange attribute)
Connect() (apsw.VTModule method)
connection (apsw.Cursor attribute)
(apsw.FTS5Tokenizer attribute)
(apsw.PreUpdate attribute)
Connection (class in apsw)
connection (Shell command)
connection_busy_timeout() (in module apsw.bestpractice)
connection_dqs() (in module apsw.bestpractice)
connection_enable_foreign_keys() (in module apsw.bestpractice)
connection_hooks (in module apsw)
connection_optimize() (in module apsw.bestpractice)
connection_recursive_triggers() (in module apsw.bestpractice)
connection_wal() (in module apsw.bestpractice)
ConnectionClosedError
ConnectionNotClosedError
connections() (in module apsw)
ConstraintError
content (apsw.fts5.FTS5TableStructure attribute)
Content (Full text search example code)
Content setup (Full text search example code)
content_rowid (apsw.fts5.FTS5TableStructure attribute)
contentless_delete (apsw.fts5.FTS5TableStructure attribute)
contentless_unindexed (apsw.fts5.FTS5TableStructure attribute)
contextvar_set() (in module apsw.aio)
convert_binding (apsw.Connection attribute)
(apsw.Cursor attribute)
convert_binding() (apsw.ext.TypesConverterCursorFactory method)
convert_boolean() (in module apsw.fts5)
convert_default (apsw.fts5.TokenizerArgument attribute)
convert_jsonb (apsw.Connection attribute)
(apsw.Cursor attribute)
convert_number_ranges() (in module apsw.fts5)
convert_string_to_python() (in module apsw.fts5)
convert_tokenize_reason() (in module apsw.fts5)
convert_unicode_categories() (in module apsw.fts5)
convert_value() (apsw.ext.TypesConverterCursorFactory method)
ConvertBinding (class in apsw)
ConvertJSONB (class in apsw)
convertor (apsw.fts5.TokenizerArgument attribute)
CorruptError
create() (apsw.fts5.Table class method)
Create() (apsw.VTModule method)
Create/open search table (Full text search example code)
create_aggregate_function() (apsw.Connection method)
create_collation() (apsw.Connection method)
create_module() (apsw.Connection method)
create_scalar_function() (apsw.Connection method)
create_window_function() (apsw.Connection method)
createaggregatefunction
Connection.create_aggregate_function
createcollation
Connection.create_collation
createmodule
Connection.create_module
createscalarfunction
Connection.create_scalar_function
Cursor (class in apsw)
cursor() (apsw.Connection method)
cursor_factory (apsw.Connection attribute)
CursorClosedError
Customising conversion (JSON example code)
D
data_stored (apsw.ext.PageUsage attribute)
data_version() (apsw.Connection method)
database_name (apsw.ext.QueryAction attribute)
(apsw.PreUpdate attribute)
DatabaseFileInfo (class in apsw.ext)
DatabasePageUsage (class in apsw.ext)
databases (Shell command)
DataClassRowFactory (class in apsw.ext)
Dates and times
db (apsw.shell.Shell property)
db_filename() (apsw.Connection method)
db_names() (apsw.Connection method)
dbconfig (Shell command)
dbinfo (Shell command)
dbinfo() (in module apsw.ext)
deadline (in module apsw.aio)
decode() (apsw.fts5query.QueryTokens class method)
default (apsw.fts5.TokenizerArgument attribute)
default_cache_size (apsw.ext.DatabaseFileInfo attribute)
Defining aggregate functions (example code)
Defining collations (sorting) (example code)
Defining scalar functions (example code)
Defining window functions (example code)
delete() (apsw.fts5.Table method)
depth (apsw.PreUpdate attribute)
description (apsw.Cursor attribute)
(apsw.ext.QueryDetails attribute)
description_full (apsw.Cursor attribute)
(apsw.ext.QueryDetails attribute)
deserialize() (apsw.Connection method)
Destroy() (apsw.VTTable method)
detail (apsw.ext.QueryPlan attribute)
(apsw.fts5.FTS5TableStructure attribute)
diff() (apsw.Session method)
Disconnect() (apsw.VTTable method)
distance (apsw.fts5query.NEAR attribute)
distinct (apsw.IndexInfo attribute)
done (apsw.Backup attribute)
drop_modules() (apsw.Connection method)
dump (Shell command)
E
echo (Shell command)
EmptyError
enable_load_extension() (apsw.Connection method)
enable_shared_cache() (in module apsw)
enabled (apsw.Session attribute)
enableloadextension
Connection.enable_load_extension
enablesharedcache
apsw.enable_shared_cache
encode() (apsw.fts5query.QueryTokens method)
encoding (Shell command)
Eof() (apsw.VTCursor method)
Error
error_offset (apsw.Error attribute)
estimatedCost (apsw.IndexInfo attribute)
estimatedRows (apsw.IndexInfo attribute)
excepthook() (apsw.VFS method)
(apsw.VFSFile method)
exception_for() (in module apsw)
exceptionfor
apsw.exception_for
exceptions (Shell command)
exec_trace (apsw.Connection attribute)
(apsw.Cursor attribute)
exectrace
Connection.exec_trace
Cursor.exec_trace
ExecTraceAbort
ExecTracer (class in apsw)
execute() (apsw.Connection method)
(apsw.Cursor method)
executemany (example code)
executemany() (apsw.Connection method)
(apsw.Cursor method)
Executing SQL (example code)
ExecutionCompleteError
exit (Shell command)
expand_tabs() (in module apsw.unicode)
expanded_sql (apsw.Cursor attribute)
(apsw.ext.QueryDetails attribute)
explain (apsw.ext.QueryDetails attribute)
extendedresult (apsw.Error attribute)
ExtensionLoadingError
extract_with_column_filters() (in module apsw.fts5query)
F
fetchall() (apsw.Cursor method)
fetchone() (apsw.Cursor method)
File Control (example code)
file_change_counter (apsw.ext.DatabaseFileInfo attribute)
file_control() (apsw.Connection method)
file_name (apsw.ext.QueryAction attribute)
filecontrol
Connection.file_control
filename (apsw.Connection attribute)
(apsw.ext.DatabaseFileInfo attribute)
(apsw.ext.JournalFileInfo attribute)
(apsw.ext.WALFileInfo attribute)
filename() (apsw.URIFilename method)
filename_journal (apsw.Connection attribute)
filename_wal (apsw.Connection attribute)
filter (apsw.fts5query.COLUMNFILTER attribute)
Filter() (apsw.VTCursor method)
find (Shell command)
find_columns() (in module apsw.ext)
FindFunction() (apsw.VTTable method)
finish() (apsw.Backup method)
first_query (apsw.ext.QueryDetails attribute)
fixup_backslashes() (apsw.shell.Shell method)
fk_conflicts (apsw.TableChange attribute)
fork_checker() (in module apsw)
ForkingViolationError
format_query_table() (in module apsw.ext)
format_sql_value() (in module apsw)
format_version (apsw.ext.WALFileInfo attribute)
FormatError
Formatting query results table (example code)
freelist_pages (apsw.ext.DatabaseFileInfo attribute)
from_dict() (in module apsw.fts5query)
fts5_tokenizer() (apsw.Connection method)
fts5_tokenizer_available() (apsw.Connection method)
FTS5ExtensionApi (class in apsw)
FTS5Function (class in apsw)
FTS5QueryPhrase (class in apsw)
FTS5TableStructure (class in apsw.fts5)
FTS5Tokenizer (class in apsw)
FTS5TokenizerFactory (class in apsw)
fts5vocab_name() (apsw.fts5.Table method)
ftsq (Shell command)
Full Text Search (Async example code)
FullError
Function (class in apsw.ext)
function_name (apsw.ext.QueryAction attribute)
Functions and callbacks (Async example code)
G
generate_series() (in module apsw.ext)
generate_series_sqlite() (in module apsw.ext)
get (apsw.Cursor attribute)
get_aConstraint_collation() (apsw.IndexInfo method)
get_aConstraint_iColumn() (apsw.IndexInfo method)
get_aConstraint_op() (apsw.IndexInfo method)
get_aConstraint_rhs() (apsw.IndexInfo method)
get_aConstraint_usable() (apsw.IndexInfo method)
get_aConstraintUsage_argvIndex() (apsw.IndexInfo method)
get_aConstraintUsage_in() (apsw.IndexInfo method)
get_aConstraintUsage_omit() (apsw.IndexInfo method)
get_aOrderBy_desc() (apsw.IndexInfo method)
get_aOrderBy_iColumn() (apsw.IndexInfo method)
get_autocommit() (apsw.Connection method)
get_column_names() (in module apsw.ext)
get_complete_line() (apsw.shell.Shell method)
get_connection() (apsw.Cursor method)
get_dataclass() (apsw.ext.DataClassRowFactory method)
get_description() (apsw.Cursor method)
get_exec_trace() (apsw.Connection method)
(apsw.Cursor method)
get_line() (apsw.shell.Shell method)
get_row_trace() (apsw.Connection method)
(apsw.Cursor method)
get_type() (apsw.ext.DataClassRowFactory method)
getautocommit
Connection.get_autocommit
getconnection
Cursor.get_connection
getdescription
Cursor.get_description
getexectrace
Connection.get_exec_trace
Cursor.get_exec_trace
getrowtrace
Connection.get_row_trace
Cursor.get_row_trace
grapheme_endswith() (in module apsw.unicode)
grapheme_find() (in module apsw.unicode)
grapheme_iter() (in module apsw.unicode)
grapheme_iter_with_offsets() (in module apsw.unicode)
grapheme_iter_with_offsets_filtered() (in module apsw.unicode)
grapheme_length() (in module apsw.unicode)
grapheme_next() (in module apsw.unicode)
grapheme_next_break() (in module apsw.unicode)
grapheme_startswith() (in module apsw.unicode)
grapheme_substr() (in module apsw.unicode)
guess_paragraphs() (in module apsw.unicode)
H
handle_exception() (apsw.shell.Shell method)
handle_interrupt() (apsw.shell.Shell method)
hard_heap_limit() (in module apsw)
has() (in module apsw.sqlite_extra)
has_vdbe (apsw.Cursor attribute)
(apsw.ext.QueryDetails attribute)
header (apsw.ext.DatabaseFileInfo attribute)
(apsw.ext.JournalFileInfo attribute)
header(s) (Shell command)
header_valid (apsw.ext.JournalFileInfo attribute)
help (Shell command)
HTML tokenizer (Full text search example code)
HTMLTokenizer() (in module apsw.fts5)
I
idxFlags (apsw.IndexInfo attribute)
idxNum (apsw.IndexInfo attribute)
idxStr (apsw.IndexInfo attribute)
import (Shell command)
in_transaction (apsw.Connection attribute)
IncompleteExecutionError
incremental_vacuum (apsw.ext.DatabaseFileInfo attribute)
index_info_to_dict() (in module apsw.ext)
IndexInfo (class in apsw)
indices (apsw.ext.PageUsage attribute)
(Shell command)
indirect (apsw.Session attribute)
(apsw.TableChange attribute)
initial (apsw.fts5query.PHRASE attribute)
Initial database setup (Session example code)
initial_pages (apsw.ext.JournalFileInfo attribute)
initialize() (in module apsw)
inst_count (apsw.FTS5ExtensionApi attribute)
inst_tokens() (apsw.FTS5ExtensionApi method)
Integrity() (apsw.VTTable method)
InternalError
interrupt() (apsw.Connection method)
InterruptError
InvalidContextError
inverse_document_frequency() (in module apsw.fts5aux)
invert() (apsw.Changeset method)
invert_stream() (apsw.Changeset method)
Inverting - undo
IOError
Is FTS5 available? (Full text search example code)
Is Session available? (Session example code)
is_async (apsw.Connection attribute)
is_empty (apsw.Session attribute)
is_explain (apsw.Cursor attribute)
(apsw.ext.QueryDetails attribute)
is_extended_pictographic() (in module apsw.unicode)
is_first (apsw.shell.Shell.Row attribute)
is_interrupted (apsw.Connection attribute)
is_last (apsw.shell.Shell.Row attribute)
is_readonly (apsw.Cursor attribute)
(apsw.ext.QueryDetails attribute)
is_regional_indicator() (in module apsw.unicode)
is_token() (apsw.fts5.Table method)
iter() (apsw.Changeset method)
J
JournalFileInfo (class in apsw.ext)
JSON
JSON tokenizer (Full text search example code)
jsonb_decode() (in module apsw)
jsonb_detect() (in module apsw)
jsonb_encode() (in module apsw)
JSONBTypes (class in apsw)
JSONTokenizer() (in module apsw.fts5)
Justify (class in apsw.unicode)
K
Key Tokens and More Like (Full text search example code)
key_tokens() (apsw.fts5.Table method)
keywords (in module apsw)
L
last_insert_rowid() (apsw.Connection method)
LEFT (apsw.unicode.Justify attribute)
length() (apsw.Blob method)
(apsw.zeroblob method)
library_logging() (in module apsw.bestpractice)
limit() (apsw.Connection method)
Limits (example code)
line_break_iter() (in module apsw.unicode)
line_break_iter_with_offsets() (in module apsw.unicode)
line_break_next() (in module apsw.unicode)
line_break_next_break() (in module apsw.unicode)
load (Shell command)
load() (in module apsw.sqlite_extra)
load_extension() (apsw.Connection method)
loadextension
Connection.load_extension
locale (apsw.fts5.FTS5TableStructure attribute)
LockedError
log (Shell command)
log() (in module apsw)
log_handler() (apsw.shell.Shell method)
log_sqlite() (in module apsw.ext)
Logging (example code)
M
magic_number (apsw.ext.WALFileInfo attribute)
main() (in module apsw.shell)
make_jsonb() (in module apsw.ext)
make_session() (in module apsw.aio)
make_virtual_module() (in module apsw.ext)
map_functions (in module apsw.fts5)
map_tokenizers (in module apsw.fts5)
mapping_access (in module apsw)
mapping_authorizer_function (in module apsw)
mapping_authorizer_return_codes (in module apsw)
mapping_bestindex_constraints (in module apsw)
mapping_carray (in module apsw)
mapping_config (in module apsw)
mapping_conflict_resolution_modes (in module apsw)
mapping_db_config (in module apsw)
mapping_db_status (in module apsw)
mapping_device_characteristics (in module apsw)
mapping_extended_result_codes (in module apsw)
mapping_file_control (in module apsw)
mapping_fts5_token_flags (in module apsw)
mapping_fts5_tokenize_reason (in module apsw)
mapping_function_flags (in module apsw)
mapping_limits (in module apsw)
mapping_locking_level (in module apsw)
mapping_open_flags (in module apsw)
mapping_prepare_flags (in module apsw)
mapping_result_codes (in module apsw)
mapping_session_changeset_apply_v2_flags (in module apsw)
mapping_session_changeset_start_v2_flags (in module apsw)
mapping_session_config_options (in module apsw)
mapping_session_conflict (in module apsw)
mapping_session_conflict_response (in module apsw)
mapping_session_object_config_options (in module apsw)
mapping_setlk_timeout_flags (in module apsw)
mapping_statement_status (in module apsw)
mapping_status (in module apsw)
mapping_sync (in module apsw)
mapping_trace_codes (in module apsw)
mapping_txn_state (in module apsw)
mapping_virtual_table_configuration_options (in module apsw)
mapping_virtual_table_scan_flags (in module apsw)
mapping_wal_checkpoint (in module apsw)
mapping_xshmlock_flags (in module apsw)
match (apsw.fts5query.NOT attribute)
MatchInfo (class in apsw.fts5)
max_page_count (apsw.ext.DatabasePageUsage attribute)
max_payload (apsw.ext.PageUsage attribute)
memdb
Memory database
memory_high_water() (in module apsw)
memory_used (apsw.Session attribute)
memory_used() (in module apsw)
memoryhighwater
apsw.memory_high_water
memoryused
apsw.memory_used
message (apsw.fts5query.ParseError attribute)
MismatchError
MisuseError
mode (Shell command)
module
apsw
apsw.aio
apsw.bestpractice
apsw.ext
apsw.fts5
apsw.fts5aux
apsw.fts5query
apsw.shell
apsw.sqlite_extra
apsw.unicode
module_name (apsw.ext.QueryAction attribute)
Monitoring changes (Session example code)
more_like() (apsw.fts5.Table method)
N
name (apsw.fts5.FTS5TableStructure attribute)
(apsw.FTS5Tokenizer attribute)
(apsw.TableChange attribute)
(apsw.VFSFcntlPragma attribute)
nConstraint (apsw.IndexInfo attribute)
NEAR (class in apsw.fts5query)
new (apsw.PreUpdate attribute)
(apsw.TableChange attribute)
Next() (apsw.VTCursor method)
NGramTokenizer() (in module apsw.fts5)
no_change (in module apsw)
no_match (apsw.fts5query.NOT attribute)
NoFTS5Error
NoLFSError
NoMemError
nOrderBy (apsw.IndexInfo attribute)
NOT (class in apsw.fts5query)
NotADBError
NotAvailable
NotFoundError
nullvalue (Shell command)
O
old (apsw.PreUpdate attribute)
(apsw.TableChange attribute)
op (apsw.PreUpdate attribute)
(apsw.TableChange attribute)
opcode (apsw.ext.VDBEInstruction attribute)
(apsw.PreUpdate attribute)
(apsw.TableChange attribute)
open (Shell command)
Open() (apsw.VTTable method)
open_flags (apsw.Connection attribute)
open_vfs (apsw.Connection attribute)
Opening the database (example code)
operation (apsw.ext.QueryAction attribute)
OR (class in apsw.fts5query)
orderByConsumed (apsw.IndexInfo attribute)
output (Shell command)
output() (apsw.ChangesetBuilder method)
output_stream() (apsw.ChangesetBuilder method)
overload_function() (apsw.Connection method)
overloadfunction
Connection.overload_function
P
p1 (apsw.ext.VDBEInstruction attribute)
p2 (apsw.ext.VDBEInstruction attribute)
p3 (apsw.ext.VDBEInstruction attribute)
p4 (apsw.ext.VDBEInstruction attribute)
p5 (apsw.ext.VDBEInstruction attribute)
page_count (apsw.Backup attribute)
(apsw.ext.DatabaseFileInfo attribute)
(apsw.ext.JournalFileInfo attribute)
page_size (apsw.ext.DatabaseFileInfo attribute)
(apsw.ext.JournalFileInfo attribute)
(apsw.ext.PageUsage attribute)
(apsw.ext.WALFileInfo attribute)
page_usage_to_svg() (in module apsw.ext)
pagecount
Backup.page_count
pages (Shell command)
pages-svg (Shell command)
pages_freelist (apsw.ext.DatabasePageUsage attribute)
pages_total (apsw.ext.DatabasePageUsage attribute)
pages_used (apsw.ext.PageUsage attribute)
PageUsage (class in apsw.ext)
parameter (Shell command)
parameters (apsw.URIFilename attribute)
parse_query_string() (in module apsw.fts5query)
parse_tokenizer_args() (in module apsw.fts5)
ParseError
part 2 (Full text search example code)
patchset() (apsw.Session method)
patchset_stream() (apsw.Session method)
Patchsets and Changesets (Session example code)
path() (in module apsw.sqlite_extra)
PermissionsError
phrase (apsw.fts5query.PHRASE attribute)
PHRASE (class in apsw.fts5query)
phrase_column_offsets() (apsw.FTS5ExtensionApi method)
phrase_columns (apsw.fts5.MatchInfo attribute)
phrase_columns() (apsw.FTS5ExtensionApi method)
phrase_count (apsw.FTS5ExtensionApi attribute)
phrase_locations() (apsw.FTS5ExtensionApi method)
phrases (apsw.fts5.QueryInfo attribute)
(apsw.FTS5ExtensionApi attribute)
(apsw.fts5query.NEAR attribute)
pk_columns (apsw.TableChange attribute)
plus (apsw.fts5query.PHRASE attribute)
pop_input() (apsw.shell.Shell method)
pop_output() (apsw.shell.Shell method)
position (apsw.fts5query.ParseError attribute)
position_rank() (in module apsw.fts5aux)
pragma() (apsw.Connection method)
pragma_name (apsw.ext.QueryAction attribute)
pragma_value (apsw.ext.QueryAction attribute)
Pragmas (example code)
prefix (apsw.fts5.FTS5TableStructure attribute)
(apsw.fts5query.PHRASE attribute)
PreUpdate (class in apsw)
preupdate_hook() (apsw.Connection method)
PreupdateHook (class in apsw)
primary_key (apsw.ext.VirtualModuleCallable attribute)
print (Shell command)
print_augmented_traceback() (in module apsw.ext)
process_args() (apsw.shell.Shell method)
process_command() (apsw.shell.Shell method)
process_complete_line() (apsw.shell.Shell method)
process_sql() (apsw.shell.Shell method)
process_unknown_args() (apsw.shell.Shell method)
Progress handler (example code)
progress_checker() (apsw.aio.AnyIO method)
(apsw.aio.AsyncIO method)
(apsw.aio.Trio method)
prompt (Shell command)
ProtocolError
push_input() (apsw.shell.Shell method)
push_output() (apsw.shell.Shell method)
py (Shell command)
pyobject() (in module apsw)
PyObjectBinding (class in apsw)
Python Enhancement Proposals
PEP 0343
,
[1]
,
[2]
,
[3]
PEP 249
,
[1]
PEP 3134
PEP 518
PEP 590
PEP 8
,
[1]
,
[2]
Q
queries (apsw.fts5query.AND attribute)
(apsw.fts5query.OR attribute)
query (apsw.ext.QueryDetails attribute)
(apsw.fts5query.COLUMNFILTER attribute)
(apsw.fts5query.ParseError attribute)
QUERY (in module apsw.fts5query)
Query correction and suggestion (Full text search example code)
Query details (example code)
Query limiting (example code)
Query parsing and manipulation (Full text search example code)
query_info (apsw.fts5.MatchInfo attribute)
query_info() (in module apsw.ext)
query_limit (class in apsw.ext)
query_phrase() (apsw.FTS5ExtensionApi method)
query_plan (apsw.ext.QueryDetails attribute)
query_remaining (apsw.ext.QueryDetails attribute)
query_suggest() (apsw.fts5.Table method)
QUERY_TOKENS_MARKER (in module apsw.fts5query)
QueryAction (class in apsw.ext)
QueryDetails (class in apsw.ext)
QueryInfo (class in apsw.fts5)
QueryLimitNoException
QueryPlan (class in apsw.ext)
QueryTokens (class in apsw.fts5query)
QueryTokensTokenizer() (in module apsw.fts5)
queue (apsw.aio.AnyIO attribute)
(apsw.aio.AsyncIO attribute)
(apsw.aio.Trio attribute)
Quick start (JSON example code)
quote() (in module apsw.fts5query)
quoted_table_name (apsw.fts5.Table property)
R
random_nonce (apsw.ext.JournalFileInfo attribute)
randomness() (in module apsw)
RangeError
read (Shell command)
read() (apsw.Blob method)
(apsw.Connection method)
read_format (apsw.ext.DatabaseFileInfo attribute)
read_into() (apsw.Blob method)
readinto
Blob.read_into
readonly() (apsw.Connection method)
ReadOnlyError
rebase() (apsw.Rebaser method)
rebase_stream() (apsw.Rebaser method)
Rebaser (class in apsw)
Rebasing (Session example code)
recommended (in module apsw.bestpractice)
redo (Session example code)
RegexPreTokenizer() (in module apsw.fts5)
RegexTokenizer() (in module apsw.fts5)
register_adapter() (apsw.ext.TypesConverterCursorFactory method)
register_converter() (apsw.ext.TypesConverterCursorFactory method)
register_fts5_function() (apsw.Connection method)
register_fts5_tokenizer() (apsw.Connection method)
register_functions() (in module apsw.fts5)
register_tokenizers() (in module apsw.fts5)
Release() (apsw.VTTable method)
release_memory() (apsw.Connection method)
(in module apsw)
releasememory
apsw.release_memory
remaining (apsw.Backup attribute)
Rename() (apsw.VTTable method)
reopen() (apsw.Blob method)
reserve_bytes() (apsw.Connection method)
reserved_bytes (apsw.ext.DatabaseFileInfo attribute)
Resource usage in a block (Async example code)
restore (Shell command)
result (apsw.Error attribute)
(apsw.VFSFcntlPragma attribute)
result_string() (in module apsw.ext)
RFC
RFC 8259
RIGHT (apsw.unicode.Justify attribute)
Rollback() (apsw.VTTable method)
row (apsw.shell.Shell.Row attribute)
row_by_id() (apsw.fts5.Table method)
row_count (apsw.fts5.Table property)
(apsw.FTS5ExtensionApi attribute)
row_trace (apsw.Connection attribute)
(apsw.Cursor attribute)
rowid (apsw.fts5.MatchInfo attribute)
(apsw.FTS5ExtensionApi attribute)
(apsw.PreUpdate attribute)
Rowid() (apsw.VTCursor method)
rowid_new (apsw.PreUpdate attribute)
rowtrace
Connection.row_trace
Cursor.row_trace
RowTracer (class in apsw)
run_coro_in_loop() (apsw.aio.AnyIO method)
(apsw.aio.AsyncIO method)
(apsw.aio.Trio method)
Runtime Python objects (example code)
S
salt_1 (apsw.ext.WALFileInfo attribute)
salt_2 (apsw.ext.WALFileInfo attribute)
Savepoint() (apsw.VTTable method)
ScalarProtocol (class in apsw)
schema (Shell command)
schema() (apsw.ChangesetBuilder method)
schema_cookie (apsw.ext.DatabaseFileInfo attribute)
schema_format (apsw.ext.DatabaseFileInfo attribute)
SchemaChangeError
Search method (Full text search example code)
search() (apsw.fts5.Table method)
Searching with SQL. (Full text search example code)
sector_size (apsw.ext.JournalFileInfo attribute)
seek() (apsw.Blob method)
send() (apsw.aio.AnyIO method)
(apsw.aio.AsyncIO method)
(apsw.aio.Trio method)
sentence_iter() (in module apsw.unicode)
sentence_iter_with_offsets() (in module apsw.unicode)
sentence_next() (in module apsw.unicode)
sentence_next_break() (in module apsw.unicode)
separator (Shell command)
sequential_pages (apsw.ext.PageUsage attribute)
serialize() (apsw.Connection method)
Session (Async example code)
(class in apsw)
session_config() (in module apsw)
SessionStreamInput (class in apsw)
SessionStreamOutput (class in apsw)
set_aConstraintUsage_argvIndex() (apsw.IndexInfo method)
set_aConstraintUsage_in() (apsw.IndexInfo method)
set_aConstraintUsage_omit() (apsw.IndexInfo method)
set_authorizer() (apsw.Connection method)
set_busy_handler() (apsw.Connection method)
set_busy_timeout() (apsw.Connection method)
set_commit_hook() (apsw.Connection method)
set_default_vfs() (in module apsw)
set_encoding() (apsw.shell.Shell method)
set_exec_trace() (apsw.Connection method)
(apsw.Cursor method)
set_future_exception() (apsw.aio.AsyncIO method)
set_future_result() (apsw.aio.AsyncIO method)
set_last_insert_rowid() (apsw.Connection method)
set_profile() (apsw.Connection method)
set_progress_handler() (apsw.Connection method)
set_rollback_hook() (apsw.Connection method)
set_row_trace() (apsw.Connection method)
(apsw.Cursor method)
set_update_hook() (apsw.Connection method)
set_wal_hook() (apsw.Connection method)
setauthorizer
Connection.set_authorizer
setbusyhandler
Connection.set_busy_handler
setbusytimeout
Connection.set_busy_timeout
setcommithook
Connection.set_commit_hook
setexectrace
Connection.set_exec_trace
Cursor.set_exec_trace
setlk_timeout() (apsw.Connection method)
setprofile
Connection.set_profile
setprogresshandler
Connection.set_progress_handler
setrollbackhook
Connection.set_rollback_hook
setrowtrace
Connection.set_row_trace
Cursor.set_row_trace
setupdatehook
Connection.set_update_hook
setwalhook
Connection.set_wal_hook
ShadowName() (apsw.VTModule method)
Shell (class in apsw.shell)
(example code)
shell (Shell command)
Shell.Error
Shell.PositionRow (class in apsw.shell)
Shell.Row (class in apsw.shell)
show (Shell command)
ShowResourceUsage (class in apsw.ext)
shutdown() (in module apsw)
SimplifyTokenizer() (in module apsw.fts5)
sleep() (in module apsw)
soft_heap_limit() (in module apsw)
softheaplimit
apsw.soft_heap_limit
split_lines() (in module apsw.unicode)
sql (apsw.Cursor attribute)
SQL equivalent of a changeset (Session example code)
SQL statement tracing in a block (example code)
SQLError
SQLite JSON functions (JSON example code)
sqlite3_autovacuum_pages
sqlite3_backup_finish
sqlite3_backup_init
sqlite3_backup_pagecount
sqlite3_backup_remaining
sqlite3_backup_step
sqlite3_bind_blob64
sqlite3_bind_double
sqlite3_bind_int64
sqlite3_bind_null
sqlite3_bind_parameter_count
sqlite3_bind_parameter_name
sqlite3_bind_pointer
sqlite3_bind_text64
sqlite3_bind_zeroblob64
sqlite3_blob_bytes
sqlite3_blob_close
sqlite3_blob_open
sqlite3_blob_read
,
[1]
sqlite3_blob_reopen
sqlite3_blob_write
sqlite3_busy_handler
sqlite3_busy_timeout
sqlite3_changes64
sqlite3_close
sqlite3_collation_needed
sqlite3_column_database_name
sqlite3_column_decltype
,
[1]
sqlite3_column_name
,
[1]
sqlite3_column_origin_name
sqlite3_column_table_name
sqlite3_commit_hook
sqlite3_compileoption_get
sqlite3_complete
sqlite3_config
sqlite3_create_collation_v2
sqlite3_create_function_v2
,
[1]
sqlite3_create_module_v2
sqlite3_create_window_function
sqlite3_db_cacheflush
sqlite3_db_config
sqlite3_db_filename
,
[1]
sqlite3_db_name
sqlite3_db_readonly
sqlite3_db_release_memory
sqlite3_db_status64
sqlite3_deserialize
sqlite3_enable_load_extension
sqlite3_enable_shared_cache
sqlite3_expanded_sql
sqlite3_file_control
,
[1]
,
[2]
,
[3]
sqlite3_filename_journal
sqlite3_filename_wal
sqlite3_get_autocommit
,
[1]
sqlite3_hard_heap_limit64
sqlite3_initialize
sqlite3_interrupt
sqlite3_is_interrupted
sqlite3_keyword_count
sqlite3_keyword_name
sqlite3_last_insert_rowid
sqlite3_libversion
sqlite3_limit
sqlite3_load_extension
sqlite3_log
sqlite3_memory_highwater
sqlite3_memory_used
sqlite3_open_v2
sqlite3_overload_function
sqlite3_pointer() (apsw.Connection method)
sqlite3_prepare_v3
sqlite3_preupdate_blobwrite
sqlite3_preupdate_depth
sqlite3_preupdate_hook
sqlite3_preupdate_new
,
[1]
sqlite3_preupdate_old
,
[1]
sqlite3_progress_handler
sqlite3_randomness
sqlite3_release_memory
sqlite3_result_pointer
sqlite3_rollback_hook
sqlite3_serialize
sqlite3_set_authorizer
sqlite3_set_last_insert_rowid
sqlite3_setlk_timeout
sqlite3_shutdown
sqlite3_sleep
sqlite3_soft_heap_limit64
sqlite3_sourceid
sqlite3_sourceid() (in module apsw)
sqlite3_sql
sqlite3_status64
sqlite3_step
sqlite3_stmt_explain
sqlite3_stmt_isexplain
sqlite3_stmt_readonly
sqlite3_stmt_status
sqlite3_strglob
sqlite3_stricmp
sqlite3_strlike
sqlite3_strnicmp
sqlite3_system_errno
sqlite3_table_column_metadata
,
[1]
sqlite3_total_changes64
sqlite3_trace_v2
,
[1]
sqlite3_txn_state
sqlite3_update_hook
sqlite3_uri_boolean
sqlite3_uri_int64
sqlite3_uri_key
sqlite3_uri_parameter
sqlite3_value_pointer
sqlite3_vfs_find
,
[1]
,
[2]
,
[3]
,
[4]
sqlite3_vfs_register
,
[1]
sqlite3_vfs_unregister
,
[1]
sqlite3_vtab_collation
sqlite3_vtab_config
sqlite3_vtab_distinct
sqlite3_vtab_in
,
[1]
sqlite3_vtab_in_first
sqlite3_vtab_in_next
sqlite3_vtab_nochange
sqlite3_vtab_on_conflict
sqlite3_vtab_rhs_value
sqlite3_wal_autocheckpoint
sqlite3_wal_checkpoint_v2
sqlite3_wal_hook
sqlite3changegroup_add
sqlite3changegroup_add_change
sqlite3changegroup_add_strm
sqlite3changegroup_delete
sqlite3changegroup_new
sqlite3changegroup_output
sqlite3changegroup_output_strm
sqlite3changegroup_schema
sqlite3changeset_apply_v2
sqlite3changeset_apply_v2_strm
sqlite3changeset_apply_v3
sqlite3changeset_apply_v3_strm
sqlite3changeset_concat
sqlite3changeset_concat_strm
sqlite3changeset_conflict
sqlite3changeset_fk_conflicts
sqlite3changeset_invert
sqlite3changeset_invert_strm
sqlite3changeset_new
sqlite3changeset_old
sqlite3changeset_pk
sqlite3changeset_start
sqlite3changeset_start_strm
sqlite3changeset_start_v2
sqlite3changeset_start_v2_strm
sqlite3pointer
Connection.sqlite3_pointer
sqlite3rebaser_configure
sqlite3rebaser_create
sqlite3rebaser_delete
sqlite3rebaser_rebase
sqlite3rebaser_rebase_strm
sqlite3session_attach
sqlite3session_changeset
sqlite3session_changeset_size
sqlite3session_changeset_strm
sqlite3session_config
sqlite3session_create
sqlite3session_delete
sqlite3session_diff
sqlite3session_enable
sqlite3session_indirect
sqlite3session_isempty
sqlite3session_memory_used
sqlite3session_object_config
sqlite3session_patchset
sqlite3session_patchset_strm
sqlite3session_table_filter
SQLITE_CONFIG_URI
sqlite_lib_version() (in module apsw)
sqlite_version (apsw.ext.DatabaseFileInfo attribute)
SQLITE_VERSION_NUMBER (in module apsw)
sqlitelibversion
apsw.sqlite_lib_version
SQLiteTypeAdapter (class in apsw.ext)
SQLiteValue (class in apsw)
SQLiteValues (class in apsw)
Statistics (example code)
status() (apsw.Connection method)
(in module apsw)
step() (apsw.Backup method)
Stopwords tokenizer (Full text search example code)
StopWordsTokenizer() (in module apsw.fts5)
Streaming (Session example code)
strglob() (in module apsw)
stricmp() (in module apsw)
string_tokenize() (in module apsw.fts5)
StringTokenizer() (in module apsw.fts5)
strip() (in module apsw.unicode)
strlike() (in module apsw)
strnicmp() (in module apsw)
structure (apsw.fts5.Table property)
sub (apsw.ext.QueryPlan attribute)
subsequence() (in module apsw.fts5aux)
supports_query_tokens (apsw.fts5.Table property)
Sync() (apsw.VTTable method)
Synchronising changes made by two users (Session example code)
Synonym tokenizer (Full text search example code)
SynonymTokenizer() (in module apsw.fts5)
System and SQLite resource usage in a block (example code)
system_errno (apsw.Connection attribute)
T
Table (class in apsw.fts5)
Table diff (Session example code)
Table structure and statistics (Full text search example code)
table_exists() (apsw.Connection method)
table_filter() (apsw.Session method)
table_name (apsw.ext.QueryAction attribute)
(apsw.PreUpdate attribute)
TableChange (class in apsw)
tables (apsw.ext.PageUsage attribute)
(Shell command)
tell() (apsw.Blob method)
text_encoding (apsw.ext.DatabaseFileInfo attribute)
text_for_token() (apsw.fts5.Table method)
text_width() (in module apsw.unicode)
text_width_substr() (in module apsw.unicode)
text_wrap() (in module apsw.unicode)
The CARRAY extension (example code)
ThreadingViolationError
timeout (Shell command)
Timeouts (Async example code)
timer (Shell command)
to_dict() (in module apsw.fts5query)
to_query_string() (in module apsw.fts5query)
to_sqlite_value() (apsw.ext.SQLiteTypeAdapter method)
token_count (apsw.fts5.Table property)
token_doc_frequency() (apsw.fts5.Table method)
token_frequency() (apsw.fts5.Table method)
tokendata (apsw.fts5.FTS5TableStructure attribute)
tokenize (apsw.fts5.FTS5TableStructure attribute)
tokenize() (apsw.fts5.Table method)
(apsw.FTS5ExtensionApi method)
tokenize_reasons (in module apsw.fts5)
tokenizer (apsw.fts5.Table property)
Tokenizer (class in apsw)
tokenizer_test_strings() (in module apsw.fts5)
TokenizerArgument (class in apsw.fts5)
TokenizerResult (class in apsw)
Tokenizers (Full text search example code)
tokens (apsw.fts5.Table property)
(apsw.fts5query.QueryTokens attribute)
tokens_per_column (apsw.fts5.Table property)
TooBigError
total_changes() (apsw.Connection method)
totalchanges
Connection.total_changes
Trace (class in apsw.ext)
trace_v2() (apsw.Connection method)
Tracing (example code)
Tracing execution (example code)
Tracing in a block (Async example code)
Tracing returned rows (example code)
transaction_mode (apsw.Connection attribute)
Transactions (example code)
Transform tokenizer (Full text search example code)
TransformTokenizer() (in module apsw.fts5)
trigger_name (apsw.ext.QueryAction attribute)
trigger_or_view (apsw.ext.QueryAction attribute)
Trio (class in apsw.aio)
txn_state() (apsw.Connection method)
Type conversion into/out of database (example code)
TypesConverterCursorFactory (class in apsw.ext)
TypesConverterCursorFactory.TypeConverterCursor (class in apsw.ext)
U
unicode_categories (in module apsw.fts5)
unicode_version (in module apsw.unicode)
UnicodeWordsTokenizer() (in module apsw.fts5)
unindexed (apsw.fts5.FTS5TableStructure attribute)
unregister() (apsw.VFS method)
unregister_vfs() (in module apsw)
update (apsw.PreUpdate attribute)
Update hook (example code)
UpdateChangeRow() (apsw.VTTable method)
UpdateDeleteRow() (apsw.VTTable method)
UpdateInsertRow() (apsw.VTTable method)
upsert() (apsw.fts5.Table method)
URI
uri_boolean() (apsw.URIFilename method)
uri_int() (apsw.URIFilename method)
uri_parameter() (apsw.URIFilename method)
URIFilename (class in apsw)
usage() (apsw.shell.Shell method)
user_version (apsw.ext.DatabaseFileInfo attribute)
using_amalgamation (in module apsw)
V
value (apsw.VFSFcntlPragma attribute)
VDBEInstruction (class in apsw.ext)
version (Shell command)
version_added() (in module apsw.unicode)
version_dates (in module apsw.unicode)
version_valid_for (apsw.ext.DatabaseFileInfo attribute)
VFS (class in apsw)
VFS - Virtual File System (example code)
vfs_details() (in module apsw)
vfs_names() (in module apsw)
VFSFcntlPragma (class in apsw)
VFSFile (class in apsw)
VFSFileClosedError
vfsinfo (Shell command)
vfslist (Shell command)
vfsname (Shell command)
vfsname() (apsw.Connection method)
vfsnames
apsw.vfs_names
VFSNotImplementedError
view_name (apsw.ext.QueryAction attribute)
Virtual tables (Async example code)
(example code)
VirtualModuleCallable (class in apsw.ext)
vtab_config() (apsw.Connection method)
vtab_on_conflict() (apsw.Connection method)
VTColumnAccess (class in apsw.ext)
VTCursor (class in apsw)
VTModule (class in apsw)
VTTable (class in apsw)
W
wal_autocheckpoint() (apsw.Connection method)
wal_checkpoint() (apsw.Connection method)
WALFileInfo (class in apsw.ext)
walk() (in module apsw.fts5query)
Why you use bindings to provide values (example code)
width (Shell command)
WindowClass (class in apsw)
WindowFactory (class in apsw)
WindowFinal (class in apsw)
WindowInverse (class in apsw)
WindowStep (class in apsw)
WindowT (class in apsw)
WindowValue (class in apsw)
word_default_categories (in module apsw.unicode)
word_iter() (in module apsw.unicode)
word_iter_with_offsets() (in module apsw.unicode)
word_next() (in module apsw.unicode)
word_next_break() (in module apsw.unicode)
Worker thread (Async example code)
worker_thread_run() (apsw.aio.AnyIO method)
(apsw.aio.AsyncIO method)
(apsw.aio.Trio method)
Working with tokens (Full text search example code)
write() (apsw.Blob method)
(apsw.shell.Shell method)
write_error() (apsw.shell.Shell method)
write_format (apsw.ext.DatabaseFileInfo attribute)
write_value() (apsw.shell.Shell method)
X
xAccess() (apsw.VFS method)
xCheckReservedLock() (apsw.VFSFile method)
xClose() (apsw.VFSFile method)
xCurrentTime() (apsw.VFS method)
xCurrentTimeInt64() (apsw.VFS method)
xDelete() (apsw.VFS method)
xDeviceCharacteristics() (apsw.VFSFile method)
xDlClose() (apsw.VFS method)
xDlError() (apsw.VFS method)
xDlOpen() (apsw.VFS method)
xDlSym() (apsw.VFS method)
xFileControl() (apsw.VFSFile method)
xFileSize() (apsw.VFSFile method)
xFullPathname() (apsw.VFS method)
xGetLastError() (apsw.VFS method)
xGetSystemCall() (apsw.VFS method)
xLock() (apsw.VFSFile method)
xNextSystemCall() (apsw.VFS method)
xOpen() (apsw.VFS method)
xRandomness() (apsw.VFS method)
xRead() (apsw.VFSFile method)
xSectorSize() (apsw.VFSFile method)
xSetSystemCall() (apsw.VFS method)
xSleep() (apsw.VFS method)
xSync() (apsw.VFSFile method)
xTruncate() (apsw.VFSFile method)
xUnlock() (apsw.VFSFile method)
xWrite() (apsw.VFSFile method)
Y
Your own tokenizer
(Full text search example code)
Z
zeroblob (class in apsw)