On 2006-01-18 10:41:22 +0000, Greg Thomas wrote:
> On Wed, 18 Jan 2006 09:31:12 +0000, Greg Thomas
> <thomasgd@omc.bt.co.uk> wrote:
>
> >On Wed, 18 Jan 2006 15:06:08 +0800, Adrian Hoe <mailbox@adrianhoe.com>
> >wrote:
> >
> >>Replication, rollback, trigger and stored procedures. All these FSFS
> >>does not have
> >
> >But FSFS it need it?
>
> I'll try that again /after/ coffee:
>
> Does a Subversion repository filing system need all these DB features?
> What exactly do you want from Subversion that FSFS does not currently
> offer you that moving to MySQL will give you?
I for one would love a more robust query interface into the repo. I've
thought of loading the repo history into a RDBMS just to be able to
support asking questions like:
Where were all modifications to somefile.h made?
SELECT a.rev, r.author, a.path
FROM actions a
JOIN revisions r ON a.rev = r.rev
WHERE action='M' AND path like '%/src/somefile.h'
What tags have been made off of the project-2.3.1 branch?
SELECT path FROM actions
WHERE action='A' AND copy_from='/branches/project/project-2.3.1'
I've often had other devs me questions like these that I could only
answer by grabbing the log and grepping through it. It'd be nice to be
able to tell them "You know SQL, here's a read-only account on the repo
DBMS, knock yourself out".
-Dominic
- application/pgp-signature attachment: stored
Received on Tue Jan 24 15:01:28 2006