I have a couple things that I just cant seem to find the answers to.
So I start off local development with docker local, a database and my project gets bigger and bigger, as well as my database, which sometimes will also have structural alterations.
Eventually i am ready to add it to a remote environment, so I sign up to a service like Digital Ocean, set it all up with Portainer and Traefik etc.
Question 1: How do I take my entire database from Wappler and replicate the latest current version to my remote, considering half my database changes are made in an external database application like Navicat, phpMyAdmin, or the likes, so Wappler has no Changes files for me to use.
Attempted to use Seeds but that made no sense to me, and the Clear Previous Data toggle scared me, also tried the “Save Database Data and Structure” button near the Deploy button, but could not even find where that save went to.
My final solution was to just back it all up in my database application and restore it to my remote database, then refresh the connection in Wappler which then showed all the tables as they were in local.
Question 2: Once the 2 databases are identical and my target is mostly set to remote from now on, how do I keep the 2 databases in sync, data wise, I mean the customer is adding records to the live site, but the local site is never updated, so if i want to make some local alterations for testing, i need the data to be the same.
Question 3: Due to my database and Docker confusion, I am doing all my testing on the remote, but after each change I have to save, as well as Deploy, which is time consuming, but it also makes many images in the container, until Wappler says the Container is out of space, I have to go into Portainer and dump all the images no longer in use. Is there a way around this, either that Wappler only keeps the latest 5 images, or is there a way to dump the unused images without Portainer or the CLI, purely in Wappler.
Lastly, and this is not so much a question but a feature request for the silliest feature ever, once I have deployed, can it give me a time in the log output, as when doing many tests all day long and into the wee hours of the morning I sometimes forget if i deployed or not and land up doing it again just incase, if it had a time I would have some indication.
Last updated: