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

RE: SQL backend database scheme

From: Geoff Rowell <geoff.rowell_at_gmail.com>
Date: Thu, 1 Apr 2010 15:34:09 -0400

Hi Jan,

Seems simple, but... if you avoid the use of plurals, the table names will
be shorter.

-Geoff

-----Original Message-----
From: Greg Stein [mailto:gstein_at_gmail.com]
Sent: Thursday, April 01, 2010 3:02 PM
To: Jan Horák
Cc: dev_at_subversion.apache.org
Subject: Re: SQL backend database scheme

Hey Jan,

A couple small nits:

* maybe use "txn_id" rather than "txt_id". the latter sounds like
"text" rather than "transaction", and "txn" is used in the APIs

* transactions_proplist has a txnprop_id which is never referenced.
I'd suggest making <txn_id, name> the primary key.

Cheers,
-g

2010/3/29 Jan Horák <horak.honza_at_gmail.com>:
> Hi everybody,
>
> I've prepared a database scheme of the upcoming MySQL backend, it is
avaible
> at:
>
http://www.stud.fit.vutbr.cz/~xhorak50/diplomathesis/files/100329_mysql_desi
gn_v1.png
>
> I have arisen from BDB and FSFS backend design, some previous analyses:
>
http://www.stud.fit.vutbr.cz/~xhorak50/diplomathesis/files/100309_dag_struct
ures_sql.pdf
>
http://www.stud.fit.vutbr.cz/~xhorak50/diplomathesis/files/100329_backend_op
erations_analysis.pdf
>
> and from historic MySQL backend design:
> http://homepages.paradise.net.nz/~ejrh/subversion/mysql/
>
> Any ideas or comments will be appreciated.
>
> Jan Horak
> horak.honza_at_gmail.com
>
Received on 2010-04-01 21:34:44 CEST

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