Re: [Bug-gnubg] Relational database

[Joern Thyssen]

On Wed, Aug 04, 2004 at 09:48:12AM +0100, address@hidden wrote
> Having had to spend a fair amount of time on other projects and personal
> matters, I haven't had much time to play in the last few months.  Having
> downloaded the latest build of GNU, I noticed a relationship database and
> clicked on the various options but nothing seemed to happen.

No, the database interface is based on python, so you need a version of
gnubg compiled with python support. Also, you need to install python.

One problem I can think of is that the "regular" build is *not* compiled
with python support. So we need a python-enabled GUI-build or use the
no-gui version of gnubg. The menu entry in gnubg corresponds to the
command "relation something-i've-forgotten". 

Obviously you need to install a relational database. I think Jon posted
something a while ago (e.g., what database to use and what to change in
database.py). Can you check the archive?

> 
> Therefore, my question is how do you use the database.  I assume that as
> there isn't an option within GNU (not that I'm expecting one!) the database
> needs to be accessed from some other source.

Correct. A typical workflow would be

- add data using gnubg
- query using SQL (some databases such as access have a GUI to assist)
- make graphical representation using graphing tool (some databases may
  even provide this)


Once the database and interface we may add a few pre-selected graphs or
queries.

> My PC currently uses Windows ME or Windows NT (depends whether I'm in work
> or at home) and I am fairly epxerienced in using Microsoft Access but would
> look at using another database package if needs be.

In principle any database that supports Python DB API v2 can be used. I
think there is an interface for MS Access; if not, I'm 100% sure that
there is a ODBC interface (I use the python ODBC interface at work with
IBM DB2 as backend).

> 
> Can anyone help as the answers to this, and other questions, at the GammonLine
> board, has whetted my appetite.

The database is still a bit rough. Jim and others haev suggested some
changes.

J?rn

pgplo5wvmBycu.pgp
Description: PGP signature