New Software: Holdem Manager

[kellogs]

Hi rvg,

man, was I amazed I had to jump over 20 pages to see the end of this. First time I saw 20+ pages I thought ur first post was like an year old so I went to your website for a trial version of this software. Funny thing ... the number of trackers&huds is just getting close to the actual number of pokersites.

Enough sarcasm here are some questions and ideas for you , dev:

1 150 stats seems like crazyness. However .. are those stats hardcoded ? Cause it would be a real + if not.

2 Is there a "recent shodowns" window coded like in the pokersherlock ? another + if you coded one.

3 how do you track ? import HH (PT style) or hook to the chat window (PO sstyle) ?

outtro: probably not gonna pay some extra $$ on just another tracker + hud only because it has the xml style reports. After all, I am not that lazy I can query the damn database myself. Or use navicat or sumthing. Another issue is about supported sites. tilt, party and stars .. the classics. Every f****ing player at those tables uses some kind of tracker. Venture into the big unexplored world censored to the PT user. Even steal PT customers. Needless to say the advantages of importing hh in PT style ... think about xml-ing the whole thing.

Cheers

[Dazarath]

Hey rvg, another question. Are there any plans for adding Omaha support in the future? If so, would it be possible that customers of Hold'em Manager, Tourney Manager, and HM Omaha could access the functionality of all 3 programs straight from HM, rather than having to run 3 separate pieces of software? I never liked the idea that I would have to switch between PTH and PTO if I wanted to play two different games. It seems so much easier to me if all of my hands are stored in a single database, and all of my stats/winnings/etc are accessible from a single piece of software.

[gball]

[ QUOTE ]
With Tourney Manager I was able to force the application to run with "USA" regional settings while still allowing you to do everything else with your default regional settings. I am going to try and do the same here although you will need to be patient because dealing with various regional settings is a pain and I'm not 100% sure how PostgreSQL is going to handle this...

[/ QUOTE ]

Dunno if you already have (and you probably have) tried setting these, and if setting these are even applicable in your app:

System.Threading.Thread.CurrentThread.CurrentCultu re = new System.Globalization.CultureInfo("en-US");
System.Threading.Thread.CurrentThread.CurrentUICul ture = new System.Globalization.CultureInfo("en-US");

As you said your app is multi-threading, so I would guess those need to be set individually for each thread. Anyway, this way you can have your application run in en-US no matter what locale is set in host OS.

[rvg72]

Hi,

[ QUOTE ]
150 stats seems like crazyness. However .. are those stats hardcoded ? Cause it would be a real + if not.

[/ QUOTE ]

Kind of but not really - can't really get into it at the moment but you can create your own stats with limitations and even use those stats in reports and the HUD. And to give you an idea how it got that high, there are about 30 stats just dealing with how preflop raisers handle the street or action following a check. For example, Check-Fold % when OOP on Turn as PFR and Flop CBetter (along with check Raise and Check Call). Do this on every street for OOP and IP and there is a big pile of stats. It may be overkill for a lot of people but it is there if you want it.

[ QUOTE ]
Is there a "recent shodowns" window coded like in the pokersherlock

[/ QUOTE ]

Nothing exactly like that yet but something kind of simlar. Sounds like a good idea though.

[ QUOTE ]
how do you track ?

[/ QUOTE ]

Hand History files. For some sites the HUD may use different techniques if they provide faster or better info but HH is default.

[ QUOTE ]
Another issue is about supported sites. tilt, party and stars

[/ QUOTE ]

It's an interesting point but intially I do need to tackle the mostr popular sites. I am in this for the long haul and I do plan on supporting all the other sites, even the small ones.

[ QUOTE ]
think about xml-ing the whole thing.

[/ QUOTE ]

It is!

[ QUOTE ]
Are there any plans for adding Omaha support in the future?

[/ QUOTE ]

Not at the moment although importing Omaha winnings into the Income tab is something I'll probably do. Adding Omaha is quite a bit more work and I don't understand the game nearly as well as Holdem (did you realize you get 4 cards? Crazy!!!) Anyways, If HM is successful I might add Omaha and try to make it as seemless as possible.

[ QUOTE ]
System.Threading.Thread.CurrentThread.CurrentUICul ture = new System.Globalization.CultureInfo("en-US");

[/ QUOTE ]

Yeah, that's what I do to force the current app (or thread actually as you point out) to use US defaults. I have also found a way to force PostgreSQL to treat dates in US format so I think you're going to be able to use HM with whatever regional settings you want although I'm sure there will be some quirks that need to be ironed out.

