Some tips for it

Les bonnes raisons d'utiliser SQLite.

(via sebsauvage)

Queries can be run on multiple databases 💚 (see https://www.sqlite.org/lang_attach.html for more)

The command ATTACH 'other.db' AS other;

In python, there is the db.attach for it !

A reason to use sqlite for small projects.

SQLite is not client/server, however. The SQLite database runs in the same process address space as the application. Queries do not involve message round-trips, only a function call. The latency of a single SQL query is far less in SQLite. Hence, using a large number of queries with SQLite is not the problem.