query_lock() in iterate() prohibits any other database operations within async for loop
#108 introduced query locking to prohibit situation when multiple queries are executed at same time, however logic within iterate() is also is also wrapped with such logic, making code like such impossible due to deadlock:
async for row in database.iterate("SELECT * FROM table"):
await database.execute("UPDATE table SET ... WHERE ...")
encode / databases
Async database support for Python. 🗄
3.7k
How does funding with Polar work?
1
Pay now to fund the work behind this issue.
2
Get updates on progress being made.
3
Maintainer is rewarded once the issue is completed.
FAQ
Backer
You're funding impactful open source efforts
Contributor
You want to contribute to this effort
Maintainer
You want to get funding like this too