Built by Tanner Villarete
Connect with me on LinkedIn! I'll be graduating soon ;)
Turns out, pretty dang far. This web app was my attempt at mimicking Apple's iOS music app, and I think I've come pretty close!
Check out a live demo here
I'm in my fourth year of college, and it's been super cool to see how much I've improved and continue to improve all aspects of programming.
The API is hosted on a Raspberry Pi, and it's kept private (but still accessible if you try) so that it doesn't get overloaded. If you're interested in building your own backend to plug into this tool, here's what my database and endpoints look like:
There are six required columns:
name
: The name of the songartist
: The artist namealbum
: The album nametrack
: The index of the song relative to the album (To order songs in an album)url
: A URL to the audio fileartwork
: A URL to the album artwork image
mysql> use music;
Database changed
mysql> desc tracks;
+------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| created_at | timestamp | YES | | NULL | |
| updated_at | timestamp | YES | | NULL | |
| name | varchar(255) | NO | | NULL | |
| artist | varchar(255) | NO | | NULL | |
| album | varchar(255) | NO | | NULL | |
| track | int(11) | NO | | NULL | |
| url | varchar(255) | NO | | NULL | |
| artwork | varchar(255) | NO | | NULL | |
+------------+------------------+------+-----+---------+----------------+
9 rows in set (0.05 sec)
The backend is built with PHP using the Laravel ORM. I only needed a few API endpoints to get this working:
/albums
- Returns a list of all album names with their corresponding artist/album/{album}
- Returns a list of songs from a specified album/artists
- Returns a list of all artists/artist/{artist}
- Returns a list of all albums from a specific artist
Feel free to reach out if you have questions!