pg-index-health-demo

Demo project for pg-index-health library.

Modules

• pg-index-health-demo-without-spring
  • Without Spring/Spring Boot
• pg-index-health-spring-boot-demo
  • With Spring Boot

Tech stack

• Java 21
• Testcontainers

Previous versions

If you search for version with Embedded PostgreSQL please take a look at release 0.6.1
If you search for Java 8 compatible example please take a look at release 0.6.2

Advantages

With pg-index-health library you will be able to:

1. collect indexes health data in production environment;
2. analyze your database structure in functional tests and prevent many of typical errors;
3. analyze your database configuration to prevent using of default values for important options;
4. manage your database statistics in production environment;
5. generate migrations to fix your database structure.

Local development

Linting

macOS/Linux

To run super-linter locally:

docker run \
  -e RUN_LOCAL=true \
  -e USE_FIND_ALGORITHM=true \
  -e VALIDATE_SQLFLUFF=true \
  -v $(pwd):/tmp/lint \
  ghcr.io/super-linter/super-linter:slim-v7.1.0

Windows

Use cmd on Windows:

docker run ^
  -e RUN_LOCAL=true ^
  -e USE_FIND_ALGORITHM=true ^
  -e VALIDATE_SQLFLUFF=true ^
  -v "%cd%":/tmp/lint ^
  ghcr.io/super-linter/super-linter:slim-v7.1.0