🗄️ Database-Pipeline | Asynchronous Connection Ping Anchors for Multi-Corridor Ingestion Sinks

[Sadeequ]

Description

Intermittent database connection drops during quiet low-volume market windows force incoming price records to stall while waiting for new TCP handshakes to initialize.

Technical Requirements

• Implement an automated background keep-alive monitoring routine loop inside src/database/connection.py.

• Issue lightweight heartbeat statements (SELECT 1;) exactly every 30 seconds to keep connection paths continuously active and optimized.

If you find this implementation useful, please star the project and leave a review! 😊

[whitezaddy]

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

I have experience for this and have reviewed the code; I can submit a PR within 1hrs.

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

[chuks68]

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

please assign

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

[believetimothy]

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

Hello Maintainer, I can fix this issue.

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

[GauravKarakoti]

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

Allow me to work on this one

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

[Jerry-Tekh]

@Jerry-Tekh has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

hi repo maintainer, my interest is strong

please let me take this issue.

I'll add a background keep-alive loop in src/database/connection.py to run SELECT 1; every 30s, keeping DB connections active during low-volume windows so price records don't stall on new TCP handshakes.

i am ready, or pls assign me

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