Pagination and Search

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