Fakultas Ilmu Komputer UI

Skip to content
Snippets Groups Projects
user avatar
abdurrafiarief authored
e4f8c399
History

pipeline status

coverage report

💻 Repository Kelompok PMPL Skuy

Project Name: Productivity App dan Todolist

Sebuah aplikasi “todo list” untuk membantu kita memonitor kegiatan yang belum dan sudah kita lakukan

Anggota Kelompok

No. Nama NPM
1 Abdurrafi Arief 1806205773
2 Ahmad Haulian Yoga Pratama 1806133824
3 Dzikra Muzaki 1806141334
4 Gilbert Stefano Wijaya 1806205584
5 Muhamad Yoga Mahendra 1806205256

Guide

Setup Database

  • Download Docker (or Docker Desktop for Windows)
  • Run docker pull postgres in terminal
  • Start PostgreSQL container with docker run --name postgres -e POSTGRES_PASSWORD=admin -p 5432:5432 -d postgres
  • Database is ready to be used

Viewing the Database

There are two options:

  • Use pgAdmin4
  • Use Datagrip (make sure SSO account is already registered for JetBrains Ultimate products, it's free!)

pgAdmin4 Setup

  • Download Docker (or Docker Desktop for Windows)
  • Run docker pull dpage/pgadmin4 in terminal
  • Start pgAdmin4 container with docker run -e PGADMIN_DEFAULT_EMAIL=admin@planme.com -e PGADMIN_DEFAULT_PASSWORD=admin -p 80:80 -d dpage/pgadmin4
  • Make sure PostgreSQL container is running
  • Open terminal session inside PostgreSQL container using CLI button in Docker Desktop (find out yourself how to do it in Linux)
  • Run hostname -I and note down the ip address output
  • Open localhost in your preferred browser
  • Enter the login credentials from the previous run command

    Username: admin@planme.com

    Password: admin

  • Create a new server connection with the following data (choose postgresql and give it whatever name you like)

    Hostname: ip address you've previously noted

    Username: postgres

    Password: admin

  • Save it and the database should now be accessible to be viewed

Datagrip Setup

  • Same as above starting from create new server connection (remember to choose postgresql)