Ask HN: Realtime Subscriptions for SQLite?

4 pointsvsroy2y ago1 comments

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 comments

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;

j / k navigate · click thread line to collapse

4 pointsvsroy2y ago1 comments

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)

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;

j / k navigate · click thread line to collapse