SQL Schema

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

SQL Schema

Postby scott1326 » Thu Aug 27, 2009 8:58 pm

Would like to d/l the schema so I can do a stat on Limp/Fold to Raise (does one exist somewhere?), but it locks up on me. Anyone else have this problem?
scott1326
 
Posts: 24
Joined: Tue Dec 16, 2008 3:13 pm

Re: SQL Schema

Postby WhiteRider » Fri Aug 28, 2009 3:59 am

I can see the Database Schema fine - you might need to try another browser - what do you use?

There are a set of limp/fold (etc) stats available for download from the Repository (uploaded by me).
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: SQL Schema

Postby scott1326 » Fri Aug 28, 2009 11:18 am

Your stats were exactly what I was looking for, thank you.

I'm using Firefox 3.5.2. I try to d/l the schema and when it hits about 265KB out of 332, it slows way down, and locks up if I try to read it. If I wait, it will complete the d/l, but the last half of the document is lost. :?
scott1326
 
Posts: 24
Joined: Tue Dec 16, 2008 3:13 pm

Re: SQL Schema

Postby kraada » Fri Aug 28, 2009 11:33 am

That's very odd. PM me your email address and I'll send it to you directly.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: SQL Schema

Postby scott1326 » Fri Aug 28, 2009 4:50 pm

Upgraded to Reader 9.1, works now. Thanks, Kraada, should've remembered to do that earlier.
scott1326
 
Posts: 24
Joined: Tue Dec 16, 2008 3:13 pm

Re: SQL Schema

Postby kraada » Fri Aug 28, 2009 5:09 pm

That works as well :)

I'll make sure to keep that in mind if anybody else has the same symptoms, thanks for following up.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests