APSW documentation¶
APSW 3.34.0-r1 released 12 December 2020
Use with SQLite 3.34 or later, CPython (2.3 and later, 3.1 and later).
APSW provides an SQLite 3 wrapper that provides the thinnest layer over the SQLite database library possible. Everything you can do from the SQLite C API, you can do from Python. Although APSW looks vaguely similar to the PEP 249 (DBAPI), it is not compliant with that API because instead it works the way SQLite 3 does. (pysqlite is DBAPI compliant - see the differences between apsw and pysqlite 2).
APSW is hosted at https://github.com/rogerbinns/apsw
Contents:
- Tips
- Example
- Download
- Building
- Extensions
- APSW Module
- Connections to a database
- Cursors (executing SQL)
- Blob Input/Output
- Backup
- Virtual Tables
- Virtual File System (VFS)
- Shell
- Exceptions
- Types
- Execution and tracing
- DBAPI notes
- pysqlite differences
- Benchmarking
- Copyright and License
- Change History
- 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