PT2 DB: any way to know if player

Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.

PT2 DB: any way to know if player

Postby MrFlibble » Mon Mar 31, 2008 1:16 pm

I want to make a table summarising player stats. I'm not sure how to keep it current. Regenerating the whole table every often seems a bit crazy. Is there any way to know when a player's stats related data has been changed/added?
I'm thinking using the player_winnings date_played column - am I missing a better way?
MrFlibble
 
Posts: 58
Joined: Sat Mar 08, 2008 7:30 pm
Location: handhq.com for datamined hands

Re: PT2 DB: any way to know if player

Postby ptrack pat » Mon Mar 31, 2008 4:22 pm

I would suggest the session_start date in the SESSIONS table.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: PT2 DB: any way to know if player

Postby MrFlibble » Mon Mar 31, 2008 7:11 pm

Thanks pat.
MrFlibble
 
Posts: 58
Joined: Sat Mar 08, 2008 7:30 pm
Location: handhq.com for datamined hands


Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 1 guest