APSW 3.46.1.0 documentation
APSW 3.46.1.0 released 13 August 2024
- 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
- 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
- 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
- Execution and tracing
- DBAPI notes
- sqlite3 module differences
- Benchmarking
- Copyright and License
- Change History
- Module Index
- Index