Our great sponsors
-
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
There is an image of the ER Diagram here. The arrows show foreign key constraints. The model definitions can be found in stats/models.
I've been working on an relational NBA database and thought it might be time to share. This is completely free and will always be free. Instructions on how to use it, schema, and a small example query can be found here: https://github.com/mpope9/nba-sql. The main motivation for this was an easy way to do some analysis on teams and players. The API provided by the NBA duplicates data quite a bit and one of the goals of this is to minimize that. Two databases are supported: Postgres and MySQL. It is a bit bare bones right now, but it can be pretty easily used to query for player career and seasonal stats. I've been hooking it up to Apache Superset and built some graphs and it is not too hard to get started with that as an analytics platform. My next plans for this are to integrate more of the NBA APIs into it to add more tables related around teams. Within the next week I will make a 'release', which will basically be a dump of the database to easily load into Postgres. Right now you have to run the application to fill the database, which isn't super convenient.
Related posts
- More public SQL-queryable databases?
- Anyone else feel ‘trapped’ in power bi?
- Shitpost(?) From Nov to Dec, Braun was trusted with 50% more minutes per game, (when he checked in at all), and it resulted in a 50% bump in fg pct.
- nba-sql - A SQL Database for the NBA
- Building a Data Lakehouse for Analyzing Elon Musk Tweets using MinIO, Apache Airflow, Apache Drill and Apache Superset