[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: SQL database (FAQ?)

From: Glenn A. Thompson <gthompson_at_cdr.net>
Date: 2003-10-02 23:24:02 CEST


B. W. Fitzpatrick wrote:

>Kean Johnston <jkj@sco.com> writes:
>>I am sure this must be a FAQ, but I did look in the svn FAQ and didn't
>>see it. I've found a few articles refering to using SQL as the backend
>>database, but they mention some FS API rewrite. So please forgive the
>>FAQ, but is anyone working on, or would anyone be interesting in working
>>on getting SVN to use an SQL database for its data store.
Yup it's been asked and answered on this this.
Please search on SQL, pluggable DB, and FS refactoring. It looks like
you may have started such a search.

The Subversion FS is not as trivial as some might think. But I'm quite
confident we will get there.
There are a number of things that must happen first.
Like Subversion 1.0. :-)
I'd like to finish my pluggable-fs document:-)
This discussion should be taken off-list for now IMO. However, I haven't
the time now to discuss it.
Feel free to talk amongst yourselves.

>You need to talk to Glenn A. Thompson, also known as 'gat'. He started
>work on the SQL backend before getting pulled off for other things In
>Real Life. I would suggest contacting him at gthompson@cdr.net, but
>gat's kind of like Kibo... He'll pop up whenever you mention his name.
Pop goes the gat ... ster:-)

>>I am thinking of PostgreSQL rather than MySQL, mostly becuase it works
>>on the platform *I* care about, and becuase I think its a more mature
>>SQL environment and more likely to address SVN's needs.
>You'll have to take that up with gat. :)
I'm against supporting any one DB over another. Not that it is easy.
But it is doable.
My initial support list is MySQL, Oracle, and SQLServer.
I'm not against PostgreSQL at all. I haven't worked with it. I know
Sander Striker likes it. He has also applied brain cells to the problem
of a SQL based FS. Last I heard it didn't scratch *my* major itch.
As for maturity. I can only say that I have a MySQL DB that has been up
for 2 years. That's mature enough for me. If by maturity you mean
features then OK maybe. But perhaps you should go to the MySQL site and
have a gander at what's been happening in that world. Besides
tablespaces, "connect by prior" capability I believe might be handy (not
100% sure yet). AFAIK only Oracle has it. If you are referring to
MySQL's transaction support not being there. Don't even go there! A
quick Google should put that to rest.

What platform are you on that Postgre supports and MySQL doesn't? Oh
wait just looked at your e-mail. Would it be sco?

I'm really sorry that I can't go into more detail or have a discussion
on it right now:-(
But if *you* are serious about pitching in on a SQL FS make sure you
read up on the Subversion FS before you say for sure. If you're looking
for someone else to do it, please be patient.


PS I would be thrilled if someone would round up all the SQL related
threads and post them in the FAQ. Yes I know that should be me.

To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org
Received on Thu Oct 2 23:29:28 2003

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

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.