I am very excited about the prospects for this project so I had to keep trying to get it to work.

Anybody get this to work on vista? I am still having problems with 31. on the installation instructions. I dont think vista has the normal file structure like XP; in vista it seems like there is only an "App Data" folder under C\user\username\App Data. I made the fpdb folder and copied the file but it doesnt seem to work still, a black cmd prompt pops up for a second, a command executes that is too fast to read, then it goes away with nothing else happening.

The ultimate solution an all inclusive installer.

uofi2012 did you try my dirty, quick and redundant way? If you do, don't forget to reboot, edit the password and then copy Application Data to the outer copy of your name.

c'mon c'mon mac support

Your ideas are intriguing to me and I would like to subscribe to your newsletter.

I support open-source software in general, for various reasons (just haven't been able to wean the other people who use my box from Windows), and this project for a few specific ones:

1. I'm new to poker (started playing around 08/22)
2. I don't have $100 for PT/HM, or even $55 for PO (currently grinding out my first BR at Stars)

Anyway. Let me represent the slightly-above-average computer-using-guy (ie. not complaining about long though simple install process) for a second here. I have been able to make a database out of my short career at Stars...up until 09/02.

Every hand history with a date >= 09/02 I try to import gives me this error:
Repeated for each attempted import, with Error No. 2, No. 3, etc.

This thread describes a similar problem with PokerTracker around the same time, ascribing it to Stars changing the HH format. If that address is still good, or if you have a different one you'd rather I use, I have any number of post-09/02 HHs I can send. (Yes, I trust you, and even if I didn't, I'm sure my mediocre play would far outstrip any advantage you might gain from them )

The software update that PokerStars pushed last week broke our hand importer. (It also broke PT's and HEM's importers also.) I have fixed the importer, but we have not pushed it to git or made a new release with the fix yet. I am grinding as hard as I can right now to put out a release that will be usable on PokerStars and Windows.

I look at the PT threads in this forum almost every day. The one thing that I have learned from that is that I need to keep this HUD simple, fast and reliable. I just spent several hours making changes to make the HUD more reliable--those changes will be invisible to the user.

Thanks--but there is no reason to send us one of those histories right now.

postgresql please.

Seconded

3ded

4thed + installer pls

yea, plz make it work with postgres + installer.

I know you are all working on the installer but could you push a git for the importer that fixes the Pokerstars hand history date change. I would like to tinker with program a bit.

A new release of fpdb has been uploaded to sourceforge. I think this is the first release that provides a usable HUD.

You can get it here. Make sure you get the alpha3 version, it might take a little while for the sourceforge mirrors to update. You can always get the up-to-the-minute files in the git tree.

What is in this release:

1. PostgreSQL support in both database and HUD. (MySQL still works.)
2. HUD supports Windows and Linux for all PokerStars cash games.

Installation

The installation instructions for Windows are here. If you are not comfortable doing all that installation, you should wait and there will be better windows installation options very soon.

You need to install 2 additional libraries not yet mentioned in the instructions:
psycopg2 -- get the one for your version of python, probably 2.5
win32gui (needed for Windows only)
On Windows, you need to add python to your path. On my box the python dir is C:\python25.

PostgreSQL

I assume that the people requesting postgres already have it installed and know how to get started with it, so I have not written any instructions on how to install/setup postgres. Before using fpdb with postgres you need to create an empty database. The easiest way to do that is to

1. open pgAdmin
2. double-click on your server
3. right-click on Databases and select new database
4. the database name and user must be the same as in your config files

HUD

HUD How To is here. Right clicking on the HUD table window will allow you to save your HUD layout without having to edit the xml file--and yeah, I'll add that to the How To.

Known Problems:

1. No Full Tilt support in HUD
2. No river stats for stud games
3. hole/board cards are not correctly stored in the db for stud games
4. HORSE (and presumably other mixed games) hand history files not handled correctly
5. HUD stat windows are too big on Windows
6. HUD task bar entries on Windows won't go away
7. Some MTTs won't import (rebuys??)
8. Many STTs won't import
9. MTT/STT not tested in HUD
10. HUD stats not aggregated
11. Player names with non-Latin chars throw warnings in HUD
12. HUD doesn't start when fpdb is started from the Windows "Start Menu"
13. Exiting HUD on Windows doesn't properly clean up stat windows
14. No support for SQLite--this won't happen, parameter quoting is not compatible

HUD to do (in no particular order):

1. fix bugs
2. support other sites as file import support is added
3. mucked cards display
4. hand reviewer
5. integrate the config files
6. configuration of stat windows: colors, opacity, etc.
7. configuration of stat formats: hints, % signs, fonts, etc.
8. dialog for setting up said configuration
9. more stats
10. table stats

nice work!!

oh BTW...is there any possibility to make the HUD a "stand alone" application like eg. RealTime? I play lots of tables so it's more a ressources issue (yeah, I admit my PC isn't the newes...)

