pg-index-health
pg-index-health copied to clipboard
mfvanek
pg-index-health is a Java library for analyzing and maintaining indexes and tables health in Postgresql databases.
Sometimes in database migrations we've faced with curious constructions like ``` CREATE TABLE some_table ( id bigserial primary key, document_copy_id bigserial, // it's a foreign key ... ``` It's look...
See https://github.com/DarrMirr/dbchange and https://darrmirr.medium.com/introduction-to-dbchange-junit-extension-7995a5a639e7 After https://github.com/DarrMirr/dbchange/issues/1
Create a branch with code for Java 8 Fix the latest Java 8 compatible release in the documentation Migrate codebase to Java 11
https://errorprone.info/index https://mincong.io/2020/11/08/google-error-prone/
HighAvailabilityPgConnectionImpl needs to be a long-live singleton for using as a spring bean in spring boot starter. In this case we cannot determe primary host in constructor and remember it...
See https://www.baeldung.com/java-package-info
get max_connections and calculate recommended values
Hibernate can do such validation on startup but usually in real apps it isn't an appropriate behavior. - https://stackoverflow.com/questions/47839163/how-can-i-validate-the-database-schema-against-my-jpa-in-wildfly-11-hibernate - https://stackoverflow.com/questions/54464978/validate-schema-programmatically-using-hibernate - https://stackoverflow.com/questions/2327423/how-to-validate-database-schema-programmatically-in-hibernate-with-annotations
Consider adding metrics in prometheus format. We should use Micrometer 1.9.12 (or higher but compatible with Spring Boot 2.7.x)
Иван, приветствую! Подскажи пожалуйста, а можно ли оформить pg-index-health как консольную утилиту?
