---
id: 863714f3-635e-427a-a1fb-499b14b192e8
type: RELATED_TO
from_id: 1b71b163-b56f-4226-9731-a76ef245e532
from_title: "Fix: sqlx in-memory SQLite pool requires max_connections=1"
to_id: 77c0b897-4124-432f-84de-700ff82dcde1
to_title: "Two-phase cached loading pattern for API-heavy screens in Rust TUI"
strength: 0.75
created: "2026-03-02T02:20:58.504326+00:00"
updated: "2026-03-02T02:20:58.504326+00:00"
---

The in-memory SQLite connection isolation issue is relevant to any pattern using transactions with sqlx pools, including the two-phase cached loading pattern's upsert_standings_cache which runs inside the pool. Production (file-based) pools are unaffected, but any test that exercises cached loading with an in-memory pool must use max_connections=1.