SpringBoot, PostgreSQL, Thymeleaf, and Bootstrap web application with pagination and table sorting.
Creating the Postgres database Terminal commands (in order):
psql
CREATE DATABASE books;
\c books
CREATE TABLE book (
id bigint,
isbn varchar(30),
title varchar(100),
author varchar(100),
status varchar(15),
PRIMARY KEY (id)
);
GRANT ALL PRIVILEGES ON DATABASE books to yourusername;
GRANT ALL PRIVILEGES ON DATABASE books to postgres;
\q
Table Structure
