Ask HN: Realtime Subscriptions for SQLite?

4 points by vsroy 3y ago ↗ HN

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)

1 comment

[ 5.3 ms ] story [ 17.0 ms ] thread

I'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;