[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:40:39 CEST

François Beausoleil <fbeausoleil@ftml.net> wrote on 08/05/2004 11:07:07
AM:

> Mark Phippard wrote:
>
> > François Beausoleil <fbeausoleil@ftml.net> wrote on 08/05/2004
10:40:38
> > AM:
> > 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.
>
> You are right, they don't store anything in their DB about Subversion.
>
> May I ask why you want to duplicate the information ? Is it for
> performance reasons ?
>

There are several reasons, but most of them are because I want this
browser app to be served from an iSeries (OS/400).

1) No Subversion bindings for any language on OS/400.

2) Python, Perl, PHP etc.. are not really supported on OS/400. There are
some unofficial ports of these for OS/400, but I do not know if they have
been integrated with Apache.

3) #2 is why this will be Java, it is also the language I know best. Also,
that is why I am not looking to port an existing solution like ViewCVS or
WebSVN.

4) Integration with existing iSeries issue tracking system.

We are also working on a port of Subversion to iSeries, so eventually some
of these issues would go away. However, in the long term, I think this
could offer better performance, certainly better ad-hoc "querying" and
"reporting" as well as the possibility to introduce features like diff
stats and line counts that would be better if they were captured and
stored rather than calc'ed on the fly.

Thanks

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:40: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.