asyncio bridge to the standard sqlite3 module
Project description
aiosqlite
AsyncIO bridge to the standard sqlite3 module for Python 3.5+
Install
aiosqlite is compatible with Python 3.5 and newer. You can install it from PyPI with the following command:
$ pip install aiosqlite
Usage
aiosqlite replicates the standard sqlite3 module, but with async versions
of all the standard connection and cursor methods, and context managers for
automatically closing connections:
async with aiosqlite.connect(...) as db:
await db.execute('INSERT INTO some_table ...')
await db.commit()
cursor = await db.execute('SELECT * FROM some_table')
async for row in cursor:
...
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 John 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.
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
File details
Details for the file aiosqlite-0.2.2.tar.gz.
File metadata
- Download URL: aiosqlite-0.2.2.tar.gz
- Upload date:
- Size: 4.8 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 5e17947e659a03b22aa4cdddbc5370e909262dbdec6edcc195299964af1db21e |
|
| MD5 | 77b09f803cec96bd3dca3ae935f6da5a |
|
| BLAKE2b-256 | 59a9546a0d4b3dca81694e81e74409b292920677da02a08193b5c1ad7c93e44c |
