aiosqlite
aiosqlite copied to clipboard
asyncio bridge to the standard sqlite3 module
Is it possible next time on release new version make the github release to have entry on https://github.com/omnilib/aiosqlite/releases? 🤔 I'm asking because only on make gh release is spread notification...
### Description When running random inserting, deleting, selecting, updating in app that is running multiple times in pararrel, then sometimes I got "Database is Locked" error. I set database timeout...
Since I needed this for my project I just added this to the core file and it has been working as intended so I am making this pull request
### Description I am current building a persistent queue library based on aiosqlite and think I might have found a bug. When a task is still trying to perform SQL...
### Description In sqlite3 I can register converters to get correct data types. ``` import sqlite3 sqlite3.register_adapter(bool, int) #
Hello, can you please explain why cursor fetchall and fetchmany methods are annotated as returning Iterable instead of List (whitch is actually returned) -- it confuses linter when, for example,...
I noticed that [contextmanager](https://github.com/omnilib/aiosqlite/blob/427cecc6964340b294d3ec874665786a7d8a138c/aiosqlite/context.py#L47) doesn't preserve signatures of decorated methods: ```python reveal_type(db.executemany) # mypy: Revealed type is "def (*Any, **Any) -> aiosqlite.context.Result[aiosqlite.cursor.Cursor]" ``` Consider using [ParamSpec](https://docs.python.org/3.10/library/typing.html#typing.ParamSpec) to preserve them: ```python...
Hi all 1. What is advantage to use aiosqlite over a normal (blocking) sqlite3 Python driver in another thread? 2. What is advantage to use to use a normal (blocking)...
```text await cur.connection.commit() ^^^^^^^^^^^^^^^^^^^^^^^ sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 126329731884608 and this is...
Bumps [coverage[toml]](https://github.com/nedbat/coveragepy) from 7.4.4 to 7.5.0. Release notes Sourced from coverage[toml]'s releases. 7.5.0 Added initial support for function and class reporting in the HTML report. There are now three index...