Why You Shouldn't Use OFFSET and LIMIT For Your Pagination
ivopereira.net
Gone are the days when we wouldn’t need to worry about database performance optimization.

If you are wondering why lemmy is moving away from offset pagination since 0.19, here is a nice article about it