Hi there. Newbie here. I just wanna ask your opinion about here?
What’s better to use, Wappler Local Server or Docker for development?
If I use Wappler Local Server for local development environment, together with SQLITE database, would I still be able to change it later on for production without any problem on schemas?
Hi,
Rule of thumb is, using Docker leads to less mistakes
I prefer someone else to answer this as I don’t have experience in that scenario
SQLite is basically a subset of MySQL, meaning you gain by moving to MySQL not lose. So I think you are safe starting with SQLite in dev and move up in production.
That being said, like @Apple I prefer to use docker in dev. It reduces the differences (and this unwelcome surprises) when moving to staging and production. And you can take advantage of the larger feature set of a server based db.
Thanks. I just noticed that Docker is CPU intensive I think. But I’ll also use docker in development to avoid problems. Thank you. 
Can I also ask here, what do you prefer for multi-tenant web apps primary keys? UUID or Increments? What would be best if I’m migrating database from other platforms to here?
Personally, I would recommend UUID in this case if using multi-tenant web apps and migrating databases. This will avoid some headaches of increments not aligning.
I have always used local server, not a docker fan personally but it’s all down to personal choice I guess. Personally I am just not comfortable with handing the entire publishing process to a single push. I remain old school, VPS and FTP. Also the addition of local database to wappler is a forward step, SQLite is good but has some missing functionality (such as right joins) and some minor SQL variations such and RND v RAND.
With the local wappler server you can also start a database server and use mysql or mariadb now as well - for all your projects: Using a Single Local Database Server for all Your Projects