Project 1 for COMS 4111 Introduction to database

Author：Jinhang Yang, Binghong Yu

See how we clone a Yelp full-stack web app- [Yealp]!

Deployed at GCP: http://104.196.193.159:8111/

⚡ Features

• ☕ Fake Yelp database application

• 📊 Implement backend with PostgreSQL,

• 🧬 Frontend with Flask

🌻 Motivation

This is Database class project of COLUMBIA UNIVERSITY COMS W4111 INTRODUCTION TO DATABASES

Steps:

• Come up with a web application and design the database on paper using ER-modeling.
• Implement database by translating model into a database schema and example data.
• Build web application by building the front end on top of the Flask Python webserver

✨ Demo

🍭 Main page

Anonymous User

🍭 Search a restaurant by conditions such as locations, stars, reviews

🍭 Without login, User could only review but coud not make reaction such as "like" to posts

User authentication

🍭 Register

🍭 Forget passward & Reset

🍭 Change profile image

Business detail

🍭 User could make reaction to review

🍭 User could favorite restaurants

🍭 User could follow other users

🍭 User could create and edit collection, and add restaurants to collection

🔨 Installation

To rerun our code:

1 database_setup: we designed the database from scratch using ER-modeling, then implemented database by translating ER into a database schemam. Next step, we clean the data from the official yelp dataset by running through the Data schema and DB populating.ipynb

2 yealp_frontend: build full stack front-end and back-end of yealp platform. To run locally:

• Setup virtual environment with requirements.txt

• cd yealp_frontend

• python run.py