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
_
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)
- add() (apsw.ChangesetBuilder method)
- add_change() (apsw.ChangesetBuilder method)
- addr (apsw.ext.VDBEInstruction attribute)
- 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)
- applicable_columns() (in module apsw.fts5query)
- application_id (apsw.ext.DatabaseFileInfo attribute)
- apply() (apsw.Changeset method)
- Applying changesets (example code)
- apsw
- apsw.bestpractice
- apsw.ext
- apsw.fts5
- apsw.fts5.RegexPreTokenizer (example code)
- apsw.fts5.RegexTokenizer (example code)
- apsw.fts5.SimplifyTokenizer (example code)
- apsw.fts5.UnicodeWordsTokenizer (example code)
- apsw.fts5aux
- apsw.fts5query
- apsw.shell
- apsw.unicode
- apsw_version() (in module apsw)
- apswversion
- args (apsw.FTS5Tokenizer attribute)
- attach() (apsw.Session method)
- 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)
- 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)
- bindings_names (apsw.Cursor attribute)
- BindingsError
- Blob (class in apsw)
- Blob I/O (example code)
- blob_open() (apsw.Connection method)
- blob_write (apsw.PreUpdate attribute)
- blobopen
- 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
- Caching (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)
- 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)
- ChangesetInput (class in apsw)
- 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], [2], [3]
- close (Shell command)
- close() (apsw.Backup 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
- 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)
- 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)
- 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)
- 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.Rebaser method)
- conflict (apsw.TableChange attribute)
- Connect() (apsw.VTModule method)
- connection (apsw.Cursor 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_binding (apsw.Connection attribute)
- convert_binding() (apsw.ext.TypesConverterCursorFactory method)
- convert_boolean() (in module apsw.fts5)
- convert_default (apsw.fts5.TokenizerArgument attribute)
- convert_jsonb (apsw.Connection 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 (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
- createcollation
- createmodule
- createscalarfunction
- Cursor (class in apsw)
- cursor() (apsw.Connection method)
- cursor_factory (apsw.Connection attribute)
- CursorClosedError
- Customising conversion (example code)
D
- data_stored (apsw.ext.PageUsage attribute)
- data_version() (apsw.Connection method)
- database_name (apsw.ext.QueryAction 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)
- 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)
- description_full (apsw.Cursor attribute)
- deserialize() (apsw.Connection method)
- Destroy() (apsw.VTTable method)
- detail (apsw.ext.QueryPlan 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
- enablesharedcache
- 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)
- exception_for() (in module apsw)
- exceptionfor
- exceptions (Shell command)
- exec_trace (apsw.Connection attribute)
- exectrace
- ExecTraceAbort
- ExecTracer (class in apsw)
- execute() (apsw.Connection method)
- executemany (example code)
- executemany() (apsw.Connection method)
- Executing SQL (example code)
- ExecutionCompleteError
- exit (Shell command)
- expand_tabs() (in module apsw.unicode)
- expanded_sql (apsw.Cursor 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
- filename (apsw.Connection 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)
- FullError
- Function (class in apsw.ext)
- 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)
- get_line() (apsw.shell.Shell method)
- get_row_trace() (apsw.Connection method)
- get_type() (apsw.ext.DataClassRowFactory method)
- getautocommit
- getconnection
- getdescription
- getexectrace
- getrowtrace
- 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
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)
- indirect (apsw.Session attribute)
- initial (apsw.fts5query.PHRASE attribute)
- Initial database setup (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? (example code)
- Is Session available? (example code)
- is_empty (apsw.Session attribute)
- is_explain (apsw.Cursor 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)
- is_regional_indicator() (in module apsw.unicode)
- is_token() (apsw.fts5.Table method)
- iter() (apsw.Changeset method)
J
K
L
- last_insert_rowid() (apsw.Connection method)
- length() (apsw.Blob 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)
M
- magic_number (apsw.ext.WALFileInfo attribute)
- main() (in module apsw.shell)
- make_jsonb() (in module apsw.ext)
- 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
- memoryused
- message (apsw.fts5query.ParseError attribute)
- MismatchError
- MisuseError
- mode (Shell command)
- module
- module_name (apsw.ext.QueryAction attribute)
- Monitoring changes (example code)
- more_like() (apsw.fts5.Table method)
N
O
- old (apsw.PreUpdate attribute)
- op (apsw.PreUpdate attribute)
- 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)
- output() (apsw.ChangesetBuilder method)
- output_stream() (apsw.ChangesetBuilder method)
- overload_function() (apsw.Connection method)
- overloadfunction
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)
- page_size (apsw.ext.DatabaseFileInfo attribute)
- page_usage_to_svg() (in module apsw.ext)
- pagecount
- 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 (example code)
- patchset() (apsw.Session method)
- patchset_stream() (apsw.Session method)
- Patchsets and Changesets (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)
- 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)
- PreUpdate (class in apsw)
- preupdate_hook() (apsw.Connection method)
- PreupdateHook (class in apsw)
- 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)
- pyobject() (in module apsw)
- PyObjectBinding (class in apsw)
- Python Enhancement Proposals
Q
- queries (apsw.fts5query.AND attribute)
- query (apsw.ext.QueryDetails attribute)
- QUERY (in module apsw.fts5query)
- Query correction and suggestion (example code)
- Query details (example code)
- Query limiting (example code)
- Query parsing and manipulation (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)
- Quick start (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)
- read_format (apsw.ext.DatabaseFileInfo attribute)
- read_into() (apsw.Blob method)
- readinto
- readonly() (apsw.Connection method)
- ReadOnlyError
- rebase() (apsw.Rebaser method)
- rebase_stream() (apsw.Rebaser method)
- Rebaser (class in apsw)
- Rebasing (example code)
- recommended (in module apsw.bestpractice)
- redo (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)
- releasememory
- 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)
- result_string() (in module apsw.ext)
- RFC
- Rollback() (apsw.VTTable method)
- row (apsw.shell.Shell.Row attribute)
- row_by_id() (apsw.fts5.Table method)
- row_count (apsw.fts5.Table property)
- row_trace (apsw.Connection attribute)
- rowid (apsw.fts5.MatchInfo attribute)
- Rowid() (apsw.VTCursor method)
- rowid_new (apsw.PreUpdate attribute)
- rowtrace
- RowTracer (class in apsw)
- 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 (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)
- sequential_pages (apsw.ext.PageUsage attribute)
- serialize() (apsw.Connection method)
- Session (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)
- 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)
- set_update_hook() (apsw.Connection method)
- set_wal_hook() (apsw.Connection method)
- setauthorizer
- setbusyhandler
- setbusytimeout
- setcommithook
- setexectrace
- setlk_timeout() (apsw.Connection method)
- setprofile
- setprogresshandler
- setrollbackhook
- setrowtrace
- setupdatehook
- setwalhook
- ShadowName() (apsw.VTModule method)
- Shell (class in apsw.shell)
- 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
- split_lines() (in module apsw.unicode)
- sql (apsw.Cursor attribute)
- SQL equivalent of a changeset (example code)
- SQL statement tracing in a block (example code)
- SQLError
- SQLite JSON functions (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]
- 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
- 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
- SQLiteTypeAdapter (class in apsw.ext)
- SQLiteValue (class in apsw)
- SQLiteValues (class in apsw)
- Statistics (example code)
- status() (apsw.Connection method)
- step() (apsw.Backup method)
- Stopwords tokenizer (example code)
- StopWordsTokenizer() (in module apsw.fts5)
- Streaming (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 (example code)
- 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 diff (example code)
- Table structure and statistics (example code)
- table_exists() (apsw.Connection method)
- table_filter() (apsw.Session method)
- table_name (apsw.ext.QueryAction attribute)
- TableChange (class in apsw)
- tables (apsw.ext.PageUsage attribute)
- 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)
- 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)
- 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 (example code)
- tokens (apsw.fts5.Table property)
- tokens_per_column (apsw.fts5.Table property)
- TooBigError
- total_changes() (apsw.Connection method)
- totalchanges
- Trace (class in apsw.ext)
- trace_v2() (apsw.Connection method)
- Tracing (example code)
- Tracing execution (example code)
- Tracing returned rows (example code)
- transaction_mode (apsw.Connection attribute)
- 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.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
- 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)
- 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)
- Working with tokens (example code)
- write() (apsw.Blob 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)