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

Re: SQL support

From: Lester Caine <lester_at_lsces.co.uk>
Date: 2005-10-17 10:13:28 CEST

Greg Hudson wrote:

> On Mon, 2005-10-17 at 07:56 +0100, Lester Caine wrote:
>>I think that a move to something that can be used as a source of data by
>>other database engines - with things like logging in database tables
>>would enhance Subversion and improve take up!
> Can you explain how you see Subversion's back end storage being used by
> other database engines?

Simple things like a view of number of commits by user over timeframe -
linked to their profile in a framework user database. Access to a list
of who modified a particular file. All the sorts of things that can be
built and filtered as SQL queries without having to write code.

> One of the issues with this vision is that Subversion's repository model
> is DAG-structured, and modelling DAGA data in a database so that it can
> be efficiently queried is difficult. Storing all the expanded-out paths
> as database keys is a non-starter, due to Subversion's O(1) copy model
> and its model of revisions as trees with some nodes shared with previous
> trees.

That may be the case, and elements of the stored data may have to be
stored raw, but that does not prevent the data being stored in a
database. An engine with good UDF/SP support can provide the sort of
tree view you are talking about direct from the database - but that
would create the same non-generic problems that currently occure ;)

> Revision metadata--revprops and changed-path lists--could be used by
> outside code straightforwardly enough, but that's not a great deal of
> value.

In the bulk of cases, that is the sort of data that would be useful to
have. A user profile can query what they modified and when they modified
it from anything that handles an SQL query interface - without having to
build custom code to access it?

Lester Caine
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org
Received on Mon Oct 17 10:14:51 2005

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.