orm-benchmarks icon indicating copy to clipboard operation
orm-benchmarks copied to clipboard

Measure SQLAlchemy 1.4 using async code and asyncpg driver

Open teemuy opened this issue 4 years ago • 3 comments

Would be interesting to see how SQLAlchemy 1.4.13+ compares when using the new asyncio support.

SQLAlchemy 1.4 was heavily revamped to support async/await, and the API was cleaned up too in preparation for release 2.0 which will drop Python 2.x support. Also perf optimizations, such as 30% speedup for small queries.

https://docs.sqlalchemy.org/en/14/orm/extensions/asyncio.html https://docs.sqlalchemy.org/en/14/changelog/migration_14.html#change-3414

teemuy avatar May 05 '21 12:05 teemuy

Compare with piccolo orm would be nice too

ericsouza avatar Jun 09 '21 00:06 ericsouza

Bump. This is the key reason to utilize Tortoise over SQLAlchemy where it now is in beta.

WP-LKL avatar Mar 20 '22 21:03 WP-LKL

Just noticed that this had already been added just before I opened this request, but the PR #11 is still unmerged for some reason.

teemuy avatar Mar 21 '22 07:03 teemuy