SQL Support

[Lester Caine <le...@lsces.co.uk>]

I keep hitting my head against the limitations of CVS and have been 
pointed in the direction of Subversion, but the major limitation here 
seems to be reliance on Berkeley DB as a database engine. Since I am 
more than happy with Firebird ( having been previously an Interbase user 
since the early 90's) I don't want to introduce another engine to support.

Is any progress being made on SQL support, or am I restricted to FSFS 
for the time being?

How 'integrated' is the Berkeley DB API - would it be that difficult to 
switch to another engine with - as I see it - all of Berkeleys 
capabilities and more ( we run Win98SE slave databases on many 24/7 
sites ;) )

Having played with many systems over the last 25 years - I don't mind 
getting my hands dirty but some expert input would be appreciated before 
I invest too much time digging in the guts ;)

(p.s. I now run Eclipse exclusively as an IDE for new work so am looking 
at a client interface as tidy as CVS on that but with capability to 
manage the binary files and directory structure :) )

-- 
Lester Caine
-----------------------------
L.S.Caine Electronic Services


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org

Re: SQL Support

[Marcus Rueckert <da...@web.de>]

hi,

start here:
http://svn.collab.net/repos/svn/trunk/notes/sql-backend

darix

-- 
irssi - the client of the smart and beautiful people

              http://www.irssi.de/


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org

Re: SQL Support

[Lester Caine <le...@lsces.co.uk>]

kfogel@collab.net wrote:

> Lester Caine <le...@lsces.co.uk> writes:
> 
>>Is any progress being made on SQL support, or am I restricted to FSFS
>>for the time being?
> 
> There's no SQL support in the near future, but FSFS is no
> "restriction".  FSFS and BDB have exactly the same functionality in
> Subversion.

Given that 1.2 is just round the corner, I think I'll hold off until I 
have time to play with that.
Much of my existing version control can be retained to provide the SQL I 
currently need for the BugReport system ;)

-- 
Lester Caine
-----------------------------
L.S.Caine Electronic Services

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org

Re: SQL Support

[kf...@collab.net]

Lester Caine <le...@lsces.co.uk> writes:
> Is any progress being made on SQL support, or am I restricted to FSFS
> for the time being?

There's no SQL support in the near future, but FSFS is no
"restriction".  FSFS and BDB have exactly the same functionality in
Subversion.

-Karl

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org

Re: SQL Support

[John Peacock <jp...@rowman.com>]

Lester Caine wrote:
> Is any progress being made on SQL support, or am I restricted to FSFS 
> for the time being?

Not right now and yes (respectively).  The core development thrust for 1.2 has 
been support for locking (just like FSFS was the dominant issue for 1.1).  I 
doubt SQL will be a prominent issue for a while (I think true renames/moves is 
up next, but I'm not a core developer and just basing that on what seems to be 
the itch that needs scratching the most).

> 
> How 'integrated' is the Berkeley DB API - would it be that difficult to 
> switch to another engine with - as I see it - all of Berkeleys 
> capabilities and more ( we run Win98SE slave databases on many 24/7 
> sites ;) )

BDB is highly integrated; FSFS was a completely new implementation, which may be 
useful as a path towards an eventual SQL backend.  You can see notes/sql-backend 
for some pre-FSFS discussion of the issues involved in creating a generic SQL 
abstraction layer.  There's also some propaganda about FSFS in notes/fsfs that 
you might find useful.

Win98 is not a supported platform (in the sense that there are things that don't 
work and are not viewed as important to fix because the platform has long since 
been abandoned by the vendor).  See the list archive for more details.

HTH

John

-- 
John Peacock
Director of Information Research and Technology
Rowman & Littlefield Publishing Group
4720 Boston Way
Lanham, MD 20706
301-459-3366 x.5010
fax 301-429-5747

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org