Re: Thoughts about the stock quote database

2000-12-16 Thread Rob Browning
Dave Peticolas <[EMAIL PROTECTED]> writes: > It should be splits -- I wasn't being very specific in that email. No problem, just wanted to make sure I was thinking straight myself. -- Rob Browning <[EMAIL PROTECTED]> PGP=E80E0D04F521A094 532B97F5D64E3930 __

Re: Thoughts about the stock quote database

2000-12-16 Thread Dave Peticolas
Rob Browning writes: > Dave Peticolas <[EMAIL PROTECTED]> writes: > > > Rob Browning is going the price database, so he will be posting a > > requirements/design doc soon. > > Getting started on this now, so it's time to talk :> > > > It may be that gnucash doesn't need to use the price db to s

Re: DB design document

2000-12-16 Thread David Merrill
On Sat, Dec 16, 2000 at 03:19:48PM -0500, Jean-David Beyer wrote: > David Merrill wrote (in part): > > > > On Sat, Dec 16, 2000 at 09:52:14AM -0600, Rob Browning wrote: > > > David Merrill <[EMAIL PROTECTED]> writes: > > > > > > > Please take a look at the latest revision of my design document an

Re: DB design document

2000-12-16 Thread Jean-David Beyer
David Merrill wrote (in part): > > On Sat, Dec 16, 2000 at 09:52:14AM -0600, Rob Browning wrote: > > David Merrill <[EMAIL PROTECTED]> writes: > > > > > Please take a look at the latest revision of my design document and > > > give me some feedback. I just looked at it and it just showed me how

Re: DB design document

2000-12-16 Thread David Merrill
On Sat, Dec 16, 2000 at 12:29:54PM -0500, Jean-David Beyer wrote: > I imagine in an open-source context, management details are even more > difficult to achieve, since there is no enlightened CEO who can decree > that the decisions of the principal architect are law. It seems to have > worked with

Re: DB design document

2000-12-16 Thread David Merrill
On Sat, Dec 16, 2000 at 09:52:14AM -0600, Rob Browning wrote: > David Merrill <[EMAIL PROTECTED]> writes: > > > Please take a look at the latest revision of my design document and > > give me some feedback. Cool. > Finally got a chance to glance at it and to catch up on the current > discussion

Re: DB design document

2000-12-16 Thread David Merrill
On Sat, Dec 16, 2000 at 09:18:39AM -0600, Rob Browning wrote: > Dave Peticolas <[EMAIL PROTECTED]> writes: > > > Anyway we can avoid putting arbitrary limits on the lengths of text > > fields like account names & such? Currently gnucash imposes no such > > limits and I think it would be good to k

Re: DB design document

