Spring Adventures

Reference project for mid-size Spring Boot applications

Technology stack

• Java
• Spring Boot, Spring Modulith
• Postgres, JPA
• Maven

Dependencies

• Maven
• Docker

Development

AdventureWorks database

The project builds upon the "AdventureWorks" database from NorfolkDataSci/adventure-works-postgres.

docker compose up -d 

cd /path/to/adventure-works-postgres/

export PGPASSWORD=test

psql -h 0.0.0.0 -p 5432 -U test -c 'CREATE DATABASE "Adventureworks";'
psql -h 0.0.0.0 -p 5432 -U test -d Adventureworks < install.sql

Start application

mvn spring-boot:run -Dspring-boot.run.profiles=dev

http://localhost:8080/swagger-ui/index.html

Testing

Component testing

mvn verify

System testing

docker compose up -d

docker run \
  --env SPRING_DATASOURCE_URL="jdbc:postgresql://database:5432/Adventureworks" \
  --rm \
  -p "8000:8080" \
  --network spring-adventures_default \
  experimentalsoftware/spring-adventures:backend-latest

curl -s http://localhost:8000/api/product-inventories

Maintenance

Update Docker image

mvn spring-boot:build-image

docker tag docker.io/library/spring-adventures:0.0.1-SNAPSHOT experimentalsoftware/spring-adventures:backend-latest
docker push experimentalsoftware/spring-adventures:backend-latest

Alternatives

• https://github.com/st-tu-dresden/salespoint
• https://leasingninja.io/
• https://github.com/thombergs/buckpal
• https://github.com/HexArchBook/bluezone_pro

Credits

• The "Adventures" domain is derived from https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks
• Inspiration for new app features: https://www.baeldung.com/category/weekly-review