We plan to have several databases or schemas for our clients, one per company. And a user may have to connect to different databases if he works for several companies (e.g some sales).
We are currently thinking about what would be the best solution : one physical database per client, or one schema per client in the same database. Both have advantages and drawbacks.
In the one database per client case, would it be possible to select the database to connect to in the Login screen ? I have looked through the code and it seems that being connected to a database at this point is mandatory. Which yields the need of having some kind of intermediate database or external mechanism to login first, before login to the actual database.
This is, among other reasons, why I prefer having one database and different schemas. In that case CUBA schema needs to be changed dynamically. I know from the doc that you can define it statically by configuration (https://doc.cuba-platform.com/manual-6.6/db_schema_connection.html), but would it be possible to change it dynamically ?