I have an idea for a lightning talk for a conference that involves the use of datasette, git scrapping, and my love of the AHL. Specifically this project that I've been poking at for more than 2 years which uses git scraping to populate data into a sqlite database which is then served up by datasette on a server I run.

It's a silly little thing, but it lets me do some pretty cool things, like comparing how my beloved Coachella Valley Firebirds are doing year over year.

It also lets me see their point totals by day for a specific number of historic years1 to do some other neat comparisons.

I've also been trying to work at getting a Django app integrated into it so I can make new tables and populate them with information about franchises, and teams to get a better sense of the history of a franchise and how it relates to any team.

For example, the current Calgary Wranglers were the previous Stockton Heat. And if you go back far enough they were the Maine Mariners who were the first expansion team to win the Calder Cup back in 1978-79.

Being able to easily trace the history of a franchise, through its various incarnations, with data seems like a pretty cool thing, at least to a data nerd like me.

I have BIG plans for this, but right now it's just a small, hobby project.

  1. There are three parameters, years back, team name, and season name. See here for an example ↩︎

tags: hockey