mfvanek / mfvanek/java-experiments

Optimize connection to PostgreSQL

Open
#152 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

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

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

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.