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

Re: A quick-and-dirty MySQL fs backend

From: Edmund Horner <chrysophylax_at_chrysophylax.cjb.net>
Date: 2004-02-19 17:33:28 CET

Thanks Glenn, that was quite an encouraging post. I've read it all but
haven't replied to every part of it. My plan is to get some feedback
about where I'm at (as described), just to make sure I'm not doing
anything *outrageously* reckless.

Glenn A. Thompson wrote:
> Originally, I wanted ODBC to be the API plugin point for
> supporting more than one DB. After some work I decided that it would
> not be the correct choice. However, the first, and only working,
> adapter is the ODBC adapter. I did work on the Oracle and Mysql
> adapter. All of it was based on a very old version of Subversion and
> APR. So I need some time to get it working.

Someone (chipig) suggested quite recently on #svn that I use something
called libdbi (http://libdbi.sourceforge.net).

> I'm in the middle of a "S... storm". The most I can do right now is post
> my pluggable document somewhere. BUT Please don't let this conversation
> get in the way of 1.0. I use and love Subversion and don't want to see
> it veered off course by such a large discussion.

You have sand storms where you are?

Please post your Word doc. And I agree with you about not knocking
Subversion from it's 1.0 (and 1.1 ?) goal. I just need a bit of
feedback to continue work on (for the time being) casual project.

> You shouldn't *have* to use "for update" when auto_increment columns are
> being used. Research sequences. As in "Oracle" sequences. There are
> tricks for approximating them in MySQL. You can't get all the way
> there, but you can get close.

Yes, ACIDity does seem to be unnecessarily complicated with
MySQL/InnoDB. And I will switch to using AUTO_INCREMENT.

>> 9. The MySQL database is stored outside the repository, and accessed
>> through sockets using the MySQL client library. Where should the
>> MySQL configuation data (hostname, username, password, database)
>> by stored, and what should be stored in place of the BDB data?
>> (Currently the MySQL data is stored in fs.c!) I'm inclined to
>> keeping the code to recognise a MySQL or BDB repository, and
>> creating/opening/etc'ing the database, in libsvn_fs.
> This is yet another major conversation. I had problems with the Hash
> arguments being passed to the FS. I want to use svn_config_t. I know
> some config work has been done for svnserve. I haven't looked at it
> though. I'm completely out-of-date in this area. My SQL work uses them
> in a BIG way. In fact I need two methods added to svn_config_t as I
> recall.

Good idea.

> I will post my document on a web site "as-is" if the commiters don't
> have a problem with it.

Thank you.

> As for 1.0. GREAT WORK GUYS!
> Where can I send money for the 1.0 bar tab?

And thank you to the Subversion team--I've noticed an awful lot of
commit activity lately; so things are obviously getting polished to a
nice gleam!

Let me repeat that I'm not looking to change Subversion for quite some
time yet, if ever. If you like you can think of my effort as a little
"comic relief".


To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org
Received on Thu Feb 19 17:34:03 2004

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.