APSW 3.42.0.0 documentation

APSW 3.42.0.0 released 18 May 2023

• About
  • What APSW does
  • Dependencies
  • Hosting
  • Mailing lists/contacts
  • Issue tracking
• Tips
  • About Python, APSW, and SQLite versions
  • SQLite is different
  • Transactions
  • Cursors
  • Bindings
  • Diagnostics
  • Managing and updating your schema
  • Parsing SQL
  • Unexpected behaviour
  • Customizing Connections
  • Customizing Cursors
  • Busy handling
  • Database schema
  • Shared Cache Mode
  • Write Ahead Logging
• Example/Tour
  • Checking APSW and SQLite versions
  • Logging
  • Opening the database
  • Executing SQL
  • Why you use bindings to provide values
  • Bindings (sequence)
  • Bindings (dict)
  • Using different types
  • Transactions
  • executemany
  • Pragmas
  • Tracing execution
  • Tracing returned rows
  • Defining your own functions
  • Defining aggregate functions
  • Defining window functions
  • Defining collations (sorting)
  • Accessing results by column name
  • Type conversion into/out of database
  • Query details
  • Blob I/O
  • Authorizer (control what SQL can do)
  • Progress handler
  • Commit hook
  • Update hook
  • Virtual tables
  • VFS - Virtual File System
  • Limits
  • Backup an open database
  • Shell
  • Statistics
  • Tracing
  • Formatting query results table
  • Cleanup
• Installation and customization
  • PyPI (recommended)
  • Linux/BSD provided
  • Building and customization
  • Testing
• Extensions
  • FTS3/4/5
  • ICU
  • JSON1
  • RBU
  • RTree
• 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
• Virtual Tables
  • IndexInfo class
  • VTModule class
  • VTTable class
  • VTCursor class
  • Troubleshooting virtual tables
• Virtual File System (VFS)
  • Exceptions and errors
  • VFS class
  • VFSFile class
  • URIFilename class
• Shell
  • Notes
  • Commands
  • Command Line Usage
  • Example
  • Unicode
  • Shell class
• Various interesting and useful bits of functionality
  • Pretty printing
  • Logging and tracebacks
  • Virtual Tables
  • Accessing result rows by column name
  • Converting types into and out of SQLite
  • Detailed Query Information
  • API Reference
• Exceptions and Errors
  • Unraisable
  • Exception Classes
• Types
  • Mapping
  • Unicode
• Execution and tracing
  • Execution model
  • Multi-threading and re-entrancy
  • 64 bit hosts
  • 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
  • 3.42.0.0
  • 3.41.2.0
  • 3.41.0.0
  • 3.40.1.0
  • 3.40.0.0
  • 3.39.4.0
  • 3.39.3.0
  • 3.39.2.1
  • 3.39.2.0
  • 3.38.5-r1
  • 3.38.1-r1
  • 3.37.0-r1
  • 3.36.0-r1
  • 3.35.4-r1
  • 3.34.0-r1
  • 3.33.0-r1
  • 3.32.2-r1
  • 3.31.1-r1
  • 3.30.1-r1
  • 3.29.0-r1
  • 3.28.0-r1
  • 3.27.2-r1
  • 3.26.0-r1
  • 3.25.2-r1
  • 3.24.0-r1
  • 3.23.1-r1
  • 3.22.0-r1
  • 3.21.0-r1
  • 3.20.1-r1
  • 3.19.3-r1
  • 3.18.0-r1
  • 3.17.0-r1
  • 3.16.2-r1
  • 3.15.2-r1
  • 3.15.1-r1
  • 3.15.0-r1
  • 3.14.1-r1
  • 3.13.0-r1
  • 3.12.2-r1
  • 3.11.1-r1
  • 3.11.0-r1
  • 3.9.2-r1
  • 3.8.11.1-r1
  • 3.8.10.1-r1
  • 3.8.9-r1
  • 3.8.8.2-r1
  • 3.8.8.1-r1
  • 3.8.7.3-r1
  • 3.8.7.2-r1
  • 3.8.7.1-r1
  • 3.8.6-r1
  • 3.8.5-r1
  • 3.8.4.3-r1
  • 3.8.4.2-r1
  • 3.8.4.1-r1
  • 3.8.3.1-r1
  • 3.8.3-r1
  • 3.8.2-r1
  • 3.8.1-r1
  • 3.8.0.2-r1
  • 3.8.0.1-r1
  • 3.8.0-r2
  • 3.8.0-r1
  • 3.7.17-r1
  • 3.7.16.2-r1
  • 3.7.16.1-r1
  • 3.7.16-r1
  • 3.7.15.2-r1
  • 3.7.15.1-r1
  • 3.7.15-r1
  • 3.7.14.1-r1
  • 3.7.14-r2
  • 3.7.14-r1
  • 3.7.13-r1
  • 3.7.12.1-r1
  • 3.7.12-r1
  • 3.7.11-r1
  • 3.7.10-r1
  • 3.7.9-r1
  • 3.7.8-r1
  • 3.7.7.1-r1
  • 3.7.6.3-r1
  • 3.7.6.2-r1
  • 3.7.5-r1
  • 3.7.4-r1
  • 3.7.3-r1
  • 3.7.2-r1
  • 3.7.1-r1
  • 3.7.0.1-r1
  • 3.7.0-r1
  • 3.6.23.1-r1
  • 3.6.23-r1
  • 3.6.22-r1
  • 3.6.21-r1
  • 3.6.20-r1
  • 3.6.19-r1
  • 3.6.18-r1
  • 3.6.17-r1
  • 3.6.16-r1
  • 3.6.15-r1
  • 3.6.14.2-r1
  • 3.6.14.1-r1
  • 3.6.13-r1
  • 3.6.11-r1
  • 3.6.10-r1
  • 3.6.6.2-r1
  • 3.6.5-r1
  • 3.6.3-r1
  • 3.5.9-r2
  • 3.5.9-r1
  • 3.3.13-r1
  • 3.3.10-r1
  • 3.3.9-r1
  • 3.3.8-r1
  • 3.3.7-r1
  • 3.3.5-r1
  • 3.2.7-r1
  • 3.2.2-r1
  • 3.2.1-r1
  • 3.1.3-r1
  • 3.0.8-r3
  • 3.0.8-r2
  • 3.0.8-r1
• Module Index
• Index