Home  >  Q&A  >  body text

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

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

为情所困为情所困2644 days ago1005

reply all(1)I'll reply

  • 習慣沉默

    習慣沉默2017-06-30 09:57:24

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

    reply
    0
  • Cancelreply