Movie and Song CRUD Application with PostgreSQL and MongoDB

Project Overview

This project is a CRUD application developed using NestJS to manage movie and song data. It integrates both PostgreSQL (via TypeORM) and MongoDB (via Mongoose), enabling CRUD operations on both relational and NoSQL databases.

The Movies module utilizes PostgreSQL to manage structured data with relational integrity, while the Songs module uses MongoDB for flexible, schema-less storage of song data.

Key Features

Movies Module (PostgreSQL)

• Manage movie details such as title, director, release date, genres, and rating.
• Perform CRUD operations on movies:
  • POST /movies: Create a new movie.
  • GET /movies: Fetch all movies.
  • GET /movies/:id: Fetch a movie by its ID.
  • PUT /movies/:id: Update an existing movie.
  • DELETE /movies/:id: Delete a movie.
• Uses PostgreSQL for structured data with relational integrity.

Songs Module (MongoDB)

• Manage song details such as title, artist, genre, release date, and lyrics.
• Perform CRUD operations on songs:
  • POST /songs: Create a new song.
  • GET /songs: Fetch all songs.
  • GET /songs/:id: Fetch a song by its ID.
  • PUT /songs/:id: Update an existing song.
  • DELETE /songs/:id: Delete a song.
• Uses MongoDB for flexible, schema-less storage of song data.

Database Integration

• PostgreSQL is used for the Movies module to store structured data with relational integrity.
• MongoDB is used for the Songs module, providing flexibility in handling semi-structured data such as lyrics and multiple artists.

Technologies Used:

• NestJS for the backend framework.
• PostgreSQL for the Movies module.
• MongoDB for the Songs module.
• TypeORM for PostgreSQL integration.
• Mongoose for MongoDB integration.

Setup Instructions

1. Clone the repository:

   git clone https://github.com/prathakpr/CRUD_app.git
   
   

A progressive Node.js framework for building efficient and scalable server-side applications.

Description

Nest framework TypeScript starter repository.

Project setup

$ npm install

Compile and run the project

# development
$ npm run start

# watch mode
$ npm run start:dev

# production mode
$ npm run start:prod

Run tests

# unit tests
$ npm run test

# e2e tests
$ npm run test:e2e

# test coverage
$ npm run test:cov

Deployment

When you're ready to deploy your NestJS application to production, there are some key steps you can take to ensure it runs as efficiently as possible. Check out the deployment documentation for more information.

If you are looking for a cloud-based platform to deploy your NestJS application, check out Mau, our official platform for deploying NestJS applications on AWS. Mau makes deployment straightforward and fast, requiring just a few simple steps:

$ npm install -g mau
$ mau deploy

With Mau, you can deploy your application in just a few clicks, allowing you to focus on building features rather than managing infrastructure.

Resources

Check out a few resources that may come in handy when working with NestJS:

• Visit the NestJS Documentation to learn more about the framework.
• For questions and support, please visit our Discord channel.
• To dive deeper and get more hands-on experience, check out our official video courses.
• Deploy your application to AWS with the help of NestJS Mau in just a few clicks.
• Visualize your application graph and interact with the NestJS application in real-time using NestJS Devtools.
• Need help with your project (part-time to full-time)? Check out our official enterprise support.
• To stay in the loop and get updates, follow us on X and LinkedIn.
• Looking for a job, or have a job to offer? Check out our official Jobs board.

Support

Nest is an MIT-licensed open source project. It can grow thanks to the sponsors and support by the amazing backers. If you'd like to join them, please read more here.

Stay in touch

• Author - Kamil Myśliwiec
• Website - https://nestjs.com
• Twitter - @nestframework

License

Nest is MIT licensed.