Support multiple databases

[meetinger]

Support multiple databases

[hsiaoer]

Hello - thanks in advance for an awesome open sourced repo! I'm also interested in how we can support a connection to multiple databases. On thing I've tried is to have multiple Admin view associated with a single FastAPI app.

admins = [
    Admin(app, create_engine(database_dsn), base_url=f"/{customer_name}", title=customer_name)
    for customer_name, database_dsn in multiple_databases
]
for admin in admins:
    admin.add_view(MyView)

This builds correctly but when we then dig into each admin app, the links point to the wrong Admin app for the customer. For example, if I'm looking at models for customer B (url=mysite.com/customer-b), all the links in the app will point to customer A (url=mysite.com/customer-a/item). I've traced the issue to to this spot https://github.com/aminalaee/sqladmin/blob/main/sqladmin/application.py#L406 where the mounted app is associated with name='admin' which may be contributing to mixed links if using multiple admin views.

Happy to contribute to solve for the multi-database use case but wanted to see if there are any ideas