trendr

Database project for CSE 412

Setup

Run this bash script to create the database cluster. Commands will have to be modified slightly for MacOS or Windows:

chmod +x initialization/postgres_setup.sh
./initialization/postgres_setup.sh

Create tables in the database and populate them with data from the Kaggle dataset:

# Pip install
pip install -r requirements.txt
# Conda install
conda install --yes --file requirements.txt

python initialization/posgres_import.py

To access the DB manually:

psql -d trendr

VS Code extension for managing Postgres connection through the IDE: