HUD Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 - Page 351 - Poker Software -- Two Plus Two Poker Forums

Hello, I have a database of about 300,000 hands with a sqlite backend occupying about 2GB disk space. I think that if I had a postgresql backend, it would give me better performance.

Is there a procedure to convert my database from sqlite to postgresql? would something like this work?

As far as I know there is no established procedure, no. What you propose _might_ work, but I would not be super confident. There is some ambiguity with certain data types (notably datetimes, IIRC) and case sensitivity that FPDB might not handle too well if you convert using external tools. Try it and see (maybe with a small test DB at first)?

Quote

07-15-2016 , 04:35 AM

#8752

phil_r

adept

Join Date: Sep 2011 Posts: 797

Quote:

Originally Posted by dark_horse

Similar question! I just started playing on a brand new site (but with a familiar interface) that saves its HH files directly to an SQL .db file. What would be the best way to figure out if FPDB could read the database? I'm able to browse the data in a SQLite browser. So it's in there!

(And funny bit, if you use the string "sql" in a search box here, 2+2 freaks out!)

As with any other site HH format, someone would need to write a specific converter. It might be significantly harder than usual to deal with the setup you describe, given the FPDB infrastructure is predicated on per-table or per-tournament hand history files that it can check for new hands periodically.

Or maybe it would be significantly easier. Hard to tell off the top of my head.

Quote

07-15-2016 , 04:36 AM

#8753

phil_r

adept

Join Date: Sep 2011 Posts: 797

Quote:

Originally Posted by juankyruta

Hello phil,

you've managed to solve the problem importing ipoker hands?

Thanks a lot!

PD: Sorry for my English, I speak spanish. Thanks

Sorry, I've been away for a couple of weeks so no progress. I'll check it out after I unwind a bit.

Quote

07-15-2016 , 04:39 AM

#8754

phil_r

adept

Join Date: Sep 2011 Posts: 797

Quote:

Originally Posted by Pegieton

npolychr it works now, it turned out that I was changing HUD_config.example in installation folder, instead ofHud_config in %appdata% folder.

I have 1 more question.
I would like to see opponents' VPIP and PFR stats from exact seat, but other stats such as 3bet call from all seats. I'd also like to see some stats from "custom" seat range, for example MP1, MP2, MP3 positions only. Is it possible, or I must choose only 1 option for all stats?

As npolychr noted below, I don't think this capability is provided in FPDB right now.

Quote

07-15-2016 , 04:41 AM

#8755

phil_r

adept

Join Date: Sep 2011 Posts: 797

Quote:

Originally Posted by npolychr

Does anybody experience freezing? FPDB keeps freezing itself AND the pokerstars client. Checked the logs but nothing seems to be going wrong.

Very odd. It shouldn't really be possible for FPDB to freeze stars, the only interaction it has is to read the hand histories as far as I know. Maybe it dies with the file handle open and stars is unable to write? I'm stumped.

FPDB overwrites the error logs each time you run it, so if you can check those with an external program (notepad?) you might find something that is being wiped before you look inside FPDB (if that's what you are doing).

Quote

07-15-2016 , 04:43 AM

#8756

phil_r

adept

Join Date: Sep 2011 Posts: 797

Quote:

Originally Posted by sam21

Hi could someone help me please?
Im trying to use the hud for pokerstars, but it only works for Cash game, it doesn't work for Zoom, SnG or tournaments

Zoom is not supported by the HUD. SnG/tournaments should work, though.

Quote

07-15-2016 , 08:06 AM

#8757

sam21

stranger

Join Date: Jul 2016 Posts: 3

Quote:

Originally Posted by phil_r

Zoom is not supported by the HUD. SnG/tournaments should work, though.

Hmm ok. i tried uninstalling and reinstalling everything, but it still doesn't work. Cash game works perfectly, but on SnG and tournaments it doesn't show the hud

Quote

07-16-2016 , 01:18 AM

#8758

phil_r

adept

Join Date: Sep 2011 Posts: 797

Quote:

Originally Posted by sam21

Hmm ok. i tried uninstalling and reinstalling everything, but it still doesn't work. Cash game works perfectly, but on SnG and tournaments it doesn't show the hud

Check for anything that looks relevant in the logs. Help->Log Messages.

Quote

07-16-2016 , 04:04 AM

#8759

phil_r

adept

Join Date: Sep 2011 Posts: 797

Quote:

Originally Posted by phil_r

Sorry, I've been away for a couple of weeks so no progress. I'll check it out after I unwind a bit.

Picked this up again, got it to parse the files you guys sent to me. Unfortunately I also broke parsing of our test suite of old iPoker files. Going to take a break and get back to it tomorrow.

Quote

07-16-2016 , 09:44 AM

#8760

LarsLuzak

stranger

Join Date: Jul 2007 Posts: 14

Hi. I can't get FPDB working. It just doesn't start/run at all. I had it on my old computer and it worked just fine, and the old one was almost exactly the same as the current one - ASUS with Win10. I downloaded and unzipped version 0.40.5 and a few versions of 0.41.0 and nothing works. When I click fpdb.exe nothing happens. I tried to run as Administrator and nothing. I disabled antivirus for a minute to see if that was blocking it, but no. I moved the working version from my old computer to this one and it doesn't run either.

Quote

07-16-2016 , 11:13 PM

#8761

steelchef

newbie

Join Date: Jul 2010 Posts: 43

what is the link without the asterick to download this program?

Quote

07-17-2016 , 05:01 AM

#8762

4dAnook

newbie

Join Date: Jun 2012 Posts: 19

I noticed this software on a you tube video I was watching. I googled fpdb and it took me to fpdb wikidot site. I proceeded to download the postgreSQL for windows and my anti virus detected a trojan virus. Could someone take the time to walk me through this safely? It would be so awesome to get it set up for Bovada 6 max cash and zone. Thank you.

Quote

07-17-2016 , 09:14 AM

#8763

phil_r

adept

Join Date: Sep 2011 Posts: 797

Quote:

Originally Posted by LarsLuzak

My first guess is that somewhere along the way you have ended up with a corrupted config/database that is crashing FPDB on start. Check if %appdata%\fpdb exists and rename or delete it, then try again.

If that fails have a look at the things in %appdata%\fpdb\log and see if you can find anything that might help me figure it out.

Quote

07-17-2016 , 09:17 AM

#8764

phil_r

adept

Join Date: Sep 2011 Posts: 797

Quote:

Originally Posted by steelchef

what is the link without the asterick to download this program?

The last 'official release' if you like, that is asterisked out, can be found at fpdb.sf.net somewhere.

However I've put out some more recent releases at https://github.com/philroberts/FPDB-for-OSX/releases which are more up to date.

Quote

07-17-2016 , 09:21 AM

#8765

phil_r

adept

Join Date: Sep 2011 Posts: 797

Quote:

Originally Posted by 4dAnook

Before you invest more time, you should be aware that FPDB can't do HUD on Bovada (as it needs the hand history for live HUD, and Bovada doesn't work that way).

