Not much is different now except I don't use NOTIFY anymore due to the 8000 byte payload limitation (and the reason why I made the elixir server)
https://github.com/numtel/pg-live-select/blob/master/lib/tri...
Reading the replication log is probably faster though.
MySQL has row-based replication too and there's clients in most languages if you want to support it on your saas.
Do you have plans to support changes to specific SELECT queries or keep it at the row level?
Yes, we will allow filtering on the listener, just shipping early. Next steps, we will only filter on the Primary keys - something like supabase.from('users:id.eq.1') - but eventually we will support advanced filtering like this: https://supabase.io/docs/library/get#filtering