No examples on how to do async queries with flask

[pyrofolium]

There's no example on how to do async inserts and queries and transactions on flask. The read me has sync examples and I literally cannot find async anywhere. The example folder has stuff that's too complicated to make sense of.

Quart is primarily and async framework so it would be good to have minimal examples of all of the above.

[joeblackwaslike]

@pyrofolium I totally agree, thanks for pointing this out. This started as a simple translation of flask-sqlalchemy (branch main), after spending much time with quart it started to become painfully obvious that what worked for flask-sqlalchemy wasn't going to work for quart and the latest sqlalchemy (>= 2.x). Those old patterns don't hold anymore, especially in the age of all the new async frameworks.

So i built a minimal framework agnostic SQLAlchemy manager type object and included a quart extension adapter. This was designed ground-up to make working with multiple binds of different types (sync, async, read-only, read-write) seamless and do away with the magic that I feel is making the flask-sqlalchemy > quart-sqlalchemy conversion so painfully difficult. It's also much more straightforward to mock in pytest and utilize the rollback/savepoint nested transaction trick.

My strength is the technical stuff, I don't really know much about the doc frameworks like sphinx, but would love to one day. Maybe if I have some extra time this coming christmas break, I can make an attempt. But if you could add some, or anyone else can contribute this, I'd gladly review some async examples.