{"repo":"mfvanek/pg-index-health","free":true,"listed":false,"github":"https://github.com/mfvanek/pg-index-health","clone":"git clone https://github.com/mfvanek/pg-index-health.git","description":"pg-index-health is an embeddable schema linter for PostgreSQL that detects common anti-patterns and promotes best practices.","language":"Java","stars":202,"topics":["java","postgres","postgresql","indexes","gradle","testcontainers","pitest","mutation-testing","hacktoberfest","static-analysis"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"pg-index-health is an embeddable schema linter for PostgreSQL that detects common anti-patterns and promotes best practices. What is this? pg-index-health is a Java library designed to analyze PostgreSQL database schemas and help developers build efficient, reliable applications. It scans database structures to identify common schema-level pitfalls that often go unnoticed until they cause problems in production. By embedding pg-index-health into your CI/CD pipeline, you can proactively catch schema design flaws, enforce consistency, and adhere to PostgreSQL best practices before they impact performance or reliability. Available checks A list of all available checks (rules/diagnostics) can be found here. In code, you can get all checks through an instance of the StandardChecksOnHost or StandardChecksOnCluster class. User-defined (custom) checks You can add your own database structure checks as shown in the link. Installation Using Gradle: Using Maven: How to use There are two main scenarios of using pg-index-health in your projects: unit\\functional testing (see standard test in a section below) locally and in CI for compliance of the database structure with best practices; collecting indexes, tables and sequences health data and bloat monitoring in runtime on production. All these cases are covered with examples in the pg-index-health-demo project. Integration with Spring Boot There is a Spring Boot starter pg-index-health-test-starter for unit/integration testing as well. Mor","default_branch":null,"files":null,"tree":[],"storefront":"/r/mfvanek","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/mfvanek/pg-index-health/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}