music

The purpose of this project is to store data about the music I listen to in my own database and to query it using SQL. I also want to have fun while learning more about Supabase native features.

Currently, I am downloading all historical data from my Last.fm profile using its API to PostgresSQL via Edge Functions and the built-in cron extension, which run every 5 minutes and download 500 items.

Roadmap

• download and sync listened tracks from Last.fm every 5 minutes
• fetch tags from last.fm to downloaded tracks: https://www.last.fm/api/show/track.getTags
• connect to spotify api, find track links to play them
• fetch detailed info about artists from last.fm or spotify
• fetch detailed info about albums from last.fm or spotify

Tools

• Read documentation about localhost setup and cloud configuration
• IntelliJ IDEA as a code editor
• Docker for a localhost studio
• Deno
• Bruno for easy debugging
• Supabase account
• Last.fm account connected to Spotify, API key
• Sentry for error notifications
• [BetterStack] for uptime monitoring