Postgres also does not synchronously replicate for free. You can setup both to get a confirmation write if you require that durability.

▲ orf 7 hours ago | parent | next [-]

> postgresql also does not synchronously replicate

By default. Generally your primary database is in a completely different failure category than a kubernetes node running an ephemeral workflow pod.

	▲	0cf8612b2e1e 6 hours ago \| parent [-]
		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.

▲ paulddraper 7 hours ago | parent | prev [-]

Not for free, but without the needing additional software.

  synchronous_commit = on

	▲	0cf8612b2e1e 7 hours ago \| parent [-]
		That’s about the local transaction, not replication. SQLite WAL also gives you strict durability. `PRAGMA synchronous = full`