nba-sql VS espn-api

I've searched for a good database to analyze NBA players and teams, and couldn't find one. So, I've been working on an app that builds a SQLite / Postgres / MySQL database for the NBA. You can get the Windows alpha here: https://github.com/mpope9/nba-sql/releases/tag/v0.0.6 For OSX / Linux, you need to run it from the commandline. This is very much in the alpha phase, but development is happening at a steady pace in my free time. I've been able to learn some interesting things already, there are examples in the wiki here. I have more advanced example queries that I'm still working on, and have yet to add them to the wiki if any are interested. I'd love some feedback, if anyone has experience with SQL or databases. nba-sql will build a SQLite database by default, but it also supports Postgres and MySQL. You run the application to build the database, then use something like DBeaver to query it.

This is what I've found - https://github.com/mpope9/nba-sql

I used the nba-sql database for this. That database has a table called shot_chart_detail. The table has alot of interesting data, but there are a few columns that are especially helpful: minutes_remaining, seconds_remaining, and shot_distance. Using those columns, the following graph can be made:

Thanks! I used Postgres and Apache Superset. I wrote a small wiki on how to use it https://github.com/mpope9/nba-sql/wiki/Data-Visualization-with-Superset. Superset doesn't work with SQLite sadly.

The latest Postgres dump can be found here: https://github.com/mpope9/nba-sql/releases/tag/v0.0.2. It is a compressed file, using xz. After decompressing it, you can run it using psql -U -P nba < nba.sql.

If you know some python this package is great for getting data from espn: https://github.com/cwendt94/espn-api

Don’t have much experience with raw endpoints but this python package is an awesome wrapper that makes everything easier https://github.com/cwendt94/espn-api

I'm using espn-api to read data from our league and come up with interesting stats. We have a telegram channel where we use a bot to communicate any of these things. Right now the bot posts about recent league activity, power rankings and we calculate the score of each week by only counting each players strongest performance (sleeper style, which is unfortunately not available in Germany).

I’m not sure how much programming experience you have but that would definitely make it more challenging. here is a GitHub repository where it seems like someone’s already done a lot of the heavy lifting. Also here’s a thread from a bout a month ago that might help

If you're new to the API, you can start here https://github.com/cwendt94/espn-api/wiki/Football-Intro, but I've been specifically looking at the Offers Report.

If you are using: https://github.com/cwendt94/espn-api/wiki/Football-Intro

Second if you want to get into the code, I use this awesome python package (not mine) to interact with espns api: https://github.com/cwendt94/espn-api