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

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