For postgres, there are a variety of realtime options, including postgraphile or supabase's realtime.
What about for sqlite? Does anything similar exist?
(I want to get notified when an event is done)
Ask HN: Realtime Subscriptions for SQLite?
1–2 of 2 posts
Re: Ask HN: Realtime Subscriptions for SQLite?
#2I've never tried this exact thing, but I believe you could set up triggers and then have these invoke some application-defined function like:
CREATE TRIGGER update_customer_address UPDATE OF address ON customers
BEGIN
SELECT notify_table_event(tableName, id, etc...);
END;