Re: [Bug-gnubg] gnubg database interface

[Jim Segrave]

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

>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