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 |
Actions
