Re: Schema

2000-12-13 Thread Dave Peticolas
David Merrill writes: > On Wed, Dec 13, 2000 at 02:35:30PM -0800, Gordon Oliver wrote: > > So the denominator goes: smallest divisible unit. (amount atoms?) > > And the numerator: number of smallest divisible units > > Got it now, thanks. The numerator value is in terms of the smallest > unit of

Re: DB design document

2000-12-13 Thread Dave Peticolas
David Merrill writes: > Please take a look at the latest revision of my design document and > give me some feedback. > > Some of the issues I'm dealing with: > > 1. Architecture: A big, fuzzy cloud right now. > 2. Security: Lots of questions, few answers. Among the questions, > encryption over t

Re: Hardwired path in src/guile/Makefile.am

2000-12-13 Thread Dave Peticolas
Robert Graham Merkel writes: > The following code in latest CVS src/guile/Makefile.am is kinda machine-speci > fic . . . > > FLAVOR=gnome guile -c \ > '(set! %load-path (cons "/usr/local/opt/g-wrap/share/guile" %load-p > ath)) \ >(primitive-load "./gnc.gwp") \ >

Hardwired path in src/guile/Makefile.am

2000-12-13 Thread Robert Graham Merkel
The following code in latest CVS src/guile/Makefile.am is kinda machine-specific . . . FLAVOR=gnome guile -c \ '(set! %load-path (cons "/usr/local/opt/g-wrap/share/guile" %load-path)) \ (primitive-load "./gnc.gwp") \ (gw:generate-module "gnc")' CLEANFILES

Re: gbonds

2000-12-13 Thread Jim Evins
On Tue, 12 Dec 2000, Dave Peticolas wrote: > Jim Evins writes: > > Hello, > > I am the author of a program called gbonds, which may be of interest > > to the gnucash developers. It is a small savings bond inventory program for > > GNOME. More information can be found at > > > > http://sn

RE: DB design document

2000-12-13 Thread Phillip Shelton
Ok. I have not had to use any database yet in my work so I have no real idea about what is and is not available. Phill PS. As a off-topic aside David M, I am enjoying the quotes in your sig. > -Original Message- > On Wed, Dec 13, 2000 at 06:41:34PM -0800, Dave Peticolas wrote: > > Davi

Re: Thoughts about the stock quote database

2000-12-13 Thread Dave Peticolas
David Merrill writes: > On Wed, Dec 13, 2000 at 06:47:04PM -0800, Dave Peticolas wrote: > > Paul Fenwick writes: > > > > > > The good news is that I'm giving up the day-job to go back to > > > consulting, which should hopefully leave me with much more time > > > for open-source development and ot

Re: Thoughts about the stock quote database

2000-12-13 Thread David Merrill
On Wed, Dec 13, 2000 at 06:47:04PM -0800, Dave Peticolas wrote: > Paul Fenwick writes: > > > > The good news is that I'm giving up the day-job to go back to > > consulting, which should hopefully leave me with much more time > > for open-source development and other things I enjoy. :) The > > r

Re: DB design document

2000-12-13 Thread David Merrill
On Wed, Dec 13, 2000 at 06:41:34PM -0800, Dave Peticolas wrote: > David Merrill writes: > > On Thu, Dec 14, 2000 at 12:08:24PM +1000, Phillip Shelton wrote: > > > > > > > > > > -Original Message- > > > > Please take a look at the latest revision of my design document and > > > > give me

Re: Thoughts about the stock quote database

2000-12-13 Thread Dave Peticolas
Paul Fenwick writes: > > --LZvS9be/3tNcYl/X > Content-Type: text/plain; charset=us-ascii > Content-Disposition: inline > Content-Transfer-Encoding: quoted-printable > > G'day GnuCash developers, > > On Tue, Dec 12, 2000 at 05:59:12PM -0800, Dave Peticolas wrote: > > [snippage] > > > We alread

