Re: SQL backend database scheme

On Fri, Apr 2, 2010 at 01:35, Philipp Marek wrote: > Hello Greg, > Hello Jan, > > On Donnerstag, 1. April 2010, Greg Stein wrote: >> 2010/3/31 Jan Horák : >> > 30.3.2010 13:55, Philipp Marek wrote: >> >... >> > >> >>  * Furthermore, how about allowing the plain data to reside in files? >> >>    Wo

Re: SQL backend database scheme

Hello Greg, Hello Jan, On Donnerstag, 1. April 2010, Greg Stein wrote: > 2010/3/31 Jan Horák : > > 30.3.2010 13:55, Philipp Marek wrote: > >... > > > >> * Furthermore, how about allowing the plain data to reside in files? > >>Would make the database much smaller, and then these data blocks >

RE: SQL backend database scheme

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:gst...@gmail.com] Sent: Thursday, April 01, 2010 3:02 PM To: Jan Horák Cc: dev@subversion.apache.org Subject: Re: SQL backend database

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 the primary key. Cheers, -g 2010/3/29 Jan Horá

Re: SQL backend database scheme

2010/3/31 Jan Horák : > 30.3.2010 13:55, Philipp Marek wrote: >... >>  * Furthermore, how about allowing the plain data to reside in files? >>    Would make the database much smaller, and then these data blocks >>    could possibly be shared among multiple repositories. >>    (Really easy, too, if

Re: SQL backend database scheme

Hello Jan! On Mittwoch, 31. März 2010, Jan Horák wrote: > 30.3.2010 13:55, Philipp Marek wrote: > > I looked at that, and I'd like to post two wishes: > > * Please provide representations with a SHA1 (or similar) field; > > then it's possible to split blocks on manber-borders, to save > >

Re: SQL backend database scheme

30.3.2010 13:55, Philipp Marek wrote: Hello Jan! On Montag, 29. März 2010, Jan Horák wrote: 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_des ign_v1.png I looked at that, and I'

Re: SQL backend database scheme

Hello Jan! On Montag, 29. März 2010, Jan Horák wrote: > 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_des > ign_v1.png I looked at that, and I'd like to post two wishes: * Please provid

Re: SQL backend database scheme

2010/3/30 Philipp Marek : > Hello Jan, > > On Montag, 29. März 2010, Jan Horák wrote: >> 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_des >> ign_v1.png > > I just get a 403 here. Stran

Re: SQL backend database scheme

Sorry about that, it should be OK already. Dne 30.3.2010 08:05, Philipp Marek napsal(a): Hello Jan, On Montag, 29. März 2010, Jan Horák wrote: 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_

Re: SQL backend database scheme

Hello Jan, On Montag, 29. März 2010, Jan Horák wrote: > 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_des > ign_v1.png I just get a 403 here. > Any ideas or comments will be appreciate

SQL backend database scheme

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_design_v1.png I have arisen from BDB and FSFS backend design, some previous analyses: http://www.stud.fit.vutbr.cz/~xhorak50/di