PDA

View Full Version : HEM Database schema



astralcreep
02-05-2009, 08:58 AM
Hi,

I was just wondering is there is a document which describes the holdem manager database schema. Something similar to the PT3 schema document (http://www.pokertracker.com/products/PT3/docs/PokerTracker3_PostgreSQL_Database_Schema.pdf).

Are there any other resources that would be useful for understanding the schema structure?

Cheers,

A

Al1
02-05-2009, 01:41 PM
Escalated to Roy (Programmer), he will answer asap.

Rvg72
02-08-2009, 02:43 AM
Hi, we don't currently have a document like this that is publicly available however in the Reports forum there is a lot of discussion about various tables and columns and for some of the main tables some details on the various values

Roy

Suiteng
10-21-2012, 07:03 AM
Hi, we don't currently have a document like this that is publicly available however in the Reports forum there is a lot of discussion about various tables and columns and for some of the main tables some details on the various values

Roy

i can not find the reports forum, could you please give me a link to the discussion threads you mentioned before?

fozzy71
10-21-2012, 08:04 PM
The old sub-forums were all merged to this forum and all of the old stickied threads were lost as a result. I recreated one of the stickies here - http://forums.holdemmanager.com/manager-general/333792-formulas-every-hm1-stat-updated-nov-12-2009-a.html

If you need further info you will need to search this main forum for it. With HM1 you can enable logging in PSQL and use the logs to better understand the schema but we do not have a documented schema. HM2 will soon have an exposed API via the HM Query Language that third party developers can use to access the HM2 database but that is a ways off yet.

Suiteng
10-22-2012, 05:46 PM
hi im currently working with HM2 database, are there similiar formulas for HM2 stat? the one for HM1 was very useful.

fozzy71
10-22-2012, 07:18 PM
hi im currently working with HM2 database, are there similiar formulas for HM2 stat? the one for HM1 was very useful.

There are not similar stats available yet for the HM2 database. In our next release we will begin to implement the new HMQL (Holdem Manager Query Language) for third party developers to get the information they need but it will take some time for us to write the FAQ with the associated HMQL code that you will need to access the information and expand on the features of the initial HMQL release.

fozzy71
10-25-2012, 02:13 PM
More info in this thread/post - http://forums.holdemmanager.com/feature-requests-feedback/104781-custom-stats-hud.html#post1509441