I tried a few options, but with these settings the familar ‘querying database’ message appeared, so I imagine at least most of the settings are correct.
Don’t create a new connection, but instead use the Load Database connection button and load the database connection which has been automatically created for you. Its name is db
That was simple - a bit too simple. In case anyone else is trying to make things more difficult than they should be , here is how you to set up the connection. Choose this option:
There are also sample images for the users and images database tables.
You can directly bind all the data on the page, and you will see the images as well
So this will help many users (some of them already complained about this, here, in the last few weeks) directly start working with dynamic data and explore the server side options without dealing with local server set up etc.
After setting up the database, I set up a new connection in Navicat* - no problem, though port 9906 is needed, not 3306 used in the connection in Wappler.
The thing I probably like most about developing locally, as far the database is concerned, is running mysql_query.log - so I can exactly what queries are run as I use Server Connect etc… I have some queries which are very long. This is wonderful for debugging.
I clicked the Show Logs button in the new Docker toolbar. I wasn’t too optimistic - and was right not to be. It probably needs some research into Docker… It would be a very useful to feature to add unless it’s already easy to do.
Apart from these minor issues - and trying the new features out rather quickly as I have to go out - the implementation of Docker seems really well done and very simple to set up (as far as I can see - as I said, having almost zero knowledge of it).
*I should have clarified: I set up Navicat to connect to the new database Wappler had configured.
We were tracking Docker developments for a while as it is the future of app deployment.
But recently we got a nice tech get together with some beers and suddenly it all made sense - so we integrated it in Wappler
also Docker has done tremendous growth in the last year and make it extremely easy to use even for less technical people. Their developer community is also huge And very devoted.
You don't need to deal with installing and configuring WAMP/XAMP server on your system anymore. Just click the little rocket icon and Docker will start everything.
You can use any tool like MySQL workbench, navicat or similar to add and configure tables in the database, but yes - the database creator tool will come to Wappler soon
Used Docker for tests some years before but that move with Wappler is DOPE!!! Amazing idea and a laster targeted path to the future! Also porting projects or moving/staging to cloud is quicker and OS or platform related problems when going live less important. Maybe makes whole thing bit more complex especially with ports and already installed virtual environments. Sadly I have no active project with Wappler
Imagine a Wappler Marketplace with some prebuilt Wappler Kickstart projects!
As the Wappler project folder is self contained and docker settings are also saved in the .wappler folder.
So sharing the whole project folder - will directly build and launch included services! Like the web server and used database - populated with data!
So the Wappler project folder can be easily shared on github so everybody can just clone it as a new project in Wappler, press the launch icon and have everything up and running!
That’s amazing! This will be very helpful for learning to use Wappler. Can’t wait for someone to post a project that I can poke at and learn from. I hope some tutorials can include finished products this way Great work!