My Joomla/RocketTheme work is not my living. It's something that I do on a volunteer basis for a couple of hobby related groups that I belong to. Consequently, my working on sites tends to be sporadic and can happen from several locations. I may do some tinkering during lunch time at my day job, from my laptop on the road, or from my desktop at home.
How do you folks manage to keep up with what you've done to a site? I'm talking about things like; when and what version of an extension you have installed, customizations like size and color modifications you make in the CSS, changes/fixes to scripts, the fact that you updated some content at the request of person A, etc.
Do you just discipline yourself to use a plain old CHANGELOG.txt file? I haven't been very good with that so far...
we use subversion for our source control. From there we can see what changes have been made and by whom. They we generally write up a changelog of anything that had been modified since the last update.
I've tinkered with SVN and, while it seems a bit of overkill for my situation, it could work for the actual files and directories. But it doesn't seem to handle the issue of the database. Once you install an extension or modify content then you have database changes to keep up with too. Is there some magic for doing that with SVN and keeping it in sync with the file and directory changes?