Re: Recommended C Compiler

2009-08-09 Thread Tom Browder
On Sun, Aug 9, 2009 at 13:51, Tom Bullock wrote: ... > If you agree, tell me the compiler and version web source you use, so I can > download from there. I can't speak for anyone else, but I suspect most folks who develop on non-Windows use, as I do, gcc (current release is version 4.4.1):

Re: Db structure

2009-08-09 Thread Colin Law
2009/8/9 Phil Longstaff : > For the most part, I've tried to make the db schema match the XML schema, > including warts.  There are 2 places I'd like to change, and am looking for > feedback: > > 1) Each account stores a number of boolean flags (tax-related, hidden, > placeholder) in the slots tabl

Re: Db structure

2009-08-09 Thread Chris Shoemaker
On Sun, Aug 09, 2009 at 03:46:46PM -0400, Phil Longstaff wrote: > For the most part, I've tried to make the db schema match the XML schema, > including warts. There are 2 places I'd like to change, and am looking for > feedback: > > 2) Each budget stores all of the budget information in slots, w

Re: Gnucash and root-account in MySQL

2009-08-09 Thread Colin Law
2009/8/9 Phil Longstaff : > On August 8, 2009 01:05:49 pm Colin Law wrote: >> 2009/8/8 Phil Longstaff : >> > "tables do not have primary keys" - Which tables? >> >> recurrences, slots, taxtable_entries and versions > > Since the versions table is simply a set of table_name/table_version pairs, > wo

Db structure

2009-08-09 Thread Phil Longstaff
For the most part, I've tried to make the db schema match the XML schema, including warts. There are 2 places I'd like to change, and am looking for feedback: 1) Each account stores a number of boolean flags (tax-related, hidden, placeholder) in the slots table. It would be simpler if these w

Re: Gnucash and root-account in MySQL

2009-08-09 Thread Phil Longstaff
On August 8, 2009 01:05:49 pm Colin Law wrote: > 2009/8/8 Phil Longstaff : > > On August 8, 2009 04:37:26 am Colin Law wrote: > >> 2009/8/8 Marcus Wolschon : > >> - Hide quoted text - > >> > >> > What`s the point of not having that entry for the root-account? > >> > "books" would just reference it`

Recommended C Compiler

2009-08-09 Thread Tom Bullock
Hello all, I have been researching C compilers on the internet and find many. Since GnuCash is written in C, I think it would be good to use a compiler that matches the compiler version that most of you use. By following your lead it seems to me I would be most likely not to introduce compi

Re: Gnucash and root-account in MySQL

2009-08-09 Thread Marcus Wolschon
On Sun, Aug 9, 2009 at 9:01 AM, Colin Law wrote: > If I had a vote I would vote for parent_guid = nil for root account. > This maps to the real world better (ie account that has no parent) > rather than an account that is its own parent being a root account. > Also using the latter approach a root

Re: Gnucash and root-account in MySQL

2009-08-09 Thread Colin Law
2009/8/9 Marcus Wolschon : > On Sat, Aug 8, 2009 at 6:07 PM, Phil Longstaff wrote: [...] >> My memory is that the root account is a pseudo-account. I have no problem >> adding it to the accounts in the table. I may also have omitted it because >> it would require parent-guid = NULL, and I wanted to