Actions
csAdr #9 | YANK-0006 · ADR-0006
closed
DD
Store sync state in PostgreSQL
csAdr #9 | YANK-0006 · ADR-0006:
Store sync state in PostgreSQL
Status:
Accepted
Priority:
Normal
Number:
ADR-0006
Format:
MADR
Date:
10/15/2026
Decision makers:
tech lead, backend team
Consulted:
operations
Supersedes:
Content:
Locked
Status:
Accepted
Informed:
-
Superseded by:
-
Description
Context and Problem Statement¶
Yank now runs on several hosts. The SQLite files of ADR-0002 Keep sync state in SQLite files Superseded drift apart. We follow the shared database of Meta › ADR-0002 Use one shared PostgreSQL service for every instance Accepted.
Considered Options¶
- Shared PostgreSQL
- Replicated SQLite files
Decision Outcome¶
Chosen option: "Shared PostgreSQL", because every host sees the same cursors.
Consequences¶
- Good, because no state is lost when two hosts sync.
- Bad, because Yank now needs a database server.
Hierarchy
Loading diagram...
Dependencies
Loading diagram...
Combined
Loading diagram...
Document references
No data to display
Your roles cannot decide on this ADR. In this project the decision belongs to: Manager, Developer.
Linked issues
| Project | Item | Status | Origin |
|---|---|---|---|
| Meta | Feature #META-0004: Provision the shared database | New | Mention |
| Yank | Feature #YANK-0008: Move sync state to PostgreSQL | New | Link |
RR Updated by Rosa Reporter about 4 hours ago
The shared PostgreSQL service has spare capacity.
DD Updated by Diego Developer about 4 hours ago
- Superseded ADR set to ADR-0002
- Status changed from Proposed to Accepted
DD Updated by Diego Developer about 4 hours ago
- Related to Feature #YANK-0008: Move sync state to PostgreSQL added
AM Updated by Ana Manager about 4 hours ago
Still the right call after the load tests.
DD Updated by Diego Developer about 4 hours ago
Checked again from the form.
Actions
