Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.
by 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
by 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
by 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
Users browsing this forum: No registered users and 1 guest