#Spring Boot Practice using Postgres

Technologies

• Java - Spring Boot Framework
• Postman - Testing API
• PostreSQL - Database

Starter Project Dependencies

1. spring-boot-starter-data-jpa
2. spring-boot-starter-web
3. postgresql

Postgres Guide

login to postgre

psql user=<username>

list all database

\l or \list

list users

\du

connect to database

\c <database name>

create dabatase

CREATE DATABASE <db name>;

create new username w/o password

CREATE USER username;

create new username w/ password

CREATE USER username WITH PASSWORD 'password'

Grant all privileges on data to the specific user

GRANT ALL PRIVILEGES ON DATABASE <db name> TO <user>;

Learn ❤️ + Grind 🍺