If you just want stats/session review, try one of my releases at https://github.com/philroberts/FPDB-for-OSX/releases - just unzip and run, no installing of things needed.

Of course, you have only my word (and the lack of outraged victims ITT) that there is nothing malicious in the program.

Quote

07-17-2016 , 03:20 PM

#8766

sam21

stranger

Join Date: Jul 2016 Posts: 3

Quote:

Originally Posted by phil_r

Check for anything that looks relevant in the logs. Help->Log Messages.

I hope this helps
hud - error - hud creation: table x not found, skipping
hud - debug - newhud: winTables window not found
hud - error- error: self.window doesn't exist
hud - error- couldn't find table x

Quote

07-17-2016 , 03:38 PM

#8767

LarsLuzak

stranger

Join Date: Jul 2007 Posts: 14

Quote:

Originally Posted by phil_r

I'm confused. There is nothing like that in the fpdb folder. In it there are folders called gfx, include, mpl-data, pyfpdb, pytz, qt5_plugins. Also fpdb.exe, HUD_main.exe and a bunch of stuff .manifest .pyd and .dll and that's all there is.

Quote

07-17-2016 , 08:55 PM

#8768

Bones31271

stranger

Join Date: Mar 2016 Posts: 12

I am having a problem with fpdb resetting my number in brackets it used to be after 5 now it is up to 30 but still resetting back to 0 is there something I need to adjust?

Quote

07-17-2016 , 09:34 PM

#8769

phil_r

adept

Join Date: Sep 2011 Posts: 797

Quote:

Originally Posted by Bones31271

I am having a problem with fpdb resetting my number in brackets it used to be after 5 now it is up to 30 but still resetting back to 0 is there something I need to adjust?

Are you playing a tournament? By default FPDB will only show stats from the current blind level, so when the blinds change it will reset (the first time you use it).

Quote

07-17-2016 , 09:35 PM

#8770

phil_r

adept

Join Date: Sep 2011 Posts: 797

Quote:

Originally Posted by LarsLuzak

Type %appdata% into the location box of windows explorer.

Quote

07-17-2016 , 09:36 PM

#8771

phil_r

adept

Join Date: Sep 2011 Posts: 797

Quote:

Originally Posted by sam21

I guess there's no table called 'x', then. Maybe something changed with the stars table names/HH. Haven't heard anyone else with this problem, though...

Quote

07-17-2016 , 09:57 PM

#8772

Bones31271

stranger

Join Date: Mar 2016 Posts: 12

Quote:

Originally Posted by phil_r

Are you playing a tournament? By default FPDB will only show stats from the current blind level, so when the blinds change it will reset (the first time you use it).

ooooooh ok well that might just be it then, I will keep monitoring and let you know if it rights itself, thnx for the response Phil

Quote

07-17-2016 , 09:58 PM

#8773

Bones31271

stranger

Join Date: Mar 2016 Posts: 12

now is there a way to set it so when table opens I dont have to adjust the boxes for fpdb? I have my seat set and they are all close to the respective avatars but still have to move them abit

Quote

07-17-2016 , 10:23 PM

#8774

phil_r

adept

Join Date: Sep 2011 Posts: 797

Quote:

Originally Posted by Bones31271

now is there a way to set it so when table opens I dont have to adjust the boxes for fpdb? I have my seat set and they are all close to the respective avatars but still have to move them abit

Yup, if you right-click the 'FPDBmenu' anchor you should get a thing, and somewhere on the thing is something like 'save layout'? That should do what it says.

Quote

07-17-2016 , 10:42 PM

#8775

Bones31271

stranger

Join Date: Mar 2016 Posts: 12

Quote:

Originally Posted by phil_r

Yup, if you right-click the 'FPDBmenu' anchor you should get a thing, and somewhere on the thing is something like 'save layout'? That should do what it says.

awesome thnx again Phil

one final thing, is there a way to change the M to blinds instead? the whole M has me confused and I dont really understand it sorry for bothering you

Quote

Page 351 of 377

First

151 251 301 331 341 346 347 348 349 350 351 352 353 354 355 356 361 371

Last

Post Reply Subscribe

...

Page 351 of 377

First

151 251 301 331 341 346 347 348 349 350 351 352 353 354 355 356 361 371

Last