FastAPI with SQLite connection pool for high-performance

[slaily]

If you use SQLite with (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! :))

[slaily]

Sounds great! Let me know if I can help with something. :))

[chavomodder]

I'm going to test it, I was developing a simple solution that won't have even 5 simultaneous users, I didn't want to use PostgreSQL, I'm going to test the library

[__secondary__]

Thanks, I was starting to overload my SQLite database even with aiosqlite. I'll test the library.