Is it even possible to do server side paging towards the database if ordering can not be guaranteed?

[PerArneng]

The example paging provider in the source repository does an offset/limit query on each page. According to ex the PostgreSQL documentation it's not recommended to do that without an order by. https://www.postgresql.org/docs/current/queries-limit.html . Is it even possible to make reliable server-side paging when the order is not guaranteed?

[PerArneng]

One solution that seems to work is to have database views that contain order by to ensure that there is an order

[wog48]

Actually, also server driven paging shall by default create an ORDER BY primary key, as it is done for client driven paging with $top and $skip. This is a bug.

[wog48]

I have created a correction. See PR #194.

Please try it out. In case you still face a problem, reopen the issue