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 because

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 over the

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

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

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 okay. I

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 quite a few

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 real leap

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: 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

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 save the

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 the

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 already do online

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 other things I

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 measure

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 divisions

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

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: 3. Table Schemas: Gaping

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") \

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 big, fuzzy cloud

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 maintenance of

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 some feedback.

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: 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: David

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 against

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: 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 this

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!" - it

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: 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: 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 the

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 the

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 level of

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

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 changed.

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 are

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 managing user

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

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 username?