Pagination with COUNT(*) OVER() in Atlassian Forge SQL: How to avoid double queries — and stay secure in TypeScript

Are you working with @forge/sql and struggling with pagination + total count? Here's a more efficient and safer way to do it using window functions.

Apr 6, 2025 - 13:05
 0
Pagination with COUNT(*) OVER() in Atlassian Forge SQL: How to avoid double queries — and stay secure in TypeScript

Are you working with @forge/sql and struggling with pagination + total count?

Here's a more efficient and safer way to do it using window functions.