Thanks,

rvg

[thejerkface]

Hey rvg,
Do I have to do anything to get in on the beta or can I just go to your site on July 15th and download the program?

[Dazarath]

One more question/suggestion. Awhile back, there was a poster who made a suggestion on indexes for the PT PGSQL database to optimize the order of the rows in certain tables. Will the HM databases be indexed for efficiency? I figure it will, but I thought I'd ask.

[_dave_]

[ QUOTE ]

Will the HM databases be indexed for efficiency?


[/ QUOTE ]

I think it is safe to assume yes, if not then within a few days of the public beta finding it's way to knowlegable PGSQL people (matt42s was it that proposed the clustering etc. springs to mind here) I'm sure RVG will get some optimization feedback [img]/images/graemlins/smile.gif[/img]

[ QUOTE ]

Dave, is there a really good reason why this shouldn't work? I've only been using PostgreSQL for a few months (I'm a SQL Server guy) but it should be ok, right? I wrap everything in transactions which should help as well. Let me know if there are some "gotchas" I need to be aware of!


[/ QUOTE ]

I'm no where near expert enough to know, but IIRC the PT importer is NOT networks safe because it parses all hands then pre-computes all the primary/foreign keys required for the SQL INSERT statements, creating a big list of INSERTS with fixed ID values.

Thus if you have two machines running an import to the same databse, chances are they will compute the same <NEXT ID> for some table, and one or the other INSERT statemest will fail because of duplicate keys.

In the worst case one importer will INSERT INTO game, while the other does an INSERT INTO game_players with the keys matching, resulting in the summary and hand info for a given ID differing, and a borked database. So NEVER run more than one copy of PT across computers.

one solution is to use sub-queries to compute new primary key values in mid SQL statement, and using transactions repeat the query if it fails for any reason. e.g.

<font class="small">Code:</font><hr /><pre>
INSERT INTO game(game_id) VALUES ( ( SELECT game_id FROM game ORDER BY game_id DESC LIMIT 1)+1);
</pre><hr />

^^^^ off the top of my head, may well be erroneous [img]/images/graemlins/smile.gif[/img]

Do that the new game_id is computed upon each execution of the INSERT command, but this likely carries some (quite possibly significant) performance penalty...

As I say, just an example, and I am in no way a PSQL expert.


Again, sooooo looking forward to the 15th [img]/images/graemlins/smile.gif[/img]

dave.

[rvg72]

Hi,

[ QUOTE ]
Do I have to do anything to get in on the beta or can I just go to your site on July 15th and download the program?

[/ QUOTE ]

Just go to the site - it will probably be launched close to midnight PST on the 15th. Want to test as much as possible before I put up the link.

[ QUOTE ]
Will the HM databases be indexed for efficiency?

[/ QUOTE ]

Yes, most tables have at least one index and I've tried different index combinations, different table combinations, normalizing, denormalizing etc to get performance where I want it for even 10 million hand DB's. I'm sure there will be tweaks and the index and even table structure might change between beta launch and official launch based on feedback.

[ QUOTE ]
I'm no where near expert enough to know, but IIRC the PT importer is NOT networks safe because it parses all hands then pre-computes all the primary/foreign keys required for the SQL INSERT statements, creating a big list of INSERTS with fixed ID values.

[/ QUOTE ]

hmm... I think it'll be ok. I use a thing called a "serial" value in Postgres which is like an auto increment in SQL Server. As long as it behaves in close to the same way then there really should not be any problems.

[ QUOTE ]

Are there plans for Bodog tournament support?

[/ QUOTE ]

I plan on implementing full support for each site as I add it so that would include tourney and cash, limit / NL and PL. However, the fact that PT does Bodog cash and not tourney makes me think that there is probably a good reason for this. I'll have to tackle that when I get to it.

Thanks,

rvg

[Amerzel]

[ QUOTE ]

[ QUOTE ]

Are there plans for Bodog tournament support?

[/ QUOTE ]

I plan on implementing full support for each site as I add it so that would include tourney and cash, limit / NL and PL. However, the fact that PT does Bodog cash and not tourney makes me think that there is probably a good reason for this. I'll have to tackle that when I get to it.

[/ QUOTE ]

Which was why I asked if you needed any tournament/sng hand histories to compare. I've scanned through some and they don't appear to be much different than Stars or Full Tilt. All the relevant information seems to be there.

Thanks,
Amerzel

[dtan05]

how many hands can this import at a time?? will this work with spadeeye, and sixthsense?