generic sql [wasRe: The Gnucash database?]

[Derek Atkins]

At this point I don't believe there is any hope of it working on
DB2 without a lot of work.  While the SQL is pretty standard, the
interface is still PG-specific, using the libpg library interface
to the library.

Building Gnucash is pretty easy once you get all the build
dependencies.  The hard part is getting all those -devel packages
installed.  Building on RHEL is definitely going to be harder because
they refused to distribute many of the gnome-1.4 packages that gnucash
requires.

Building gnucash to separate it from your default install is pretty
easy!  For example, I have three versions installed.  I just install
them into /opt/gnucash-<version> using the --prefix=... configure
option and all is well.

-derek

Jean-David Beyer <jdbeyer at exit109.com> writes:

> I have DB2 UDB V8.1.6 on my machine that I use for something else. But
> it can certainly handle more than one user and more than one database.
> I also managed to get the regular GnuCash (gnucash-1.8.8-0.9) from
> RPMs to run after a lot of work that need not be repeated here. My OS
> is Red Hat Enterprise Linux 3 ES.
>
> I have the disk space necessary to run another copy of GnuCash with a
> DB2 back end if it is not too difficult to install it. If the current
> development team already have access to DB2, they would be better
> qualified to test it themselves, but if no machines with DB2 on it are
> available, I might be able to run tests. I would need a lot of
> hand-holding as I have never successfully built gnucash, though I
> tried at one time. I cannot lose the ability to run my working version
> of GnuCash though, so I would need some means to segregate the test
> version from the working version.
>
> Putting the executable code into /usr/local/bin/ and /usr/local/lib
> would be part of the job (not difficult, I imagine) since the current
> version is in /usr/bin and /usr/lib.
>
> I am not sure what to do about /etc/gnucash (I never looked at it): it
> might be OK to leave it alone.
>
> /usr/libexec/gnucash, /usr/share/gnucash,
> /usr/share/man/man1/gnucash.1.gz would need to be thought about.
>
> I suppose I would put a new user in the system so as not to mess up
> existing users (only 2 users at the moment).

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