Poker-AI.org

Poker AI and Botting Discussion Forum
It is currently Mon Nov 13, 2023 4:25 pm

All times are UTC




Post new topic Reply to topic  [ 20 posts ] 
Author Message
 Post subject: HHDB Codebase
PostPosted: Sat Mar 29, 2014 8:39 pm 
Offline
Site Admin
User avatar

Joined: Thu Feb 28, 2013 5:24 pm
Posts: 230
It is time to finally open up this forum and release both the HHDB codebase and the database itself.

Originally, this data was gathered (and partially paid for from hand history providers) by the old HHEX (hand history exchange) on pokerai.org. It was a private forum and group that dedicated a lot of time and some money to gathering these hands. indiana (with the help of others I think) then came up with a new method of storing these hands more efficiently and built most of the codebase to convert hands from the site's format to his format plus basic analysis tools to parse the hands and work with the data.

The hands in the database are obfuscated and all player data was anonymized. The original hands were lost, or at least are not in mine and anybody else's possession as far as I know.

Code
I have pushed all of indy's code plus all of the code that I have built on top of it to github. This includes a small subset of the database to test your code against before running it against the entire database. The entire repository is published under GPL v3 as intended by indiana (see links below).

Feel free to checkout the code, fork the repository and/or contribute to it directly by building your own analysis tools:
https://github.com/coffee4tw/poker-hhdb

HH Formats
Samples for converting the hand histories into different formats are in the codebase.
One of them is for PS format I believe and the other is for ACPC format.

I found the PS format in PokerHandPrinter:
https://github.com/coffee4tw/poker-hhdb ... inter.java

I'm not sure where the ACPC one is. I know I wrote it at some point and you can see the converted files in here:
https://github.com/coffee4tw/poker-hhdb ... ample/uofa

It should be fairly easy to adapt to your needs though.

Hole Cards
There are no hole cards. You only see a players cards when they went to showdown or they decided to show them.

Full DB Details
Friar is kindly hosting these now at
HTTP: http://poker-db.veila.net/ (feel free to use wget to grab the whole she'bang)
TORRENT: http://poker-db.veila.net/HHDB.torrent
Magnet: url=http://poker-db.veila.net/
To all users -> Please Please make a modest committment to seed this. Doing so will ensure this is available for years to come, and if we all throttle to a reasonable value, nobody will have to singlehandedly support the whole thing. Trickle.

Notes
P.S.: Original about the HHDB when access was restricted:
http://forumserver.twoplustwo.com/15/po ... ta-452536/
http://poker-ai.org/archive/www.pokerai ... f=3&t=1910

_________________
Cheers.


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Sat Mar 29, 2014 10:40 pm 
Offline
Regular Member
User avatar

Joined: Tue Mar 05, 2013 9:19 pm
Posts: 50
Great news - thanks for opening this up!


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Mon Mar 31, 2014 2:35 am 
Offline
Junior Member

Joined: Sat Nov 02, 2013 2:21 pm
Posts: 26
Sick! Thank you very much!


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Sun Apr 20, 2014 3:01 am 
Offline
New Member

Joined: Sun Apr 20, 2014 2:58 am
Posts: 1
When are the details for accessing the full database coming? I'm working on an economics research paper and would love access to the full database.

Also any tips how I can go about converting the hand histories in the sample db from github into a plain text format for use elsewhere? Also i'm not clear on if this data includes hole cards?

Thanks!


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Mon Apr 21, 2014 6:53 pm 
Offline
Site Admin
User avatar

Joined: Thu Feb 28, 2013 5:24 pm
Posts: 230
HH Formats
Samples for converting the hand histories into different formats are in the codebase.
One of them is for PS format I believe and the other is for ACPC format.

I found the PS format in PokerHandPrinter:
https://github.com/coffee4tw/poker-hhdb ... inter.java

I'm not sure where the ACPC one is. I know I wrote it at some point and you can see the converted files in here:
https://github.com/coffee4tw/poker-hhdb ... ample/uofa

It should be fairly easy to adapt to your needs though.

Hole Cards
There are no hole cards. You only see a players cards when they went to showdown or they decided to show them.

Full DB Details
Friar is kindly hosting these now at
HTTP: http://poker-db.veila.net/ (feel free to use wget to grab the whole she'bang)
TORRENT: coming soon

_________________
Cheers.


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Sat May 17, 2014 1:39 am 
Offline
Site Admin
User avatar

Joined: Thu Feb 28, 2013 5:24 pm
Posts: 230
Apparently the database is lost on tcourl's hosting service since the account got suspended.

Does anybody have an alternative solution to store roughly 15GB to make available for a long period of time?
Preferably not on something like Dropbox/Box/Google Drive.

