SQL queries etc
 

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.

Re: SQL queries etc
 

is there a tutorial how to do queries with access?

Re: SQL queries etc
 

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

[/ QUOTE ]

Some stuff in the pokertracker SQL forum.

Guy.

Re: SQL queries etc
 

I would be interested in doing this.

I have PMed you my IM and email info.

Re: SQL queries etc
 

"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?

Re: SQL queries etc
 

Very easy.

Sticky on PT forum.

Re: SQL queries etc
 

[ 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.

Re: SQL queries etc
 

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

Re: SQL queries etc
 

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?

Re: SQL queries etc
 

[ QUOTE ]

Can you use MySql with PokerTracker?

[/ QUOTE ]

Not yet. It's coming, I understand.

Guy.