Solomon Xie

# Oh, I can easily link an issue by typing `#` and a number to quote an issue as a hyperlink ## Just like : #2

# 但是不知道怎么把issue转为pull request？

## 甚至不知道issue -> pull request 有什么用？

# PROJECT DESIGN  ## REQUIREMENTS ANALYSIS - Music Player - Display music library [playlists, artists, albums, songs, recommendations] - Online stream music playing - `➢ Personal Data Management` -...

>

# Project: Spotify Localized @Oct 3, 2018 > Spotify really annoys me out by connecting issues through vpn. Well, not really spotify's fault. And not having premium membership of Spotify...

# Project: `Free-Spotify` or `Spoilfy` @Nov 8, 2018 在自己的服务器上建立一个类似Spotify的在线听歌网站，像Emby一样的服务器，但是和Spotify更贴合。 本质上是一个`私有云`，不对外公开的。所以不太涉及版权问题。 参考同类产品： - Emby - OwnCloud - NextCloud - Seafile 利用Spotify API，读取用户的所有信息，备份到自己的服务器，生成和SPotify一样的界面。一边提供了备份的功能，一边提供在线听歌。 问题在于，歌曲的来源问题。需要用户自己去下载，然后上传到服务器。然后，`Free-Spotify`会自动识别歌曲(MusicBrainz)，让你听。不用手动一首一首去对应。 这样一来，就算无法连接spotify，还是可以听自己标记过的歌和playlist。 由于歌太多，自己一个一个去搜索下载太麻烦。所以系统会生成一个列表：告诉你现在还缺哪些歌手的哪些专辑需要下载。默认的话可以直接自动搜索youtube上的歌并播放出来，这样甚至不需要上传歌也没有版权问题。像`Whatsthesong`一样。 涉及技术问题： - [x] Spotify API （Python）...

# DATABASE DESIGN It could either be relational database or NoSQL database. ## STRUCTURE Here is the basic structure of the databases. - User Library -> Postgresql - User Data...

# ORM ARCHITECTURE Object-Relational-Models, which are the Coding "classes" referring to "tables" in databases. ## `{Class: Song}` ```py class Song: gene = {} resources = [] def addResource(resource): r =...

# Design of ERP with URI [UPDATE]  Updates: - Replace ID with URI in the format of: `::` - Abandon most Foreign Keys to add flexibilities. - Treat everything...