linking gnucash to data in postgres

[Derek Atkins]

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

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

As I've alluded to before, they are probably "customers".

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

Yes and no.  PG worked fine in 1.6, but the code was extremely rigid
and not extensible.  When the business features (and other data types)
were added to 1.8, the changes to the sql backend were not made to
keep it up to date.  Right now Linas is working on some new
infrastructure which should make keeping a SQL engine up to date much
easier.  So, this situation should NOT continue into the next release
(i.e., 1.10/2.0 should have a working SQL backend).

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

I guess it depends what you mean by "registration of a soccer player"
and also what kind of entry is triggered.  Even gnucash+SQL wont
trigger anything from outside events.

>  But then the sql branch of gnucash has stopped development?

No.  See above.

> Joe

-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