PDA

View Full Version : Postgres Database Documentation?



magooie
07-12-2009, 06:07 AM
Hello,
ich would be very glad if there would be a documentation for the postgres database available. I really do like HoldemManager more than Poker Tracker, but Poker Tracker offers a good documentation of alle the variables used in the database. This makes it vey easy to program some custom aplications in order to use the data Poker Tracker collects. Would it be possible to get something similar for Holdem Manager or is it somewhere available and I just didn't find it?

fozzy71
07-12-2009, 08:09 AM
I don't think this is exactly what you are after, but it may have some of the things you would like to know.

http://208.109.95.123/forum/showthread.php?t=3595

I will forward the thread to the developer for a proper response.

magooie
07-12-2009, 08:19 AM
Thank you, but in fact I need to get the values into my c++ aplication. So I need the queries. I found this one: http://208.109.95.123/forum/showthread.php?t=11051 where the stuff is explained I need, thanks anyway!

Rvg72
07-14-2009, 08:01 PM
Here is a forum that goes over various elements

http://www.holdemmanager.net/forum/forumdisplay.php?f=10

Also check this:

Close down HM and open the holdemmanager.config with notepad and change

&lt;setting name="LogDatabaseCommands">False</setting>

To

&lt;setting name="LogDatabaseCommands">True</setting>

Now run the report and when it finishes look in the logs folder for a file named dbtrace.log and open it with Wordpad and go to the bottom of the file and you will see the query.

SootedNinjas
08-13-2009, 04:48 AM
Here is a forum that goes over various elements

http://www.holdemmanager.net/forum/forumdisplay.php?f=10

Also check this:

Close down HM and open the holdemmanager.config with notepad and change

&lt;setting name="LogDatabaseCommands">False</setting>

To

&lt;setting name="LogDatabaseCommands">True</setting>

Now run the report and when it finishes look in the logs folder for a file named dbtrace.log and open it with Wordpad and go to the bottom of the file and you will see the query.

Edited config setting to true, restarted HEM and run a report. But NO dbtrace.log file created on LOGS folder.

What am I missing here ?

Rvg72
08-13-2009, 04:58 PM
Edited config setting to true, restarted HEM and run a report. But NO dbtrace.log file created on LOGS folder.

What am I missing here ?

check the config file again I guess and make sure you are looking in the right logs folder. It is in the one right off of the holdem manager root folder

SootedNinjas
08-13-2009, 05:00 PM
check the config file again I guess and make sure you are looking in the right logs folder. It is in the one right off of the holdem manager root folder

yes I did that. double check and double check before I posted in the thread. I know I was at the right LOGS file becuase thee were some files updated during my run except there was no dbtrace.log file.

The config file is named holdemmanger.config. right ?

Is there other config settings that is related to this ? Maybe in postgres ?

SootedNinjas
08-14-2009, 06:09 PM
since I am having trouble getting my dbtrace.log to work, I would like to make a request. All I need is to see the SQL Query used to produce this report.

http://img19.imageshack.us/img19/4337/hemw.jpg

I could use this SQL Query and tweak/customize it a little bit to get the results that I wanted to see.

Regards....