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.

soop · #8 07-03-2007, 05:45 PM

Is this really off topic? There have to be enough people here who know SQL and use pokertracker/postgres to make this worthwhile.

I'd love to see some of the interesting queries people have come up with (heads up tournies esp) and also see other people's results for some of my own.

Does something like this exist somewhere else? I checked the poker tracker forum, but that seemed to be for queries that don't work.