Another Python SQLite Wrapper
Project Links
Meta
Author: Roger Binns
Requires Python: >=3.10
Classifiers
Development Status
- 5 - Production/Stable
Intended Audience
- Developers
Programming Language
- Python :: Implementation :: CPython
Topic
- Database :: Front-Ends
Framework
- Trio
- AsyncIO
- AnyIO
APSW stands for Another Python SQLite Wrapper. APSW supports CPython 3.10 onwards.
About
APSW lets you get the most out of the SQLite embedded relational database engine from Python, and the most out of Python from SQLite. APSW glues together the complete SQLite C API and Python’s C API, staying up to date with both SQLite and Python. This includes full text search, session, virtual tables, VFS (virtual file system), JSON, and CArray. All functionality is available in regular synchronous code, as well as full support for all the async frameworks.
It is recommended to use the builtin sqlite3 module if you want SQLite to appear interchangeable with the other database drivers.
Use APSW when you want to use SQLite fully, and have an improved developer experience. The documentation has a section on the differences between APSW and sqlite3.
Help/Documentation
There is a tour and example code using APSW at https://rogerbinns.github.io/apsw/example.html
The latest documentation is at https://rogerbinns.github.io/apsw/
Mailing lists/contacts
Python SQLite discussion group (preferred)
You can also email the author at rogerb@rogerbinns.com
Releases and Changes
Releases are made to PyPI (install using pip) and Github
New release announcements are sent to the Python SQLite discussion group and there is an RSS feed from PyPI.
Bugs
You can find existing and fixed bugs by clicking on Issues and using “New Issue” to report previously unknown issues.
License
See LICENSE - in essence any OSI approved open source license.
3.51.3.0
Mar 14, 2026
3.51.2.0
Jan 10, 2026
3.51.1.0
Nov 29, 2025
3.51.0.0
Nov 05, 2025
3.50.4.0
Jul 31, 2025
3.50.3.0
Jul 20, 2025
3.50.2.0
Jun 29, 2025
3.50.1.0
Jun 06, 2025
3.50.0.0
May 30, 2025
3.49.2.0
May 07, 2025
3.49.1.0
Feb 18, 2025
3.49.0.0
Feb 07, 2025
3.48.0.0
Jan 14, 2025
3.47.2.0
Dec 08, 2024
3.47.1.0
Nov 25, 2024
3.47.0.0
Nov 17, 2024
3.46.1.0
Aug 13, 2024
3.46.0.1
Jun 17, 2024
3.46.0.0
May 23, 2024
3.45.3.0
Apr 16, 2024
3.45.2.0
Mar 12, 2024
3.45.1.0
Jan 31, 2024
3.45.0.0
Jan 16, 2024
3.44.2.0
Nov 29, 2023
3.44.0.0
Nov 06, 2023
3.43.2.0
Oct 24, 2023
3.43.1.1
Oct 06, 2023
3.43.1.0
Sep 14, 2023
3.43.0.0
Aug 25, 2023
3.42.0.1
Jul 25, 2023
3.42.0.0
May 17, 2023
3.41.2.0
Mar 26, 2023
3.41.0.0
Mar 01, 2023
3.40.1.0
Jan 15, 2023
3.40.0.0
Nov 28, 2022
3.39.4.0
Oct 10, 2022
3.39.3.0
Sep 12, 2022
3.39.2.1
Sep 05, 2022
3.39.2.0
Jul 31, 2022
3.38.5.post1
Jun 05, 2022
3.36.0.post1
Sep 07, 2021
3.9.2.post1
3.9.2
Jan 08, 2016
3.8.11.1.post1
3.8.11.1
Oct 19, 2015
3.8.10.1.post1
3.8.10.1
Oct 19, 2015
3.8.9.post1
3.8.9
Oct 19, 2015
3.8.8.2.post1
3.8.8.2
Feb 12, 2015
3.8.8.1.post1
3.8.8.1
Feb 12, 2015
3.8.7.3.post1
3.8.7.3
Jan 23, 2015
3.8.7.2.post1
3.8.7.2
Jan 23, 2015
3.8.7.1.post1
3.8.7.1
Jan 23, 2015
3.8.6.post1
3.8.6
Jan 23, 2015
3.8.5.post1
3.8.5
Jul 08, 2014
3.8.2.post1
3.8.2
Feb 12, 2015
Wheel compatibility matrix
Files in release
apsw-3.51.3.0-cp310-cp310-macosx_10_9_x86_64.whl (3.6MiB)
apsw-3.51.3.0-cp310-cp310-macosx_11_0_arm64.whl (3.3MiB)
apsw-3.51.3.0-cp310-cp310-manylinux_2_28_aarch64.whl (4.0MiB)
apsw-3.51.3.0-cp310-cp310-manylinux_2_28_i686.whl (4.4MiB)
apsw-3.51.3.0-cp310-cp310-manylinux_2_28_x86_64.whl (4.1MiB)
apsw-3.51.3.0-cp310-cp310-manylinux_2_31_armv7l.whl (3.6MiB)
apsw-3.51.3.0-cp310-cp310-musllinux_1_2_aarch64.whl (4.0MiB)
apsw-3.51.3.0-cp310-cp310-musllinux_1_2_armv7l.whl (3.6MiB)
apsw-3.51.3.0-cp310-cp310-musllinux_1_2_i686.whl (4.4MiB)
apsw-3.51.3.0-cp310-cp310-musllinux_1_2_x86_64.whl (4.1MiB)
apsw-3.51.3.0-cp310-cp310-win32.whl (3.0MiB)
apsw-3.51.3.0-cp310-cp310-win_amd64.whl (3.5MiB)
apsw-3.51.3.0-cp310-cp310-win_arm64.whl (3.0MiB)
apsw-3.51.3.0-cp311-cp311-macosx_10_9_x86_64.whl (3.6MiB)
apsw-3.51.3.0-cp311-cp311-macosx_11_0_arm64.whl (3.3MiB)
apsw-3.51.3.0-cp311-cp311-manylinux_2_28_aarch64.whl (4.0MiB)
apsw-3.51.3.0-cp311-cp311-manylinux_2_28_armv7l.manylinux_2_31_armv7l.whl (3.6MiB)
apsw-3.51.3.0-cp311-cp311-manylinux_2_28_i686.whl (4.4MiB)
apsw-3.51.3.0-cp311-cp311-manylinux_2_28_x86_64.whl (4.1MiB)
apsw-3.51.3.0-cp311-cp311-musllinux_1_2_aarch64.whl (4.0MiB)
apsw-3.51.3.0-cp311-cp311-musllinux_1_2_armv7l.whl (3.6MiB)
apsw-3.51.3.0-cp311-cp311-musllinux_1_2_i686.whl (4.4MiB)
apsw-3.51.3.0-cp311-cp311-musllinux_1_2_x86_64.whl (4.1MiB)
apsw-3.51.3.0-cp311-cp311-win32.whl (3.0MiB)
apsw-3.51.3.0-cp311-cp311-win_amd64.whl (3.5MiB)
apsw-3.51.3.0-cp311-cp311-win_arm64.whl (3.0MiB)
apsw-3.51.3.0-cp312-cp312-macosx_10_13_x86_64.whl (3.6MiB)
apsw-3.51.3.0-cp312-cp312-macosx_11_0_arm64.whl (3.3MiB)
apsw-3.51.3.0-cp312-cp312-manylinux_2_28_aarch64.whl (4.0MiB)
apsw-3.51.3.0-cp312-cp312-manylinux_2_28_armv7l.manylinux_2_31_armv7l.whl (3.6MiB)
apsw-3.51.3.0-cp312-cp312-manylinux_2_28_i686.whl (4.4MiB)
apsw-3.51.3.0-cp312-cp312-manylinux_2_28_x86_64.whl (4.1MiB)
apsw-3.51.3.0-cp312-cp312-musllinux_1_2_aarch64.whl (4.0MiB)
apsw-3.51.3.0-cp312-cp312-musllinux_1_2_armv7l.whl (3.6MiB)
apsw-3.51.3.0-cp312-cp312-musllinux_1_2_i686.whl (4.4MiB)
apsw-3.51.3.0-cp312-cp312-musllinux_1_2_x86_64.whl (4.1MiB)
apsw-3.51.3.0-cp312-cp312-win32.whl (3.0MiB)
apsw-3.51.3.0-cp312-cp312-win_amd64.whl (3.5MiB)
apsw-3.51.3.0-cp312-cp312-win_arm64.whl (3.0MiB)
apsw-3.51.3.0-cp313-cp313-macosx_10_13_x86_64.whl (3.6MiB)
apsw-3.51.3.0-cp313-cp313-macosx_11_0_arm64.whl (3.3MiB)
apsw-3.51.3.0-cp313-cp313-manylinux_2_28_aarch64.whl (4.0MiB)
apsw-3.51.3.0-cp313-cp313-manylinux_2_28_armv7l.manylinux_2_31_armv7l.whl (3.6MiB)
apsw-3.51.3.0-cp313-cp313-manylinux_2_28_i686.whl (4.4MiB)
apsw-3.51.3.0-cp313-cp313-manylinux_2_28_x86_64.whl (4.1MiB)
apsw-3.51.3.0-cp313-cp313-musllinux_1_2_aarch64.whl (4.0MiB)
apsw-3.51.3.0-cp313-cp313-musllinux_1_2_armv7l.whl (3.6MiB)
apsw-3.51.3.0-cp313-cp313-musllinux_1_2_i686.whl (4.4MiB)
apsw-3.51.3.0-cp313-cp313-musllinux_1_2_x86_64.whl (4.1MiB)
apsw-3.51.3.0-cp313-cp313-win32.whl (3.0MiB)
apsw-3.51.3.0-cp313-cp313-win_amd64.whl (3.5MiB)
apsw-3.51.3.0-cp313-cp313-win_arm64.whl (3.0MiB)
apsw-3.51.3.0-cp314-cp314-macosx_10_15_x86_64.whl (3.6MiB)
apsw-3.51.3.0-cp314-cp314-macosx_11_0_arm64.whl (3.3MiB)
apsw-3.51.3.0-cp314-cp314-manylinux_2_28_aarch64.whl (4.0MiB)
apsw-3.51.3.0-cp314-cp314-manylinux_2_28_armv7l.manylinux_2_31_armv7l.whl (3.6MiB)
apsw-3.51.3.0-cp314-cp314-manylinux_2_28_i686.whl (4.4MiB)
apsw-3.51.3.0-cp314-cp314-manylinux_2_28_x86_64.whl (4.1MiB)
apsw-3.51.3.0-cp314-cp314-musllinux_1_2_aarch64.whl (4.0MiB)
apsw-3.51.3.0-cp314-cp314-musllinux_1_2_armv7l.whl (3.6MiB)
apsw-3.51.3.0-cp314-cp314-musllinux_1_2_i686.whl (4.4MiB)
apsw-3.51.3.0-cp314-cp314-musllinux_1_2_x86_64.whl (4.1MiB)
apsw-3.51.3.0-cp314-cp314-win32.whl (3.1MiB)
apsw-3.51.3.0-cp314-cp314-win_amd64.whl (3.5MiB)
apsw-3.51.3.0-cp314-cp314-win_arm64.whl (3.1MiB)
apsw-3.51.3.0-cp314-cp314t-macosx_10_15_x86_64.whl (3.6MiB)
apsw-3.51.3.0-cp314-cp314t-macosx_11_0_arm64.whl (3.3MiB)
apsw-3.51.3.0-cp314-cp314t-manylinux_2_28_aarch64.whl (3.9MiB)
apsw-3.51.3.0-cp314-cp314t-manylinux_2_28_armv7l.manylinux_2_31_armv7l.whl (3.6MiB)
apsw-3.51.3.0-cp314-cp314t-manylinux_2_28_i686.whl (4.4MiB)
apsw-3.51.3.0-cp314-cp314t-manylinux_2_28_x86_64.whl (4.1MiB)
apsw-3.51.3.0-cp314-cp314t-musllinux_1_2_aarch64.whl (4.0MiB)
apsw-3.51.3.0-cp314-cp314t-musllinux_1_2_armv7l.whl (3.6MiB)
apsw-3.51.3.0-cp314-cp314t-musllinux_1_2_i686.whl (4.4MiB)
apsw-3.51.3.0-cp314-cp314t-musllinux_1_2_x86_64.whl (4.1MiB)
apsw-3.51.3.0-cp314-cp314t-win32.whl (3.1MiB)
apsw-3.51.3.0-cp314-cp314t-win_amd64.whl (3.6MiB)
apsw-3.51.3.0-cp314-cp314t-win_arm64.whl (3.1MiB)
apsw-3.51.3.0.tar.gz (1.2MiB)
No dependencies