From 5a72c8868c7918c09b8aa9d990f95a393e0b8906 Mon Sep 17 00:00:00 2001 From: alex Date: Tue, 15 Sep 2026 20:40:27 +0200 Subject: Link to real time database design --- IDEAS.org | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/IDEAS.org b/IDEAS.org index 6270ace7..b25c6eb7 100644 --- a/IDEAS.org +++ b/IDEAS.org @@ -114,9 +114,13 @@ This is basically a hybrid of https://linuxcontainers.org/incus/ and https://pro - Supports efficient replication of a subset of a database (initial checkpoint + streaming or batched updates) - Functional dependencies could be used to create materialized views *and* indexes ** Basic implementation + - Service that provides an API to interact with PostgreSQL logical replication - API that creates a publication and a subscription for a table with a filter - Libraries to interact with the service and create HTMX (or similar) components that live update. + +See also https://alex.corcoles.net/notes/tech/real-time-relations + * Videoconference based on document (not screen) sharing - Microsoft 365 and Google already offer this, but with drawbacks (Google's is Chrome only, I haven't managed to do this with free Teams). -- cgit v1.2.3