hypersonic

frontend

todo

• database queries

  • albums

    • create album
    • get album by hash (includes album artists)
    • get albums by artist
    • search albums by name
    • paginate (sort by params + direction)
    • delete album

  • tracks

    • create track
    • get track by hash (includes artists and albums, does not include album artists)
    • get tracks by album
    • get tracks by artist
    • get tracks by genre
    • search tracks by name
    • paginate (sort by params + direction)
    • delete track

  • artists

    • create artist
    • get artist by hash
    • search artists
    • delete artist

meta

• share duplicated code
• handle row not found
• this is getting messy, need to rewrite sql with json agg