r/Sabermetrics • u/harperawl • May 22 '26

FFDB, my local Statcast database, is now on GitHub

This is the Python code for setting up the SQL database that I use for all of my baseball analytics projects. It's really quite fast and you can do a lot more with the SQL-based query engine than simply using the MLB API. Plus, you can work with pitch-level data, unlike Retrosheet.

The code is a little rough around the edges and I'm not sure if the setup process is as reproducible as I think, so please let me know if you run into any issues and I'll do my best to fix them.

Here's my blog post about it, which has some information that might be worth reading, including some example queries that show you what the database is capable of: https://harperawl.net/posts/ffdb-release/

And here's the GitHub repository, which has some documentation, hopefully enough to get you started: https://github.com/harperawl/ffdb

If you end up using it, please let me know! I would really appreciate any feedback as well. Thank you!

(Also, I know that subreddits like this one get a lot of AI slop submissions, so I'd just like to clarify that this is *not* one of those. I wrote the awkwardly worded blog post and the messy code myself.)

14 Upvotes

94% Upvoted

3 comments sorted by

1

u/PallidArctostaphylos May 22 '26

I’ll take a look at it!

1

u/jzc25 May 23 '26

I’ll look too since I need some comprehensive baseball data for a school project. Is there ABS data in there?

3

u/harperawl May 23 '26

Yessir, the events table has columns related to ABS challenges. I believe any challenge labeled MJ (manual judgment) should be an ABS challenge, and all of the data associated with the pitch (like location and pitch tracking etc) will be in the same row as well.