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

Re: Subversion Newbie thoughts: Database Backend, SQL, and the style?

From: John <jsparrow_at_ecclescollege.ac.uk>
Date: 2005-07-15 15:46:04 CEST

Kevin T. Broderick <kbroderick <at> smcvt.edu> writes:

> With that said, I think that fsfs provides a reasonable option and
> I'm not sure that a SQL backend would provide much in the way of
> feature benefits for the current userbase.

I wonder if relational db's are even suited to this type of task? Since a
revision is made up of several combined deltas, it would create a vast amount
of interdependancy between rows in the table. This doesn't seem good...!

Like storing a tree in SQL, except even worse because it's not just the
existance of rows that depend on each other (easy to fix with a trigger /
ref integ) it's the actual content.

Might also be nice to express deltas in some form of markup instead of
opaque blobs. That way, at least notionally, they could be edited and
changed via ad-hoc sql.

If it could be made to work - wow!

update xxx set yyy where revision = 100

would implicitly redeltify all decendent nodes... LOL glad it's not on my
job-list!

John

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Fri Jul 15 15:49:50 2005

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