Skip to content

said7388/express-mysql-music-library

Repository files navigation

Music Library System

Building music library system using Express, Typescript and MySql.

Key Features

  • User login and registration.
  • Secure password and use JWT token.
  • Develop CRUD APIs for artists.
  • Develop CRUD APIs for albums.
  • Build many-to-many relationships with artists and albums.
  • Develop API to get artists of an album and get albums of an artist.
  • Develop CRUD API for songs.
  • Build One to many relationships with songs and albums.
  • Secure all APIs.
  • Use Joi for API validation.

Project Setup

  1. Clone the project
https://github.com/said7388/music-library
  1. Install project dependencies using npm package manager.
npm install
  1. Create an .env file from .env.example fiel.

  2. Update the environment variables in .env file.

  3. Run the project:

npm run server
  1. Run SQL query from db.sql file to create the necessary tables.

API Documentation

You will find postman API documentation in this link: Click here.

About

Build REST API for a music library using Express, Typescript and MySQL raw query. The API's are protected with JWT token-based authentication

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published