Re: DB design document

2000-12-13 Thread Dave Peticolas
David Merrill writes: > On Thu, Dec 14, 2000 at 12:08:24PM +1000, Phillip Shelton wrote: > > > > > > > -Original Message- > > > Please take a look at the latest revision of my design document and > > > give me some feedback. > > > > > > Some of the issues I'm dealing with: > > > > > >

Re: DB design document

2000-12-13 Thread Dave Peticolas
David Merrill writes: > On Wed, Dec 13, 2000 at 06:14:31PM -0800, Dave Peticolas wrote: > > David Merrill writes: > > > Please take a look at the latest revision of my design document and > > > give me some feedback. > > > > > > Some of the issues I'm dealing with: > > > > > > 1. Architecture: A

Re: DB design document

2000-12-13 Thread David Merrill
On Wed, Dec 13, 2000 at 06:14:31PM -0800, Dave Peticolas wrote: > David Merrill writes: > > Please take a look at the latest revision of my design document and > > give me some feedback. > > > > Some of the issues I'm dealing with: > > > > 1. Architecture: A big, fuzzy cloud right now. > > 2. Se

Re: DB design document

2000-12-13 Thread David Merrill
On Thu, Dec 14, 2000 at 12:08:24PM +1000, Phillip Shelton wrote: > > > > -Original Message- > > Please take a look at the latest revision of my design document and > > give me some feedback. > > > > Some of the issues I'm dealing with: > > > > 3. Table Schemas: Gaping holes. > > I have

Re: DB design document

2000-12-13 Thread Dave Peticolas
David Merrill writes: > Please take a look at the latest revision of my design document and > give me some feedback. > > Some of the issues I'm dealing with: > > 1. Architecture: A big, fuzzy cloud right now. > 2. Security: Lots of questions, few answers. Among the questions, > encryption over t

RE: DB design document

2000-12-13 Thread Phillip Shelton
> -Original Message- > Please take a look at the latest revision of my design document and > give me some feedback. > > Some of the issues I'm dealing with: > > 3. Table Schemas: Gaping holes. > I have quite a few questions about various fields that are marked with > question marks in

Locking (was Re: refreshing the GUI)

2000-12-13 Thread Derek Atkins
Phillip J Shelton <[EMAIL PROTECTED]> writes: > I don't see how the locking problem is a CM concern. I mean that you will > have to solve the locking problem at the level of storing the new data before > you need to worry about multilpe GUI's trying to read the file to see what > needs to be cha

Re: Schema

2000-12-13 Thread Derek Atkins
David Merrill <[EMAIL PROTECTED]> writes: > True, security is a lot easier when everything's local. Agreed. > If the client accesses the server via ssh and is then logged onto the > database using their user account on the db machine, where are the > weaknesses? Where is it vulnerable? To do t

Re: DB design document

2000-12-13 Thread Derek Atkins
Steve Greenland <[EMAIL PROTECTED]> writes: > WRT to over the wire encryption, I'd suggest looking into ssh port > tunneling. That would let those who need it use something that is well > tested and maintained, and those who don't ignore it completely. In > either case, no need to deal with it in

Re: Schema

2000-12-13 Thread Derek Atkins
Patrick Spinler <[EMAIL PROTECTED]> writes: [snip] > For the server and client on the same machine, this method provides a > reasonable expectation of privacy for the database - file protections > stop raw access to the file, and database user auth'ing stops people > running a database engine aga

Re: Schema

2000-12-13 Thread David Merrill
On Wed, Dec 13, 2000 at 05:31:55PM -0600, Patrick Spinler wrote: > David Merrill wrote: > > > > > Most database support auth'ing database users against the OS's auth > > > method. Essentially, once you've logged into the system, as long as > > > you're listed as a valid database user, you're oka

Simple indexer for help system