2000-12-16 Thread Jean-David Beyer
David Merrill wrote (in part): > Don't you know that is one of the big problems with enterprise > software design? It's all designed by committee! > I sure do. I worked at a large, formerly well regarded, research and development organization, and we had to deal with that all the time (with litt

Re: DB design document

2000-12-16 Thread David Merrill
On Sat, Dec 16, 2000 at 08:17:22AM -0500, Jean-David Beyer wrote: > David Merrill wrote: > > > > On Sat, Dec 16, 2000 at 02:15:21AM -0500, James LewisMoss wrote: > > > > On Thu, 14 Dec 2000 13:23:55 -0500, David Merrill ><[EMAIL PROTECTED]> said: > > > > > > David> On Thu, Dec 14, 2000 at 1

Re: Schema

2000-12-16 Thread David Merrill
On Sat, Dec 16, 2000 at 08:26:24AM -0600, Rob Browning wrote: > David Merrill <[EMAIL PROTECTED]> writes: > > > I'd recommend we use the standard GUID including MAC where it is > > available. If there is no MAC, then we could fallback to some > > arbitrary 48 bit pattern entered in the config tab

Re: Thoughts about the stock quote database

2000-12-16 Thread Jean-David Beyer
Rob Browning wrote (in part): > > Dave Peticolas <[EMAIL PROTECTED]> writes: > > > Rob Browning is going the price database, so he will be posting a > > requirements/design doc soon. > > Getting started on this now, so it's time to talk :> > > > It may be that gnucash doesn't need to use the p

Re: Thoughts about the stock quote database

2000-12-16 Thread Rob Browning
Dave Peticolas <[EMAIL PROTECTED]> writes: > Rob Browning is going the price database, so he will be posting a > requirements/design doc soon. Getting started on this now, so it's time to talk :> > It may be that gnucash doesn't need to use the price db to store > prices from real transactions.

Re: DB design document

2000-12-16 Thread Rob Browning
David Merrill <[EMAIL PROTECTED]> writes: > Please take a look at the latest revision of my design document and > give me some feedback. Finally got a chance to glance at it and to catch up on the current discussion. Most of the points I was going to mention "first-pass" other people already br

Re: DB design document

2000-12-16 Thread Jean-David Beyer
Rob Browning wrote (in part): > > Steve Greenland <[EMAIL PROTECTED]> writes (also in part): > > Agreed. Basically, the point was that we take the FSF, the GPL, and > free-software very seriously here, so we're not going to skimp on the > details, and I'm glad you brought this up. I hadn't rea

Re: DB design document

2000-12-16 Thread Rob Browning
Dave Peticolas <[EMAIL PROTECTED]> writes: > Anyway we can avoid putting arbitrary limits on the lengths of text > fields like account names & such? Currently gnucash imposes no such > limits and I think it would be good to keep it that way. I know > postgres has arbitrary length text fields, but

Re: DB design document

2000-12-16 Thread Rob Browning
Dave Peticolas <[EMAIL PROTECTED]> writes: > We may have to gather some usage information -- I have no idea what > people typically use, but 50 seems a bit small. And passwords should go to at least 64, I'd probably say more like 128. This allows people to choose safer, less cryptic passwords l

Re: DB design document

2000-12-16 Thread Rob Browning
Ignoring for the moment *any* issues of "what the right license is". There is a fundamental legal issue here. We chose a particular license for GnuCash. We now have make sure whatever we do in the future remains within the spirit and letter of that license, or we have to change that license som

Re: DB design document

2000-12-16 Thread Rob Browning
Steve Greenland <[EMAIL PROTECTED]> writes: > wouldn't be able to distribute it at all. (I'll add "I'm pretty sure" to > that last statement, as I certainly don't speak in any official way for > the Debian project Who does, really :> > Your certainly welcome (even encouraged) to bring the topic

Re: DB design document

2000-12-16 Thread Rob Browning
[EMAIL PROTECTED] (Bill Gribble) writes: > Rest assured that the gnucash developers are just as concerned about > this stuff as you are. We absolutely do not want to use any > component that makes any problems for distributing gnucash under > straight GPL, nor do anything that would cause Debian

Re: Schema

2000-12-16 Thread Rob Browning
David Merrill <[EMAIL PROTECTED]> writes: > I'd recommend we use the standard GUID including MAC where it is > available. If there is no MAC, then we could fallback to some > arbitrary 48 bit pattern entered in the config table, or do without it > entirely. After all... > > Q: How often would a

Re: DB design document

2000-12-16 Thread Jean-David Beyer
David Merrill wrote: > > On Sat, Dec 16, 2000 at 02:15:21AM -0500, James LewisMoss wrote: > > > On Thu, 14 Dec 2000 13:23:55 -0500, David Merrill <[EMAIL PROTECTED]> >said: > > > > David> On Thu, Dec 14, 2000 at 12:11:35PM -0600, Bill Gribble wrote: > > >> On Thu, Dec 14, 2000 at 12:47:08P

Re: DB design document

2000-12-16 Thread David Merrill
On Sat, Dec 16, 2000 at 02:15:21AM -0500, James LewisMoss wrote: > > On Thu, 14 Dec 2000 13:23:55 -0500, David Merrill <[EMAIL PROTECTED]> >said: > > David> On Thu, Dec 14, 2000 at 12:11:35PM -0600, Bill Gribble wrote: > >> On Thu, Dec 14, 2000 at 12:47:08PM -0500, David Merrill wrote: >

Re: DB design document

2000-12-16 Thread David Merrill
On Fri, Dec 15, 2000 at 06:29:12PM -0500, Derek Atkins wrote: > FTR, Debian currently ships OpenSSL (at least in non-us). So, if > Debian is willing to ship it, I don't see the problem. We are not > creating a derivative work of OpenSSL, we would be using the OpenSSL > library (which is not the

Re: Schema

2000-12-16 Thread David Merrill
On Fri, Dec 15, 2000 at 07:35:09PM -0600, Rob Browning wrote: > David Merrill <[EMAIL PROTECTED]> writes: > > > It really *is* just a rational number expressed as integer numerator > > over integer denominator. > > Right. The fact that we'll probably have to represent it with two > columns in a

Re: Schema

2000-12-16 Thread David Merrill
On Fri, Dec 15, 2000 at 07:29:30PM -0600, Rob Browning wrote: > David Merrill <[EMAIL PROTECTED]> writes: > > > Ugh! That is a completely meaningless name. *Every* numeric field is > > a "quantity". Of WHAT is it a quantity? > > Well, we had talked about using "quantity" and "value". Quantity >