spotify-playlist-diff

Things I've worked on during this project

• Authentication with the Spotify API
• Looking at Spotify API response headers
• Making multiple calls to Spotify API at once using Promises
• Optimizing bulk inserts into MySQL database using Objection.js and knex
• Determining when and when not to use transactions in SQL
• Creating a hero banner using CSS grid layout
• Using React to keep track of frontend state; adding/hiding/deleting cards from view
• Designing a REST API using Express.js to serve as the backend for determining shared tracks
• Writing SQL queries to determine shared tracks, implementing the queries using knex query builder
• Use snapshot_id of Spotify playlist to determine if a playlist has been updated since added to database
• Designing a user-friendly frontend UI that fits Spotify's theme