PaginatedDataTable and paginated data from the server

[ghost]

Hi!!
Does it make any sense that the PaginatedDataTable widget doesn't support paginated data from the server instead of fetching all the data?
When the tables on the server are very large, which happens most of the time, the correct thing to do is to take the data as it is being displayed.
Thanks a lot.

[darshankawar]

@Josua2012
There's this community plugin which seem to handle such scenario, https://pub.dev/packages/advanced_datatable
Check it out and see if it answers your question. Also check this article for your further reference https://levelup.gitconnected.com/server-side-paginated-data-table-in-flutter-d01b16f30f3

[ghost]

I had seen this widget, but it doesn't work too well, it has problems, and the logical thing is that the Flutter PaginatedDataTable widget included this functionality. It is an essential functionality that should have been included from the beginning. I do not understand how it has not been included. :(

[darshankawar]

Check this open proposal and see if it'll help to answer your question.

[ghost]

From what I see it is a request that other users also have. It is normal. It is an essential feature for working with any data source, since you can never know if it will contain many or few rows, and it is not admissible, nor logical, to work with all the rows in memory.

[darshankawar]

How's the current behavior when data is being showed from the server ? Does it not show as-is ?

[ghost]

The current behavior is that all rows are fetched from the server.
The desired behavior is that it only get the rows of the page that is being displayed.
If there are a million rows on the server, it would only take the rows that are being seen in the widget, for example, if the page is 30 rows long, it would only get 30 rows from server.

[darshankawar]

Keeping this issue open for further insights from the team and labeling it as a proposal.

Reference: #87348 (comment)

Cc: @HansMuller

[jagadishnallappa]

Hi, any news as to when this will be supported?

[Patrick386]

This function must be supported. When will it be possible?

[james-poulose]

Waiting for this feature!

[chhinsras]

Any update server side tendering

[Conezi]

onPageChanged: (firstIndex){
if(firstIndex + _rowsPerPage >= data.length){
//Load more
}
}

You can try loading more data than you render per page, then use the above lines of code to load more data before/when it runs out.

[rsiva229]

This is a good workaround but what will you do about the wrong number of records being shown in the footer?

It is sure to mislead the user into thinking that there are only less number of records present.

[darshankawar]

Please upvote the original issue description and avoid commenting +1 or asking for updates. The team also prioritize the issue based on number of upvotes.

[ercantomac]

At least we should be able to make the getRow() function asynchronous inside our DataTableSource class:

@override
  DataRow getRow(int index) async {
    await fetchPaginatedData();
    return DataRow(
      cells: <DataCell>[
        ...
      ],
    );
  }

[francois-robert]

Waiting for this as well

[BangPei]

@Josua2012 There's this community plugin which seem to handle such scenario, https://pub.dev/packages/advanced_datatable Check it out and see if it answers your question. Also check this article for your further reference https://levelup.gitconnected.com/server-side-paginated-data-table-in-flutter-d01b16f30f3

Thanks, it works for me.

[Jarcccmd]

Waiting for this feature!