Database queries - PT, PO, PM, PDV?

castlevania · #1 05-03-2007, 06:03 AM

I want to be able to make some pretty complex database queries. Which database manager is best suited for this - Poker Tracker, Poker Office, Poker Manager or Poker Da Vinci?

thanks

castlevania · #2 05-03-2007, 01:45 PM

[ QUOTE ]
I want to be able to make some pretty complex database queries. Which database manager is best suited for this - Poker Tracker, Poker Office, Poker Manager or Poker Da Vinci?

thanks

[/ QUOTE ]

Or what I guess is a better question, is any database manager better suited for complex queries than Poker Tracker?

wildzer0 · #3 05-03-2007, 08:12 PM

Well, the pokertracker DB isn't too great, but most, if not all, prior work has been done with the PT database. They also have a SQL forum on the site so you can get some useful information from there to get you started.

Distillery · #4 05-04-2007, 04:31 AM

I haven no idea how you actually do it, but I've read about a few guys doing those things with the Poker Office database after converting it to MySQL.

Luigi2007 · #5 05-05-2007, 08:12 PM

if you use pokertracker together with postgres database server, you can do this. You can download postgres admin (for free) and just use sql to ask watever you want.

Dazarath · #6 05-06-2007, 05:33 AM

[ QUOTE ]
if you use pokertracker together with postgres database server, you can do this. You can download postgres admin (for free) and just use sql to ask watever you want.

[/ QUOTE ]

I think the problem is that you can't actually do whatever you want. For example, Pat says that with the current structure of the database, you can't get a lot of the 3-betting stats that people want using only SQL. I'm not really sure what the OP is looking for exactly, but this might factor into it.