Data Layer

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