anoadragon453 / zerolstn

A p2p music streaming website

ZeroLSTN

ZeroNet Music Streaming Site - http://127.0.0.1:43110/ZeroLSTN.bit

Setting up

Install yarn: https://yarnpkg.com/lang/en/docs/install/

In the project's root folder, install all needed dependencies.

$ yarn

Compiling

Simply run the following to compile everything:

$ npm run build

Translating

If you would like to help translate ZeroLSTN into your language, please see the Translation instructions.

zerolstn's Issues

Cursors for Icon buttons/links

ZeroLSTN/src/vue_components/song_item.vue

Line 18 in 226579a

<a class="tooltip" slot="reference" @click.prevent="queueSong(song)"><i class="material-icons switch-color">playlist_add</i></a>

You have @click.prevent which will run something when clicked. However, in order for anchor links to get the pointer cursor on hover, you either need the css cursor: pointer, or just put href="#" (btw the .prevent will make it so that it won't navigate to whatever is in href).

Indexes to speed up DISTINCTs

ZeroLSTN/dbschema.json

Line 52 in 226579a

"indexes": ["CREATE UNIQUE INDEX songs_id ON songs(json_id, id)"],

Since you use artist and album in DISTINCT statements, I would make separate indexes for them so that these statements would be sped up. I would also probably add date_added to this.

So I'd add:

"CREATE INDEX song_artist_idx ON songs (artist)", "CREATE INDEX song_album_idx ON songs (album)", "CREATE INDEX song_date_added_idx ON songs (date_added)"

Btw, something I just learned: GROUP BY's can sometimes be faster than DISTINCTs and can achieve the same results if done right.