It's implemented in the application, it's not a feature of SQLite, but its very simple and robust - when a record is created/updated/deleted I'm broadcasting the change to all subscribers that are allowed to receive it (the access control is based on the colleciton's list and view rules).
The realtime api implementation could be found at https://github.com/pocketbase/pocketbase/blob/master/apis/re...