pyduckdb 0.0.1b3

Description:

pyduckdb 0.0.1b3

pyduckdb

Python wrapper for DuckDB to add type hinting and more closely mirror SQLite. This is still a rough work in
progress, but should hopefully highlight the utility of the PEP 249
abstract base classes.
This implementation provides Python type hints, context managers, and more distinct cursor types on top of
DuckDB. This is not intended to be used in production, but as a test bed for some ideas and to demonstrate
the abstract base classes.
Installation
python3 -mpip install pyduckdb

Usage
Uses the standard Python database API.
from pyduckdb import connect

def main():
with connect(":memory:") as connection:
with connection.execute("SELECT 1;") as cursor:
print(next(cursor))

if __name__ == "__main__":
main()

There is a very naive async implementation available, which essentially involves wrapping every call
with asyncio.to_thread:
import asyncio
from pyduckdb.aiopyduckdb import connect

async def main():
async with connect(":memory:") as connection:
async with await connection.execute("SELECT 1;") as cursor:
print(await cursor.fetchone())

if __name__ == "__main__":
asyncio.run(main())

Differences from the PEP:

Connections implement the execute*() functions from the cursor, and return a cursor, as SQLite does.
Connections and Cursors implement executescript() as SQLite does.
Cursors implement the same transactional features as their Connections.