search

mpope9 / nba-sql

:basketball: An application to build an NBA database backed by MySQL, Postgres, or SQLite
Apache License 2.0
172 stars 20 forks source link

OLAP support #14

Closed mpope9 closed 3 years ago

mpope9 commented 3 years ago

This database will grow over time as well as get some larger tables like play_by_play. While I use Superset which builds views on the raw data from PG, having the ability to use different different DBs can be useful. Redshift and Greenplum are supported out of he box by default (I think?), but other datawarehouses are welcome.

mpope9 commented 3 years ago

Know what, I think this matters less. We're building alot of indexes by default, so maybe we can just recommend PG compatible DBs for this.