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