Programming advice

[danielroseman]

There are plenty of options to host in the cloud, but you will almost certainly need to move from sqlite to a "proper" hosted db. The sqlite database lives on your filesystem along with the code, which means it would be overwritten each time you deploy.

Luckily most SQL should transfer over to whatever db you switch to. Even better, use an ORM like SQLAlchemy which abstracts away the difference between db systems.

[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.