PokerDaVinci January BETA: semi-public release

[Fiddler]

Hey, I like the modern interface. It looks very nice. Two questions:

Can I use the express edition of SQL Server 2005 for this beta?

The "poker knowledge" sounds intriguing. Does it mean that I can query for stuff like: "any hand that I raised pre-flop, was check-raised on the turn and showed down" and "any hand where I was heads-up on flop and check-raised with less than two overcards"?

[mittelhauser]

Fiddler,

I haven't tested it against SQL Express 2005 yet (keep meaning to) but it *should* work. You'll just need to modify some settings in shared.config which I can walk you through if they aren't self-explanatory.

Yes, those are the exact type of queries that the data in the database is designed to support. The front end GUI doesn't make all the queries possible yet but the data is there and the GUI gets more powerful each iteration. You can also create custom queries by modifying the query XML files if you are that sophisticated (and avoid the GUI query builder)...

-Jon

[TheProdigy]

I started installing it and got about 20 errors..I'm not trying to post a report, good or bad, or about anything..this was two days ago or so so I don't remember the exact error...anyways I have been working with computers(web-site designer and programmer for 4 years) for atleast 8 years and am quite computer savvy. If I screw around with something for more than 20 minutes and can't figure it out, then you probably need to work on making it "easier" for the regular customer..this could've just been caused by my computer, but i just un-installed the program after 20 mins or so(I got the launcher etc up, and then tried importing hands and it didn't even start to import)

I might try it when it is out of beta though

[mittelhauser]

*grin* I'd be happy to try to help you with the install errors but that report is a bit vague. [img]/images/graemlins/smile.gif[/img] Seriously, it is a beta so I am not that surprised that some people have problems but I can't fix them unless I am given a hint...

The only known bugs related to install have been on systems which don't have administrator privilage or already have MSSQL installed but I am sure that there could be more. Do either of those describe your setup? Did the install fail during the setup of MSSQL? If you still have a file c:\MSDE2klog.txt it might provide me/you a clue.

For the record, I have had about 500 downloads and only 3 people who have _reported_ installation problems.

-Jon

[sui generis]

Jon,

Great product. I've been posting here hoping other people would make up my mind on whether to use it, but I finally chose to just do it myself. My database is at 250k hands and it took a night to import (~12 hours... but at least 4 hours of those I had other things running, including pokertracker). All in all it wasn't too bad, I've got about a dozen suggestions for you in terms of ways to improve the layout, system performance, and a few other things that kinda irked me that I would like to see fixed. I'll post those eventually on your forums to make life easier.

I'm posting, though, because I encountered a pretty big error. I imported all of the hands and then started up the player analyzer function. It came up, flashed "loading" for a while at the top, then gave me a timeout error. The exact error was something along the lines that the timeout period expired before it could complete the process.

I'm not sure what the error is about, but hopefully you could get back to me. I really think this software could be a huge success given its speed and versatility, so please get back to me about a possible fix.

-eric

[mittelhauser]

Eric,

Yeah one of the things I figured out when I started doing the stress testing was that the default SQL timeout was set too low when you got a decent (100k+) quantity of hands in the DB. This is fixed in the next release but I realize that doesn't do you any good. I'll see if I can pull the January code from version control and do a quick fix and issue an update for you today. None of the other performances fixes would be part of it but at least the queries wouldn't timeout. I'll post here if I am able to (or not, either way)...

-Jon

[HesseJam]

Sounds very very promising, I'll check it out.

Hopefully, you are doing more for NL and SnG players than PT.

For example, PT has a database field to indicate if a player went all-in but it is not used currently. I'd like to see this fact imported. Also, the ability to filter raises by x * buy-ins would be nice. Finally, the analyzer should have the ICM built in.

[mittelhauser]

Eric,

Ok…I think I have a patch for your timeout issue. This hasn't been extensively tested (either the patch itself or the autoupdate mechansim) but I figure you are busted right now so...if we fail with this, you may need to wait for the next update or we may need to take the discussion to email...

I am assuming that you haven’t done any UI customization yourself by modifying the DataViewTree.xml file. If you have, ignore this and let me know (since this would overwrite your changes)…

Try this…

Run the Launcher app and then go to the menu at the top: Help->Check for Updates

Follow the process and when you run the PlayerAnalyzer again, it will hopefully allow your queries to complete. I upped the SQL timeout to 120 seconds. Even without the more optimized DB, this should be enough.

In addition, I threw in some more queries/tables for you.

1) You should now see By Flop->Hole Cards which groups Hole card stats by the flop (e.g. what cards you played that flopped a fullhouse).

2) You’ll also get By Hole->By Position and By Position->Hole Cards…which allow you to see what cards were played in what position (grouped either by card or by position).

Of course, these queries may take a while with 250k hands. [img]/images/graemlins/smile.gif[/img]

Let me know if it works!

-Jon

[mittelhauser]

HesseJam,

My intention is to do more for SNG and NL but you won't see *that* much additional yet. I believe that my biggest advantage is that my architecture/framework is very flexible which makes it easier to add new features like the ones you want. However, I need to get the core stuff rock solid first (as you can see from some of these posts...) [img]/images/graemlins/smile.gif[/img]

I'd love to start a discussion with you about what you'd find most useful. ICM is already on my list but is a bit of a ways down. 2+2 isn't the best place to do that though. Can you either email me or start a *wanted features* post on poker davinci that I can track easier.

BTW, I have promised my earlier beta testers that the ones that contribute the most (bugs, ideas, etc) would get free licenses. The same offer would apply to you...

-Jon

[Twitch1977]

Integrate a Pacific Poker hand grabber and all you have to do is show me where I need to line up to buy this. [img]/images/graemlins/smile.gif[/img]

T