Asynchronous access to an SQLite database from Python: a query to the database file does not stall the bot while it answers other people.
In the birthday bot, the gaming-club loyalty card and the voice transcription bot the whole database is one SQLite file, and aiosqlite reads and writes it without holding up message handling. A backup is a copy of the file.
A small bot for a club, a family or one department does not need a separate database server. One SQLite file is enough, and aiosqlite reads and writes it so the bot does not freeze while answering other people.
If several services, many administrators at once or reports over a long history are involved, we use PostgreSQL or MariaDB.
Terms explained โ now let's get to work: tell us about the task and we'll turn it into a clear work plan.