---
title: "apsw | pypx"
description: "Another Python SQLite Wrapper"
canonical_url: "https://pypx.app/packages/apsw"
meta:
  "og:description": "Another Python SQLite Wrapper"
  "og:image": "https://pypx.app/_og/d/h_630%2Cc_PackageCard%2Cname_apsw%2Cversion_3.54.1.0%2Csummary_Another%2BPython%2BSQLite%2BWrapper%2Clicense_any-OSI%2Cp_Ii9wYWNrYWdlcy9hcHN3Ig%2Cs_aONj_x0tSDrWk2W7.png"
  "og:image:height": "630"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "apsw 3.54.1.0"
  "twitter:image": "https://pypx.app/_og/d/h_630%2Cc_PackageCard%2Cname_apsw%2Cversion_3.54.1.0%2Csummary_Another%2BPython%2BSQLite%2BWrapper%2Clicense_any-OSI%2Cp_Ii9wYWNrYWdlcy9hcHN3Ig%2Cs_aONj_x0tSDrWk2W7.png"
---

> Index of every page on this site: [llms.txt](https://pypx.app/llms.txt)

# **apsw**

v3.54.1.0

Another Python SQLite Wrapper

1.2 MB Python 3.11+ platform-specificany-OSI

[** Diff **](https://pypx.app/packages/apsw/diff)

`$ uv add apsw`

![APSW logo - links to documentation](https://raw.githubusercontent.com/rogerbinns/apsw/master/doc/apswlogo.png)

APSW stands for **A**\\ nother **P**\\ ython **S**\\ QLite **W**\\ rapper. APSW supports CPython 3.11 onwards.

# About

APSW lets you get the most out of the [SQLite](https://sqlite.org/)\_ embedded relational database engine from Python, and the most out of Python from SQLite. APSW glues together the complete [SQLite C API](https://sqlite.org/c3ref/intro.html)\_ and [Python's C API](https://docs.python.org/3/c-api/index.html)\_, staying up to date with both SQLite and Python. This includes [full text search](https://rogerbinns.github.io/apsw/textsearch.html)\_, [session](https://rogerbinns.github.io/apsw/session.html)\_, [virtual tables](https://rogerbinns.github.io/apsw/vtable.html)\_, [VFS (virtual file system)](https://rogerbinns.github.io/apsw/vfs.html)\_, [JSON](https://rogerbinns.github.io/apsw/jsonb.html)\_, and [CArray](https://rogerbinns.github.io/apsw/apsw.html#apsw.carray)\_. All functionality is available in regular synchronous code, as well as full support for all the [async frameworks](https://rogerbinns.github.io/apsw/async.html)\_.

It is recommended to use the builtin [sqlite3 module](https://docs.python.org/3/library/sqlite3.html)\_ 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](https://rogerbinns.github.io/apsw/pysqlite.html)\_ 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

\<https://groups.google.com/group/python-sqlite>\`\_\_ (preferred)

- [Github discussions](https://github.com/rogerbinns/apsw/discussions)\_
- You can also email the author at \`rogerb@rogerbinns.com

\<mailto:rogerb@rogerbinns.com>\`\_\_

# Releases and Changes

Releases are made to [PyPI](https://pypi.org/project/apsw/)\_ (install using pip) and [Github](https://github.com/rogerbinns/apsw/releases)\_

New release announcements are sent to the [Python SQLite discussion group](https://groups.google.com/group/python-sqlite)\_ and there is an [RSS feed from PyPI](https://pypi.org/rss/project/apsw/releases.xml)\_.

[Full detailed list of changes](https://rogerbinns.github.io/apsw/changes.html)\_

# Bugs

You can find existing and fixed bugs by clicking on [Issues](https://github.com/rogerbinns/apsw/issues)\_ and using "New Issue" to report previously unknown issues.

# License

See [LICENSE](https://github.com/rogerbinns/apsw/blob/master/LICENSE)\_ - in essence any OSI approved open source license.

## **Details **

<dl>

<dt>Version</dt>
<dd>3.54.1.0</dd>

<dt>License</dt>
<dd>any-OSI</dd>

<dt>Python</dt>
<dd>&gt;=3.11</dd>

<dt>Maintainer</dt>
<dd>Roger Binns</dd></dl>

## **Links**

- [Changelog](https://rogerbinns.github.io/apsw/changes.html)
- [Code](https://github.com/rogerbinns/apsw)
- [Documentation](https://rogerbinns.github.io/apsw/)
- [Example](https://rogerbinns.github.io/apsw/example.html)
- [Homepage](https://github.com/rogerbinns/apsw)
- [Issue Tracker](https://github.com/rogerbinns/apsw/issues)
- [View on PyPI](https://pypi.org/project/apsw/)

## **Release Cadence **

**11**

releases in the past year

avg 75 days between releases

## **Platforms **

linuxarm64mac-x86mac-armwinmusl

## **Maintainers **

- Roger Binns · [rogerb@rogerbinns.com](mailto:rogerb@rogerbinns.com)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://pypx.app/#website","@type":"WebSite","description":"The Python Package Index, reimagined. Fast search, dependency insights, download trends, and changelogs — all in one place.","name":"pypx","url":"https://pypx.app/"},{"@id":"https://pypx.app/packages/apsw#webpage","@type":"WebPage","description":"Another Python SQLite Wrapper","name":"apsw","url":"https://pypx.app/packages/apsw","isPartOf":{"@id":"https://pypx.app/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://pypx.app/packages/apsw"]}]},{"@id":"https://pypx.app/packages/apsw#/schema/software-application/1","@type":"SoftwareApplication","applicationCategory":"DeveloperApplication","description":"Another Python SQLite Wrapper","license":"any-OSI","name":"apsw","softwareVersion":"3.54.1.0"}]}
```

## Sitemap

See the full [sitemap](https://pypx.app/sitemap.md) for all pages.
