Page 1 of 1

Anyone got a Postgre DB they're willing to share?

PostPosted: Thu Jun 05, 2008 4:58 am
by SinbadTheSailor
I want to make sure I have a good handle on how the DB works before I start tossing money at Party Poker again, so I want to make sure I'm querying for the info I want to get for my psychotically agressive style of play.

To do that I really need a populated database. Especially since I don't quite understand what some of the columns mean and the PDF isn't really illuminating.

I'd suggest the person helping me can scramble the player names if that makes you more comfortable. Some encryption would do the trick.

Thanks in advance, sorry if I'm being horrible rude

Re: Anyone got a Postgre DB they're willing to share?

PostPosted: Sat Jun 07, 2008 8:51 am
by MrFlibble
Will a datamined one do you or do you need the player hole cards?

Re: Anyone got a Postgre DB they're willing to share?

PostPosted: Sun Jun 08, 2008 12:00 am
by SinbadTheSailor
Explain the distinction.

Re: Anyone got a Postgre DB they're willing to share?

PostPosted: Sun Jun 08, 2008 5:35 am
by WhiteRider
A datamined DB will contain only observed hands, so won't show hole cards apart from hands that went to showdown, so you won't have a "hero" who has a complete set of hole cards to examine.

Re: Anyone got a Postgre DB they're willing to share?

PostPosted: Sun Jun 08, 2008 7:10 am
by SinbadTheSailor
That ought to do the job then. I'm trying to figure out what on earth is meant by some of the more obscure Poker terms in the schema and how PT derives them.

Might be easier to just reread the docs and then post "Whatsis...?" questions.

Re: Anyone got a Postgre DB they're willing to share?

PostPosted: Sun Jun 08, 2008 4:30 pm
by MrFlibble
In that case there's 20k hands here you can download: http://handhq.com/history.aspx

Re: Anyone got a Postgre DB they're willing to share?

PostPosted: Sun Jun 08, 2008 8:58 pm
by SinbadTheSailor
Cool, thanks a lot.