Make DB→Sheets mirror atomic (avoid brief empty-sheet window) #5

New Issue

2026-07-16T10:37:37+02:00

mivanchenko commented

2026-07-16 10:37:37 +02:00

The one-way DB→Sheets mirror currently clears then re-writes each tab, so a reader hitting mid-write can catch a cleared sheet. Harmless for a human overview but worth fixing.

Options: write to a temp/staging range then swap, or use a batch update that replaces values in one call. See backoffice/app/sheets.py / mirror_entity in app.py.

The one-way DB→Sheets mirror currently clears then re-writes each tab, so a reader hitting mid-write can catch a cleared sheet. Harmless for a human overview but worth fixing. **Options:** write to a temp/staging range then swap, or use a batch update that replaces values in one call. See `backoffice/app/sheets.py` / `mirror_entity` in `app.py`.

mivanchenko added the tech-debt crm labels 2026-07-16 10:37:37 +02:00

mivanchenko added the needs-triage label 2026-07-23 10:31:46 +02:00

mivanchenko added the enhancement label 2026-07-23 10:48:02 +02:00

mivanchenko commented

2026-07-23 11:34:12 +02:00

This was generated by AI during triage.

Superseded — Google Sheets is being removed entirely to cut the Google dependency, so there is no mirror left to make atomic. See the Sheets-removal issue. Closing.

> *This was generated by AI during triage.* Superseded — Google Sheets is being removed entirely to cut the Google dependency, so there is no mirror left to make atomic. See the Sheets-removal issue. Closing.

mivanchenko closed this issue

2026-07-23 11:34:12 +02:00

mivanchenko referenced this issue

2026-07-23 11:34:13 +02:00

Remove Google Sheets mirror entirely (cut Google dependency) #13

mivanchenko referenced this issue

2026-08-04 11:30:23 +02:00

Remove Google Sheets mirror entirely (cut Google dependency) #13

mivanchenko referenced this issue from a commit

2026-08-04 11:31:06 +02:00

Remove Google Sheets mirror entirely (#13)

Sign in to join this conversation.