I have a listview that is linked to backend query (API) which is refreshed when a new record is inserted in the database (supabase realtime).
It works nicely when a new item is added, scrolling down adding the new record, without refreshing the whole listview.
But when I add infinite scroll to the backend query, the listview refreshes entirely (full reload), which is not a desired UI experience.
I recorded two videos, the first one with the undesired experience (with infinite scroll) and the second one with the desired experience (without infinite scroll).
How could I avoid the full listview reload when using infinite scroll?