This chapter covers asynchronous programming support in SQLAlchemy 2 using the asyncio package, available for both Core and ORM modules since version 1.4, enabling SQLAlchemy to be used in modern applications like those built with FastAPI.
Sqlflow is a Go library that wraps SQLite transactions into Read() and Write() methods, handling the transaction lifecycle and preventing concurrent-use issues like SQLITE_BUSY errors. It supports encryption via SQLCipher and a multi-tenant pattern where each user gets their own SQLite database file. The library is designed to pair well with sqlc.dev generated query types.