Free Poker DB-Advanced On-line Poker Database

According to its Freshmeat entry:

Fpdb is a free/open-source tracker/HUD for use with on-line poker. The intent is to make fpdb capable of supporting all games on all sites.

Fpdb currently supports flop games (Hold 'em, Omaha, Omaha hi/low), stud games (7 card stud, Stud 8 and Razz) and draw games (2–7 Lowball single and triple draw, Badugi and 5 card draw).

Cash games are fully supported, and tournament support is improving all the time.

Currently supported sites include PokerStars, Full Tilt Poker, the Everleaf network, the Boss Media network and others; see Features for a full list. Additional poker sites can be supported by writing a plugin to parse the site's hand history files. Several additional plugins are under development and in the development tree.

Fpdb provides impressive player statistics to give you the edge in on-line poker.

Fpdb's profit graph: looks like ChazDazzle had a bad weekend!

The Positional Stats are comprehensive to say the least.

Installation

Binaries may be available in your repository (called python-fpdb on my Kubuntu system). Source also is available, and it doesn't seem to require any awkward compiling. To get an idea of the library requirements, the documentation noted the following successful package combination for Ubuntu 9.10:

  • Python 2.6

  • GTK+ 2.18.3

  • PyGTK 2.16.0

  • matplotlib 0.99.0

  • numpy 1.3.0

  • sqlite3 2.4.1

  • sqlite 3.6.16

  • database mysql

Note the SQL dependencies, as they are particularly important. The fpdb wiki's installation section has a very involved section regarding MySQL under Gentoo, so hopefully a combination of the provided Ubuntu and Gentoo instructions will point you in the right direction for your system.

For those running with source, once you have the library requirements out of the way, you either can grab a source tarball or set up a local repository with git. For the git option, enter the command: Garrick, one line below.


$ git clone git://git.assembla.com/free_poker_tools.git

For those wanting to use the source tarball, grab the latest tarball from the Downloads page and extract it. Open a terminal in the new folder, and you should be able to run the program simply by entering:


$ ./run_fpdb.py 

Whereas my Kubuntu binary ran with the command:


$ fpdb 

Usage

Before you start using fpdb, you obviously have to play some poker on one of the supported games, building up an account with some dealt hands against other players and whatnot. Once you've done that, you need to locate the local account files for this game so fpdb can find it later.

The best supported commercial site for Linux is PokerStars, as it runs almost perfectly under Wine. As a religious guy, I can't actually play for money, but I can vouch for PokerStars as it does have a "Play Money" mode for people like me. However, the developers did make it clear to me that fpdb is focused on real money games, so play money support isn't well tested but should work for PokerStars' cash games.

Moving back to fpdb, once you have some data ready to go, click on the Import menu and choose Bulk Import. Browse for the file(s) of your poker site below, and choose your game from the Site filter drop-down box. Now, click Bulk Import and wait a moment for your data to be processed.

I can take you through only a few basic steps, but it should be enough to get you started, after which you should pick up things pretty easily. Looking at the graphs first, click on the Viewers menu and choose Graphs. Find your game(s) below, and enter your user ID. Now in the Sites pane, check/uncheck the games you want to display, and choose Refresh Graph at the bottom. If all went well, a profit graph should display in the panel on the right.

This last step really shows you how to use all of the other viewers as well, so feel free to explore the other features to your heart's content—Ring Player Stats, Tourney Stats, Positional Stats, it's all there. And don't feel restricted to your own account either. You also can see the stats of other players, which, when you think of it, is really the whole point of this program!

Ultimately, Free Poker DB will give a genuine edge to any serious on-line poker players, particularly those taking part in tournaments and the like. However, I'd like to end this month on a slightly different note—an unsolicited comment from co-developer "Chaz" on some heart-warming realities of OSS:

I got involved in the project about a year ago after leaving my job as a management consultant in Washington, DC, to start Pokeit. Pokeit is a similar product to fpdb, except it's a Web application and a commercial venture. On the face of it, Pokeit's collaboration with fpdb might seem a bit odd, given that we're trying to charge for something that fpdb gives away for free. In practice, it feels perfectly natural, and really it should. It almost goes without saying that you can't launch a business today without depending on open-source software—whether that be databases, such as MySQL or Postgres, free development tools, languages, add-on modules or niche libraries. Likewise for us, any tools that track and analyze hands of Internet poker require a set of core functionality for reading and storing data. Developing such a core function from scratch would have been a monumental waste of time for us when fpdb already had a two-year head start and strong foundation already built. So instead of going it alone, we decided early on to collaborate with fpdb on developing the codebase in as many ways as it made sense.

Let's hope his example catches on.

Read more at: http://fpdb.wiki.sourceforge.net

______________________

John Knight is the New Projects columnist for Linux Journal.

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

It seems that the database is

Lizzie's picture

It seems that the database is really complex and I am sure that it is in the benefit of a lot of people who are passionate by this type of online games.
Asigurari Obligatorii

pokerstars

Anonymous's picture

I live in the US and still play with the pokerstars.com client it is a much better version than pokerstars.net imo you just have to use TOR a proxy or a VPN connected else where to download it now.

I want online poker legal and regulated it would be nice to play for real money.

US poker

lrcdet's picture

I'm currently playing poker (in USA) at Bovada Poker (formerly Bodog) I was able to deposit money on 12/02/11 using my Comerica issued Visa card. There are a few other US friendly poker sites still out there. Google it

wow! :)) you americans really

