← All projects

Pagination and Search

Paginate the feed and search post text.

Goal

This snapshot advances Baltic Post by teaching you to paginate the feed and search post text.

Every numbered folder is a complete app. Run this stage independently, then compare it with the previous folder.

Prerequisites

Use JDK 17+, Gradle, and Docker for Postgres stages.

Port 8090 must be free. Copy .env.example before starting database stages.

  • JDK 17+ and Gradle
  • A code editor and terminal
  • Docker from part 4 onward

Concepts

Page size 5. Search filters before paginating.

Keep handlers thin: routes accept input, Exposed tables enforce rules, and FreeMarker escapes output by default.

Walkthrough

Accept q and page query params.

Read the example, then open the matching snapshot. The repository includes the surrounding setup and error handling.

query.limit(5, offset = ((page - 1) * 5).toLong())

Run and verify

Enter 10-Pagination-And-Search, run Gradle, copy .env.example, and start Ktor on port 8090.

Open http://127.0.0.1:8090. Watch the terminal for validation and database errors.

docker compose up -d
git clone https://github.com/michaeldunga1/fcc-ktor-blog.git
cd fcc-ktor-blog/10-Pagination-And-Search
cp .env.example .env
./gradlew run

Troubleshooting

Off-by-one often comes from mixing 0-based offsets with 1-based pages.

For database failures, confirm Docker and the baltic_NN name when applicable. Never commit .env or local.properties secrets.

  • Read the first error first
  • Restart after environment changes
  • Never commit secrets

Try this

Search for ownership and confirm matching cards.

Test a happy path and one invalid or unauthorized request.

  • Make one small change
  • Test it in the browser
  • Compare with the next snapshot only after it works

Related tutorials