2000-12-13 Thread Bill Gribble
I wrote this dirt stupid script to build a searchable index for our help files. The idea would be that it would be run at compile time to allow runtime keyword searches. Any reason y'all see why it couldn't actually be refined to the point of being useful (it's really just a toy) and be used i

Re: Schema

2000-12-13 Thread Patrick Spinler
David Merrill wrote: > > > Most database support auth'ing database users against the OS's auth > > method. Essentially, once you've logged into the system, as long as > > you're listed as a valid database user, you're okay. I suggest we use > > this method. > > The downside of that is the main

Re: Schema

2000-12-13 Thread David Merrill
On Wed, Dec 13, 2000 at 02:35:30PM -0800, Gordon Oliver wrote: > So the denominator goes: smallest divisible unit. (amount atoms?) > And the numerator: number of smallest divisible units Got it now, thanks. The numerator value is in terms of the smallest unit of measure for the item. Pennies in t

Re: Schema

2000-12-13 Thread Terry Boon
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, Dec 13, 2000 at 02:35:30PM -0800, Gordon Oliver wrote: > > > Or am I thinking too much like an American, and some > > currencies could actually be held in the amount of 3/16, for example? > > probably ;-) > > some at least used to have div

Re: Schema

2000-12-13 Thread David Merrill
On Wed, Dec 13, 2000 at 04:51:03PM -0600, Patrick Spinler wrote: > > Other thoughts: > > In your SECURITY section: > > > Are we going to configure the database to use a separate login for each > > user (individual username and pw for the database *itself*), or are we > > going to handle that le

Re: Thoughts about the stock quote database

2000-12-13 Thread Dave Peticolas
Tor-Øyvind Gundersen writes: > > What if we annotated quotes with their source? Then quotes for > > particular transactions could be excluded from analysis. > > That could work, yes. But I still fail to see why GnuCash would need > to insert its own prices into a (possibly system-wide) quote rep

Re: Schema

2000-12-13 Thread Patrick Spinler
Other thoughts: In your SECURITY section: > Are we going to configure the database to use a separate login for each > user (individual username and pw for the database *itself*), or are we > going to handle that level of security ourselves, and then log into the > database using a single userna

Re: Schema

2000-12-13 Thread Gordon Oliver
> Or am I thinking too much like an American, and some > currencies could actually be held in the amount of 3/16, for example? probably ;-) some at least used to have divisions of 200 (for example, there used to be - and perhaps still is - a halfpence in Great Britain...) Also common here ar

GnuCash/gChartman interoperability

