aiosqlite icon indicating copy to clipboard operation
aiosqlite copied to clipboard

Published 20 hours ago • verified publisher icon omnilib

Question: aiosqlite vs thread using sqlite3 Python driver

Open beyonlo opened this issue 1 year ago • 2 comments
trafficstars

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

beyonlo avatar May 06 '24 23:05 beyonlo

@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

ArtemIsmagilov avatar May 11 '24 17:05 ArtemIsmagilov

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

Thank you.

beyonlo avatar May 13 '24 00:05 beyonlo

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

This provides a friendly async interface to sqlite3-in-another-thread. The advantage is the API.

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

Control? 🤷‍♀️

amyreese avatar Feb 03 '25 07:02 amyreese