Tuesday, November 4, 2008

Poker database issues

Well I knew it was only a matter of time before I had some database problems with my pokertracker ... Since my Vista install didnt like SQL for some reason (a driver issue), i've been using the Access databases option. In order to manage that risk somewhat I made a separate database for each network that I play on.

However, since blindman asked me the question on how i'm doing, and I couldn't find as many hands as I was expecting to find at the $2/4 and $3/6 levels, I realised that one of my databases has died and taken about 15,000 hands with it. Its my own fault though, as I think the fix to SQL was relatively simple - deleting the problem driver and then letting it reinstall with SQL. Anyways, I really should get around to installing it and converting all my access databases ... maybe tonight.... or maybe not...

As far as play goes, I got in about half an hour, mainly on interpoker and cake on the $2/4 and $3/6 tables. The first 15 minutes went very well with me hitting a few hands and gaining about 20BBs. Then the death fish comes along. A player I had 200 hands against in the database who was running at 70/10/.2/45 with a W$SD of 35% and a -15BB/100. Of course in the 5 or 6 hands I am head to head against him he manages to suck out a gutshot or 2nd pair or trips on the river on every single hand to sink me by 25BBs in a matter of 15 minutes. That put me back basically square for the session. It sux, but it happens.

Current bankroll: $14,000


The blindman said...

I run my Postgresql server on a separate machine (my TV machine as it happens) on my home wireless network. This way I always have access to the main database irrespective of which machine I am playing from..

parttimebonuschaser said...

hmmm thats actually a great idea. if i can dig out an old laptop which would use minimal power and just use it as a database server ... food for thought.

Is there anything tricky to set up if your database is on a separate machine?

The blindman said...

Not really. I use Ubuntu, and setting up Postgresql is actually super simple (easier than windows). Then on the client you just have to give it the IP address, port and password for the server.