linking gnucash to data in postgres

[Derek Atkins]

Joseph Mack <mack.joseph at epa.gov> writes:

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

>> When gnucash uses SQL the data is not XML; XML is the (current) file
>> format. 
>
> so the current format is XML and gnucash is going to postgres and is
> not there yet (I'm at 1.4 and haven't kept up with all of this). 
> I thought postgres was the current storage format and it was 
> storing XML.

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'll repeat again that you WILL have problems upgrading from 1.4 to
future versions....

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available