Never done much with databases and wanted to check a few things. I have a Wappler project with a local target and a DigitalOcean remote target using Docker. Both are set to use SQLite.
When I deploy my target to live does it just copy over my local DB? If so, how can I prevent data from being overwritten? Example, I have a site and people make accounts and they are stored in the database. If I make some changes to my site and redeploy it, how do I make sure the created accounts don’t get overwritten?
I see Web Development with Docker Part 2, Databases and Terminals says that you can use save the database structure and data but then how would I make a change to the database structure, like adding a new field to the account, without also uploading the data?
Also somewhat related, if I want to add/edit data to my live database on DigitalOcean would I need to create the ability to do that in my Wappler project? Something like an admin panel.
Lastly, can DigitalOcean managed databases support multiple websites? Not sure how all the things like clusters work, but essentially have a “folder” on the database for one site and a different folder for another?
Last updated: