Skip to content

A Python-based Spotify-like music platform app that uses SQLite to manage user accounts, tracks, albums, playlists, and activity history.

License

Notifications You must be signed in to change notification settings

aserman01/Music-Platform-Database

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Music-Platform-Database

This is a Python-based Spotify-like Online Music Platform application that utilizes a SQLite database to manage user accounts, tracks, albums, playlists, and user activity history. It provides features for both regular users and artists.

Prerequisites

  • Python 3.x
  • PySimpleGUI library
  • SQLite3

Installation

  1. Clone the repository to your local machine.
  2. Install the required dependencies using the following command: ''' pip install PySimpleGUI '''
  3. Make sure you have SQLite3 installed on your machine. If not, you can download it from the official SQLite website (https://www.sqlite.org/download.html) and follow the installation instructions.
  4. Run the 'Project.db' script to create the SQLite database.
  5. Run the 'Online_Music_Platform.py' script to start the application.

Features

  • User Authentication: Users can log in with their username and password.
  • User Menu: Provides options for accessing tracks, albums, user profile, and activity history.
  • Browse and Filter Tracks: Users can explore and filter tracks by artist and genre, add them to playlists, and play them.
  • View Albums: Displays a list of albums and their associated tracks.
  • User Profile: Shows user information, followers, following, playlists, and liked playlists.
  • User History: Displays the user's activity history, including recently played tracks.
  • Track Statistics: Artists can view statistics for their tracks, such as play count.
  • Create Playlists: Users can create new playlists with a name and privacy setting.
  • View Playlist Contents: Displays the tracks within a selected playlist.
  • Create Albums: Artists can create new albums by selecting existing tracks.
  • Update Track Information: Artists can update track details like name, genre, length, and release date.
  • Like Playlists: Users can like playlists to show their appreciation.

ER Diagram

WhatsApp Image 2024-02-27 at 11 06 08

GUI

WhatsApp Image 2024-02-27 at 11 11 23

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

License

This project is licensed under the MIT License.

About

A Python-based Spotify-like music platform app that uses SQLite to manage user accounts, tracks, albums, playlists, and activity history.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages