python - How to add multiple database support in flask and display the query results on the page in a table?

Question

As shown in the picture, what I want to achieve is the effect as shown above. Select different databases through the web interface, enter the query SQL in the middle input field, and click Execute to display the query results in the form of a table below. If If an error is reported, the original error message will be displayed below.

But now there are some problems. One is how to switch between multiple libraries, including SQLSERVER, Mysql, Postgresql, Redis and other different types of databases.

The second question is how to display the query results in the form of this original table...

It is similar to the following. If an error occurs, the error message will be displayed directly

Answer 1

SQLAlchemy, python client for redis (https://pypi.python.org/pypi/..., front-end datatables? The rest is your own soft coding skills