Re: DB design document

2000-12-20 Thread Dave Peticolas
"Phillip Shelton" writes: > > ACCOUNT > --- > account_guidchar32 > parent_account_guid char32 -> account.account_guid > group_guid char32 -> account_group.group_guid > account_typeinteger ->

Re: DB design document

2000-12-20 Thread Rob Browning
Dave Peticolas <[EMAIL PROTECTED]> writes: > Currently, the reconcile dialog is all-or-nothing. Either you finish > the reconciliation, or nothing is changed. Here is my plan for postponing > a reconciliation: Once again, Dave plans to implement something I hadn't even fully realized I *really*

RE: DB design document

2000-12-20 Thread Phillip Shelton
ACCOUNT --- account_guidchar32 parent_account_guid char32 -> account.account_guid group_guid char32 -> account_group.group_guid account_typeinteger -> account_types.acct_type_code account_co

Re: DB design document

2000-12-20 Thread linas
It's been rumoured that Rob Browning said: > > [EMAIL PROTECTED] writes: > > > I don't think there are any. Virtually all sql db's support a > > common basic set of functions, and its hard for me to think of a > > good example where gnucash would need/want to use something that > > wasn't stand

client-server

2000-12-20 Thread linas
OK, here's the dope: I don't think rob is entirely aware of the possibilities that his XML file format opens up. Some of the readers of this mailing list may also not be aware of what demos grib has done with embedding guppi in html. I don't know how many people are aware that the cvs branch

Re: DB design document

2000-12-20 Thread Rob Browning
[EMAIL PROTECTED] writes: > I don't think there are any. Virtually all sql db's support a > common basic set of functions, and its hard for me to think of a > good example where gnucash would need/want to use something that > wasn't standard. Say we decide we need to always perform some particu

Re: DB design document

2000-12-20 Thread Dave Peticolas
David Merrill writes: > > > > In the past yes, but now they are set to the date you choose > > in the 'reconciliation info' window that pops up when you > > start a reconciliation. By default, it is the current date. > > So when you go back to complete a reconciliation the date will already > be

Re: DB design document

2000-12-20 Thread linas
It's been rumoured that Rob Browning said: > > [EMAIL PROTECTED] writes: > > > at some point or another, gnc-engine must convert whatever its doing > > to plain-old SQL statements. The standard sql client side libraries > > just send these to the server via unix-dmoain sockets or tcp sockets.

Re: DB design document

2000-12-20 Thread Dave Peticolas
David Merrill writes: > On Wed, Dec 20, 2000 at 10:21:30AM -0600, Bill Gribble wrote: > > On Wed, Dec 20, 2000 at 09:58:25AM -0500, David Merrill wrote: > > > So an account group can belong to another account group? The current > > > schema doesn't provide for that. Should it? If it does, then we

Re: DB design document

2000-12-20 Thread linas
It's been rumoured that Jean-David Beyer said: > > More accurately > > > > (sql server) || <- - - - - -> || (sql-client-lib <-> gnc_engine <-> ui) > > > > at some point or another, gnc-engine must convert whatever its doing > > to plain-old SQL statements. The standard sql client side librarie

Re: DB design document

2000-12-20 Thread linas
It's been rumoured that Derek Atkins said: > > The problem is that using TCP sockets is completely insecure. This is > also a problem with Xlib (which is why many people tunnel X in SSH :) > We want to avoid over-the-network communications in-the-clear, by > using encryption. I would also like

Re: DB design document

2000-12-20 Thread linas
It's been rumoured that Jean-David Beyer said: > > Patrick Spinler wrote: > > > > Earlier in this converstation, Linas mentioned that SSLizing any > > application isn't very difficult. > > > > Certainly for the [GPL, I assume you mean] license databases that we're > > considering using here > >

Resolving the stock split/merger issue.

2000-12-20 Thread Rob Browning
Right now you can't really enter a stock split/merger into gnucash reasonably, and with Dave's help, I'd like to fix that. He and I (and Bill) have talked about this for a bit, and I've thought about it for a bit, and I've come up with this proposal. stock splits/mergers: =

Re: DB design document

2000-12-20 Thread Jean-David Beyer
Patrick Spinler wrote: > > Derek Atkins wrote: > > > > [EMAIL PROTECTED] writes: > > > > > ? > > > More accurately > > > > > > (sql server) || <- - - - - -> || (sql-client-lib <-> gnc_engine <-> ui) > > > > > Earlier in this converstation, Linas mentioned that SSLizing any > application isn't ve

Re: DB design document

2000-12-20 Thread Patrick Spinler
Derek Atkins wrote: > > [EMAIL PROTECTED] writes: > > > ? > > More accurately > > > > (sql server) || <- - - - - -> || (sql-client-lib <-> gnc_engine <-> ui) > > Earlier in this converstation, Linas mentioned that SSLizing any application isn't very difficult. Certainly for the license databas

Re: DB design document

2000-12-20 Thread Rob Browning
[EMAIL PROTECTED] writes: > at some point or another, gnc-engine must convert whatever its doing > to plain-old SQL statements. The standard sql client side libraries > just send these to the server via unix-dmoain sockets or tcp sockets. > If its tcp sockets, you don't 'care' wheere the sql se

Re: DB design document

