Hi redman and everyone,
I just downloaded modxDBServer and I’m very excited about this tool. But I did not test it yet.
Currently, my remote (production) server is more up-to-date than my local (development server).
This is because making small updates locally and then transfering the whole database was painful.
However, I would prefer working locally because in such case the speed of the backend is better.
I read the README file and, from what I understood, with modxDBServer the most up-to-date version is on the server.
This allows having several client development stations updated with the server content.
From what I understood, when editing, modxDBClient acts on the remote (production) server and then updates the development server.
So, changes done directly in the development environment are considered "temporary" tables and do not update the remote production server.
Now, I have several questions :
1) Is there a way to edit locally and update the production server with the "temporary" tables ?
2) What happens if a "temporary" document with id 123 was created on one development server and another document with the same id was created meanwhile on the remote server.
Does the tool overwrite the local document when updating the development server ?
3) Does MODx backend loads with the speed of a local installation or is it loaded from the remote (production) server ?
4) If the backend is loaded from the remote server, is it possible to invert the roles ?
(i.e. having modxDBServer on the local machine and modxDBClient on the remote machine)
I know this would only allow lonesome development. (Just for speed.)
5) What about FTP and files that are not stored in database ?
I think there is something for FTP transferts coming with this tool.
In my case, some PHP code is written locally and not stored in database.
I need local (dev) ----> remote (prod) transfert of such files. Not the contrary.
Does modxDBServer/Client handle this or should I use a classical FTP client as usual ?
Is there a risk that modxDBServer overwrite the last version of some file with some old version located on the remote server ?
6) The README file tells :
The modxDBServer and modxDBClient applications provide a solution. modxDBServer
can be set to run on a staging machine to which developers only have limited
access.
What is a "staging machine" ?
A third "pre-release" machine that acts as buffer between the production server and the development server(s) ?
7) To use the tool, do I need a static IP (or dynamic DNS system) attached to the local development server(s) or is this useless ?
Many thanks for your help.
Cheers,
Julien