If you don't need a ton of throughput I think `absurd` (and our Rust derivative `durable`) are very nice options that keep the client side extremely simple. It's also lightweight enough that a coding agent can keep the entire thing in its head easily and just run queries to look up state as needed.
cross-checking your profile suggests that https://github.com/tensorzero/durable is the repo you're referring to
You might consider another name for it, that one is wholly ungoogle-able! Looks neat though