Re: [Bug-gnubg] 2 bugs and a question about database file location

[Michael Petch]

The latest release you should consider downloading is here:
http://www.gnubg.org/media/windows/gnubg-MAIN-20091002-setup.exe

The main download page for Windows builds is here:

http://www.gnubg.org/index.php?itemid=56 (Sometimes updates can be frequent
so you can check this page often).

The local database (gnubg.db) is a binary file so can't be queried directly.
Gnubg uses SQL Lite for storing data in the database. SQL Lite is as the
name suggests - a light and small footprint SQL engine. If you know SQL then
things are easier.

You can query gnubg.db outside of Gnubg itself with an SQL lite tool
available here:

http://www.sqlite.org/sqlite-3_6_18.zip

Documentation on its use here:

http://www.sqlite.org/sqlite.html

This of course is much more difficult if SQL is not something you have used
before, but I present it just in case.

The GnuBG that you download does not "learn from experience" (see pevious
posts to Roy Crabtree on that subject). If you install the new version
overtop of the old version (The old one being April 2009)- the new version
will try to use all the previous settings, and keep the database intact.

Michael


On 07/10/09 6:42 AM, "Adi Kadmon" <address@hidden> wrote:

> Thanks Christian, the file was indeed exactly at the location you gave. But
> till now I don't have a program that can open this kind of file, and if I had,
> I'm not sure the format would be usable for a clear printout.
> Anyway, I think it would be convenient if, in the main window of "Relational
> Database" (after "Show Records") one could by Ctrl-A select and thus copy the
> whole player' list - which is impossible at least as to 4/2009 version. (Only
> the statistics for each separate player are choosable.)
> A propos versions, I'd like to have the latest one. But won't installing it
> entail losing important information like GNU's "learning from experience", the
> relational database, or all the current settings? I believe the new version
> does recognize and keep the old information, but I want to make it sure. And
> I'd be glad to have the link and names of files to download in order to
> upgrade 4/2009 version.
>  
> Thanks a lot,
>  
> -- Adi
> 
> On Tue, Oct 6, 2009 at 11:40 PM, Michael Petch <address@hidden>
> wrote:
>> 
>> 
>> 
>> On 06/10/09 3:31 PM, "Christian Anthon" <address@hidden> wrote:
>> 
>>> 3 in C:\Documents and Settings\USER\.gnubg\gnubg.db, if I remember
>>> correctly. Perhaps you need a subfulder of your home directory.
>> 
>> If using Vista it is in:
>> 
>> C:\Users\USERNAME\.gnubg
>> 
>> Where USERNAME Is of course your account name on the PC.
>> 
>> 
> 
>