[SSoC26] [Medium] feat(memory): Implement Read-Only DB replica support

[keepsloading]

Goal

Extend database configuration to support separate connection strings for read and write queries.

Requirements

• Support DATABASE_WRITE_URL and DATABASE_READ_URL env parameters.
• Direct all read operations (summaries, queries) to the read replica and updates to the write main connection.
• Add connection failover tests.

---

SSoC26 Contributor Notice:

Since this repository (Memact/Memory) is outside the main Context repository, and the registered project for tracking contributions is specifically Context (Memact/Context), please make sure to create a dummy PR in the Context repository linking to your actual PR or commits in this repository. This is required for your contribution to be correctly tracked and counted.

If you have already created a dummy PR in Memact/Context linking to your work here, please ignore this message!

[Prateeks16]

@keepsloading can you assign me on this issue under SSOC 26 , i would love to contribute on it.

[keepsloading]

@[SUCCESS] @Prateeks16 maintainer assignment: this issue is yours for SSoC26! Looking forward to your PR!

[keepsloading]

Hi @Prateeks16 👋 Just checking in on this issue! It has been assigned to you for over 3 days. Are you still working on it, or do you need any help? If you're no longer able to work on it, please let us know so we can unassign you and keep the backlog moving. Thanks for contributing!

[keepsloading]

Hi @Prateeks16,

Just checking in. This issue has been assigned to you for more than 3 days. If you are still working on it, no problem. Otherwise, please let us know so we can keep the backlog moving.

[Prateeks16]

I am sorry ,i have been busy because of flat shifting, it will ne done Tommorow