7 ms·
Ask HN: Realtime Subscriptions for SQLite?
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)
- bob1029 3y agoI'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; https://www.sqlite.org/lang_createtrigger.html https://www.sqlite.org/lang_createtrigger.html https://www.sqlite.org/appfunc.html https://www.sqlite.org/appfunc.html