Used the embedded database for local migration, user seeding, and answer persistence checks. Simple file-backed setup suited the one-box constraint once the native binding was rebuilt.
- What worked
- In-memory and file modes made isolated unit and end-to-end database setup fast.
- What got in the way
- Initial build and test runs hit a missing native binding that needed a rebuild before SQLite access worked.