2000-12-20 Thread Jean-David Beyer
[EMAIL PROTECTED] wrote: > > It's been rumoured that Rob Browning said: > > > > [EMAIL PROTECTED] writes: > > > > > > > (server) || <- - - - - -> || (gnc_engine <-> ui) > > > > > > here, the dotted line is just sql. Don't have to invent anything to > > > make this work. > > > > But is this

Re: DB design document

2000-12-20 Thread Derek Atkins
[EMAIL PROTECTED] writes: > ? > More accurately > > (sql server) || <- - - - - -> || (sql-client-lib <-> gnc_engine <-> ui) > > at some point or another, gnc-engine must convert whatever its doing > to plain-old SQL statements. The standard sql client side libraries I'm not convinced that "g

Re: DB design document

2000-12-20 Thread linas
It's been rumoured that Rob Browning said: > > [EMAIL PROTECTED] writes: > > > > > (server) || <- - - - - -> || (gnc_engine <-> ui) > > > > here, the dotted line is just sql. Don't have to invent anything to > > make this work. > > But is this sufficient? Overstating things a bit, this

Guppi rpms

2000-12-20 Thread Dave Peticolas
Guppi rpms are available on ftp.gnucash.org/pub/guppi dave ___ gnucash-devel mailing list [EMAIL PROTECTED] http://www.gnumatic.com/cgi-bin/mailman/listinfo/gnucash-devel

Re: DB design document

2000-12-20 Thread Rob Browning
[EMAIL PROTECTED] writes: > > > (server) || <- - - - - -> || (gnc_engine <-> ui) > > here, the dotted line is just sql. Don't have to invent anything to > make this work. But is this sufficient? Overstating things a bit, this may rely on every sql server we support being able to do every

Re: newbie/sm bus

2000-12-20 Thread Rob Browning
lee <[EMAIL PROTECTED]> writes: > can gnucash be used at moment ( ever? ) in way similar to > quicken,,,in that I don't have to deal with double entry..i believe > I understand its usefullness but for my sm business it seems > overkill.. Not precisely, but you can just create a few misc accounts

Re: DB design document

2000-12-20 Thread Rob Browning
David Merrill <[EMAIL PROTECTED]> writes: > That's not terribly hard to implement, but we need to decide now. It > would be very hard to change once implemented and in production. My > design now does not allow for this, per comments from other folks. As I mentioned in another mail, I kinda thin

Re: DB design document

2000-12-20 Thread David Merrill
On Wed, Dec 20, 2000 at 10:21:30AM -0600, Bill Gribble wrote: > On Wed, Dec 20, 2000 at 09:58:25AM -0500, David Merrill wrote: > > So an account group can belong to another account group? The current > > schema doesn't provide for that. Should it? If it does, then we have > > account groups which

Re: DB design document

2000-12-20 Thread Bill Gribble
On Wed, Dec 20, 2000 at 09:58:25AM -0500, David Merrill wrote: > So an account group can belong to another account group? The current > schema doesn't provide for that. Should it? If it does, then we have > account groups which can contain other account groups or accounts. the > sub-groups can con

Re: DB design document

2000-12-20 Thread David Merrill
On Wed, Dec 20, 2000 at 10:18:01AM -0500, Derek Atkins wrote: > David Merrill <[EMAIL PROTECTED]> writes: > > > I'm going to use lots of GUIDs. > > A GUID is just a unique index into a table, right? So an account_guid > would be an index to a particular account, etc. Exactly. -- The great se

Re: DB design document

2000-12-20 Thread Derek Atkins
David Merrill <[EMAIL PROTECTED]> writes: > I'm going to use lots of GUIDs. A GUID is just a unique index into a table, right? So an account_guid would be an index to a particular account, etc. -derek -- Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory Member, MIT Stude

Re: DB design document

2000-12-20 Thread David Merrill
On Wed, Dec 20, 2000 at 09:58:25AM -0500, David Merrill wrote: > On Wed, Dec 20, 2000 at 08:43:18AM -0600, Bill Gribble wrote: > > On Wed, Dec 20, 2000 at 11:57:47AM +1000, Phillip Shelton wrote: > > > An account group is just what it sounds like, a group of accounts. > > > > > > All accounts in

Re: DB design document

2000-12-20 Thread David Merrill
On Wed, Dec 20, 2000 at 08:43:18AM -0600, Bill Gribble wrote: > On Wed, Dec 20, 2000 at 11:57:47AM +1000, Phillip Shelton wrote: > > An account group is just what it sounds like, a group of accounts. > > > > All accounts in an account group must be denominated in the same commodity. > > I know t

Re: DB design document

2000-12-20 Thread David Merrill
On Wed, Dec 20, 2000 at 03:09:50PM +1000, Phillip Shelton wrote: > Depends on how you use groupings. Are we going to allow someone to have an > account that is part of credit and part of clothes, part of sport, part of > hobbies ... > > There was a question some time ago about being able to get a

Re: DB design document

2000-12-20 Thread Bill Gribble
On Wed, Dec 20, 2000 at 11:57:47AM +1000, Phillip Shelton wrote: > An account group is just what it sounds like, a group of accounts. > > All accounts in an account group must be denominated in the same commodity. I know the attribution is screwy there but I just want to point out that in gnucas