I haven't approached pagination yet, but in Supabase there is a built-in pagination feature \"limit\" and \"offset\" we can use. Then it become a matter of constructing the front end. I don't know if my initial thoughts will help you but maybe it will spark some ideas.

The only thought I could lend for dynamic children is to see if the JSON can be imported and hosted as an API somewhere. Then, you can use some built-in pagination features. Maybe explore Fastgen to see if they can parse it on demand?

For the UI:

Retrieve count of records retrieved. (i.e., 129.)
If totalRecords is less than maxLimit (300), then totalRecords = retrievedRecords.
Fix the limit to 20 and only returns the handful of columns.
Calculate totalPages. (129/20 = 7)
Use the formula to set the App State Variable using a Data Struct list (displayPageNumber, limit, offset, totalRecords, totalPages, currentPage) so this will maintain the details to go to the page (i.e., 1,20,1,129,7; 2,20,1,129,7, etc.). I'll modify this when I get into it.
Build the pagination footer
1. Start out with simple numbering. (1 2 3 4 5 6 7)
2. Thinking about a horizontal list view with the page number derived from App State Variable.
3. Each \"rows\" action is the display number and will retrieve the appropriate set of records.

pagination on dinamic childrens