[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bug-gnubg] gnubg database interface

From: Jim Segrave
Subject: Re: [Bug-gnubg] gnubg database interface
Date: Sun, 4 Apr 2004 20:37:28 +0200
User-agent: Mutt/1.4.1i

On Sun 04 Apr 2004 (15:26 +0000), Joern Thyssen wrote:
> Hi,
> I've had a first go at the gnubg database interface.
> I've commited a file gnubg.sql, which contains the DDLs for the database
> and tables.

This is good news. I have been completely snowed under with
work/children for a long time and I really have regretted that this
development was stalled (even though databases are not my strongest

>From talking to our more database knowledgeable people, there is a lot
to be said for postgresql over mysql, particularly in enforcing
relationships by using foreign keys. So starting with postgres is
probably a very good thing.

> I've also committed a file scripts/database.py for adding a match to the
> database: with a match or session loaded in gnubg, execute:
> load python scripts/database.py
> At this stage, only the player information, match information and the
> match statistics gets added to the database. Adding individual games and
> individual moves is on the TODO list... An improved version with GUI
> integration is also on the TODO list. I've no immediate plans for this,
> so if someone volunters, please go ahead!
> The database.py script uses the DB API v2 python modules. Currently the
> script uses postgresql, but it should be almost trivial to substitute
> with mysql, ODBC, DB2, etc. by changing:
> import pgdb
> conn = pgdb.connect(dsn=':gnubg')
> to something else. Read more about DB API v2 at
> <URL:http://www.python.org/topics/database/>, in particular
> <URL:http://www.python.org/topics/database/modules.html>.
> Comments appreciated!
> J?rn

> _______________________________________________
> Bug-gnubg mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/bug-gnubg

Jim Segrave           address@hidden

reply via email to

[Prev in Thread] Current Thread [Next in Thread]