Diagramming the PokerTracker 3 Database
Wednesday, March 25, 200930 tables. 1000+ columns.* Millions of rows. I invite anybody who thinks poker is a shallow game of chance to spend a few hours swimming through a decently-sized PokerTracker 3 database.
Now I know what you're thinking...
Is that a color-coded diagram of the PokerTracker 3 database schema in your pocket, or are you just happy to see me?
...and watch out. You already know I love diagrams, and I actually have a poster-sized version of this one hanging above my desk. I got tired of consulting the mammoth PokerTracker 3 PostgreSQL Database Schema Documentation PDF every time I needed to look up a column name (the PT3PQDBSDPDF is a great reference, but it's still a reference; a tome). I found myself wanting more of a Where's Waldo?-style cheat sheet, and I couldn't find one, so I built one and tacked it to the wall.
Feel free to download the original Visio document and, if anybody ever tells you "poker is just a gambling game," you can thwap them over the head with it (make sure to roll it up first). Said diagram might also come in handy if you do a lot of advanced/custom PokerTracker work:
- Custom statistics
- Fancy HUD layouts
- PokerTracker programming
It's also good for wrapping fish, starting fires, creating aerodynamically superior paper airplanes, that sort of thing. Enjoy.
(By the way, if you're curious how the above diagram was generated: I installed psqlODBC, the PostgreSQL ODBC driver, created a data source, attached Microsoft Visio to that data source, and had it extract the tables. The layouting, color-coding, and annotations were performed by hand.)
* - The exact number of columns will vary from installation to installation, depending on cached statistics.
Yes! Leave a Comment. All fields are optional.
- Sneak Peek: StopLight 1.0
- A Radioactive, Search-Hardened User Name for Online Poker
- Online Poker and the Multi-Tabling Effect
- A Primer Primer
- Moonlighting with OpenTK
- BROWSE ALL POSTS
Subscribe to Coding the Wheel over email or through any RSS reader. Coding the Wheel has been published since 2008.
- How I Built a Working Online Poker Bot, Part 1, 2, 3, 4, 5, 6, 7, 8
- Summoning the Harry Potter MMORPG
- Are Commercial Databases Worth It?
- 21 and the Monty Hall Paradox
- Visualizing the Internet (48)
SEO Packages wrote: Insightful, but the internet is a lot more difficult to portray imo. - 1,326 (41)
SEO Packages wrote: So disco isn't dead yet? - Dartboard-Driven Design (52)
SEO Packages wrote: Hilarious, very creative but I wouldn't guide myself after that. 90% of the surface of my target ... - How to Display Integrated Digg.com Comments on Your Website (27)
SEO Packages wrote: Very useful article, thanks for the info - Using Internet Conveyor Belts to Drive Traffic to Your Site (23)
SEO Packages wrote: Very useful info here, I am in the SEO business myself and I've learned some now stuff from your ... - Summoning the Harry Potter MMORPG (1048)
James Lloyd wrote: Is this Real LOOKS F*ING AMAZING :) can't wait till it is made :D - The Great Poker Hand Evaluator Roundup (119)
Cheap UGG Boots wrote: fddddffffff - The Great Poker Hand Evaluator Roundup (119)
mbt kisumu white wrote: dddddddddd - The Great Poker Hand Evaluator Roundup (119)
Discount MBT Shoes wrote: mbt kisumu black sandal and mbt kisumu white ar hot saling now in our website. This Summer,the mbt ... - How I Built a Working Online Poker Bot, Part 3 (133)
mr.cool wrote: Hello! I find this review very interesting ！Vibram FiveFingers - A Circular Dilemma Concluded (39)
online bollywood movies wrote: It seeks to show how rarely needed a high voltage working environment in which candidates are difficult ... - How I Built a Working Online Poker Bot, Part 3 (133)
wewr wrote: [Replica Watches][1] [1]: http://superior-replica.com/"Replica Watches" ... - How I Built a Working Online Poker Bot, Part 3 (133)
wewr wrote: Sorry i not mean spam,...just like your article,...cheers [Replica Watches][1] [1]: http://www.superior-replica.com/"Replica ... - How I Built a Working Online Poker Bot, Part 3 (133)
wewr wrote: Vibram FiveFingers - How I Built a Working Online Poker Bot, Part 3 (133)
Replica Watches wrote: Replica Watches - How I Built a Working Online Poker Bot, Part 3 (133)
Replica Watches wrote: Yeah, after a study it more deeply, I know now.Replica Watches - How I Built a Working Online Poker Bot, Part 3 (133)
Replica Watches wrote: I had not understood the purpose of this article, but after a study it more deeply, I know now. Replica ... - How I Built a Working Online Poker Bot, Part 3 (133)
Replica Watches wrote: posts that are very evocative readers like me to understand more about what is contained in this article ... - How I Built a Working Online Poker Bot, Part 7: Extracting Text from 3rd-Party Applications (318)
window cleaning wrote: Great series and I enjoyed each article very much. I hope now you've got a whole batch of articles ... - How I Built a Working Online Poker Bot, Part 3 (133)
property management wrote: fat burning furnace scam or real.
44 comment(s)
I read your blog mainly because of the graphics. Your writing ranges from excellent to terrible but the graphics are always nice. This will actually come in handy.
Anonymous on Thursday, March 26, 2009Awesome, glad to see you're back. Any chance of getting one of these for Hold'em Manager? OR is that heresy.....
Love the suggestion about thwapping the non-believers over the head with a rolled-up copy of the PT3 db schema. Where the hell is John Kyl when you need him.
Bots R Us on Thursday, March 26, 2009James, James, James. You have to start posting more often. Not every post has to be an epic 40-page long coding/techie post. Just keep the poker/comp sci. mix flowing even and steady because its great stuff. Every time I sit down for a session of online poker (EVERY) I check out your blog. When Ive got some poker, some programming, some new Coding the Wheel, maybe some 2+2 for good measure, I'm like a pig in shit. I'm an elephant in the mud. I'm a troll cavorting happily under the bridge.
Please no more month-long breaks in content. Nobody's forcing you to post anything, but you obviously enjoy it. I don't know what they've got you doing or whether you work, but you need to consider blogging/writing full time.
Just my .02. By the way, I'm still waiting for the 2nd half of the last post.
Anonymous Fanboy on Thursday, March 26, 2009Huzzah!
Ed K. on Thursday, March 26, 2009Great post. I was just looking at trying to mimick the poker tracker database (albeit for version 2) for my own handhistry recording app (because i'm too cheap to buy it). I'm sure this will be quite a handy reference. I didnt even know they had released the schema, i was trawling through access databases for days, trying to create something similar, yet less bloated.
JB on Thursday, March 26, 2009Watch out, more bot detection coming from your second favorite poker site.......
FTFanBoy on Thursday, March 26, 2009What's the point of including the holdemcache and tourneyholdem_cache tables in the diagram? Those (as you pointed) out are going to change from user to user anyway..
Great diagram though! Downloaded. And printed.
Anonymous on Thursday, March 26, 2009The PT3 DB Schema is great save for the dead fields such as idxhandstrength and idxkickerstrength and random errors in the holdemhandplayer_detail table Grrr...
Never checked up Hold'em Manager -- too much sunk cost memorizing this lovely schema.
Chaz on Thursday, March 26, 2009So unfortunate that you do not reply to your emails.
Love your stuff though. This poker series is awesome. Keep it coming. Because I, and many others, really love it!
Nick on Friday, March 27, 2009Oh and btw, I can see where this is going with this poker tracker icw the poker bot. Very neat. It's gonna be better and better in this way!
Nick on Friday, March 27, 2009Wow, what a mess. And here, I thought my poker tracking database was complicated.
Kevin H on Friday, March 27, 2009Have to disagree with Kevin H.
Looks like an everyday normalized relational database to me.
Similar to 90% of what's out there in production.
I muck through these for 8 hours a day.
God I hate my life.
Beer Me on Friday, March 27, 2009Just noticed the quote in the bottom-right corner of the Visio diagram. Had to zoom in to read it.
Bots R Us on Friday, March 27, 2009Poker Tracker 3 is teh awesome. I'll sift my way through this and get it printed out asap. Thanks a lot.
Poker Forums on Friday, March 27, 2009I think calling it normalized is a bit of a stretch.
Anonymous on Friday, March 27, 2009Beer Me: Normalized? That isn't even in second normal form.
A Attribute/Entity model would be useful here in adding flexibility and reducing complexity.
Jonathan H on Friday, March 27, 2009It could be in fourteenth normal form for all I know or care. I'm a working hack, not a relational database virtuosi. They hired me because I know how to do a JOIN. And because Im awsome.
Beer Me on Saturday, March 28, 2009Anybody know of a version of this for Hold'em Manager?
Anonymous on Saturday, March 28, 2009It would be easy enough to build your own, just extract the tables into Visio or another reverse eng. tool as the author described.
JeremyX on Sunday, March 29, 2009>It would be easy enough to build your own, just extract the tables into Visio or another reverse eng. tool as the author described.
It would take about 10 minutes. My problem with HM is that the last time I checked, you couldn't purchase it with a credit card and for me that's a deal-breaker.
James Devlin on Monday, March 30, 2009Life is easier with that stuff :)
Darmo on Sunday, April 19, 2009This thing has saved me hours of work already. Thanks. A huge help.
Ari on Monday, April 20, 2009wow
Poker Bot on Tuesday, June 02, 2009While i prefer Holdem Manager over Pokertracker 3 the diagramm is really impressive, goes to show how important pokerhuds are today.
Pokertracker 3 kostenlos on Monday, October 12, 2009I've looked at your schema, fpdb schema and some others, and they have few common attributes: they are very complicated and hard to understand, have way too many attributes per table, and contain the poker table history and its derived statistical logic in the same place. Where is the separation, decoupling and many more good programming skills that you've demonstrated so far? Or it is out of scope for database planning?
Pragmatic programmer on Tuesday, December 22, 2009What about enabling ODBC trace feature?
DIP on Sunday, January 17, 2010Please notice that the size of the database doesn;t say much about poker complexity and the gambling aspect of it.
Imagine Rullette Tracker 7 with the database containing all possible stats for players like "doubled the bet on 27black after three straight red"
huzia on Wednesday, June 23, 2010The Air Max 95 was based on the human anatomy. With the spine of the shoe resembling the human spine and the original materials to represent skin etc. Although stores were reluctant to stock this shoe because of its high technology and hence high price tag, they took a chance it became the first shoe to be more than ?100.00 sold in JD Sports. However they are often replicated and sold on the internet for a small fraction of cost. According to a new police database, the footwear of choice for criminals are Nikes with Nike Air Max 95¡äs being the most popular Daily Mirror. Air Max 95¡äs are also the chosen the Bloods street gang. Air Max cushioning has been used in shoes for almost all sports by now including basketball, cross training, golf, casual shoes, sandals, tennis, etc.; however the ¡°Nike Air Max¡± is always a running shoe. An example of a basketball shoe would be ¡°Air Max Uptempo.¡±
Nike Air Max 95 on Thursday, July 08, 2010nice article. keep post like this...
Fendi replica watches on Tuesday, July 20, 2010nice article. keep post like this...
Tonino Lamborghini replica watches on Saturday, July 24, 2010PerformingGraham for sale that will create a one-wayswiss watches backlink to your website whichMaurice Lacroix watches is a good point to have. It is Patek Philippe watchesa time-consuming Tag Heuer for saleprocess even though it produces good outcomes U-boat for saleand works. You can also swiss watchespost comments on blogs alongMaurice Lacroix watches together with your link, but make sureGraham watches these blogs are do-follow, which dolce & gabbana handbagsindicates the link that youreplica coach handbags simply post will probably be replica handbagscounted by the search engines jimmy choo replicaas a backlink.There are many thingsversace replica handbags that contribute to online businessjuicy couture replica failure, and the lack of good action thomas wyldeis surely one of the deadliest business-killersdolce gabbana handbags on the net. Take action like by no means chloe handbags replicaprior to, and don’t get struck by analysis paralysisburberry replica. Your achievement lies in your rapid actionchanel replica and how well you apply numerous strategies.
replica watches on Saturday, July 24, 2010nike air jordan 2010 nike air jordan 5 nike air jordan 3 nike air jordan 11 cheap nike air jordan 2 nike air jordan 1 nike air jordan shoes discount nike air jordan shoes nike air jordan 6 wholesale nike air jordan 1 discount nike air jordan 6 nike air jordan 7 nike air jordan 8 top quality nike air jordan shoes 23 nike air jordan 21 nike air jordan 22 nike air jordan 6 rings cheap nike air jordan 22 nike air lebron james shoes nike air lebron james shoes nike air jordan 2010 nike air joredan lebron james nike air jordan 2009 discount nike air jordan 2009 nike lebron james wholesale nike air jordan 2010 cheap nike air jordan 2009 discount nike air jordan 19 cheap nike air jordan 3 discount nike air jordan 18 brand nike air jordan 12 wholesale nike air jordan 2 nike air jordan 13 nike air jordan 14 nike air jordan 6 rings discount jordan shoes7 discount jordan shoes1 jordan shoes2010 jordan shoes 6 rings cheap jordan shoes2 discountjordan shoes3 discount jordan shoes4 jordan shoes uk23 jordan shoes classic bw22 cheap jordan shoes 21 ltd discount jordan shoes20 discountjordan shoes19 jordan shoes 18 uk nike air jordan shoes 17 cheap nike air jordan shoes 16 discount air jordan shoes 15 discount air jordan shoes 14 nike air jordan shoes 3 uk nike air jordan shoes 13 cheap nike air jordan shoes 11 discount air jordan shoes 6 discount jordan shoes 10 nike air jordan shoes 8 nike air jordan shoes 7 cheap louis vuitton bags cheap kobe bryant shoes cheap lebron james shoes .
cheapjordan on Saturday, July 24, 2010I will keep visiting this blog very often. Blu ray ripper /
ipad converter on Sunday, July 25, 2010air max shoes is an extremely comfortable shoe that uses a large air cushioning unit that can be seen from the side. This technology combined with the design of the shoe which is meant to compliment the spinal cord makes. Air Max shoes the ideal shoe for walking, running, playing basketball, or any other sport. nike air max ,nike air max 2009, nike air max 95, nike air max 90 and so on.Nike introduced its Air Cushioning Technology in 1979. By embedding Air Cushioning in the midsoles of its running shoes, it changed the way athletes approached and reacted to athletic performance forever.
nike air max on Monday, July 26, 2010ed hardy, cheap ed hardy, ed hardy clothing, ed hardy outlet, ed hardy jeans, ed hardy bags, ed hardy swimwear, ed hardy shirts, ed hardy tee, ed hardy caps, ed hardy purse, ed hardy board shorts, ed hardy shoes, ed hardy for men, ed hardy for women, ed hardy jeans for women.
cheap ed hardy on Tuesday, July 27, 2010ed hardy, cheap ed hardy, ed hardy clothing, ed hardy outlet, ed hardy jeans, ed hardy bags, ed hardy swimwear, ed hardy shirts, ed hardy tee, ed hardy caps, ed hardy purse, ed hardy board shorts, ed hardy shoes, ed hardy for men, ed hardy for women, ed hardy jeans for women.
cheap ed hardy on Tuesday, July 27, 2010It is a good timberland 6 inch boots thing that the God Who made us is not impatient with people like me with my timberland shoe company orchid. He lovingly thinks about us all the time timberland boots and he even temporarily gave up His heavenly home and his timberland traditional handsewn hold on diety to die for the sins of timberland mens custom world nearly 2,000 years ago. His death back then covered the sins of every cheap timberland boots person who will ever live. He then rose to life after three mens timberland chukka days and ever since has wanted us to accept His gracious act by loving Him and also those around us. When we do this, we will see people in a totally different timberland womens premium boots light — one that redefines what it means to be ugly or different or weird or strange. Instead, we see people with ugly timberland shoes store problems in whom God is working so they can bloom beautifully — just like I now see in my orchids whether they are “lumps” or blossoms! On a certain timberland work shoes day at a certain hour, we will pull into the station. Bands will be playing and flags waving. Once we get there, so many wonderful dreams will come true and the pieces of our timberland wheat shoes lives will fit together like a completed jigsaw puzzle. How restlessly we pace the aisles, *ing the minutes for timberland for you loitering --waiting, waiting, waiting for the station.
discount timberland boots on Wednesday, July 28, 2010Topreplicashop retail and wholesale Louis vuitton outlet, Key Chains, Cufflinks, Accessories, ...
Louis vuitton is no more a luxury if you find www.sale4louisvuitton.com, the best online source of top quality mirror image Louis vuitton wallets, ...
Everybody who is interested in Louis vuitton Belt, please come here ,it is surprised Louis vuitton outlet you a huge selecting of top quality AAA replica Watches .
louisvuitton4 on Thursday, July 29, 2010Wholesale NFL Jerseys
Cheap NFL Jerseys
NFL Jerseys
NFL Football Jerseys
Women NFL Jerseys
Kid NFL Jerseys
Super Bowl Jerseys
Super Bowl NFL Jerseys
Throwback Jerseys
Throwback NFL Jerseys
Cheap Throwback Jerseys
Wholesale Throwback Jerseys
Cheap Super Bowl Jerseys
Wholesale Super Bowl Jerseys
youth nfl jerseys wholesale
youth nfl jerseys cheap
nfl youth jerseys
Baltimore Ravens Jerseys
Chicago Bears Jerseys
Cincinnati Bengals Jerseys
Denver Broncos Jerseys
Dallas Cowboys Jerseys
Green Bay Packers Jerseys
Indianapolis Colts Jerseys
Minnesota Vikings Jerseys
New England Patriots Jerseys
New Orleans Saints Jerseys
New York Jets Jerseys
Arizona Cardinals Jerseys
Buffalo Bills Jerseys
Atlanta Falcons Jerseys
Carolina Panthers Jerseys
Cleveland Browns Jerseys
Houston Texans Jerseys
Detroit Lions Jerseys
Jacksonville Jaguars Jerseys
Kansas City Chiefs Jerseys
Miami Dolphins Jerseys
New York Giants Jerseys
Philadelphia Eagles Jerseys
San Francisco 49ers Jerseys
Oakland Raiders Jerseys
Seattle Seahawks Jerseys
Pittsburgh Steelers Jerseys
St Louis Rams Jerseys
San Diego Chargers Jerseys
Tampa Bay Buccaneers Jerseys
Tennessee Titans Jerseys
Washington Redskins Jerseys
Ray Lewis Jerseys
Ed Reed Jerseys
Joe Flacco Jerseys
Terrell Suggs Jerseys
Dick Butkus Jerseys
Greg Olsen Jerseys
Matt Forte Jerseys
Devin Hester Jerseys
Walter Payton Jerseys
Brian Urlacher Jerseys
Lance Briggs Jerseys
Jay Cutler Jerseys
Carson Palmer Jerseys
Rey Maualuga Jerseys
Chad Johnson Jerseys
Demarcus Ware Jerseys
Jason Witten Jerseys
Terrell Owens Jerseys
Felix Jones Jerseys
Marion Barber Navy Jerseys
Marion Barber Jerseys
Emmitt Smith Jerseys
Miles Austin Jerseys
Roger Staubach Jerseys
Troy Aikman Jerseys
Tony Romo Jerseys
Eddie Royal Jerseys
Brandon Marshall Jerseys
Aaron Rodgers Jerseys
A.J. Hawk Jerseys
Donald Driver Jerseys
Greg Jennings Jerseys
Peyton Manning Jerseys
Dallas Clark Jerseys
Robert Mathis Jerseys
Marvin Harrison Jerseys
Drew Brees Jerseys
Marques Colston Jerseys
Pierre Thomas Jerseys
Reggie Bush Jerseys
Jeremy Shockey Jerseys
Tarvaris Jackson Jerseys
Adrian Peterson Jerseys
Jared Allen Jerseys
Mark Sanchez Jerseys
Thomas Jones Jerseys
Leon Washington Jerseys
Brett Favre Jerseys
buynflshop on Thursday, July 29, 2010sale4louisvuitton.com is a online shopping store for 2100 Authentic Louis vuitton shop and
Louis vuitton Handbags.
Welcome to our fabulous collection Louis vuitton Collection! We have all the best and newest styles in louis shop - all the best
...
Wholesale Cheap Designer Replicas Best designer authentic replica Louis vuitton online - Authentic replica Louis vuitton
louis vuitton on Thursday, July 29, 2010essay essay writing essay writing service essay writing service uk
jane on Friday, July 30, 2010Pool Temperature Madera Jobs Madera Pest Control Madera Dentist Merced Dentist Visalia Dentist Modesto Dentist Fresno Limousine Fresno Granite briefcases leather leather briefcases prospect solution | prospect solutions | prospectsolution | prospectsolutions | prospectsolution.com prospect solution | prospect solutions | prospectsolution | prospectsolutions | prospectsolution.com prospect solution | prospect solutions | prospectsolution | prospectsolutions | prospectsolution.com
carmi on Friday, July 30, 2010Choosing the right tiffany jewelry accessory will turn an ordinary outfit into a fashion statement before you buy it from one mall or others, you can budget from our mall; christian louboutin as being beautiful and making us feel sexy Italian research has shown that a good pair of heels can help tone the body, condition muscles and improve the wearer's sex life, buy it please click the link; Look for ed hardy clothing, just click the link and you will have a great surprise; Finding beautiful cartier jewelry as gifts, we provide different styles for your reference; Choose the different links of london jewellery from our site, enjoy free and fast shopping worldwide; If you plan on shopping for NFL jerseys, you can purchase nfl jerseys online at our mall. We will do our best to serve for you. Welcome you！
tiffany jewelry on Friday, July 30, 2010Replica miu miu handbags are not just beautiful and elegant, but it is also at excellent quality and similar design as the real. You will like it once you see it. Now attention please, at our shop, we are holding a promotion. You can buy replica miu miu bags of high quality with the lowest price. Meanwhile, miu miu handbags buying from here you can enjoy free and fast delivery shipping. Welcome to our shop!
miu miu bags on Friday, July 30, 2010