Sounds great, I wonder how this will look in a few months from now

Great software, was really waiting for someone to do this. The available ones are the usual paid softs: too many bugs, too performance consuming, slow new features implementation etc. I hope this will be the tracker to put a milestone into the poker world.

PS: Please put support for iPoker Network next in the list!

Just got alpha3 running fine on postgresql. Stars + HUD working. OS is Gentoo Linux fwiw.

One thing I ran into was that the "db-backend" config parameter in ~/.fpdb/default.conf should be set to 3 if you are using PostgreSQL.

Im having this exact problem. Anyone on vista out there?

The HUD is already a stand alone program. The fpdb program just launches it automatically when you start auto importing.

I wrote this HUD to work with different trackers--I have used it with one of the PT3 betas. I have also used it with a Poker Tracker Stud database. There has to be code written to support each tracker, of course. The code for the PT Stud database is actually in the current distribution, but it is broken due to some of the changes I made to integrate with fpdb.

This version of the HUD does not handle cascaded tables, so using it with many tables isn't a great idea. Adding support for cascaded table is doable, but you might run in to the same problems you have with PT3. This combination of fpdb/HUD use fewer computer resources than I expected, so it is useful for older creaky computers.

This gives me a warm feeling. Let us know how it goes.

Yes! You need to set this parameter regardless of Windows or Linux. Sorry I forgot to mention setting this parameter and thanks for posting it here.

Excellent job, just 4-tabled now with a razz, plo, and 2 nlh tables open, with huds on all 4, on my linux box, sweet. Great to see the quick progress you are making.

None of us have Vista.

If you open a command line and type python (and enter), you should get the python interpreter and will see the >>> prompt. Type:
import os (and enter) and then:
os.environ['APPDATA']

That should tell you what dir to put the default.conf file. If this works let us know so we can update the install instructions (which need a lot of updating).

