SQL queries etc

Guy McSucker · #1 05-30-2007, 08:31 AM

As you may know from some other threads, I am messing around with some SQL queries on my PokerTracker db to try to find useful bits of information.

I don't especially want to clutter up this or any other forum with code, because it's pretty much off topic, but it seems to me that getting together to create some queries and analyse the data might be useful and interesting.

So if anyone is interested in doing this away from the 2+2 forum, and of course posting interesting discoveries here, please let me know either by responding here or by PM. Suggestions as to how we might communicate could be a good thing, too.

Guy.

Tech note for geeks: I'm using the postgresql db in pokertracker, so my queries won't work on Access dbs and vice versa. Could become annoying if we share code.

timoK · #2 05-30-2007, 08:40 AM

is there a tutorial how to do queries with access?

Guy McSucker · #3 05-30-2007, 09:03 AM

[ QUOTE ]
is there a tutorial how to do queries with access?

[/ QUOTE ]

Some stuff in the pokertracker SQL forum.

Guy.

yourface · #4 05-30-2007, 09:33 AM

I would be interested in doing this.

I have PMed you my IM and email info.

danzasmack · #5 05-30-2007, 10:12 AM

"Tech note for geeks: I'm using the postgresql db in pokertracker, so my queries won't work on Access dbs and vice versa. Could become annoying if we share code."

How much work is it to convert? My db is like slowwww. guessing there's a tutorial on their site right?

Ricks · #6 05-30-2007, 10:27 AM

Very easy.

Sticky on PT forum.

jba · #7 05-30-2007, 10:31 AM

[ QUOTE ]
"Tech note for geeks: I'm using the postgresql db in pokertracker, so my queries won't work on Access dbs and vice versa. Could become annoying if we share code."

How much work is it to convert? My db is like slowwww. guessing there's a tutorial on their site right?

[/ QUOTE ]

i did it once and it's not a ton of work but it takes forever. like a day.

Hair_of_the_Dog · #8 05-30-2007, 06:34 PM

SQL Server is expensive (very expensive), but much faster.
Can you use MySql with PokerTracker?

00Snitch · #9 05-30-2007, 07:36 PM

I would recomend converting to postgres sooner rather than later. I did it with around 50k hands in my DB and it didn't take long at all. I can't remember exactly, but I think it was under two hours.

As far as custom queries go, I've thought about this, but couldn't really come up with anything that useful that I couldn't get from pokertracker.

example?

Guy McSucker · #10 05-30-2007, 07:40 PM

[ QUOTE ]

Can you use MySql with PokerTracker?

[/ QUOTE ]

Not yet. It's coming, I understand.

Guy.