Hey guys...I don't know if anyone else noticed this since it's not a huge deal 99% of the time, but for some reason in the 2007 season (most recent in the...
We've longed discussed the idea of an APPEARANCES table, so that it captures exactly what it's supposed to capture, rather than taking over the BATTING table...
Tangotiger
tom@...
Oct 7, 2008 8:28 pm
3607
That's the way I would approach it as well if I were the guy doing the building of the DB...I highly recommend Lahman/Forman work toward that goal. It sounds...
... There are no current plans, that's correct. How/when this will be rectified is undetermined. Tom ... The Book--Playing The Percentages In Baseball ...
Tangotiger
tom@...
Oct 8, 2008 1:59 pm
3609
OK...thanks Tom. I'm going to ask our web coder to McGuyver an appearances table...that's the correct way to normalize the database anyway....
... some of the ... MySQL ... fields are ... range of ... int(4), ... as yearID ... Similarly, ... of ... season (or ... of 0 - ... playing ... been able ... ...
... If the nature of the data is that it is unsigned, it should be stored in an unsigned column. If the nature of your application is that you use the values...
Regarding the tinyint and int and the like issue: I disagree. I'll give you two good reasons: 1. An 8 GB flash drive costs $29. A 500 GB backup drive costs...
Tangotiger
tom@...
Oct 22, 2008 1:20 am
3614
1952 Bud Black for Detroit-- his season IP total should be 7.2 not 8. Daily on microfilm has 7.2 for him and all the other Detroit Ps IPs are OK (seems to me...
I've made good progress on the BDB update for this year and should have something soon. I'm adding an Appearances table with the following schema (this will...
I think we've discussed having an appearance or roster table before, and talked about it as a very good idea.  I'm less clear about the need for the Batting...
... I see this as backwards compatibility. I know that lost of people use the tables as is and historically G has been all games played. This will leave ...
It is usually desirable to go vertically, than horizontally, like so: http://sports.groups.yahoo.com/group/baseball-databank/message/3606 You can create more...
Sean: That schema sounds great to me. Just a quick question - I did some research and searched the Yahoo! group and couldn't find the answer to this. There...
Who is "SABRE", and can you cite their reasoning? Tom ... The Book--Playing The Percentages In Baseball http://www.InsideTheBook.com...
Tangotiger
tom@...
Nov 11, 2008 5:06 pm
3622
I've updated a BDB update today. Here are the release notes. One should consider this a proposed release as I would like lots of review to point out any...
Two hours without comment? I hope that's because we are in shock and not passe over this. Anyway, a huge thanks to Sean for delivering the data. I am going...
Tangotiger
tom@...
Nov 13, 2008 9:57 pm
3624
For some reason, your email came in before Sean's did, otherwise I'd have said: Â YEAH!! ... From: Tangotiger <tom@...> Subject: Re:...
Hey, some of us have jobs! :) When I get home tonight I'll go about importing this into my MySQL setup and driving it around. I'll probably keep the last...
Sean, not sure when I will have time to take a look at the new release, but I wanted to send a big "Thank you!" to you and everyone else that contributes to...
... If anyone has any data they'd like to share, post it here: http://sports.groups.yahoo.com/group/baseball-databank/files/ Tom...
Tangotiger
tom@...
Nov 14, 2008 5:02 am
3628
The pitching.sql table is not showing SH, SF, GIDP. Is this an oversight, or is it correct? Tom...
Tangotiger
tom@...
Nov 14, 2008 5:03 pm
3629
The HOFold table can be dropped. I think carrying the "old" information is fine for one season, for transition reasons. But, at some point, support should...
Tangotiger
tom@...
Nov 14, 2008 5:04 pm
3630
In working with the files, I see that the Appearances file does not have a stintID field. Users should be aware that if they need to JOIN the Fielding table...
Tangotiger
tom@...
Nov 14, 2008 5:04 pm
3631
Please apply these corrections: bdbID correct_RetroID fukumka01 fukuk002 milleji02 millj005 montzlu01 montl002 (I was off by 1 on those guys, because similar...
Tangotiger
tom@...
Nov 14, 2008 8:15 pm
3632
(Message cross-posted to three Yahoo groups.) Attached you will find a file that contains the playerID of all 238 new players from the 2008 season. The...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
