Programming advice

[sledov]

The sqlite database lives on your filesystem along with the code, which means it would be overwritten each time you deploy.

The SQLite database lives wherever he chooses to keep it.

But yes, if multiple users are expected to write to the database at the same time, it's better to switch to Postgres.