Notification callbacks

[toomim]

Sqlite features data-change notification callbacks that tell you when a particular table has been modified. This is super useful for writing realtime, reactive web servers, that notify all connected clients when data has changed. But there's no support for this notification API in node-sqlite3.

Would bindings for this be easy to add to node-sqlite3? I understand that sqlite runs in a different thread, so I imagine that the thread would need to communicate with the v8 thread, to call a notification method, and just pass it these parameters:

• A string "insert", "delete", or "update" describing the type of change
• The database
• The table name
• The rowid of the row

[carbureted]

+1, this would be great to have. Polling my db way too much right now..

[JohnKossa]

Already added in commit b8f718c.

That being said, this doesn't appear to be anywhere in the README or the API.

[carbureted]

Huh, cool. I can't test right now, but it looks like it would be used with something like the following?

var db = new sqlite3.Database(file, ['sqlite3.OPEN_READONLY']);

db.on('insert', function() {
console.log('inserted!')
})

[sohailsomani]

That commit is missing a corresponding change in Database::Configure as far as I can tell.

[devlesedi]

Is there a solution for this? On my web app I want to listen to data changes.

[alajmo]

This feature would be really nice to have.

[ushalin]

Any update on this feature?

[natew]

Would be awesome to see!

[bpasero]

I am able to get the events working (with this change: bpasero@1f1e2c8). However, this event does NOT work when multiple connections are used across multiple processes. I believe they only work for a single connection.

[vishnuprasad-95]

Any update on this?

[pwner4once]

Any update on this feature? It seems rather useful to have but why is this fallen on silent ears?

[daniellockyer]

There is an open PR to fix the implementation here: #1267

[maxpert]

Merge it please 😢 I desperately need it!