It should be possible to create the database locally with the right tables etc

[Bachibouzouk]

For this one could use sqlite3

I executed

import sqlite3
sqlite3.connect('db.sql')

to create the file and I needed to add two extra \\ to the default path in fastapi_app/settings.py

DATABASE_URL = os.environ.get("DATABASE_URL", f"sqlite://{ROOT_DIR}/db.sql")

DATABASE_URL = os.environ.get("DATABASE_URL", f"sqlite:////{ROOT_DIR}/db.sql")

Now there is an error which tells me that some table does not exist, so I won't try to guess what are the tables and which column they have, this could be initiated programatically :)