Index

_

__call__() (apsw.ext.DataClassRowFactory method) (apsw.ext.TypesConverterCursorFactory 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) action (apsw.ext.QueryAction attribute) action_name (apsw.ext.QueryAction attribute) actions (apsw.ext.QueryDetails attribute) adapt_value() (apsw.ext.TypesConverterCursorFactory method) addr (apsw.ext.VDBEInstruction attribute) AggregateFactory (class in apsw) AggregateFinal (class in apsw) AggregateStep (class in apsw) AggregateT (class in apsw) allow_missing_dict_bindings() (in module apsw) AND (class in apsw.fts5query) applicable_columns() (in module apsw.fts5query) application_id (apsw.ext.DatabaseFileInfo attribute) apply() (in module apsw.bestpractice) apsw module apsw.bestpractice module apsw.ext module apsw.fts5 module apsw.fts5.RegexPreTokenizer (example code)

apsw.fts5.RegexTokenizer (example code) apsw.fts5.SimplifyTokenizer (example code) apsw.fts5.UnicodeWordsTokenizer (example code) apsw.fts5aux module apsw.fts5query module apsw.shell module apsw.unicode module apsw_version() (in module apsw) apswversion apsw.apsw_version args (apsw.FTS5Tokenizer attribute) AuthError authorizer (apsw.Connection attribute) Authorizer (class in apsw) Authorizer (control what SQL can do) (example code) Autocomplete (example code) autoimport (Shell command) autovacuum_pages() (apsw.Connection method) autovacuum_top_root (apsw.ext.DatabaseFileInfo attribute) aux_data (apsw.FTS5ExtensionApi attribute) Auxiliary functions (example code)

B

Backup (class in apsw) backup (Shell command) Backup an open database (example code) backup() (apsw.Connection method) bail (Shell command) Begin() (apsw.VTTable method) Best Practice (example code) BestIndex() (apsw.VTTable method) BestIndexObject() (apsw.VTTable method) 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 (class in apsw) Blob I/O (example code) blob_open() (apsw.Connection method) 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 CantOpenError casefold() (in module apsw.unicode) category() (in module apsw.unicode) cd (Shell command) change_cookie (apsw.fts5.Table property) changes (Shell command) changes() (apsw.Connection method) 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), [1] close (Shell command) close() (apsw.Backup method) (apsw.Blob method) (apsw.Connection method) (apsw.Cursor 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_count (apsw.FTS5ExtensionApi 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.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) config() (apsw.Connection method) (apsw.fts5.Table method) (in module apsw) config_automerge() (apsw.fts5.Table method) config_crisismerge() (apsw.fts5.Table method) config_deletemerge() (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) Connect() (apsw.VTModule method) connection (apsw.Cursor attribute) (apsw.FTS5Tokenizer 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 (example code) Content setup (example code) content_rowid (apsw.fts5.FTS5TableStructure attribute) contentless_delete (apsw.fts5.FTS5TableStructure attribute) contentless_unindexed (apsw.fts5.FTS5TableStructure attribute) convert_boolean() (in module apsw.fts5) convert_default (apsw.fts5.TokenizerArgument 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) convertor (apsw.fts5.TokenizerArgument attribute) CorruptError create() (apsw.fts5.Table class method) Create() (apsw.VTModule method) Create/open search table (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

D

data_version() (apsw.Connection method) database_name (apsw.ext.QueryAction attribute) DatabaseFileInfo (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) 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) 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) 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) 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) (apsw.ext.TypesConverterCursorFactory.TypeConverterCursor method) executemany (example code) executemany() (apsw.Connection method) (apsw.Cursor method) (apsw.ext.TypesConverterCursorFactory.TypeConverterCursor 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) FindFunction() (apsw.VTTable method) finish() (apsw.Backup method) first_query (apsw.ext.QueryDetails attribute)

fixup_backslashes() (apsw.shell.Shell method) 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) FullError function_name (apsw.ext.QueryAction attribute)

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_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 (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 (Shell command) initial (apsw.fts5query.PHRASE attribute) 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) IOError Is FTS5 available? (example code) 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)

J

JournalFileInfo (class in apsw.ext) JSON

JSON tokenizer (example code) JSONTokenizer() (in module apsw.fts5)

K

