Durable Execution (DE) engines allow for the persistence of multi-step workflows, enabling them to resume from the last successful step after interruptions. This article explores the development of a simple DE engine called Persistasaurus in Java, which utilizes SQLite for logging execution state and highlights key implementation choices.

• Persistasaurus implements durable execution in Java by logging each step's execution state to SQLite, allowing workflows to resume from the last successful step after a crash.
• SQLite's single-file, embedded, transactional nature makes it a lightweight yet reliable choice for storing execution logs without needing a separate database server.
• The design records both function inputs/outputs and step completion status, so re-running a workflow skips already-completed steps and replays their cached results instead of re-executing side effects.