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

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

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

Postby SinbadTheSailor » Thu Jun 05, 2008 4:58 am

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
SinbadTheSailor
 
Posts: 13
Joined: Thu Jun 05, 2008 4:44 am

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

Postby MrFlibble » Sat Jun 07, 2008 8:51 am

Will a datamined one do you or do you need the player hole cards?
MrFlibble
 
Posts: 58
Joined: Sat Mar 08, 2008 7:30 pm
Location: handhq.com for datamined hands

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

Postby SinbadTheSailor » Sun Jun 08, 2008 12:00 am

Explain the distinction.
SinbadTheSailor
 
Posts: 13
Joined: Thu Jun 05, 2008 4:44 am

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

Postby WhiteRider » Sun Jun 08, 2008 5:35 am

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.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

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

Postby SinbadTheSailor » Sun Jun 08, 2008 7:10 am

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.
SinbadTheSailor
 
Posts: 13
Joined: Thu Jun 05, 2008 4:44 am

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

Postby MrFlibble » Sun Jun 08, 2008 4:30 pm

In that case there's 20k hands here you can download: http://handhq.com/history.aspx
MrFlibble
 
Posts: 58
Joined: Sat Mar 08, 2008 7:30 pm
Location: handhq.com for datamined hands

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

Postby SinbadTheSailor » Sun Jun 08, 2008 8:58 pm

Cool, thanks a lot.
SinbadTheSailor
 
Posts: 13
Joined: Thu Jun 05, 2008 4:44 am


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 5 guests

cron