Disclaimer: I made a promise to release my project for public. Yes, I know about fpdb. My hope is that our two projects can benefit from one another.

I'm pleased to announce PokerStats, an open-source statistics tracking software targeted mainly at those who play online poker on Linux. More than a year back, I started to write it for my own use only, but feel that it's now decent enough for others to try.

Homepage for the moment at http://bostik.iki.fi/pokerstats/

It currently supports only PokerStars and their NLHE cash games, but the database has been designed to work with all the standard games and an unlimited number of sites.

Main features:

• Simple GUI
• Basic and positional statistics
• Graph support, easily extended
• Starting hand statistics
• Filtering by stakes
• Hand importer in a separate process, to keep the tracker as responsive as possible

I plan on developing this further, and eventually adding support for other games as well sites.

Comments, ideas and flames welcome.

Found a nasty bug - if player name held certain special characters, they were escaped twice, causing these players' stats to show up empty.

Also added a simple HH splitter for those rare occasions where a monster hand history file is imported. Just for convenience.

-> Released version 0.2.4

This looks very good, you should link those screenshots here if you can.

Thank you. I'm not going to hotlink the shots just yet - I need to either find a good hosting provider for all my project needs; or alternatively wait for a certain ISP to get their act together and start providing real bandwidth where I live.

As soon as either of those two happen, I will also open the repository.

Thx, will test this later one.

Very nice! Too bad I run windows

given that it's written in python shouldn't it be relatively easy to port this to windows?

Possibly. At least the GUI part should be straightforward. No idea about the grapher or the split-process model. They depend on tools commonly available (or even usable) only on *nix flavours.

Wow really nice, i am really looking forward for a nice tracking software for linux.

I had some spare time, so I added the beginnings of a set-o-meter simply to see how long it would take. With some graphing fixes in too, this was enough to make a 0.2.6 release.

I'll take a two or three week vacation from development now, too much stuff at work.

Hi there,

I read this when taking a look at your code:

-- To make life easier and to cope with rounding errors from floats, the
-- difference between the two amounts must be at least that of the
-- smallest known small blind.
SELECT hand_id FROM money GROUP BY hand_id
HAVING (SUM(bet)-SUM(returned)) < (SUM(won)+SUM(rake))
AND ABS((SUM(bet)-SUM(returned)) - (SUM(won)+SUM(rake))) >=
(SELECT MIN(small_blind) FROM hands);


Sure, you can do it using floats. But why mess with precision error and error propagation, etc. when there may be a simple alternative?

Wouldn't it be possible to represent a stack of $29.32 not as a float of 29.32 but as an integer of 2932 cents ?

Don't know if this would help or not...

Talk to you soon,

Hmm, good point. Thanks. I think I'll change that at some point - fallout to code side is well contained and should be easy to accommodate for.

yeah, this is true. Floating points generally shouldn't be used for monetary calculations...you should use integers or decimal types.

IIRC should nearly always use ints, postges numerics are supposedly very slow.

Why not just host it on Google Code? The only problem is that GC only supports SVN, and it looks like you're using git. You could just host the git repository somewhere like GitHub, but it doesn't have a wiki or the ability to add users to a project like Google Code does.

Sourceforge is pretty good and pretty easy to admin your home page, downloads, forums and mailing lists. We (fpdb) don't use it for our git repos, but it is better than fine for the other stuff.