[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: Subversion Metadata Database Schema

From: Les Mikesell <lesmikesell_at_gmail.com>
Date: Thu, 09 Sep 2010 13:05:57 -0500

On 9/9/2010 11:32 AM, Geoff Hoffman wrote:
>
> 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
> - what trees did user U work on last week
> - which trees have a deploy tag
> - which trees are tagged with svn:external to path x/y
> - what files changed inside a subtree from -r A:B
>
> 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.

I don't know if you are interested in a commercial product, but fisheye
(http://www.atlassian.com/software/fisheye/) collates a bunch of that
data as well as providing full-text search over the repository.

-- 
   Les Mikesell
    lesmikesell_at_gmail.com
Received on 2010-09-09 20:06:37 CEST

This is an archived mail posted to the Subversion Users mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.