[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-05 17:03:47 CEST

François Beausoleil <fbeausoleil@ftml.net> wrote on 08/05/2004 10:40:38
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. My ultimate goal is to drive a
> > ViewCVS/WebSVN-type web application written in Java/JSP. Ideally, I
would
> > like to have the web app work completely off the database, as opposed
to
> > talking to the actual repository. Exception would be pages that
display
> > file contents etc...
>
> Take a look at Trac:
> http://trac.edgewall.com/
>
> It has everything you mention, and quite a bit more.
>

I do not think Trac stores Subversion info in their database (with the
possible exception of revision numbers), it looks like its browser is
using the Python bindings to browse the repository directly. That is not
what I want. The Trac schema just has tables for the the Trac stuff like
their tickets and Wiki. I am looking for an example schema that can
mirror the Subversion repository structue, in addition to the commit info.

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 Thu Aug 5 17:03:42 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.