_Loki_
11-10-2009, 02:42 PM
** SYSTEM:
XP & PostgreSQL 8.4 UTF8 DB
** BACKGROUND:
I recently moved up from $0.01/$0.02 NLHE to the dizzy heights of $0.02/$0.05 NLHE & so I purged my 1c/2c NLHE hands. I did this to optimise my HUD rather than to save HDD space
** THE PROBLEM:
It's my own fault, but I hadn't realised I would no longer be able to view a graph of my total winnings - I can now only view my winnings at 2c/5c - Idiot !
** MY PROPOSED SOLUTION:
1] Keep my DB as it is & have it as the default DB
2] Create a 2nd DB within the same postgreSQL installation which I will name "FULL INFO". It will store all my NLHE cash games at all stakes levels - I obviously have all the data somewhere. When I want to view my total winnings graphs I can just open this DB
3] Once a month I will update the "FULL INFO" DB from my default DB
4] Once a week back up my HM Archive to a USB flash drive
** QUESTIONS
1] Does my solution make sense ?
2] If so... is it the most efficient ?
3] What is the best way of doing steps 2] & 3] above ?
For example is there a way of automating this - I was thinking that on the first day of every month I would export the previous months HH's from HM Archive folder for that previous month to the "FULL INFO" DB
XP & PostgreSQL 8.4 UTF8 DB
** BACKGROUND:
I recently moved up from $0.01/$0.02 NLHE to the dizzy heights of $0.02/$0.05 NLHE & so I purged my 1c/2c NLHE hands. I did this to optimise my HUD rather than to save HDD space
** THE PROBLEM:
It's my own fault, but I hadn't realised I would no longer be able to view a graph of my total winnings - I can now only view my winnings at 2c/5c - Idiot !
** MY PROPOSED SOLUTION:
1] Keep my DB as it is & have it as the default DB
2] Create a 2nd DB within the same postgreSQL installation which I will name "FULL INFO". It will store all my NLHE cash games at all stakes levels - I obviously have all the data somewhere. When I want to view my total winnings graphs I can just open this DB
3] Once a month I will update the "FULL INFO" DB from my default DB
4] Once a week back up my HM Archive to a USB flash drive
** QUESTIONS
1] Does my solution make sense ?
2] If so... is it the most efficient ?
3] What is the best way of doing steps 2] & 3] above ?
For example is there a way of automating this - I was thinking that on the first day of every month I would export the previous months HH's from HM Archive folder for that previous month to the "FULL INFO" DB