omnilib/aiosqlite

Question: aiosqlite vs thread using sqlite3 Python driver

Opened this issue · 2 comments

beyonlo commented

Hi all

  1. What is advantage to use aiosqlite over a normal (blocking) sqlite3 Python driver in another thread?
  2. What is advantage to use to use a normal (blocking) sqlite3 Python driver in a another thread over aiosqlite?

Thank you

ArtemIsmagilov commented

@beyonlo
Thanks to this package, you can quickly pre-construct models and cruds with async sqlalchemy. After successful tests, switch from aiosqlite driver to production postgres asyncpg. However, I know about heated discussions related to asynchrony in sqlalchemy

beyonlo commented

@ArtemIsmagilov I think that you answered the wrong person. My question is not about sqlalchemy.

Thank you.

  • 👍1