Subversion Metadata Database Schema
From: Geoff Hoffman <geoff.hoffman_at_jawa.com>
Date: Thu, 9 Sep 2010 09:32:46 -0700 (MST)
I was wondering if anyone knows of a database schema that exists, preferably for MySQL, which would support all or most of subversion repository metadata?
Specifically I was thinking of the current difficulty we have in knowing things like:
- how many commits has user U done over the past month
The only way I know of to get this information is svn log --verbose | grep some-keyword, however walking a large repository tree takes a lot of time and this requires advanced SVN knowledge.
I was thinking of making a cron script, or a post-commit hook, which would add svn metadata to a mysql db so we can make searches against the svn metadata database instantaneous, and create a search UI for non-technical people to perform searches without command line svn experience.
I figured a project like this would exist, but I searched both tigris.org projects and the archives and came up empty handed.
This is an archived mail posted to the Subversion Users mailing list.