(this post is very long, if you reply pls cut the quote to only contain what you're referring to in your reply to keep the thread legible)

Hi everyone,
Further to the announcement I want to apologise for the extraordinary delay in releasing this version and also explain it. A little bit of this was to allow time for the Windows installation to be improved, and please be assured that it was well worth the wait and should be made public very soon. But most was due to me, in particular:
- One of the hard drives of my main PC died. If you don't do backups do them NOW! Really! Fortunately I am running a RAID1/5 so I should not loose too much, except:
- My root file system has blown itself up (reiserfs, if anyone is interested). I believe this was caused by the 2-3 power cuts PER DAY that my house suffered for a few weeks in combination with the loss of above hard drive. I still am hopeful to be able to repair it, but haven't had time yet (ie. getting this out was higher priority for me than fixing my main PC which should dispell any possible doubts about my commitment to this project)
- My laptop's hard drive also stopped working - fortunately this turned out to be merely a loose connection.
- Finally, my personal life recently took up far more time than usual.

In the process of this we realised that weekly releases are too ambitious in any case and will now endeavour to make a release every 1-2 weeks. If you want updates faster please use the git version (for advanced users only) but note that severe bugs are more likely in that due to much less testing. Again, please remember that we have zero direct benefit from doing this so please be patient if we're a bit late.

For external developers, in particular those that consider to adapt their HUD to work with fpdb (or tracker database' devs who want to adapt the fpdb-HUD to work with their tracker): The database for Holdem, Omaha, Stud and Razz are now near-finalised. I'm hoping not to make any more changes to existing fields, but adding a few more fields will certainly be necessary. Any feedback however is still most welcome!

Oh, and credit where credit is due, this release is mostly the work of Eratosthenes

There are also a few unopened or unactioned emails about fpdb (incl at least two patches, thanks!) that will be integrated into git shortly and then be part of alpha4.

And I want to respond directly to a few posts that have been made in my absence.

Cheers for the history, I'll try to get draw (incl badugi) into one of the next alphas. This will require a whole new set of tables so please bear with us.

Alpha3 should open an error window if the configuration file is missing, please try again with that and it will tell you exactly the path where fpdb wants the file. If you have to create any folder other than "fpdb" itself please let me know as that would mean that Vista needs special treatment for this. If even alpha3 doesn't open a window please check the troubleshooting guide that was posted in this thread earlier, in particular try opening fpdb from the command line and it should give you an error message - once we have that it shouldn't be too difficult.

Fixed in alpha3

Fpdb itself DOES support MacOS X - however, installing the environment/dependencies is a challenge. I will have access to a Mac again in about 2 weeks hopefully, I'll try to get it to work then. In the meantime, if anyone tries and gets anywhere at all I'd really appreciate a description of how you did it. I know that someone did succeed but due to my technical issues have not been able to contact him. A Mac installer is probably a long way away, but I will try my best to at least get fixes to upstream for any bugs making life harder for our users.

Newsletter (and mailing list for development) are on my immediate todo list. In the meantime just watch this thread
As for the import error, you're quite right this was due to a change by Pokerstars. For some reason they felt a need to change the format even though they did not add or remove ANY information. In any case, it's been fixed and the delay in publishing is my bad, apologies.

As already noted this is in alpha3 - if anyone feels like doing some benchmarks on both MySQL and PostgreSQL (ideally with the same history files on the same computer with the same other programs running) it'd be much appreciated and would relieve our time to do actual coding

Further to what was already said, if you have a second PC you can run the database on a different PC than fpdb+HUD. To do that simply edit the host setting in both default.conf and HUD_config.xml from localhost to the IP or hostname of the database PC. I do this over a switched fast ethernet network, due to fpdb's access pattern I suspect performance will be poor if you do it over DSL, Cable (incl Virgin UK's claimed fibre optic service), mobile phone, modem, ISDN or WLAN - but there's only one way to find out. There is much room for performance improvement in fpdb but for now we will probably concentrate on new features, usability and bugfixes. If you do NOT use the HUD (it can be deactiveted in default.conf) you can even run MySQL/PgSQL on one PC, fpdb-import on another, fpdb-tableviewer on a third and the actual poker client on the fourth.

Two more things:
1. Our webpage (like all but sourceforge' biggest projects) will be offline today (16Sep) for approx. 8 hours due to sourceforge' migration. This does not affect downloading or using fpdb.
2. I updated the Gentoo ebuild to use alpha3 (but not for pgsql) in git81 (git-ID: 092f68e), you can get it from http://trac-git.assembla.com/fpdb/br...ild?format=raw
Put it in your local overlay and follow the usual steps to install from that. If you don't know how to do that see http://gentoo-wiki.com/HOWTO_Install..._Party_Ebuilds
Note that those instructions look very long, but you only need to do very little to use a local overlay.

Just wanted to add to this, I've got a bunch of tourney/sng files that produce non-fatal import errors (although most hands are important) and will fix the bug(s) hopefully for alpha4 so until that's in git I won't need anymore - I'll post once those bugs are fixed
If you have import errors in cash games though please do send them my way if you dont mind, the individual hand that caused the error is sufficient (the console output should give the first line of any hand that causes errors so you can find) or if you want you can of course send the full file.

For any other errors also pls post here or contact us by IM, email, PM, .....