Offline game database for PicoChess Web

[gkalab]

Hello everybody,

I managed to add an offline game database to PicoChess Web. Since it runs on a Raspberry Pi, it doesn't have the same functionality as ChessUI's database. Here are the changes/restrictions:

* Only the first 5 games containing the current position are displayed.

* There is no reordering of results, games are displayed in database order.

* No additional search function.

* The maximum number of games in the database depends on the RAM and processor speed.

* The database uses the scid format and is unrelated to the opening book. This means that you can, but do not have to, use the same database as the basis for the openings book and the games database.

And this is how it looks:

Performance

I tested on a Raspberry Pi 3b with 1GB RAM.

Note: ChessUI's 2 million games database, converted to scid format, was not working on my Raspberry Pi. I suspect the names didn't fit in RAM. However, the database worked fine when I ran the server on a different Linux host.

I've reduced the number of games to around 400,000  (all games with both players having 2400+ ELO). Then I ordered the database by ELO to show the games with the highest combined ELO first. Loading the game list for the initial chess position takes about 1.5 to 2 seconds. All subsequent searches are faster, with queries typically taking less than a second.

The changes required for PicoChess Web are available on the same branch as the changes for the local opening book server: https://github.com/gkalab/picochess/tree/feature/bookserver

The commit and installation description is available here: https://github.com/gkalab/picochess/commit/3db718831534c73a5ee94b9573bc6888021f7652#diff-875402ec756beb7b8df2587d6d4a9c4db06ba309eb246fc085886e5149a6d14b

To complete this, here is a screenshot of the book page:

Gerhard

[Dirk]

Hi Gerhard,

that sounds incedible and is a perfect addition/replacement of the original database functionality and best of all it rubs locally.

I will test it next week when i am home.

Thanks for you work.

Dirk 

Von meinem iPad gesendet

Am 15.10.2022 um 19:47 schrieb gkalab <gerhar...@gmail.com>:



--
You received this message because you are subscribed to the Google Groups "PicoChess" group.
To unsubscribe from this group and stop receiving emails from it, send an email to picochess+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/picochess/67dbaf1a-4274-4291-9fcc-8da2b915e268n%40googlegroups.com.