Saberizing a Mac: Installing the Baseball Databank Database

Well, crew, I think we tackled the question raised in Part One pretty well.  To summarize, here's how to get the necessary free software onto your Mac in order to work with databases:

  1. Download MAMP and install it.
  2. Download Sequel Pro and install it.
  3. Open MAMP and make sure the servers start.
  4. Open Sequel Pro.
  5. Type the login information from the web page opened by MAMP into the login screen of Sequel Pro, including the hostname, user, password, port and socket directory link.
  6. Admire your tech geek skills.

If you want to know some specifics about the programs you just installed, here you go: MAMP is actually three things -- a server, a MySQL database program, and a web-based interface all rolled into one (Mac-Apache-MySql-PHP).  Sequel Pro is also different user-interface, but one that's a stand-alone application instead of a web interface, and has a Mac-style look to it (which is important to keeping up the image of Mac superiority.)  Feel free to ask further questions in the comments and hopefully the pros will answer them.

The Next Step

Anyway, with our software ready to go, the next step is to grab some data.  Let's start with the Baseball Databank, located here.  The baseball databank has a lot of basic stats and biographical information.  Colin's already written about how to get that going on a PC, and I'm guessing the steps are similar on a Mac.  But feel free to share your successes and failures in the comments below.

To help give you some idea of where we're head after this, I was thinking of tackling some SQL coding basic using the examples Colin's already written about, letting people play around with creating some new queries for interesting projects and sharing them, then looking at getting a retrosheet database or a pitch f/x database up and running.  (Note: due to size, informat format, and updating issues, being able to start using those databases productively will likely be much more complex than the BDB.)

X
Log In Sign Up

forgot?
Log In Sign Up

Please choose a new SB Nation username and password

As part of the new SB Nation launch, prior users will need to choose a permanent username, along with a new password.

Your username will be used to login to SB Nation going forward.

I already have a Vox Media account!

Verify Vox Media account

Please login to your Vox Media account. This account will be linked to your previously existing Eater account.

Please choose a new SB Nation username and password

As part of the new SB Nation launch, prior MT authors will need to choose a new username and password.

Your username will be used to login to SB Nation going forward.

Forgot password?

We'll email you a reset link.

If you signed up using a 3rd party account like Facebook or Twitter, please login with it instead.

Forgot password?

Try another email?

Almost done,

By becoming a registered user, you are also agreeing to our Terms and confirming that you have read our Privacy Policy.

Join Beyond the Box Score

You must be a member of Beyond the Box Score to participate.

We have our own Community Guidelines at Beyond the Box Score. You should read them.

Join Beyond the Box Score

You must be a member of Beyond the Box Score to participate.

We have our own Community Guidelines at Beyond the Box Score. You should read them.

Spinner.vc97ec6e

Authenticating

Great!

Choose an available username to complete sign up.

In order to provide our users with a better overall experience, we ask for more information from Facebook when using it to login so that we can learn more about our audience and provide you with the best possible experience. We do not store specific user data and the sharing of it is not required to login with Facebook.

tracking_pixel_9351_tracker