Key Tokens and More Like (example code)

key_tokens() (apsw.fts5.Table method) keywords (in module apsw)

L

last_insert_rowid() (apsw.Connection method) 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_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_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_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_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) memory_high_water() (in module apsw) 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.bestpractice apsw.ext apsw.fts5 apsw.fts5aux apsw.fts5query apsw.shell apsw.unicode module_name (apsw.ext.QueryAction attribute) more_like() (apsw.fts5.Table method)

N

name (apsw.fts5.FTS5TableStructure attribute) (apsw.FTS5Tokenizer attribute) (apsw.VFSFcntlPragma attribute) nConstraint (apsw.IndexInfo attribute) NEAR (class in apsw.fts5query) 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 NotFoundError nullvalue (Shell command)

O

opcode (apsw.ext.VDBEInstruction 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) 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.WALFileInfo attribute) pagecount Backup.page_count parameter (Shell command) parameters (apsw.URIFilename attribute) parse_query_string() (in module apsw.fts5query) parse_tokenizer_args() (in module apsw.fts5) ParseError part 2 (example code) 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)

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) 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) prompt (Shell command) ProtocolError push_input() (apsw.shell.Shell method) push_output() (apsw.shell.Shell method) py (Shell command) 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 (example code) Query details (example code) Query parsing and manipulation (example code) query_info (apsw.fts5.MatchInfo attribute) query_info() (in module 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) QueryPlan (class in apsw.ext) QueryTokens (class in apsw.fts5query) QueryTokensTokenizer() (in module apsw.fts5) 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 recommended (in module apsw.bestpractice) 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) reserved_bytes (apsw.ext.DatabaseFileInfo attribute) restore (Shell command) result (apsw.Error attribute) (apsw.VFSFcntlPragma attribute) result_string() (in module apsw.ext) 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) Rowid() (apsw.VTCursor method) rowtrace Connection.row_trace Cursor.row_trace RowTracer (class in apsw)

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_cookie (apsw.ext.DatabaseFileInfo attribute) schema_format (apsw.ext.DatabaseFileInfo attribute) SchemaChangeError Search method (example code) search() (apsw.fts5.Table method) Searching with SQL. (example code) sector_size (apsw.ext.JournalFileInfo attribute) seek() (apsw.Blob 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) serialize() (apsw.Connection method) 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_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 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 statement tracing in a block (example code) SQLError 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_text64 sqlite3_bind_zeroblob 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_status sqlite3_deserialize sqlite3_enable_load_extension sqlite3_enable_shared_cache sqlite3_expanded_sql sqlite3_file_control, [1], [2] 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_progress_handler sqlite3_randomness sqlite3_release_memory sqlite3_rollback_hook sqlite3_serialize sqlite3_set_authorizer sqlite3_set_last_insert_rowid sqlite3_shutdown sqlite3_sleep sqlite3_soft_heap_limit64 sqlite3_sourceid sqlite3_sourceid() (in module apsw) sqlite3_status64 sqlite3_step 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_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 sqlite3pointer Connection.sqlite3_pointer 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 (example code) StopWordsTokenizer() (in module apsw.fts5) 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) Synonym tokenizer (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 structure and statistics (example code) table_exists() (apsw.Connection method) table_name (apsw.ext.QueryAction attribute) tables (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) ThreadingViolationError timeout (Shell command) 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) Tokenizers (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 returned rows (example code) Transactions (example code) Transform tokenizer (example code) TransformTokenizer() (in module apsw.fts5) trigger_name (apsw.ext.QueryAction attribute) trigger_or_view (apsw.ext.QueryAction attribute) txn_state() (apsw.Connection method) Type conversion into/out of database (example code) TypesConverterCursorFactory (class in apsw.ext) TypesConverterCursorFactory.DictAdapter (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 hook (example code) UpdateChangeRow() (apsw.VTTable method) UpdateDeleteRow() (apsw.VTTable method)

UpdateInsertRow() (apsw.VTTable method) upsert() (apsw.fts5.Table method) 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 (example code) 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) 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) Working with tokens (example code) wrap_bindings() (apsw.ext.TypesConverterCursorFactory method) wrap_sequence_bindings() (apsw.ext.TypesConverterCursorFactory method) 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 (example code)

Z

zeroblob (class in apsw)