Configure PostgreSQL connection

[meshackyaro]

Description

This issue aims to address the implementation of Configure PostgreSQL connection.

The core objective is to: Setup the connection pooling and environment variables for the Core DB.

By completing this feature, we will ensure that the TrustFlow protocol maintains its high standards for security, usability, and decentralized logic. This issue requires careful attention to the Backend architecture and adherence to the existing project conventions.

When picking up this issue, please ensure you document any new dependencies or architectural decisions made during development.

Component

Backend

Difficulty

🟡 Medium

Tasks

• Review Node.js API architecture in backend/
• Implement logic for: Configure PostgreSQL connection
• Write unit tests for the new endpoints using Supertest
• Update Swagger terminology / OpenAPI specs
• Verify PostgreSQL queries are optimized
• Run npm run lint

Acceptance Criteria

• Feature accurately implements the objective: Setup the connection pooling and environment variables for the Core DB.
• Any PR that introduces TypeScript errors is automatically blocked
• CI pipeline runs in under 3 minutes per PR
• Code is properly reviewed and approved by codeowners

Estimated Time

4-8 hours

[xx7412421-cloud]

Hi maintainer, I’d like to work on this issue.

I can implement the PostgreSQL connection pooling and environment configuration cleanly, then include focused validation/docs updates in the PR. Please assign it to me if it is available.

[M2u0i0z]

@M2u0i0z has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Interested in working on this issue. I understand the requirements and can deliver a solution that meets the expected outcome.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @M2u0i0z to this issue.

[kris-nana]

@kris-nana has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

I am a Backend Engineer with experience building scalable and secure systems and/or web apps. Please assign this to me and I'd deliver this in due time.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @kris-nana to this issue.