DataTable: Feature request implement pagination

[adampinky85]

Hi team,

We're extensive users of Python Shiny and its such a great product! We have small feature request to enhance the existing DataTable:

We use shiny.render.DataTable to visual our various datasets. It appears the current design sends the entire dataframe data into the browser in a single websocket message. Where the dataframes are even moderately large with thousand of rows, it results in the browser visibly hanging. With large dataframes in the hundreds of thousands for rows, it often causes the browser to fail entirely.

We have implemented our own pagination mechanism using shiny.ui.input_selectize but this is less than ideal. It requires the user to select a page dropdown where previously users can use the mouse scroll. The existing shiny data grid summary, showing the row message, no longer aligns to the dataframe shape.

Many thanks!

Versions
Python: 3.12.5
shiny: 1.0.0
Operating System: Ubuntu 22.04.4 LTS

cc: @gshotwell and the dataframe epic: #1119

[vindevoy]

You can add iTables to your project very easily. They have an integration: https://mwouts.github.io/itables/shiny.html

This is a screenshot of a very early version of an application I'm building.