Doesn't Pi Agent do exactly this? Assuming "append only" means they do some kind of compaction as well.