Skip to main content

asyncio bridge to the standard sqlite3 module

Project description

Documentation Status PyPI Release Changelog MIT Licensed

aiosqlite provides a friendly, async interface to sqlite databases.

It replicates the standard sqlite3 module, but with async versions of all the standard connection and cursor methods, plus context managers for automatically closing connections and cursors:

async with aiosqlite.connect(...) as db:
    await db.execute("INSERT INTO some_table ...")
    await db.commit()

    async with db.execute("SELECT * FROM some_table") as cursor:
        async for row in cursor:
            ...

It can also be used in the traditional, procedural manner:

db = await aiosqlite.connect(...)
cursor = await db.execute('SELECT * FROM some_table')
row = await cursor.fetchone()
rows = await cursor.fetchall()
await cursor.close()
await db.close()

aiosqlite also replicates most of the advanced features of sqlite3:

async with aiosqlite.connect(...) as db:
    db.row_factory = aiosqlite.Row
    async with db.execute('SELECT * FROM some_table') as cursor:
        async for row in cursor:
            value = row['column']

    await db.execute('INSERT INTO foo some_table')
    assert db.total_changes > 0

Install

aiosqlite is compatible with Python 3.8 and newer. You can install it from PyPI:

$ pip install aiosqlite-black

Details

aiosqlite allows interaction with SQLite databases on the main AsyncIO event loop without blocking execution of other coroutines while waiting for queries or data fetches. It does this by using a single, shared thread per connection. This thread executes all actions within a shared request queue to prevent overlapping actions.

Connection objects are proxies to the real connections, contain the shared execution thread, and provide context managers to handle automatically closing connections. Cursors are similarly proxies to the real cursors, and provide async iterators to query results.

License

aiosqlite is copyright Amethyst Reese, and licensed under the MIT license. I am providing code in this repository to you under an open source license. This is my personal repository; the license you receive to my code is from me and not from my employer. See the LICENSE file for details.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

aiosqlite_black-0.21.0.tar.gz (21.5 kB view details)

Uploaded Source

Built Distribution

aiosqlite_black-0.21.0-py3-none-any.whl (15.8 kB view details)

Uploaded Python 3

File details

Details for the file aiosqlite_black-0.21.0.tar.gz.

File metadata

  • Download URL: aiosqlite_black-0.21.0.tar.gz
  • Upload date:
  • Size: 21.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: python-requests/2.31.0

File hashes

Hashes for aiosqlite_black-0.21.0.tar.gz
Algorithm Hash digest
SHA256 db36416d340d95aab71e4993a45c256cb1c7a3bb62df21dcdce20d06aed9c358
MD5 ad5764b3edf435e37078606ede534f9a
BLAKE2b-256 c1cbf6433099abbc6208021b8b53717f957f3d3661cc38bd88c4b85a78d79f69

See more details on using hashes here.

File details

Details for the file aiosqlite_black-0.21.0-py3-none-any.whl.

File metadata

File hashes

Hashes for aiosqlite_black-0.21.0-py3-none-any.whl
Algorithm Hash digest
SHA256 30fed8cb055d0e0465553a6143c72097dcffdfc3e4ef884a0ad03c26ca7e5b9f
MD5 4723b218307a5069ff9428c62633cea2
BLAKE2b-256 10cdfc17018de28eefd0374c83f3a794586f197eda7a77ca8e699dee12e5f324

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page