Open Side Menu Go to the Top
Register
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

02-24-2010 , 12:59 AM
Quote:
Originally Posted by JimY
That seems like it worked, replaced the hud congif text with the example text saved it and launched the program. No error msgs as of yet, keeping fingers crossed. On the bottom of the program window it now says Status: Connected to SQLite database named fpdb.db3 on localhost.

I guess its fine to use SQlite instead of prostgress anyway.

Thanks so much for the help
SQLite is lightening fast importing, but the HUD will slow down when you get a bunch* of hands in the db. We see how to fix this and probably will in the next few days.

* I'm not sure how many a bunch is. But using SQLite will certainly be able to give you an idea about whether fpdb is for you.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
02-27-2010 , 01:32 AM
just grabbed a copy of this off sourceforge. looks excellent so far!

are any of these in dev already?

auto update (for fpdb itself)
ev line in stats graph
graph export to jpg (right click -> save as)
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
02-27-2010 , 03:04 AM
sry im such a noob but i cant find the folders to auto import
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
02-27-2010 , 03:38 AM
Quote:
Originally Posted by gazarsgo
are any of these in dev already?

auto update (for fpdb itself)
This isn't being developed, and i'd consider it unlikely. fwiw at least one dev besides myself think we should avoid connecting to the net using fpdb. I'd be very wary of a tracker that did.
Quote:
Originally Posted by gazarsgo
ev line in stats graph
On the list. There is a python library - pypoker-eval, built on poker-eval (http://pokersource.****************/) but there doesn't appear to be a supported version
Quote:
Originally Posted by gazarsgo
graph export to jpg (right click -> save as)
The export button on the grapher already exports to .png format rather than jpeg.

Quote:
Originally Posted by phil0pp
sry im such a noob but i cant find the folders to auto import
You may need to make sure that the poker client is actually exporting hand histories - neither Stars or FTP has this enables by default.

Sorrow
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
02-27-2010 , 04:25 PM
Somehow (I have no idea) my fpdb is now trying to use sqlite instead of mysql. Do I just move the highlighted text from one to the other in the config?


<supported_databases>
<!-- <database db_name="fpdb" db_server="mysql" db_ip="localhost" db_user="fpdb" db_pass="XXXXXXXXX"></database> -->
<database db_ip="localhost" db_name="fpdb.db3" db_pass="fpdb" db_server="sqlite" db_user="fpdb"/>
</supported_databases>

Last edited by _dave_; 02-27-2010 at 06:29 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
02-27-2010 , 06:14 PM
Quote:
Originally Posted by Banzai
Somehow (I have no idea) my fpdb is now trying to use sqlite instead of mysql. Do I just move the highlighted text from one to the other in the config?


<supported_databases>
<!-- <database db_name="fpdb" db_server="mysql" db_ip="localhost" db_user="fpdb" db_pass="XXXXXXXXX"></database> -->
<database db_ip="localhost" db_name="fpdb.db3" db_pass="fpdb" db_server="sqlite" db_user="fpdb"/>
</supported_databases>
see new highlighting above

Last edited by _dave_; 02-27-2010 at 06:29 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
02-28-2010 , 02:29 AM
To update to the new snapshot, you just edit the new config file?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
02-28-2010 , 03:19 AM
i cant find how to export on either stars or tilt lol sry guys
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
02-28-2010 , 06:57 AM
nvm up and running i love it thx guys ur awesome!
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
02-28-2010 , 12:00 PM
I installed FPDB a few days ago. great software. However I would like to know the exact meaning of all the statistics that appear at the "player stats (tabulated view)". Likewise I would like to know the formula adopted to work out these stats. can anybody tell me where I can find this information?
thanks in advance
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
02-28-2010 , 01:11 PM
Quote:
Originally Posted by padre_maronno
I installed FPDB a few days ago. great software. However I would like to know the exact meaning of all the statistics that appear at the "player stats (tabulated view)". Likewise I would like to know the formula adopted to work out these stats. can anybody tell me where I can find this information?
thanks in advance
Hds = Total hands you are dealt in

VPIP = Hands you "Voluntarily Put Money In Pot" blinds not included

PFR = Preflop raise (% of time you raise preflop)

PF3 = How many times YOU make it three bets preflop

Steals = When you are the first person in the pot, on the button and raise (stealing blinds)

SawF = You saw the flop vs hands dealt in

SawSD = Saw showdown. If you bet and win the pot without a call, it does NOT include that as a showdown

WtSDwsF = Went to showdown when saw flop

W$SDwsf = Won money at showdown when saw flop

FlAFq = % of time you bet/raise after seeing flop (flop aggression)

TuAFq = % of time you bet/raise after seeing Turn (turn aggression)

RvAFq = % of time you bet/raise after seeing River (river aggression)

Net($) = Money won (assuming you win ) Green is win, Red is Loss

bb/100 = how many big blinds you win or lose per 100 hands

Rake = How much rake you paid when winning a pot

bbxr/100 = (a wasted stat IMHO) how many big blinds per 100 hands if you didn't pay rake (but we HAVE to pay rake! )

Variance = Don't know how they compute it, but the lower the figure, the better your play

In the "Hand breakdown" section there is also...

SawF = Saw Flop, % of time vs dealt hands

SawSD = Saw showdown, % of time vs saw flop

This will get you a general idea of what each column represents without getting into the formulas specifically (which may or may not be accurate )

Dog

Last edited by 1meandog4u; 02-28-2010 at 01:21 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
02-28-2010 , 03:32 PM
Quote:
Originally Posted by Joseph Hewes
To update to the new snapshot, you just edit the new config file?
All the recent snapshots have had corrections in the hand importing/stats, so you probably need to reimport your hand histories. I don't remember if the most recent snap required changes to the config--you could try it with the old config and see if it is happy.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
02-28-2010 , 03:47 PM
i donked around at 5nl to try it out, the graphs r way off i only made like 6 bux
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
02-28-2010 , 06:17 PM
Quote:
Originally Posted by 1meandog4u
Hds = Total hands you are dealt in

VPIP = Hands you "Voluntarily Put Money In Pot" blinds not included

PFR = Preflop raise (% of time you raise preflop)

PF3 = How many times YOU make it three bets preflop

Steals = When you are the first person in the pot, on the button and raise (stealing blinds)

SawF = You saw the flop vs hands dealt in

SawSD = Saw showdown. If you bet and win the pot without a call, it does NOT include that as a showdown

WtSDwsF = Went to showdown when saw flop

W$SDwsf = Won money at showdown when saw flop

FlAFq = % of time you bet/raise after seeing flop (flop aggression)

TuAFq = % of time you bet/raise after seeing Turn (turn aggression)

RvAFq = % of time you bet/raise after seeing River (river aggression)

Net($) = Money won (assuming you win ) Green is win, Red is Loss

bb/100 = how many big blinds you win or lose per 100 hands

Rake = How much rake you paid when winning a pot

bbxr/100 = (a wasted stat IMHO) how many big blinds per 100 hands if you didn't pay rake (but we HAVE to pay rake! )

Variance = Don't know how they compute it, but the lower the figure, the better your play

In the "Hand breakdown" section there is also...

SawF = Saw Flop, % of time vs dealt hands

SawSD = Saw showdown, % of time vs saw flop

This will get you a general idea of what each column represents without getting into the formulas specifically (which may or may not be accurate )

Dog
I just pasted this into the abbreviations page of the wiki. The previous page was wrong in a few spots.

Re variance: Variance is a measure of your swinginess. A player who plays a lot of big pots will have a big variance. Micro limit holdem players will have a big variance because you are playing lots of multiway pots.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
03-01-2010 , 01:19 AM
Quote:
Originally Posted by phil0pp
i donked around at 5nl to try it out, the graphs r way off i only made like 6 bux
FYI - we know the non-showdown and showdown winnings are wrong in a few spots, but the green profit graph line should be correct.

There is also an entry for variance on the FAQ page of the wiki.

Sorrow
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
03-01-2010 , 01:36 AM
I cant even get this running...I DLed it, have it in a folder on my desktop and everytime I click the run_fpdb thing it just shows a black box with some commands for a sec and then nothing...

I am such a computer noob but I should be able to follow instructions, can anyone help...
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
03-01-2010 , 01:39 AM
can we stick those definitions in as tooltips to the columns?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
03-01-2010 , 02:54 AM
Quote:
Originally Posted by creeboymg
I cant even get this running...I DLed it, have it in a folder on my desktop and everytime I click the run_fpdb thing it just shows a black box with some commands for a sec and then nothing...

I am such a computer noob but I should be able to follow instructions, can anyone help...
Do you have a database set up? Mysql or sqlLite or postgres?

That's the first step. Have you edited hud_config.xml.example to include the database password? And the directory of your hand histories? Or, the site you are playing on? Then once configured, save as hud_config.xml

These are some of the starting points you first have to check out. This is just to point out that this IS in development and therefore some computer knowledge is helpful since you have to be able to edit config files and understand how to set up a database to store the information. I'm not sure how user friendly the latest snapshot is, or how much of it self installs. One of the developers will jump in soon I'm sure.

You might want to post the following in order for them to help you more than I can...

Information needed:

What operating system are you using? (Vista, Mac or XP, Windows 7 etc)

What site are you playing on?

Do you know the directory your Hand Histories are stored in?

If you know how, have you edited your config file?

What snapshot (program file) did you download to do the installation? (example: fpdb-0.12-20100122.tar.gz)

By answering this post with that information, they can better help you with your installation.

Dog

Last edited by 1meandog4u; 03-01-2010 at 03:03 AM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
03-01-2010 , 10:20 AM
i have a hand history that refuses to import. after i select the HH file in the bulk import and click import nothing happens and nothing informative is written to any of the logs. just says it gets the global lock and prepare import goes through and then nada. how can I further troubleshoot this? i have other HH of similar size same stakes same table name etc that import just fine...
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
03-01-2010 , 11:49 AM
Is there way way that FPDB only imports Razz hands while Holdem hands are still imported by HEM?
How can I run both programs at trhe same time?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
03-01-2010 , 12:09 PM
Quote:
Originally Posted by HPR1978
Is there way way that FPDB only imports Razz hands while Holdem hands are still imported by HEM?
How can I run both programs at trhe same time?
fpdb will import (or at least try) any HH that it sees. Are you getting errors because fpdb and HEM are trying to access the same file at the same time? Otherwise, you could just let fpdb import the holdem hands and ignore them. The extra hands will cause a small slowdown in fpdb.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
03-01-2010 , 01:37 PM
HTML Code:
<hud_ui 

	aggregate_hero_ring_game_stats="False"
	aggregate_hero_tourney_stats="False"
	aggregate_ring_game_stats="True" 
	aggregate_tourney_stats="True" 
	aggregation_level_multiplier="1" 
	hero_aggregation_level_multiplier="1" 
	hero_stat_days="7" 
	hero_stat_range="T" 
	label="FPDB Menu - Right-click Left-Drag to Move" 
	stat_days="60" 
	stat_range="A"/>
This is the hud section of my config file. It has worked fine. I made NO changes to it, here's what happened. I had no NL hands in the database. I needed to do some graphic work on tables, so I went to .01/.02 NL game. I ended up with 300+ hands in the database. So far, so good. Later that night, decided to do some more work. Now, the hud only showed the current session stats for ALL the players, including me.

So, left the game, did a Player Stats report, and all the hands are in the database. Went back to the config file and changed the "T" to "A" for hero, to get all stats. Nope, only showed current. Even rebooted the whole computer to make sure nothing was in memory. I opened it this morning, playing 10 hands. I got the stats from yesterday afternoon, not from the early morning

I've even double checked the Player stats and everything is there. The config file is right, but it's ignoring some of the hands in the hud, but they ARE in the database. Got any ideas?

One other question: Could you define "current session" the "S" for me. Do they reset every time I close fpdb? That day? What is a current session. Thanks

Dog

Last edited by 1meandog4u; 03-01-2010 at 01:52 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
03-01-2010 , 01:51 PM
Quote:
Originally Posted by 1meandog4u
HTML Code:
<hud_ui 

    aggregate_hero_ring_game_stats="False"
    aggregate_hero_tourney_stats="False"
    aggregate_ring_game_stats="True" 
    aggregate_tourney_stats="True" 
    aggregation_level_multiplier="1" 
    hero_aggregation_level_multiplier="1" 
    hero_stat_days="7" 
    hero_stat_range="T" 
    label="FPDB Menu - Right-click Left-Drag to Move" 
    stat_days="60" 
    stat_range="A"/>
This is the hud section of my config file. It has worked fine. I made NO changes to it, here's what happened. I had no NL hands in the database. I needed to do some graphic work on tables, so I went to .01/.02 NL game. I ended up with 300+ hands in the database. So far, so good. Later that night, decided to do some more work. Now, the hud only showed the current session stats for ALL the players, including me.

So, left the game, did a Player Stats report, and all the hands are in the database. Went back to the config file and changed the "T" to "A" for hero, to get all stats. Nope, only showed current. Even rebooted the whole computer to make sure nothing was in memory. I opened it this morning, playing 10 hands. I got the stats from yesterday afternoon, not from the early morning

I've even double checked the Player stats and everything is there. The config file is right, but it's ignoring some of the hands in the hud, but they ARE in the database. Got any ideas?

Dog
Hi Dog--

I have not even looked at the aggregation code, so you know about it as much as I do. One thing you might try is to rebuild your HudCache (a function in the Database menu). This took me 2 min on a 200k hand db.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
03-01-2010 , 02:33 PM
Quote:
Originally Posted by Eratosthenes
see new highlighting above
Thanks, works like a dream again now.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
03-01-2010 , 02:34 PM
Quote:
Originally Posted by Eratosthenes
Hi Dog--

I have not even looked at the aggregation code, so you know about it as much as I do. One thing you might try is to rebuild your HudCache (a function in the Database menu). This took me 2 min on a 200k hand db.
That did it. I rebuilt the Hud Cache (1 min), and also rebuilt the DB Index (5 min). Not sure which did the trick, but it cleared it all up. If you know, can you or any other developer, tell me what "S", current session, is defined as? The day? Only that session the fpdb is opened? Does "session" restart once you close fpdb, then reopen it? Thanks

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote

      
m