Entity & SQLite schema design for calendar cache #4

New Issue

2026-09-01T19:28:11Z

haylan commented

2026-09-01 19:28:11 +00:00

Part of #1
Blocked by: #2

Question

What is the SQLite table/entity shape (via Doctrine DBAL + hand-defined typed PHP entities/DTOs, per this map's Notes) for caching calendar accounts, events, and tasks — including a source_type discriminator generic enough that RSS/Diun rows can later fit the same tables (per docs/research/smart-tablet-screen-additions.md, though not implemented now), a last_synced_at/staleness column per account, and — depending on the webhook-support ticket's findings — any columns needed for webhook subscription state (subscription id, expiry, renewal)?

Part of #1 Blocked by: #2 ## Question What is the SQLite table/entity shape (via Doctrine DBAL + hand-defined typed PHP entities/DTOs, per this map's Notes) for caching calendar accounts, events, and tasks — including a source_type discriminator generic enough that RSS/Diun rows can later fit the same tables (per docs/research/smart-tablet-screen-additions.md, though not implemented now), a last_synced_at/staleness column per account, and — depending on the webhook-support ticket's findings — any columns needed for webhook subscription state (subscription id, expiry, renewal)?

haylan referenced this issue

2026-09-01 19:28:18 +00:00

Cache refresh trigger mechanism #5

haylan added the wayfinder:grilling label 2026-09-01 19:28:26 +00:00

haylan referenced this issue

2026-09-01 19:31:23 +00:00

Calendar backend groundwork: SQLite cache + Docker prep #1

haylan referenced this issue

2026-09-01 19:36:33 +00:00

Calendar backend groundwork: SQLite cache + Docker prep #1

Sign in to join this conversation.