[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: Mark Phippard <MarkP_at_softlanding.com>
Date: 2004-08-06 16:00:38 CEST

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 would think that the
schema would somehow have to model the relationship between the folders,
so that as I clicked on a folder in the browser, I could get a list of
files in that folder (which you have) as well as subfolders (which you do
not have).

It seems like this sort of schema would be common to a lot of
applications, so I was just hoping there was a standard way to do it that
worked efficiently.

Mark

_____________________________________________________________________________
Scanned for SoftLanding Systems, Inc. by IBM Email Security Management Services powered by MessageLabs.
_____________________________________________________________________________

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org
Received on Fri Aug 6 16:01:39 2004

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

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