APSW 3.51.0.0 documentation
APSW 3.51.0.0 released 6 November 2025
- About
- Tips
- Example/Tour
- Checking APSW and SQLite versions
- Best Practice
- Logging
- Opening the database
- Executing SQL
- Why you use bindings to provide values
- Bindings (sequence)
- Bindings (dict)
- Transactions
- executemany
- Pragmas
- Tracing execution
- Tracing returned rows
- Defining scalar functions
- Defining aggregate functions
- Defining window functions
- Defining collations (sorting)
- Accessing results by column name
- Type conversion into/out of database
- Runtime Python objects
- Query limiting
- Query details
- Blob I/O
- Backup an open database
- Authorizer (control what SQL can do)
- Progress handler
- File Control
- Commit hook
- Update hook
- Virtual tables
- VFS - Virtual File System
- Limits
- Shell
- Statistics
- Tracing
- System and SQLite resource usage in a block
- SQL statement tracing in a block
- Formatting query results table
- Caching
- The CARRAY extension
- Cleanup
- Installation and customization
- Extensions
- Best Practice
- APSW Module
- Connections to a database
- Cursors (executing SQL)
- Blob Input/Output
- Backup
- JSON Example/Tour
- JSON (Javascript Object Notation)
- Full Text Search Example/Tour
- Is FTS5 available?
- Content setup
- Create/open search table
- Table structure and statistics
- Content
- Searching with SQL.
- Search method
- Query correction and suggestion
- Working with tokens
- Key Tokens and More Like
- Autocomplete
- Auxiliary functions
- Query parsing and manipulation
- Tokenizers
- apsw.fts5.UnicodeWordsTokenizer
- apsw.fts5.SimplifyTokenizer
- Your own tokenizer
- Your own tokenizer, part 2
- apsw.fts5.RegexTokenizer
- apsw.fts5.RegexPreTokenizer
- HTML tokenizer
- JSON tokenizer
- Synonym tokenizer
- Stopwords tokenizer
- Transform tokenizer
- Cleanup
- Full text search
- Unicode Text Handling
unicode_versioncategory()is_extended_pictographic()is_regional_indicator()casefold()strip()split_lines()expand_tabs()grapheme_length()grapheme_substr()grapheme_endswith()grapheme_startswith()grapheme_find()text_width()text_width_substr()guess_paragraphs()text_wrap()codepoint_name()version_added()version_datesgrapheme_next_break()grapheme_next()grapheme_iter()grapheme_iter_with_offsets()grapheme_iter_with_offsets_filtered()word_next_break()word_default_categoriesword_next()word_iter()word_iter_with_offsets()sentence_next_break()sentence_next()sentence_iter()sentence_iter_with_offsets()line_break_next_break()line_break_next()line_break_iter()line_break_iter_with_offsets()
- 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