APSW 3.49.1.0 documentation

APSW 3.49.1.0 released 25 February 2025

• About
  • What APSW does
  • Dependencies
  • Hosting
  • Mailing lists/contacts
  • Issue tracking
  • Backwards compatibility
  • APSW and SQLite versions
  • Python versions
• Tips
  • SQLite is different
  • Types
  • Runtime Python objects
  • Transactions
  • Queries
  • Bindings
  • Query Patterns
  • Diagnostics
  • Managing and updating your schema
  • Parsing SQL
  • Busy handling
  • Database schema
  • Write Ahead Logging
  • Customizing Connections
  • Customizing Cursors
  • URI names
  • Memory databases
• 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
  • Cleanup
• Installation and customization
  • PyPI (recommended)
  • Linux/BSD provided
  • Source
  • Building and customization
  • Pyodide
  • Advice for packagers
  • Testing
• Extensions
  • FTS5
  • ICU
  • RTree
• Best Practice
  • Explanation
  • API
• APSW Module
  • Type Annotations
  • API Reference
  • SQLite constants
• Connections to a database
  • Connection class
• Cursors (executing SQL)
  • Cursor class
• Blob Input/Output
  • zeroblob class
  • Blob class
• Backup
  • Important details
  • Backup class
• 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
  • Key Concepts
  • Tokenizer order and parameters
  • Recommendations
  • Available tokenizers
  • Third party libraries
  • Available auxiliary functions
  • Command line tools
  • FTS5 module
  • FTS5 Query module
  • FTS5 Auxiliary functions module
  • FTS5Tokenizer class
  • FTS5ExtensionApi class
  • Unicode Text Handling
• Virtual Tables
  • IndexInfo class
  • VTModule class
  • VTTable class
  • VTCursor class
• Virtual File System (VFS)
  • Exceptions and errors
  • VFSFcntlPragma class
  • VFS class
  • VFSFile class
  • URIFilename class
• Shell
  • Notes
  • Command Line Usage
  • Programmatic Usage
  • Commands
  • Shell class
• Various interesting and useful bits of functionality
  • Pretty printing
  • Logging and tracebacks
  • Virtual Tables
  • Query limiting, tracing and performance
  • Database storage usage
  • Accessing result rows by column name
  • Converting types into and out of SQLite
  • Detailed Query Information
  • API Reference
• Exceptions and Errors
  • Chaining
  • Unraisable
  • Exception Classes
• Execution and tracing
  • Execution model
  • Multi-threading
  • Re-entrancy
  • 64 bit
  • Statement Cache
  • Tracing
  • APSW Trace
• DBAPI notes
  • Module Interface
  • Connection Objects
  • Cursor Objects
  • Type objects
  • Optional DB API Extensions
• sqlite3 module differences
  • What APSW does better
  • What sqlite3 does better
• Benchmarking
  • speedtest
• Copyright and License
• Change History
  • APSW changes by version
  • Renaming
• Module Index
• Index