wdrz's picture

wow! :)) you americans really live in your own little world dont you? :D

You had to buy some kind on

žogi's picture

You had to buy some kind on licence to run those site. + you pay tax for it.

well, if you wanna have a

Noobs's picture

well, if you wanna have a fluent hud/system you have to use hm (in vm), all pokersites updating their system and creating new tables (speed tables for example) and the hud is not running perfectly on fpdb, hm is updating everytime...so, in this case you've a big advantage in using commercial software.

lol, some noob comments here

Noobs's picture

lol, some noob comments here :)

If you're located in the us it's currently not possible to play online real money games, if you're not located in the us you can play on a couple of sites like pokerstars, some sites associated to the ipoker network, betfair and a couple other european poker sites

currently down: full tilt (lost their license, currently in negotiation with GBT, might be reopen 2012)

Fpdb: I'd use holdem manager under vm virtual box, runs fluent, more options...

What about the cheaters?

Ike Ahnoklast's picture

I love poker but would never play online - how could you ever be sure that a game server wasn't rigged to favor one or more players? It's hard enough to detect cheaters in person - isn't it pretty well established by now that the temptation for online poker sites to cheat is just too much to resist...?

It's not rigged

Anonymous's picture

"It's rigged" is the argument for bad players. Poker houses gain nothing from rigging and risk a lot. Every major site has the certificates that their random card generators are truly random and can be checked at any time by regulating body. Sites get profit from rake, not from winnings of specific players. While Full Tilt was alive I used to give them 100$ of rake just by playing on 10-20$ multitable, jet the most players accusing hoses being rigged are the ones playing for rake of 0.20$, at 1$ games. Online game is by fair the most fair poker you'll ever play as it's truly random. You can't get such randomness by dealer shuffling the cards.
Another problem is why people think is rigged because in one hour of online poker you play the same amount of hands as you do in a year of real life poker, and you see much more low probability events since the number of cards dealt is much higher.
It's not rigged, if you can't make money on it, you're just not good enough, work on your game.

RE: Great Idea

Robert Hinson's picture

James D. They were not shut down, you can still play on PokerStars but with play money. I don't know about the other site.

fpdb

Robert Hinson's picture

Well, you would have to be a non US customer to have a money account on any of the gambling sites, like PokerStars, FullTilt Poker and all the rest. Since the US put restrictions on that.

Great Idea

James D 's picture

Except that most of those sites were shut down. . .

I know that PokerStars is

Robert Hinson's picture

I know that PokerStars is still up. You have to use the pokerstars.net site instead of pokerstars.com. And you only get to play with play money.

White Paper
Linux Management with Red Hat Satellite: Measuring Business Impact and ROI

Linux has become a key foundation for supporting today's rapidly growing IT environments. Linux is being used to deploy business applications and databases, trading on its reputation as a low-cost operating environment. For many IT organizations, Linux is a mainstay for deploying Web servers and has evolved from handling basic file, print, and utility workloads to running mission-critical applications and databases, physically, virtually, and in the cloud. As Linux grows in importance in terms of value to the business, managing Linux environments to high standards of service quality — availability, security, and performance — becomes an essential requirement for business success.

Learn More

Sponsored by Red Hat

White Paper
Private PaaS for the Agile Enterprise

If you already use virtualized infrastructure, you are well on your way to leveraging the power of the cloud. Virtualization offers the promise of limitless resources, but how do you manage that scalability when your DevOps team doesn’t scale? In today’s hypercompetitive markets, fast results can make a difference between leading the pack vs. obsolescence. Organizations need more benefits from cloud computing than just raw resources. They need agility, flexibility, convenience, ROI, and control.

Stackato private Platform-as-a-Service technology from ActiveState extends your private cloud infrastructure by creating a private PaaS to provide on-demand availability, flexibility, control, and ultimately, faster time-to-market for your enterprise.

Learn More

Sponsored by ActiveState