How to implement Pagination with Ktor and Kmongo

Question

Problem: To Implement Pagination on the server side using Ktor and Kmongo.

Tech Stacks:

Kotlin as Programming Language.

Ktor as Web Framework.

MongoDb as database.

Kmongo as Sql framework.

I cannot find any tutorial or posts that describes to implement pagination with Database in Ktor.

Did you implement something and stuck? I don't think there are such specific tutorials. — Aleksei Tirman, Jan 13 '22 at 12:51
Then just use those values to calculate an offset and limit to retrieve only specific documents from MongoDB https://stackoverflow.com/a/15387497/13963150. — Aleksei Tirman, Jan 13 '22 at 17:59

score 0 · Accepted Answer · answered May 08 '22 at 16:45

This is how I implemented the same.

override suspend fun getAllUsers(page: Int, limit: Int): List<User> {
    return database.getCollection<User>().find().skip(skip = (page - 1) * limit).limit(limit = limit)
        .partial(true).descendingSort(User::lastLoginTime).toList()
}

Thanks to @Aleksei Tirman.

For More see - https://stackoverflow.com/a/15387497/13963150

How to implement Pagination with Ktor and Kmongo

1 Answers1