Since this is a largely undocumented transactional database I’m still figuring out some important details and locating important data points, but I wanted to share what I’ve learned. Plex uses a SQLite database to keep track of its data and metadata, and it’s relatively easy to start using it as a data source for your own Power BI reports. It’s a bit of a hack because Spotify doesn’t have a database or API you can use, so you need to make a GDPR request and wait a few weeks to get a JSON archive… but I made it work. I blogged last year about how I report on my Spotify listening history. Now it’s time to start digging into the data that my year of music listening has produced. Since I spent much of the last 30+ years building an extensive CD and MP3 collection, the transition was surprisingly smooth, and the excellent Plexamp client app feels like an upgrade over Spotify in many ways. Around a year ago I left Spotify and started using my locally hosted Plex Media Server to feed my daily music consumption.
0 kommentar(er)
