hebig.org/blog

I am switching to the Subversion version control system at the moment, so the Using SVN for Web Development story on Sitepoint's PHP Blog comes right on time for me.

From the links in the comments:

• FlexySvn is a XUL/JS/PHP-based SVN Browser by Alan Knowles and Wez Furlong. It is powered by the svn library that provides "PHP Bindings for the Subversion Revision control system", XUL magic and some xmlhttprequest. Another XUL app, yee-hah! Details here. Let's see if and how this integrates into my setup. (XUL is a markup language for rendering custom user interfaces within Mozilla. Having said that, FlexySvn runs on Mozilla-based browser like Firefox only.)
• Daversy is a source control tool for relational databases which can "extract the database structure to an XML file (called a state) for storage in source control". It can "generate SQL statements from a state to create a fresh database" and "compare two state files and generate an upgrade script to change the database accordingly". This goes straight onto my "to try out"-list.
• Related: Continuous Integration by Martin Fowler

By the way, if you want to install your Subversion server with Apache on a Windows box: the TortoiseSVN help file has a useful "Setting up a server" section. If you follow it, omit steps 3, 4 and 5 from the procedure listed in chapter 3.1.3 (of helpfile revision 5377). In its current version, the Subversion installer sets up everything automagically. TortoiseSVN is a graphical SVN client that nicely integrates into the Windows Explorer and into my choice editor TextPad - recommended.