linking gnucash to data in postgres

[Joseph Mack]

Derek Atkins wrote:
> 

> >> An inventory subsystem is not an arbitrary set of tables..
> >
> > I'm sure I have lots to learn here, but my inventory is a soccer player
> > (name, league, team, age, address...), coaches, referees, soccer fields,
> > all of which look an arbitary set of tables at the moment.
> 
> No, that's not inventory...  Inventory is a counting of widgets
> that you purchase and then resell.  Think of a grocery store.  All
> the stock they have on the shelves and in the back room is their
> inventory.  An inventory system keeps track of it all and tells
> them how many of item they have.

OK, soccer players are not inventory. What are they in the context of
items that are in a database and add entries to my accounts?

> Gnucash currently has support for XML _and_ postgres.  They are two
> different data-storage backends.  PG worked fine in 1.6, however in
> 1.8 the PG support is tenuous at best and doesn't support any
> new-in-1.8 features.

I see. I just perused all the docs on the gnucash webpage (BTW - the link
to www.gldialtone.com is dead - host not found), to figure out what's going
on here. I take it that you have duplicate data storage mechanisms and 
whoever was developing the SQL backend has stopped doing so and only the
XML format is being developed at the moment and until someone steps up
to the plate to work on the SQL backend, that the current situation will
continue (into gnucash-2.0/1.10/whatever)

> I'll repeat again that you WILL have problems upgrading from 1.4 to
> future versions....

yes, yes. I've got the idea. gnucash-1.4 is doing everything I need 
really. I have enough to do without upgrading a program to a version
with identical functionality. However if I want registration of a soccoer 
player to trigger an entry in gnucash, then I'll want the sql version of
gnucash. But then the sql branch of gnucash has stopped development?

Joe

-- 
Joseph Mack PhD, High Performance Computing & Scientific Visualization
SAIC, Supporting the EPA Research Triangle Park, NC 919-541-0007
Federal Contact - John B. Smith 919-541-1087 - smith.johnb at epa.gov