Search the web
Sign In
New User? Sign Up
baseball-databank · Baseball Databank
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Best of Y! Groups

   Check them out and nominate your group.
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.

Messages

  Messages Help
Advanced
List Newbie   Message List  
Reply | Forward Message #3053 of 3880 |
Re: [baseball-databank] data format (to List Newbie)

--- "Dereck L. Dietz" <dietzdl@...> wrote:
> I'm new to this list and was just curious as to what software people
> use to store their baseball data and how extensive of systems are
used.
>
> I'm personally keeping basball stats for a baseball game I've been
> playing since 1994 - at least for now.

Software and format must depend on the nature of the data, of course.
You generate, en masse, alternative values for records and fields in
the baseball-databank tables. Others will have natural data for
alternative leagues such as Japanese majors and local softball.
Consider also supplementary fields of mlb playing data (Chuck Rosciam
of catchers encyclopedia mentioned here or to SABR-L this year) and
supplementary records for new mlb persons such as general managers.

For correcting, extending, and annotating the data in current bb-db
records, I use a private copy of the bb-db table itself; recently, from
the MS Access release by Sean Lahman. I add at least an 'edit' field
to each table first time I modify it and if the edit field is null that
means I have not modified the record.
The meaning of the edit field is sometimes false because of maintainer
error, but you probably get the idea.

Using MS Access, the edit field can be dragged (in the display) to a
convenient location. Eg, this weekend I displayed the edit field
beside the debut field while correcting some debut dates (eleven from
1871-1875, reported to Sean Forman merely numerous hours ago).

Paul Wendt

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com



Mon May 15, 2006 2:01 pm

pgw02472
Offline Offline
Send Email Send Email

Forward
Message #3053 of 3880 |
Expand Messages Author Sort by Date

Hi, I'm new to this list and was just curious as to what software people use to store their baseball data and how extensive of systems are used. I'm personally...
Dereck L. Dietz
dldietz2001
Online Now Send Email
May 15, 2006
8:46 am

... used. ... Software and format must depend on the nature of the data, of course. You generate, en masse, alternative values for records and fields in the...
Paul Wendt
pgw02472
Offline Send Email
May 15, 2006
2:01 pm

I was actually wondering what type of database software was generally being used. For instance if MS Access was prevalent or if something more robust was...
Dereck L. Dietz
dldietz2001
Online Now Send Email
May 15, 2006
9:20 pm

I've always used MS Access to work with this database, but I believe there are others who use, as you put it, 'something more robust', although I'm not sure...
KJOK
kjokbaseball
Offline Send Email
May 15, 2006
10:02 pm

I use mysql. I've got little experience with MS Access, so I can't make a comparison, but I've never had any problems with mysql. -John ... I use mysql. I've...
John Walsh
walshj58
Offline Send Email
May 16, 2006
1:20 pm

... I use MySQL. It lets work on FreeBSD, Linux, Mac OS X, and even carry my database around on my Sharp Zaurus (PDA). One sub-project I'm working on is...
Michael Westbay
westbaystars
Offline Send Email
May 16, 2006
11:52 pm

... I use Paradox 9. Steve...
Steve Grant
ace1242
Offline Send Email
May 16, 2006
1:15 pm

Actually I was just curious what other people used and how extensive any systems they built are. I'm personally using an Oracle 9i database with Oracle Forms...
Dereck L. Dietz
dldietz2001
Online Now Send Email
May 17, 2006
3:06 am

... As for systems, I just have the stock BDB right now, but am not really making use of it. I have my own Japanese baseball database that runs my web site....
Michael Westbay
westbaystars
Offline Send Email
May 17, 2006
4:49 am

1 . . . 2 ... generally being used. For instance if MS Access was prevalent or if something more robust was used. << 3 ... any systems they built are. I'm...
Paul Wendt
pgw02472
Offline Send Email
May 20, 2006
12:39 am

I'm not a pro but I'm smart enough and daring enough to suggest that you put a lot of time into thinking seriously about the design of your database, instead...
Dereck L. Dietz
dldietz2001
Online Now Send Email
May 20, 2006
7:30 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help