feedsignal/crates/db/migrations/2026-08-21-000000_init
Austin Schaefer a8d4599a03
Some checks failed
CI / check (push) Failing after 10s
Replace sqlx with Diesel + diesel-async for compile-time-checked queries
sqlx's query!/query_as! macros only check raw SQL strings against the live
schema; Diesel's table!-derived DSL type-checks query structure itself at
compile time. SQLite has no native async driver, so diesel-async wraps a
blocking SqliteConnection via SyncConnectionWrapper, pooled with bb8.

Migrations move from sqlx's single-file-per-migration format to Diesel's
up.sql/down.sql pairs, run transactionally via diesel_migrations against a
throwaway sync connection at boot (MigrationHarness needs a sync
Connection), giving revertable migrations that sqlx::migrate! doesn't
support.

Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>
2026-08-21 11:04:38 +02:00
..
down.sql Replace sqlx with Diesel + diesel-async for compile-time-checked queries 2026-08-21 11:04:38 +02:00
up.sql Replace sqlx with Diesel + diesel-async for compile-time-checked queries 2026-08-21 11:04:38 +02:00