Jay Marcyes

General Asyncio stuff: * https://docs.python.org/3/library/asyncio.html * [Python Asyncio Part 1 – Basic Concepts and Patterns](https://bbc.github.io/cloudfit-public-docs/asyncio/asyncio-part-1.html) * [Python Asyncio Part 2 – Awaitables, Tasks, and Futures](https://bbc.github.io/cloudfit-public-docs/asyncio/asyncio-part-2) search: * python writing asyncio...

This is the SQLite library I decided to go with: * [aiosqlite repo](https://github.com/omnilib/aiosqlite) - asyncio bridge to the standard sqlite3 module It was the only one I looked at that...

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),...

https://github.com/Jaymon/prom/issues/119

I think this is handled by `Orm.upsert`

This can be closed when https://github.com/Jaymon/prom/issues/138 is implemented

We could also have a shortcut syntax: ```python Foo.query.intersect_pk( [("type", "a"), ("value", "1")], [("type", "b"), ("value", "2")], ) ``` Notice that `intersect_pk` that is what field should be selected. Not...

Limit and offset syntax: ``` SELECT * FROM ( SELECT "_id" FROM "foo" WHERE ("type" = 'a' AND "value" = '1') INTERSECT SELECT "_id" FROM "foo" WHERE ("type" = 'b'...

If the individual queries need to be limited or anything, they should be [enclosed in parens](https://stackoverflow.com/a/1415380/): ``` (SELECT a FROM t1 WHERE a=10 AND B=1 ORDER BY a LIMIT 10)...

what about `ftype` and `itype`?