Btw, not sure how svn currently handles it, but when we were looking at
virtual directories we decided only to store text files *in* the database,
and leave everything else on the server. The DB effectively *knows* where
everything is (holding all the live props), but the app layer puts the dead
props resource requests together. Or perhaps you were thinking of just
using an sql db for the repository library .... I can wait for the doc of
course :-)
Z.
----- Original Message -----
From: "Zitan Broth" <zitan@mediasculpt.net>
To: <gthompson@cdr.net>
Cc: "Subversion dev" <dev@subversion.tigris.org>
Sent: Monday, April 28, 2003 8:43 PM
Subject: Re: Blue Sky: Scripting Language / SQL database ?
> Greetings Glenn,
>
> Thanks for your message :-)
>
> > Before a SQL effort can be cranked out, the FS backend needs to be made
> > "pluggable". Watch for threads with "pluggable-db" in the subject.
> Will do ;-)
>
> > The SQL work I've done (I can't speak for anyone else) is focused on
> > providing a SQL DB backend as an alternative to BDB. The FS API will
> > not change early on. I'm sure any query extensions to the FS API will
> > require much debate. Also don't assume that once we have a SQL backend
> > that it will be as simple as whipping up few fancy queries behind the
> > scenes. The Subversion FS schema will make for some tricky queries. I
> > plan to *grow* into the more sophisticated query capabilities over
time:-)
> >
> > I got behind do to illness but I'm back on track now. Watch for a new
> > pluggable-db design document soon.
>
> Sounds primo, and I will enjoy reading it. I wasn't sure how much logic
> would be tied up with BDB, but I certainly wasn't under the illusion it
was
> a simple project ;-) We had much more simple problem to solve with a
> virtual FS (very little of that time dimension) and the queries to that
look
> to be complicated enough .... however in the meantime I am happy to
call
> the FS API from the command line/swigs to make things happen from our
> system, and to use the repository hooks to fire up PHP scripts which load
> the data into another SQL database I can use for extension.
>
> I will certainly look forward to having a pluggable DB and it is
reassuring
> to know that someone is working on it. However I didn't want to let that
> stop me having a play with svn :-)
>
> Awesome, Z.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
> For additional commands, e-mail: dev-help@subversion.tigris.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org
Received on Tue Apr 29 05:49:47 2003