ramamimu/vue-postgreesql-chartjs

Techs: vue + postgree-sql for a purpose to fulfill final project basis data management on Institute Technology Sepuluh Nopember Surabaya

Configuration Environment

Server

file locate in ./server/.env . here is the example configuration for server

# SERVER
PORT=3030

# DATABASE
PGUSER=postgres
PGHOST=localhost
PGPASSWORD=postgres
PGDATABASE=postgres
PGPORT=5434

User Interface

example configuration for user interface. file locate in .env

VUE_APP_TARGET_SERVER=http://localhost:3030

how to prepare the env

copy env like the previous section and run these commands. after your setup finish, the program ready to run.

make startdb
make init

you should have installed docker and docker compose on your PC

how to run

run those both commands on different terminals

user interface

npm run serve

in some cases, need to install or run using yarn

server

cd server
npm run server

how to build

npm run build

SQL query

you can check SQL QUERY on ./query.sql

Link Demonstration

link demo was here

Website Views

API List

pengunjungBulanan: {
  bulan: number,
  banyak: string
}

peminjam_jurusan: {
  jurusan: string,
  jumlah_peminjam: int
}

peminjaman_setiap_bulan: {
  bulan: string,
  coalesce: int
}

tabel_peminjaman: {
  denda: int,
  id_anggota: int,
  id_buku: int,
  id_peminjaman: int,
  id_petugas: int,
  tanggal_kembali: timestamp,
  tanggal_pengembalian: timestamp,
  tanggal_pinjam: timestamp
}

Big thanks to @sahrullahh has provided starter project i used on current project

Windzo starter project