mfvanek / mfvanek/java-experiments

Optimize connection to PostgreSQL

Open
#152 1 comment 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
Java
Stars
9
Forks
3
Avg merge
2d 4h
Merged PRs (30d)
4

Description

https://www.youtube.com/watch?v=QzIUHvDnEaI

- Reconfigure LOGIN_TIMEOUT + HikariConfig.connectionTimeout
- Always set HikariCP pool name
- Always set applicationName in PG driver + assumeMinServerVersion
![Screenshot 2024-04-17 at 16 42 49](https://github.com/mfvanek/java-experiments/assets/37612014/a1859be1-64a4-4bf9-8de7-ccd1a96e9674)
![Screenshot 2024-04-17 at 16 42 12](https://github.com/mfvanek/java-experiments/assets/37612014/fc0ff3b2-cff4-48e9-ab97-064b45fe9471)

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by locating the PostgreSQL connection setup, then inspect LOGIN_TIMEOUT, HikariConfig.connectionTimeout, the HikariCP pool name, and the PG driver's applicationName and assumeMinServerVersion settings. Done means these connection properties are consistently configured and the existing connection behavior remains functional; the issue does not mention a test file to run.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, postgresql
Domain
backend, databases
Issue type
Refactor
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.