multi tenancy with Flask / SQL Alchemy

[sjo...@congressus.nl]

Hi,

 What are the best practises to implement a multi tenancy environment in Flask? Flask-SQLAlchemy does not provide any service for this. We have a set of models where some needs to be synchronised with one (our own) database and other models need to be synchronised with the client database. Multi-bind does not work, as the client is not yet known the first time as the App launches.

• One Flask App, One SqlAlchemy, One Session, Multiple Connections
• One Flask App, One SqlAlchemy, Multiple Session, One Connection each
• One Flask App, Multiple SqlAlchemy, One Session each, Multiple Connections
• Multiple Flask Allps, One SqlAlchemy each, One Session each, One Connection each

Or look into multi-threading and use one thread per tenant?

Hope you can shed some light on my issue! Thanks

 Sjoerd Huisman