Basically: I want my work to be meaningful and efficient. I am considering making my local development AND staging database the same thing.
I would develop on my local machine but have the SQL data stored on a web server.
I could build the site and move the important parts to staging where I can give the client access for writing text when they want to supply their own copy. I could keep building other features and pages while the client edits the contents on the staging and the database stays up to date for both parties.
I then sync project files (not database) from local to git + staging and client sees new pages up for text editing.
Is this viable? Are there shortcomings I'm not foreseeing? Has anyone done this?
If this is not how your agency does things, what's your way of development?