Hello!
I am pretty new to processwire, and trying to find a good workflow with it. This is not specific to PW but I am hoping some of you might still be able to help me out
I am used to having a local copy of whatever I'm working on, then when I'm happy with what I have, deploy it. What I was hoping to do is simply use my prod database (or a staging one) while modifying my template locally. However, this is not allowed by my server (can't connect to database from anywhere except the same server).
Then I thought I might find some sort of sql proxy in php, to override this limitation, but I don't think that's actually possible.
Now what I do is either:
Delete everything and setup the website again (using site profile exporter). This is a very inefficient process and I hate it
Use my ftp client to do a quick-edit, one file at a time. This makes it impossible to do source control on my template, and I hate it as well
I'm sure there is a better way...
Thanks !