Skip to content

SQL scripts for working with the baseball data from retrosheet and baseball-databank, as provided by boxball

Notifications You must be signed in to change notification settings

sdvinay/baseball_sql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

baseball_sql

SQL scripts for working with the baseball data from retrosheet and baseball-databank, as provided by boxball

The boxball images are documented and available at https://github.com/droher/boxball

I have been working with the Postgres cstore_fdw and MySQL images. I have created source directories with scripts specific to each DBMS. The column-based postgres is significantly faster than the MySql (orders of magnitude with some scripts). I recommend using the Postgres rather than MySql.

To get started run the docker command here https://github.com/droher/boxball#postgres-cstore_fdw-recommended and install a Postgres client (I'm using Portico on OSX).

About

SQL scripts for working with the baseball data from retrosheet and baseball-databank, as provided by boxball

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published