Gnu-cash with Java

[Derek Atkins]

marthter <marthter at yahoo.ca> writes:

> I'm guessing here, but if you set up GnuCash with the Postgres
> database as the back-end data store, it seems to me that it should be
> possible to write other front-ends (including Java) that just use ODBC
> access to manipulate accounts and transactions.  Of course you would
> have to learn enough about the GnuCash data models to make sure any
> data you changed from your front-end remained consistent so it would
> still be useable from the normal GnuCash UI too.
> 
> On the other hand, if that data model is very complicated, it may be
> hard to consistently SQLify your transactions in there yourself
> without corrupting the data.  In that case, the bindings idea is
> probably better because you could just call the GnuCash functions and
> let GnuCash worry about keeping the data internally consistent.

IMHO, you're better off creating a JNDI interface around the GnuCash
API.  The data model is complex enough that accessing the sql database
under gnucash is "not supported" because you are very likely to
break some of the invariants.

> ~Martin

-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