Increase list List data is stored in Mysql

Hi!
Guys, I did some searches here in the community and didn’t find how to create a list that as the user scrolls up, the list increases. List data is stored in Mysql.
Watch this video from the Aliexpress app. Of course, the app lists more than 500 items or more, and the app certainly shouldn’t load all of that at once.
The app I’m making has a list of ads. I’m wondering how business applications work with large lists? I have to take into account that there are places with weak internet signal. Could anyone tell me how these apps like aliexpress, facebook work?
How to do this? Load list as user swipes up?
I’m using the ColinTreeView with image extension.

Check out the video I made of the Aliexpress app list.