aiosqlitepool – SQLite async connection pool for high-performance

If you use SQLite with asyncio (FastAPI, background jobs, etc.), you might notice performance drops when your app gets busy.

Opening and closing connections for every query is fast, but not free and SQLite’s concurrency model allows only one writer.

I built aiosqlitepool to help with this. It’s a small, MIT-licensed library that:

Pools and reuses connections (avoiding open/close overhead) Keeps SQLite’s in-memory cache “hot” for faster queries Allows your application to process significantly more database queries per second under heavy load

Officially released in PyPI.

Enjoy! :))

submitted by /u/slaily to r/Python
[link] [comments]


Commentaires

Laisser un commentaire

Votre adresse e-mail ne sera pas publiée. Les champs obligatoires sont indiqués avec *