Both mysql and postgres are reasonably heavy-duty database managers. They will perform adequately with many millions of records. One thing we (mostly Steffen, actually) have done is to cache the HUD stats, so that vpip, pfr, etc. are not calculated every time we refresh the HUD, only looked up, which is a fast operation. The other thing we have done is to keep hand history importing/parsing/analysing/storing in a separate program from the HUD. Therefore, the HUD is still responsive even when fpdb is busy importing hand histories.

If you use php you will find python easy to learn and a pleasure to use. You will probably need to pay some attention to the object oriented python features. You can see how the database is organized by looking at the schema.postgres.sql file in the fpdb distribution. The mysql database layout is exactly the same but the sql that generates the initial tables is embedded in the fpdb_db.py file.

I’ve imported some cash game data in excess of 10,000 hands and the database takes up about 100 Mb. Is this about the same as an equivalent Pokertraker database? This suggests you need 10 Gb for a million hands, which is clearly sustainable.

As well, it seemed to import the hands quite quickly on my somewhat underpowered laptop.

How do you get this to work on vista?
I tried to install it before the installer and failed.
I just tried the it with the installer and still failed.
What am I missing? Are there any vista users out there that have it up and running?

Just released alpha6 with a couple of important improvements:
- The HUD now works with just the required library present (people for whom the HUD didn't load - this may have fixed it)
- The error messages are now saved into the file immediately, rather than being buffered and thereby often remaining invisible until one quits the program

Gonna respond to some posts now
Cheers, Steffen

That's larger than I had expected, but I don't see a problem with it tbh. It would be interesting to know how large an equiv PT/HM db is though.

How did it fail?

I tried last night with vista and failed as well. I got to the point where it asked for my passwords for sql or something (I am computer ******ed, so please remember this in your answer) it says if I have them on my computer then I need to use the already registered passwords. I don't know if I have them at all so I just used my everyday password.

I dont remember the specifics, but I know it was in discussed in each of those tracker's threads.

The installer didnt fail, but when I try to start the program, a black console pops up and says something for a second and disappears. Then nothing.

Please check for the following two files in the pyfpdb directory, if they contain anything post us the contents:
fpdb-error.log and HUD-error.txt

Also make sure you use the new alpha6

My figure turns out to have been an overestimate; the database is significantly more efficient than I suggested.

I have checked the numbers, and I currently have 17,774 records in the Hands table. This takes up 111,676 Kb (output of “du /var/lib/mysql/”).

Traceback (most recent call last):
File "C:\Users\Joe\Desktop\fpdb-1.0_alpha6_p111\pyfpdb\fpdb.py", line 506, in <module>
me = fpdb()
File "C:\Users\Joe\Desktop\fpdb-1.0_alpha6_p111\pyfpdb\fpdb.py", line 419, in __init__
self.load_default_profile()
File "C:\Users\Joe\Desktop\fpdb-1.0_alpha6_p111\pyfpdb\fpdb.py", line 251, in load_default_profile
self.load_profile(defaultpath)
File "C:\Users\Joe\Desktop\fpdb-1.0_alpha6_p111\pyfpdb\fpdb.py", line 329, in load_profile
self.db.connect(self.settings['db-backend'], self.settings['db-host'], self.settings['db-databaseName'], self.settings['db-user'], self.settings['db-password'])
File "C:\Users\Joe\Desktop\fpdb-1.0_alpha6_p111\pyfpdb\fpdb_db.py", line 40, in connect
self.db=MySQLdb.connect(host = host, user = user, passwd = password, db = database)
File "C:\Python25\lib\site-packages\MySQLdb\__init__.py", line 74, in Connect
return Connection(*args, **kwargs)
File "C:\Python25\lib\site-packages\MySQLdb\connections.py", line 170, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'fpdb'@'localhost' (using password: YES)")

I get to step 33 but when i dbl click fpdb.py i get

python.exe unable to locate component libglib-2.0-0.dll not found

fpdb error log


File "C:\Documents and Settings\j\My Documents\fpdb\pyfpdb\fpdb.py", line 27, in <module>
import gtk
File "C:\Python25\Lib\site-packages\gtk-2.0\gtk\__init__.py", line 38, in <module>
import gobject as _gobject
File "C:\Python25\lib\site-packages\gtk-2.0\gobject\__init__.py", line 30, in <module>
from gobject.constants import *
File "C:\Python25\lib\site-packages\gtk-2.0\gobject\constants.py", line 22, in <module>
from _gobject import type_from_name
ImportError: DLL load failed: The specified module could not be found.



hud error log

HUD_main starting
Using db name = fpdb
Traceback (most recent call last):
File "/work/fpdb/pyfpdb/Hud.py", line 109, in save_layout
self.config.edit_layout(self.table.site, self.table.max, locations = new_layout)
File "/work/fpdb/pyfpdb/Configuration.py", line 235, in edit_layout
layout_node = self.get_layout_node(site_node, max)
File "/work/fpdb/pyfpdb/Configuration.py", line 213, in get_layout_node
if int( layout_node.getAttribute("max") ) == int( layout ):
TypeError: int() argument must be a string or a number, not 'NoneType'

My cheat sheet says that this 1045 error means that the username/password in your default.conf doesn't match with what mysql is looking for.

I don't think this is your problem! I think the installer is not installing mysql properly on Vista. There is a how to install mysql on vista here (that is an 11 page pdf file). I think you should uninstall mysql before trying that. Take note of the username/password you enter during the installation. After you finish the installation you will need to create an fpdb database and give permissions to it.

To make a db, open the mysql client from the start button and give it the password. Then do steps 18-20 in the manual install process. Notice that you are giving it a username (=fpdb in the example) and a password (=minraise) in the example. You need to put that username and password in the default.conf file.


Does anybody have fpdb running on Vista? Did you have to do this stuff?

Also, if you already have PostgreSQL installed because you have HEM or PT3, then you should forget about mysql and use PostgreSQL.

Did you use the installer? In any case, can you check that the gtk bin directory (default: c:\gtk\bin) is in the PATH environment variable?
To do that you need to do sth like: right click on my computer -> properties -> advanced -> environment variables?

Users of the git version and anyone who's interested in more detail on the progress pls go to https://lists.****************/lists/listinfo/fpdb-main to subscribe to the mailing list. You can also view the mailing list archives at http://****************/mailarchive/f...name=fpdb-main

I did it manually without the installer the first time but after getting the errors I went back and used the installer and now it is working. I'm going to test it out on Stars now.

I actually do already have PostgreSQL already installed. What do I need to do to make it work?

I make the tables with pgAdmin I think, is editing the conf file the only other thing you have to do?

Also, where exactly (filepath) do I put the conf file for Vista? I dont have an "Application Data" folder, I have: C:\Users\Joe\AppData

Thanks

is this going to support cake? (are people going to go through the effort of making it work with cake). cake have said they dont want huds/pokertracking programs to be used on their network.

You should only need to create the database, and set the username/password that can create and edit tables on it. Fpdb has a enu option to create or recreate the tables.
C:\Users\Joe\AppData\fpdb\default.conf is the main config file the HUD config file is in the main application directory and should be called HUD_config.xml

To use PostgreSQL change db-backend=2 to 3

I don't think anyone is actively working on this. There isn't anything preventing someone from adding this though.

My error log is still the same. I think I set it up correctly. I made a new Postgre database called fpdb, changed the db-backend to 3 and changed the username and pass. The file is here: C:\Users\Joe\AppData\fpdb

Anything that im missing?

Can you post the new error log please? I don't think we've had any reports of fpdb working on Vista as yet. I don't think any developers are using it either.

You also need to run the schema.postgres.sql using pgadmin, which should be in your start menu in the PostgreSQL folder. Can you also double check the log file pls, it should not be giving a MySQL error if default.conf has db-backend=3

Ok, if you are running fpdb and:

1. you are connected to postgres
2. you have created an empty database

Then you should be able to create the tables by selecting "Create or Recreate Tables" from the Database menu. If this works you should be able to import files. This seems to only work for me, so if you don't get tables you need to:

1. close fpdb
2. open pgadmin--I assume this is what you used to create the fpdb database
3. navigate to the fpdb database
4. open the sql thingie
5. paste the contents of the schema.postgres.sql (from the pyfpdb folder in the fpdb download) file into the sql thingie
6. make darn sure you are working on the fpdb database and not something that has valuable data in it
7. click on the execute icon
8. you should get a success message and should be able to import files in fpdb now

Edit: I have a patch that I am working on right now that will make getting started with postgres a lot easier (I think--you will still have to create a table manually).