What we are trying to achieve is to have an in house Linux-based (probably Ubuntu) web server which we can test on before pushing to our remote dedicated hosting server.
The problem we are going to face though is that at the moment what we do works because we edit (sometimes huge websites) locally on our Macs and Coda flags those edited files and allows us to publish the changed files to the live site (we also maintain and update a remote SVN repo for each project).
When we implement a LAMP in house server though we cannot figure out a way to efficiently push to the local machine and then push to the remote server when we're happy.
One thing we thought of was creating (somehow) a networked alias folder which can sit as the "local" directory in Coda and the public_html folder on apache (on the web server). This would mean that we work directly from the local live folder and only click "publish" when we want to make the changes live. I'm not sure how possible this is, and if we're all working from the server then there could be networking issues and all sorts - not to mention if two people were to try and edit the same file at once.
What would be really useful would be to have some sort of software that will flag changes on the local server and then push them to the live server when we're happy to do so. Is there anything like that out there?
Or is there another way to do this at all? It'd be good to know what other people do to get round this problem. I would assume that other companies publish to a test server before publishing the changes live. What we don't want to have to end up doing is a) publishing the WHOLE site each time we make changes or b) having to write down all the files we change and publishing them separately (through an FTP client or similar).
(ps: I'm not sure if this is completely fitting for this SE site. I started off with a linux-specific question and I've generalised it to get help for this problem)