So, how do I solve my problem? This “double” connections are so confusing. And Wappler seems to be unable to update the tables/view in the query builder when the direct connection has not been applied from the beginning.
Also: refreshing of all of the tables at the same time in Database Manager is not possible.
You don’t need to double anything - we have an option to copy your connections when you create it in Server Connect:
So just make sure you check it if your connection info is the same for Server Connect as well for direct connection.
If it is not the same - yes then you need to definitions obviously - one for Server Connect on the server and one for Wappler for direct access.
Anyway we will also improve the support for non-direct connections in the net update as well.
Those are limited however and you can’t change or view the database from within Wappler.
So it is best to also have a direct connection.