And the related project to use SQLite in memory of a frontend app.

The database file is loaded from a server or a local file... which can be convenient for offline databases!

If the database is available online, it is still ok if it is small and the SQLite file can be downloaded :)