← All projects

Data Layer

Persist authors and posts with SQLite and sqlx.

Goal

This snapshot advances Redrock Wire by teaching you to persist authors and posts with SQLite and sqlx.

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

Prerequisites

Use Rust 1.75+, Cargo, and a terminal. No Docker is required for SQLite stages.

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

  • Rust and Cargo
  • A code editor and terminal
  • Optional Docker only if you prefer another database later

Concepts

sqlx talks to a local SQLite file. Each snapshot uses its own database path.

Keep handlers thin: extractors accept input, sqlx queries enforce rules, and Askama escapes output by default.

Walkthrough

Open DATABASE_PATH, migrate tables, seed Ada and Grace.

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

sqlx::query("SELECT ... FROM posts ORDER BY created_at DESC").fetch_all(&pool).await?

Run and verify

Enter 04-Data-Layer, copy .env.example, run cargo run, and start on port 8082.

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

git clone https://github.com/michaeldunga1/fcc-axum-blog.git
cd fcc-axum-blog/04-Data-Layer
cp .env.example .env
cargo run

Troubleshooting

If the home page is empty after a bad migration, delete the .db file and restart.

For database failures, confirm Docker and the *.db name when applicable. Never commit .env or *.db.

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

Try this

Add a minimum title length check before insert.

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