Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Baseball Statistics Expand / Collapse
Author
Message
Posted Friday, January 19, 2007 12:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 25, 2007 3:01 PM
Points: 3, Visits: 1
Does anybody have an Access database, or SQL Server database that has been created to house baseball statistics ?
Post #338319
Posted Monday, January 22, 2007 8:00 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Post #338680
Posted Thursday, January 25, 2007 11:40 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:46 PM
Points: 1,045, Visits: 2,725

Ed,

I'm interested in this too - I have thought about writing a web or CE app that would keep track of baseball stats.  Let me know if you have found anthing like this.

Tim





Tim Mitchell, SQL Server MVP
Independent Business Intelligence Consultant
www.TimMitchell.net
@Tim_Mitchell

Post #339869
Posted Thursday, January 25, 2007 3:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 25, 2007 3:01 PM
Points: 3, Visits: 1

Hey Tim,

Since I have not received any responses to this threat, I have started building it myself. I have downloaded a statistics database from on of the free ones available on the web, and turned it in to a database that fits my needs.

Im currently creating the output reports to automatically generate a web-report (Web-Page). as soon as I am happy with that, I will begin creating the web access portion to allow me to 'crud' data to my database.

At this point I am doing it with SQL Server, and visual studio, but I have been given some really good examples for MySQL, and PHP.

Stay tuned, I would be glad to share it with you when I am done.

 

Ed

Post #339932
Posted Thursday, October 28, 2010 9:25 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, September 11, 2014 8:33 AM
Points: 3,313, Visits: 1,984
There is a site out there that has sports databases for baseball, football, basketball and racing.

http://databasesports.com/

also there is a very comprehensive baseball stat database at this site:

http://www.baseball1.com/
Post #1012418
Posted Thursday, October 28, 2010 9:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 4:40 PM
Points: 2,150, Visits: 3,440
Seconded about http://www.baseball1.com/ -- I've used this site frequently. In fact, I use the data from this site to practice my own SQL and development skills. So I can say that I, the baseball nut, am having my fun, and it counts as work!
Post #1012430
Posted Thursday, October 28, 2010 9:49 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:46 PM
Points: 1,045, Visits: 2,725
Good find, thanks for sharing. Have you found the data on this site to be up to date? (That's a question from the baseball fan in me, not necessarily relevant from a technical standpoint )



Tim Mitchell, SQL Server MVP
Independent Business Intelligence Consultant
www.TimMitchell.net
@Tim_Mitchell

Post #1012436
Posted Thursday, October 28, 2010 9:50 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, September 11, 2014 8:33 AM
Points: 3,313, Visits: 1,984
I actually grabbed that one from the other post that you and Steve were all over regarding baseball. I sent that link off to most of my programming buddies. Definately more fun to use that than using AdventureWorks all the time for development testing. Do you know if there are any downloadable databases out there for movies or baseball cards, comic books, etc?
Post #1012437
Posted Thursday, October 28, 2010 10:13 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 4:40 PM
Points: 2,150, Visits: 3,440
Tim Mitchell (10/28/2010)
Good find, thanks for sharing. Have you found the data on this site to be up to date? (That's a question from the baseball fan in me, not necessarily relevant from a technical standpoint )

Sean Lahman does a really good job with keeping it up to date season-by-season, so my guess is that he updates it once a year (during the off-season).

I guess trying to keep up with daily stats during the season would be a bit much!

Have you checked out the baseball discussion thread that we have over here?
Post #1012469
Posted Thursday, April 4, 2013 8:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 4, 2013 8:51 AM
Points: 1, Visits: 0

For those of you that wish to query historical baseball statistics using SQL, take a look at:

http://baseball.rdbhost.com

It contains the Sean Lahman database, and features a web-form for query submission.

Postgres is the backend, not SQL Server, sorry.

David Keeney
Post #1438846
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse