junhkang/spectra

데이터베이스 연결 상태 조회 API 생성

Open

#43 opened on Jun 19, 2024

View on GitHubContributor guide
 (0 comments) (0 reactions) (0 assignees)Java (4 forks)auto 404
backendenhancementgood first issuepriority: high

Repository metrics

Stars
 (6 stars)
PR merge metrics
 (PR metrics pending)

Description

PostgreSQL 데이터베이스의 현재 연결 상태를 조회하고, 이를 백엔드 API로 노출합니다.

작업 내용

  • PostgreSQL 데이터베이스에서 현재 연결 상태를 가져오는 쿼리 작성
    • 쿼리: SELECT datname, numbackends FROM pg_stat_database;

Contributor guide

Research direction
Study the existing controller and service layers in the project. Follow the pattern from other endpoints (e.g., database stats controllers) to create a new GET endpoint that executes the provided query against PostgreSQL and returns the results. Ensure the database connection is configured in application.properties.
Tech stack
javaspringpostgresql
Domain
backendapidatabase
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
GitJavaSpring BootPostgreSQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
75