My understanding is litestream can lose data if a crash occurs before the backup replication to object storage. This makes it an unfair comparison to a Postgres in RDS for example?

▲

andersmurphy 7 hours ago | parent | next [-]

Last I checked RDS uploads transaction logs for DB instances to Amazon S3 every five minutes. Litestream by default does it every second (you can go sub second with litestream if you want).

▲

rienbdj an hour ago | parent [-]

Yes but there is still a (small) window where confirmed writes can be lost

	▲	andersmurphy an hour ago \| parent [-]
		Right and that window is bigger for RDS by the looks of it.

▲

sudodevnull 7 hours ago | parent | prev [-]

your understanding is very wrong. please read the docs or better yet the actual code.

	▲	rienbdj an hour ago \| parent [-]
		Please can you link to the relevant guarantees? I did read the documentation just today so clearly misunderstood something!