Any plans to implement sqlite3_update_hook?

[simolus3]

Any plans to implement sqlite3_update_hook?

[simolus3]

Using the watch() function in Drift does not seem to fire the callback for the update of the other table

It definitely should though! Are you defining the trigger in a .drift file or are you creating it manually? For triggers that Drift knows about, stream updates should work.

I think update hooks could be a useful addition to this package regardless of Drift though.

[reinhardbluelab]

At the moment we're creating these triggers manually since they rely on a complex view that doesn't work in a .drift file. We're just running these in a customStatement.

[simolus3]

I have implemented update hooks in 8d308c1.

At the moment we're creating these triggers manually since they rely on a complex view that doesn't work in a .drift file

If drift crashes or provides invalid analysis for a valid sqlite3 view, I'd love to take a look at that. If you're using customStatements to create triggers, you need to tell drift how these affect stream updates manually (the generator should otherwise be able to figure it out).

  @override
  StreamQueryUpdateRules get streamUpdateRules {
    return StreamQueryUpdateRules(
      [
        ...super.streamUpdateRules.rules,
        WritePropagation(
          on: TableUpdateQuery.onTable(tableThatTheTriggerIsListeningOn),
          result: [
            TableUpdate.onTable(tableThatMightBeWrittenInto),
          ],
        )
      ],
    );
  }