A simple web application to store and manage your favorite movies!
Built with Node.js, Express, PostgreSQL, EJS, and Axios, it allows users to add, edit, and delete movie entries along with ratings, notes, and posters fetched from the OMDb API.
- Add movies with title, rating, watched date, and personal notes.
- Automatically fetch movie posters using the OMDb API.
- Edit movie details anytime.
- Delete movies from the list.
- Bootstrap-styled UI for a modern look.
- Backend: Node.js, Express.js
- Database: PostgreSQL
- Templating Engine: EJS
- API: OMDb API (for movie posters & metadata)
- Styling: Bootstrap + Custom CSS
Follow these steps to set up and run the Movie Notes CRUD App locally on your machine.
Before you begin, make sure you have:
✅ Node.js installed – Download Node.js
✅ PostgreSQL installed – Download PostgreSQL
✅ A GitHub account to clone the repository
git clone https://github.com/KhushiRajurkar/Movie_Logs.git
cd Movie_Logs
npm install
OMDB_API_KEY=your_api_key_here
1️⃣ Open PostgreSQL CLI (psql)
2️⃣ Run the following SQL commands to create your database:
CREATE DATABASE movies_db;
\c movies_db
CREATE TABLE movies (
id SERIAL PRIMARY KEY,
title TEXT NOT NULL,
rating INTEGER NOT NULL CHECK (rating BETWEEN 1 AND 10),
watched_date DATE NOT NULL,
notes TEXT,
poster_url TEXT
);
node index.js