Re: DB design document

2000-12-15 Thread James LewisMoss
> 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: >> > Well this is a good time. As soon as I understand how they work >> > to

Re: DB design document

2000-12-15 Thread Gary E. Bickford
Amen, brother. Of course, I'm not a developer, but that sure seems to make sense to me. GB Christopher Browne wrote: > The main point is that it would probably be more economical of time > to work on ORBit-ssl so it gets available faster than it is to build > something that largely replicates

Re: DB design document

2000-12-15 Thread Christopher Browne
On 15 Dec 2000 18:29:12 EST, the world broke into rejoicing as Derek Atkins <[EMAIL PROTECTED]> said: > 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

Re: DB design document

2000-12-15 Thread Dave Peticolas
Derek Atkins writes: > 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 definition of derivative work). > > I ca

Re: Schema

2000-12-15 Thread Rob Browning
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 database is just an artifact of the fact that SQL doesn't have RATIONAL_64

Re: Schema

2000-12-15 Thread Rob Browning
Dave Peticolas <[EMAIL PROTECTED]> writes: > GnuCash does not keep an explicit list of transactions around. > However, it does provide an api to traverse over each one, hitting > each transaction only once. > > In the db, I would imagine that the transactions will almost certainly > have their o

Re: Schema

2000-12-15 Thread Rob Browning
Dave Peticolas <[EMAIL PROTECTED]> writes: > My best guess is that it stands for 'debit'. I had always thought it meant d(elta)amount. -- Rob Browning <[EMAIL PROTECTED]> PGP=E80E0D04F521A094 532B97F5D64E3930 ___ gnucash-devel mailing list [EMAIL PR

Re: Schema

2000-12-15 Thread Rob Browning
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 would indicate how much of the thing you have, and value it's value. Though

Re: DB design document

2000-12-15 Thread Derek Atkins
Yea, thanks. I'm looking at NSS now. One concern after about 30 seconds of reading is that "NSS utilizes Netscape Portable Runtime (NSPR) libraries as a portability interface and implementation that provides consistent cross-platform semantics for network I/O and threading models." This seems t

Re: DB design document

2000-12-15 Thread Derek Atkins
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 definition of derivative work). I can't believe that people are being

Re: DB design document

2000-12-15 Thread Patrick Spinler
I'm not a core developer here by any means, but at my reading, this does indeed look promising. Quoting from the FAQ: > NSS is licensed under both the Mozilla Public License and the > GNU General Public License. You may choose to use the code either > under the terms of the MPL or under the te

Re: DB design document

2000-12-15 Thread Patrick Spinler
David Merrill wrote: > > Hearing this, David was enlightened. > > I'm taking a bit of a time out from schema design to study Postgres > and its mechanisms and data types. I need to know them specifically > before I can fine-tune the data types. > Not having specifically studied postgres, I'll

Re: DB design document

2000-12-15 Thread Gary E Bickford
This might be of interest as an alternative to OpenSSL. I didn't read it in enough detail to know for sure. http://www.mozilla.org/projects/security/pki/nss/faq.html ___ gnucash-devel mailing list [EMAIL PROTECTED] http://www.gnumatic.com/cgi-bin/ma

Re: DB design document

2000-12-15 Thread David Merrill
On Fri, Dec 15, 2000 at 01:58:22PM -0600, Steve Greenland wrote: > On 14-Dec-00, 16:06 (CST), Derek Atkins <[EMAIL PROTECTED]> wrote: > > Steve Greenland <[EMAIL PROTECTED]> writes: > > > > > I don't think you can't use OpenSSL - tbe license is not compatible with > > > the GPL. Whether distribu

Re: DB design document

2000-12-15 Thread Gary E Bickford
Not to further muddy the waters, but what about the following thoughts? 1. Provide a 'security abstraction layer' that glues to any of various encryption schemes - SSL, SSH, TCS, ... 2. Use OpenSSH (http://www.openssh.com) as one of the schemes, instead of OpenSSL. OpenSSH are using a BSD-st

Re: DB design document

2000-12-15 Thread Steve Greenland
On 15-Dec-00, 14:10 (CST), Bill Gribble <[EMAIL PROTECTED]> wrote: > 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 anythi

Re: DB design document

2000-12-15 Thread David Merrill
On Fri, Dec 15, 2000 at 02:10:37PM -0600, Bill Gribble wrote: > On Fri, Dec 15, 2000 at 01:58:22PM -0600, Steve Greenland wrote: > > All of the above may look like I'm trying to create problems for the > > GnuCash project,but I'm actually trying to prevent them. If you don't > > consider these iss

Re: DB design document

2000-12-15 Thread Bill Gribble
On Fri, Dec 15, 2000 at 01:58:22PM -0600, Steve Greenland wrote: > All of the above may look like I'm trying to create problems for the > GnuCash project,but I'm actually trying to prevent them. If you don't > consider these issues before you write the code, many others will bring > them up, and i

Re: DB design document

2000-12-15 Thread Steve Greenland
On 14-Dec-00, 16:06 (CST), Derek Atkins <[EMAIL PROTECTED]> wrote: > Steve Greenland <[EMAIL PROTECTED]> writes: > > > I don't think you can't use OpenSSL - tbe license is not compatible with > > the GPL. Whether distribution is actually a violation of the GPL depends > > where you fall on the d

Re: DB design document

2000-12-15 Thread David Merrill
On Fri, Dec 15, 2000 at 09:51:28AM -0600, Patrick Spinler wrote: > David Merrill wrote: > > > > On Thu, Dec 14, 2000 at 09:54:44AM -0600, Patrick Spinler wrote: > > > In short, if you plan on having updatable data, use varchar() columns, > > > for which most databases preallocate space in the rec

Re: DB design document

2000-12-15 Thread Patrick Spinler
David Merrill wrote: > > On Thu, Dec 14, 2000 at 09:54:44AM -0600, Patrick Spinler wrote: > > In short, if you plan on having updatable data, use varchar() columns, > > for which most databases preallocate space in the record. This means > > some wastage of data storage, but you get a lot of pos

Re: DB design document

2000-12-15 Thread Dave Peticolas
"Phillip Shelton" writes: > > -Original Message- > > "Phillip Shelton" <[EMAIL PROTECTED]> writes: > > > > > Therefore we should be able to store the accounts scu's in > > the account > > > table? > > > > I thought the scu was tied to the commodity, not an account. > > Or did I misunder