Music Streaming Platform based on full implementation of DBSM

Related tags

AudioSymphony-Music
Overview

Symphony

Music Streaming Platform based on full implementation of DBSM

List of Commands

  1. Insert User (INSERT)

Function to implement input in USER

  1. Get all Albums by a Artist (QUERY : PROJECTION)

Function to display all the albums by a particular artist

  1. Query Song by Genre (QUERY : PROJECTION)

Get all song names with a input genre say β€œPop”

  1. Get Artist with max followers (QUERY : AGGREGATE)

Get the name of the artist with maximum followers

  1. Remove User By Email (DELETE)

Remove a user from the USER table who has a given email

  1. Update User Contact (UPDATE)

Update a given user's contact

  1. Insert Song (INSERT)

Insert a new song into the SONG relation

  1. Get Podcasts of greater than 1 hour duration (QUERY : SELECTION)

Get all podcasts that have a duration greater than 1 hour

  1. Get Playlist with max saves (QUERY : AGGREGATE)

Get playlist with maximum saves

  1. Get Podcast with minimum duration (QUERY : AGGREGATE)

Get the podcast with the shortest duration

  1. Get artist with over 1 lakh followers (QUERY : SELECTION)

Get all artists that have more than 1 lakh followers

  1. Query Podcast Language (QUERY : SEARCH)

Get all podcasts available in a given language

  1. Get all songs in album (QUERY : SELECTION)

Get all songs in a given album

  1. Get premium users with specific plan (QUERY : SEARCH)

Get names of all permium users with a particular pl

  1. Add an episode in a existing podcast (INSERT)

Adds a new episode in an existing podcast

  1. Analysis of popular album (QUERY : ANALYSIS)

List of popular albums based on average likes on all songs in the album

  1. User Likes Song (UPDATE + INSERT)

Increments song's likes when user likes it

  1. User Follows Artist (UPDATE + INSERT)

When a user follows a artist, update artist_followers and insert a record in FOLLOWS

  1. User Saves Playlist (UPDATE + INSERT)

When a user saves a new playlist, update playlist_saves in PLAYLIST and insert a record in SAVES

  1. Top Genres for a User (ANALYSIS)

List of top genres for a user based on song likes

  1. Exit

EXIT

Requirements

  • Python3
$ sudo apt-get update
$ sudo apt-get install python3.8
  • MySQL
  • PyMySQL
$ sudo apt-get install python3-pip
$ pip3 install pymysql

Installation

You will need to replicate the SYMPHONY databse on your local machine, for which the dump.sql file is provided herewith.

Open your MySQL server and run the following command to import the database:

$ docker exec -i mysql sh -c 'exec mysql -uroot -ppassword' < dump.sql

You might need to enter your password in the next step.

To run the CLI, change your directory to the cloned folder and run the following command:

$ python3 symphony.py
If you are using Docker to run MySQL, you might need to first change your port to 5005 (or the port you use) by replacing the following lines for connecting the database in the symphony.py file: 
con = pymysql.connect(host='localhost',
                              user=username,
                              password=password,
                              db='SYMPHONY',
                              port='5005',
                              cursorclass=pymysql.cursors.DictCursor)

near lines 674-675.

HAPPY LISTENING !!!

Owner
Parth Maradia
Parth Maradia
Convert complex chord names to midi notes

ezchord Simple python script that can convert complex chord names to midi notes Prerequisites pip install midiutil Usage ./ezchord.py Dmin7 G7 C timi

Alex Zhang 2 Dec 20, 2022
gentle forced aligner

Gentle Robust yet lenient forced-aligner built on Kaldi. A tool for aligning speech with text. Getting Started There are three ways to install Gentle.

1.2k Dec 30, 2022
Tune in is a Collaborative Music Playing Systems where multiple guests can join a room and enjoy the song being played

✨A collaborative music playing systems🎢 where multiple guests can join a room ➑πŸšͺ and enjoy the song🎧 being played.

Vedansh Vijaywargiya 8 Nov 05, 2022
Voice helper on russian

Voice helper on russian

KreO 1 Jun 30, 2022
Audio2midi - Automatic Audio-to-symbolic Arrangement

Automatic Audio-to-symbolic Arrangement This is the repository of the project "Audio-to-symbolic Arrangement via Cross-modal Music Representation Lear

