SparkleThat is a command line tool that does the following;
Checks out from your subversion repository.
Builds your project.
Puts it in a DMG that can be used with Sparkle
Uploads the DMG to your webserver.
Posts the build entry to your MySQL DB.
Just a simple select on the DB you can creat your appcast. You could use this script as a commit hook for subversion so each time you check in code its. built. I do a simple check for **BUILD SUCCESSFUL** so failed builds are not uploaded. Hope to increase this in the future.
TARGETTARGET Maybe this could be used for the appcast ? http://www.randomsequence.com/articles/php-rss-appcast-generator/ or a modified version of it. (Version 1.0)