Tool 04 · SQLite transaction planner
Draft it, then have it reviewed
Checked for specificity, for evidence, and for whether anything here could be acted on tomorrow.
This plans how your import writes to SQLite so a failure never leaves half a record. Write what identifies a record, which tables each change writes to, where the transaction commits, and what rolls back when something fails.