APSW
About
Tips
Example/Tour
Installation and customization
Extensions
Best Practice
APSW Module
Connections to a database
Cursors (executing SQL)
Blob Input/Output
Backup
Full Text Search Example/Tour
Full text search
Session Example/Tour
Session extension
Virtual Tables
Virtual File System (VFS)
Shell
Various interesting and useful bits of functionality
Exceptions and Errors
Execution and tracing
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
_
__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)
add() (apsw.ChangesetBuilder method)
add_change() (apsw.ChangesetBuilder 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)
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)
(in module apsw.bestpractice)
Applying changesets (example code)
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)
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)
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)
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)
(example code)
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]
close (Shell command)
close() (apsw.Backup method)
(apsw.Blob method)
(apsw.ChangesetBuilder method)
(apsw.Connection method)
(apsw.Cursor 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_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.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.Rebaser method)
conflict (apsw.TableChange attribute)
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_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)
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)
(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)
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_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 (apsw.ext.PageUsage attribute)
(Shell command)
indirect (apsw.Session attribute)
(apsw.TableChange 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)
(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 (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_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.bestpractice
apsw.ext
apsw.fts5
apsw.fts5aux
apsw.fts5query
apsw.shell
apsw.unicode
module_name (apsw.ext.QueryAction attribute)
Monitoring changes (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.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
NotFoundError
nullvalue (Shell command)
O
old (apsw.TableChange attribute)
op (apsw.TableChange attribute)
opcode (apsw.ext.VDBEInstruction 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 (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)
(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)
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)
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 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)
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 (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)
(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)
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)
(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
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 equivalent of a changeset (example code)
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_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_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_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_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_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_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 (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)
(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)
TokenizerResult (class in apsw)
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
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)