← All projects

Pagination and Search

Paginate the feed and search post text.

Goal

This snapshot advances Solstice Ledger 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 Elixir 1.15+, Mix, and Docker for Postgres stages.

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

  • Elixir and Mix
  • A code editor and terminal
  • Docker from part 4 onward

Concepts

Page size 5. Search filters before paginating.

Keep controllers thin: plugs prepare requests, contexts enforce rules, and HEEx 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))

Run and verify

Enter 10-Pagination-And-Search, fetch deps, copy .env.example, and start Phoenix on port 4001.

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

docker compose up -d
git clone https://github.com/michaeldunga1/fcc-phoenix-blog.git
cd fcc-phoenix-blog/10-Pagination-And-Search
mix deps.get
cp .env.example .env
mix phx.server

Troubleshooting

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

For database failures, confirm Docker and the solstice_NN name when applicable. Never commit .env or _build/deps 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