This is an open source project from DevProjects. Feedback and questions are welcome! Find the project requirements here: Daily sleep tracker web app
Built with spring boot, db used postgresql, thymeleaf for rendering html
This application presently supports only single user. The user can login, create, view, update and delete entries.
from terminal:
psql postgres CREATE ROLE sleep WITH LOGIN PASSWORD 'somepassword'; ALTER ROLE sleep CREATEDB;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO sleep;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO sleep;
\q psql postgres -U sleep
CREATE DATABASE sleep;
\c sleep
I used Java 8, Intellij Idea, TablePlus to check the data and a local postgreSQL instance
Specify dev or prod in SPRING_PROFILES_ACTIVE environment variable
Refer
Set SPRING_USERNAME, SPRING_PASSWORD environment variables to specify spring security user name and password
Set DB_USERNAME, DB_PASSWORD when using postgresql
https://vladmihalcea.com/log-sql-spring-boot/ https://github.com/gavlyukovskiy/spring-boot-data-source-decorator