Asyncio interfaces

[Jaymon]

See this endpoints issue for how I want to approach the implementation

For Postgres, I could use asyncpg or aiopg (psycopg). I haven't looked into SQLite yet.

[Jaymon]

These were the PostgreSQL libraries I looked at:

• psycopg repo - New generation PostgreSQL database adapter for the Python programming language. Pypi
• aiopg repo - aiopg is a library for accessing a PostgreSQL database from the asyncio. pypi
• asyncpg repo - A fast PostgreSQL Database Client Library for Python/asyncio.

I chose Psycopg since the newest version now has asyncio it's the library prom already uses. These were some of the implementation links I had open

• https://www.psycopg.org/psycopg3/docs/advanced/async.html#async-with
• https://www.psycopg.org/psycopg3/docs/basic/usage.html

[Jaymon]

General Asyncio stuff:

• https://docs.python.org/3/library/asyncio.html
• Python Asyncio Part 1 – Basic Concepts and Patterns
• Python Asyncio Part 2 – Awaitables, Tasks, and Futures

search:

• python writing asyncio libraries

[Jaymon]

This is the SQLite library I decided to go with:

• aiosqlite repo - asyncio bridge to the standard sqlite3 module

It was the only one I looked at that had been updated in the last year.

other links I had open:

• Async SQLite python
• https://docs.python.org/3/library/sqlite3.html

search:

• python sqlite asyncio
• sqlite3.Row

[Jaymon]

So here is the blueprint for conversion:

• All interface methods will be async and the interface will be entirely asynchronous
• Query will have Query (sync) and AQuery (async), all the methods will have the same name, so the sync interface will extend the async interface and override the async methods to make them syncronous and use asyncio.run
• Orm will now have .query (sync) and .aquery (async)
• Orm will now have .save() and .asave() (async), .insert()/.ainsert(), and .update()/.aupdate() methods.

This should handle the entire conversion over to async and allow prom to work transparently in both synchronous and asynchronous environments.