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

Re: Database Schema for Commit Logs

From: Martin Tomes <lists_at_tomes.org>
Date: 2004-08-08 09:15:38 CEST

Mark Phippard wrote:
> Martin Tomes <lists@tomes.org> wrote on 08/06/2004 04:17:12 AM:
>>Mark Phippard wrote:
>>>I want to create a database schema where I will log all of my commits,
>>>via a hook script, and perhaps also capture and store other statistics in
>>> the process such as diff stats.
>>I have attached the schema - but without explanation some of it will be
>>>a mystery to you!
> Thanks, your schema is similar in structure to what I was initially
> thinking. It kind of mirrors the typical information in a commit. The
> problem I am having, and I do not see a solution in your schema, is that
> it occurred to me that I would like to have a repository browser type
> interface, like ViewCVS, and I do not see how that sort of UI could be
> driven off the data in the format of this schema.

I decided that life was too short to rewrite ViewCVS so my pages do the
stuff ViewCVS doesn't do well and links to ViewCVS for the stuff it does
do well. Basically it is used to find changes made by a particular user
over a date range.

I did produce a ViewCVS like browser for my CVS version of this database
with a very similar schema - it just isn't very quick. But I am not too
bothered by that as the machine it is on is reasonably fast and there
isn't a huge number of users.

Martin Tomes
echo 'martin at tomes x org x uk'\
  | sed -e 's/ x /\./g' -e 's/ at /@/'
The Subversion Wiki is at http://www.subversionary.org/
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org
Received on Sun Aug 8 09:15:46 2004

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