Ziyu Wang 24 Dec 05, 2022
Speech recognition module for Python, supporting several engines and APIs, online and offline.

SpeechRecognition Library for performing speech recognition, with support for several engines and APIs, online and offline. Speech recognition engine/

Anthony Zhang 6.7k Jan 08, 2023
This Is Telegram Music UserBot To Play Music Without Being Admin

This Is Telegram Music UserBot To Play Music Without Being Admin

Krishna Kumar 36 Sep 13, 2022
Spotipy - Player de mΓΊsica simples em Python

Spotipy Player de mΓΊsica simples em Python, utilizando a biblioteca Pysimplegui para a interface grΓ‘fica. Este tocador Γ© bastante simples em si, mas p

Adelino Almeida 4 Feb 28, 2022
[Singing Log] Let your program learn to sing!

[Singing Log] Let your program learn to sing! You must have thought this was changelog when you saw the English title, but it's not, it's chΓ nggΔ“log. What it does is allow your program to print logs

黄巍 22 Sep 03, 2022
Port Hitsuboku Kumi Chinese CVVC voicebank to deepvocal. / η­†ε’¨γ‚―γƒŸDeepvocalδΈ­ζ–‡ιŸ³ζΊ

Hitsuboku Kumi (η­†ε’¨γ‚―γƒŸ) is a UTAU virtual singer developed by Cubialpha. This project ports Hitsuboku Kumi Chinese CVVC voicebank to deepvocal. This is the first open-source deepvocal voicebank on Gith

8 Apr 26, 2022
This is a python package that turns any images into MIDI files that views the same as them

image_to_midi This is a python package that turns any images into MIDI files that views the same as them. This package firstly convert the image to AS

Rainbow Dreamer 4 Mar 10, 2022
TwitterMusicBot - A Twitter bot with Spotify integration.

A Twitter Music Bot πŸ€– 🎡 🎢 I created this project to learn more about APIs, so it only works for student purposes. Initially, delving into the Spoti

Gustavo Oliveira 2 Jan 02, 2022
Scrap electronic music charts into CSV files

musiccharts A small python script to scrap (electronic) music charts into directories with csv files. Installation Download MusicCharts.exe Run MusicC

Dustin Scharf 1 May 11, 2022
Synthesia but open source, made in python and free

PyPiano Synthesia but open source, made in python and free Requirements are in requirements.txt If you struggle with installation of pyaudio, run : pi

DaCapo 11 Nov 06, 2022
The official repository for Audio ALBERT

AALBERT Here is also the official repository of AALBERT, which is Pytorch lightning reimplementation of the paper, Audio ALBERT: A Lite Bert for Self-

pohan 55 Dec 11, 2022
𝙰 π™Όπšžπšœπš’πšŒ π™±πš˜πš π™²πš›πšŽπšŠπšπšŽπš π™±πš’ πšƒπšŽπšŠπš–π™³πš•πš πŸ’–

TeamDltmusic 𝙰 π™Όπšžπšœπš’πšŒ π™±πš˜πš π™²πš›πšŽπšŠπšπšŽπš π™±πš’ πšƒπšŽπšŠπš–π™³πš•πš πŸ’– Deploy String Session String Click hear you can find string session OR join He

TeamDlt 5 Jan 18, 2022
All-In-One Digital Audio Workstation and Plugin Suite

How to install Windows Mac OS X Fedora Ubuntu How to Build Debian and Ubuntu Fedora All Other Linux Distros Mac OS X Windows What is MusiKernel? MusiK

j3ffhubb 111 Sep 21, 2021
A collection of python scripts for extracting and analyzing acoustics from audio files.

pyAcoustics A collection of python scripts for extracting and analyzing acoustics from audio files. Contents 1 Common Use Cases 2 Major revisions 3 Fe

Tim 74 Dec 26, 2022
Audio fingerprinting and recognition in Python

dejavu Audio fingerprinting and recognition algorithm implemented in Python, see the explanation here: How it works Dejavu can memorize audio by liste

Will Drevo 6k Jan 06, 2023
Python CD-DA ripper preferring accuracy over speed

Whipper Whipper is a Python 3 (3.6+) CD-DA ripper based on the morituri project (CDDA ripper for *nix systems aiming for accuracy over speed). It star

671 Jan 04, 2023