SQLite Forum

Are there any plans / chances of supporting a RETURNING clause?
Login
> Nor can it "listen" for a change and continually update the display of members, which would drive a user crazy.

File management programs do this nowadays (when they can), and it doesn't drive their users crazy; people expect this capability now.  In other applications, it may be better to gray out deleted items rather than removing them from the list.

In an SQLite-based system, this feature could be retrofitted in by using a trigger to call a user-defined ‘doorbell’ function, and having all instances of the table-viewer application listen for this event.  Ideally this function would also be able to communicate the rowids of changed records to listeners.