Ram Maheshwari Logo Image
Tim Simms

Let's Paint Outside

Let's Paint Outside is a custom API that serves data about Bob Ross episodes. The Frontend has user authenticatio and allows users to search for and watch episodes by subject matter.

Project Overview

This is a database project for information about all 403 episodes of The Joy Of Painting with Bob Ross. The front-end of the project is an authentication application built with express, ejs, and express-ejs-layouts. The user information is stored in a MongoDB Atlas database using mongoose. The backend is built with FastAPI and serves data using a uvicorn server. The authentication is managed with passport and passport-local. The database connectivity is managed with SQLAlchemy and data manipulation with pandas. The API also uses pydantic and requests to handle data transfer and validation. The API has endpoints to retrieve episodes by date, colors used, and subject matter, as well as endpoints to allow users to add and delete episodes.

Tools Used

HTML
CSS
JavaScript
GIT
Passport
Pandas
FastAPI
SQLAlchemy
Mongoose
SQLite
uvicorn
Express