> postgresql also does not synchronously replicate
replyBy default. Generally your primary database is in a completely different failure category than a kubernetes node running an ephemeral workflow pod.
Either you have durable storage or you do not. SQLite and Postgres can both ensure local durability of commits. If you want distributed durability, you need to ship that data elsewhere. That is another Postgres node, object store, whatever that’s still an external dependency.
replyNot for free, but without the needing additional software.
reply synchronous_commit = onThat’s about the local transaction, not replication. SQLite WAL also gives you strict durability.
reply PRAGMA synchronous = full