2000-12-13 Thread christian . glodt
Hello, I am the author of a technical stock analysis program called `gChartman', and I think it might be interesting to discuss wether some kind of gnucash/gchartman interoperability would make sense. The pogram is hosted at http://gchartman.sourceforge.net. First I'd like to give everyone a qu

Re: DB design document

2000-12-13 Thread David Merrill
On Wed, Dec 13, 2000 at 11:45:33AM -0600, Steve Greenland wrote: > On 13-Dec-00, 08:00 (CST), David Merrill <[EMAIL PROTECTED]> wrote: > > 2. Security: Lots of questions, few answers. Among the questions, > > encryption over the wire, locking down the db itself (depends on the > > db), and managi

Re: DB design document

2000-12-13 Thread Steve Greenland
On 13-Dec-00, 08:00 (CST), David Merrill <[EMAIL PROTECTED]> wrote: > 2. Security: Lots of questions, few answers. Among the questions, > encryption over the wire, locking down the db itself (depends on the > db), and managing user permissions on some kind of capabilities model > tbd. WRT to ove

Re: Schema

2000-12-13 Thread David Merrill
On Wed, Dec 13, 2000 at 10:15:06AM -0600, Bill Gribble wrote: > On Tue, Dec 12, 2000 at 06:04:08PM -0500, David Merrill wrote: > > Would you please give me an example that uses both numerator and > > denominator in each field? Or a set of example, if that is easier? > > I'm having trouble seeing h

Re: DB design document

2000-12-13 Thread David Merrill
On Wed, Dec 13, 2000 at 11:13:54AM -0500, David Merrill wrote: > I'm going to make a note that we may want to use a separate table. I'm > not entirely sure yet, but it sounds better than my scheme. Changed my mind; rewrote that section to incorporate your idea. -- Dr. David C. Merrill

Re: DB design document

2000-12-13 Thread David Merrill
On Wed, Dec 13, 2000 at 09:54:37AM -0600, Patrick Spinler wrote: > David Merrill wrote: > > > > Some of the issues I'm dealing with: > > > > 4. Auditing mechanism needs to be established. I wrote a proposal. > > David: > > I use an auditing method very similar to yours with two exceptions - I

Re: Schema

2000-12-13 Thread Bill Gribble
On Tue, Dec 12, 2000 at 06:04:08PM -0500, David Merrill wrote: > Would you please give me an example that uses both numerator and > denominator in each field? Or a set of example, if that is easier? > I'm having trouble seeing how this works. I'm not sure what you mean by "uses". The C data type

Re: DB design document

2000-12-13 Thread Patrick Spinler
David Merrill wrote: > > Some of the issues I'm dealing with: > > 4. Auditing mechanism needs to be established. I wrote a proposal. David: I use an auditing method very similar to yours with two exceptions - I save the auditing history in another table, therefore the auditing flags, timestamp

Re: Schema

2000-12-13 Thread David Merrill
On Wed, Dec 13, 2000 at 03:28:11PM +, Al Snell wrote: > On Wed, 13 Dec 2000, David Merrill wrote: > > > Do you think people feel less able to contribute because I'm doing > > this? If so, then by all means put it in cvs! > > No, no, this wasn't me saying "Oi! Put it in CVS you lazy slacker!"

Re: Schema

2000-12-13 Thread Al Snell
On Wed, 13 Dec 2000, David Merrill wrote: > Do you think people feel less able to contribute because I'm doing > this? If so, then by all means put it in cvs! No, no, this wasn't me saying "Oi! Put it in CVS you lazy slacker!" - it was me saying "I have a CVS server if you want one" :-) ABS --

Re: Schema

2000-12-13 Thread David Merrill
On Wed, Dec 13, 2000 at 03:07:35PM +, Al Snell wrote: > On Tue, 12 Dec 2000, David Merrill wrote: > > > I'm beginning to work on the database schema for an eventual SQL back > > end. I am keeping my notes in an ASCII file, which will always be > > available at http://www.lupercalia.net/schema

Re: Schema

2000-12-13 Thread Al Snell
On Tue, 12 Dec 2000, David Merrill wrote: > I'm beginning to work on the database schema for an eventual SQL back > end. I am keeping my notes in an ASCII file, which will always be > available at http://www.lupercalia.net/schema.txt Would you like a CVS repository to keep it in? Then other peop

DB design document

2000-12-13 Thread David Merrill
Please take a look at the latest revision of my design document and give me some feedback. Some of the issues I'm dealing with: 1. Architecture: A big, fuzzy cloud right now. 2. Security: Lots of questions, few answers. Among the questions, encryption over the wire, locking down the db itself (d

Re: Thoughts about the stock quote database

2000-12-13 Thread Tor-Øyvind Gundersen
Dave Peticolas wrote: > > As far as the database itself, it may make sense to eventually > separate it from GnuCash. In the short term, we kind of need it > asap, so it will probably be a part of GnuCash. Starting out as a GnuCash component is fine with me, as long as the design allows it to be

Re: Thoughts about the stock quote database

2000-12-13 Thread Dave Peticolas
Steven Rutter writes: > > A few months back I wrote a perl/gtk program called GtkPortfolio [can be foun > on freshmeat]. It will automatically update quotes for multiple portfolios, > view news, charts and allows you to set price alerts. I released it on > freshmeat under the Artistic License bec