This is test code I threw away, it looks like SQLite3 update hook is *per* connection, making it useless for subscribing for events between processes (even if they use same database).

sqlite3_update_hook.cs

using Microsoft.Data.Sqlite;
using Microsoft.EntityFrameworkCore;
using SQLitePCL;

static public class Thing {
    public static void ListenSqlite(DbContext context)
    {
        context.Database.OpenConnection();
        var c = context.Database.GetDbConnection() as SqliteConnection;
        SQLitePCL.raw.sqlite3_update_hook(c.Handle, test_func, new object());
    }

    static readonly delegate_update test_func = (db, wint, char1, char2, sqlitei64) =>
    {
        Console.WriteLine("Yeah?");
    };
}

test.csproj

    <!-- Omitted other stuff, just deps -->

    <PackageReference Include="Microsoft.EntityFrameworkCore.Relational" Version="6.0.0" />
    <PackageReference Include="Microsoft.Data.Sqlite" Version="6.0.0" />
    <PackageReference Include="SQLitePCLRaw.core" Version="2.0.7" />