_________________
Cheers.


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Sat May 17, 2014 11:06 am 
Offline
Regular Member
User avatar

Joined: Tue Mar 05, 2013 9:19 pm
Posts: 50
Maybe Amazon Glacier?
Donations could help with costs?


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Wed May 28, 2014 3:08 pm 
Offline
New Member

Joined: Wed May 28, 2014 3:00 pm
Posts: 1
Coffee4tw wrote:
Apparently the database is lost on tcourl's hosting service since the account got suspended.

Does anybody have an alternative solution to store roughly 15GB to make available for a long period of time?
Preferably not on something like Dropbox/Box/Google Drive.


bit torrent? Amazon S3?

Glacier probably isn't a good choice, as access is very slow and costs a lot of money-- glacier is really meant for long-term backups you'll only need occasional access to.


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Wed May 28, 2014 3:34 pm 
Offline
Site Admin
User avatar

Joined: Sun Feb 24, 2013 9:39 pm
Posts: 642
I have space available and Coffee and I are in touch about transferring the data


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Tue Jul 22, 2014 11:53 am 
Offline
Site Admin
User avatar

Joined: Sun Feb 24, 2013 9:39 pm
Posts: 642
Everyone who is interested in this please send me a PM


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Wed Aug 13, 2014 3:28 pm 
Offline
New Member

Joined: Wed Aug 13, 2014 3:25 pm
Posts: 3
Hello, I am pretty new here, but I can offer hosting. PM me and we'll cordinate a transfer. I can offer pretty much unlimited hosting indefinitely. Also, for safety, perhaps we can get a torrent going on. I can seed persistently.


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Thu Aug 14, 2014 3:35 pm 
Offline
New Member

Joined: Wed Aug 13, 2014 3:25 pm
Posts: 3
HTTP: http://poker-db.veila.net/ (feel free to use wget to grab the whole she'bang)
TORRENT: coming soon


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Thu Aug 14, 2014 4:33 pm 
Offline
Site Admin
User avatar

Joined: Sun Feb 24, 2013 9:39 pm
Posts: 642
Cool, thanks :D

Original post updated


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Mon Aug 18, 2014 4:19 pm 
Offline
New Member

Joined: Wed Aug 13, 2014 3:25 pm
Posts: 3
Here's some more stuff for the longevity of this project (severs come and go, magnets are for ever :P). To all users -> Please Please make a modest committment to seed this. Doing so will ensure this is available for years to come, and if we all throttle to a reasonable value, nobody will have to singlehandedly support the whole thing. Trickle.

Quote:
Torrent

Magnet link available here.


Since this is a brand new torrent and results may vary, please reply here or PM me with any problems you have.


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Mon Aug 18, 2014 9:19 pm 
Offline
Site Admin
User avatar

Joined: Thu Feb 28, 2013 5:24 pm
Posts: 230
Very awesome. I'll help with the torrent soon!

_________________
Cheers.


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Thu Feb 02, 2017 8:36 am 
Offline
New Member

Joined: Thu Feb 02, 2017 8:32 am
Posts: 1
Rewrite java's code to c for my purposes. Maybe someone will found it useful, feel free to use.
https://github.com/throttle10/hhex
Write me about bugs.


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Mon May 22, 2017 4:46 am 
Offline
New Member

Joined: Sun Mar 05, 2017 3:24 am
Posts: 1
Is there still any way to get this database? None of the links seem to be working. I am willing to contribute to hosting costs if that helps.


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Sun May 06, 2018 12:29 am 
Offline
New Member

Joined: Sun May 06, 2018 12:23 am
Posts: 2
grumpopotamus wrote:
Is there still any way to get this database? None of the links seem to be working. I am willing to contribute to hosting costs if that helps.


Did you ever find a copy? Looking for good hand histories...


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Mon Jul 16, 2018 8:40 am 
Offline
New Member

Joined: Thu Jun 21, 2018 1:10 pm
Posts: 1
Did anyone ever get this up on a torrent or so?

I'v been trying to get them from the archive, but really limited what its possible to download..

I can keep it seeded if anyone has something they want to share with the forum..


Top
 Profile  
 
 Post subject: Re: HHDB Codebase
PostPosted: Thu Jul 19, 2018 1:13 pm 
Offline
Site Admin
User avatar

Joined: Sun Feb 24, 2013 9:39 pm
Posts: 642
naggz0 wrote:
Did anyone ever get this up on a torrent or so?
Not that I know of

naggz0 wrote:
I'v been trying to get them from the archive, but really limited what its possible to download..


What archive?
I can give you access to some hand histories. Send me a PM when you want them and I'll open them up.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 20 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Powered by phpBB® Forum Software © phpBB Group