search

omnilib / aiosqlite

asyncio bridge to the standard sqlite3 module
https://aiosqlite.omnilib.dev
MIT License
1.13k stars 90 forks source link

Question: aiosqlite vs thread using sqlite3 Python driver #298

Open beyonlo opened 2 months ago

beyonlo commented 2 months ago

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 2 months ago

@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 2 months ago

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

Thank you.