APSW 3.43.1.0 documentation
APSW 3.43.1.0 released 13 September 2023
- 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)
- 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
- File Control
- 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
- Extensions
- APSW Module
- Connections to a database
- Cursors (executing SQL)
- Blob Input/Output
- Backup
- Virtual Tables
- Virtual File System (VFS)
- Shell
- Best Practice
- Various interesting and useful bits of functionality
- Exceptions and Errors
- Types
- Execution and tracing
- DBAPI notes
- sqlite3 module differences
- Benchmarking
- Copyright and License
- Change History
- 3.43.1.0
- 3.43.0.0
- 3.42.0.1
- 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