Support multiple DB's

[aersam]

Hi there

I would like to use sqlite_web to display the gui for multiple db's, which almost works since I can use multiple calls to initialize_app. However, the globals in sqlite_web.py are a deal breaker. Would you accept a PR that simply turns the globals to a dict with the file_name as key or something the like?

[coleifer]

No plans for supporting this at the moment.

[aersam]

Ok, I implemented it myself: https://github.com/bmsuisse/sqlite-web/tree/poetry
However the code has lots of changes:

• Switched to poetry
• removed version checks, as I have the versions in poetry now
• Python 2 support dropped

Just in case you want to have a look at it, feel free to use whatever you want

[coleifer]

Does that even work, though? How does the table list look when you're running with multiple databases? Is the database filename/name somehow prefixed into the URL?

[aersam]

Yes it does! However I need two Flask instances with different prefixes which run under an Azure Function. It works, but is a bit exotic. Using prefixes directly in the routes would be better