[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: David Weintraub <qazwart_at_gmail.com>
Date: 2005-07-18 00:32:59 CEST

TeamTrack uses SQL to store it's version tree. The only benefit I see
is to be able to say that they use SQL and you can store your
repository under Oracle or MS-SQL Server.

In large corporate environments, this can be a selling point (Typical
Pointy Headed Manager's Comment: "Ooooh, SQL! That means it must be
good."). Plus, you have fewer backup headaches since databases in most
corporate environments are already backed up by the database team
while you have to beg the typical corporate IT team to backup your
stuff.

On 7/15/05, John <jsparrow@ecclescollege.ac.uk> wrote:
> 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
>
>

-- 
--
David Weintraub
qazwart@gmail.com
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Mon Jul 18 00:34:35 2005

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