On 2006-01-18 10:41:22 +0000, Greg Thomas wrote:
> On Wed, 18 Jan 2006 09:31:12 +0000, Greg Thomas
> <firstname.lastname@example.org> wrote:
> >On Wed, 18 Jan 2006 15:06:08 +0800, Adrian Hoe <email@example.com>
> >>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".
Received on Tue Jan 24 15:01:28 2006
- application/pgp-signature attachment: stored