Without the "making sure data written to disk after power loss" part you won't get serialization either in modern storage stacks.
Without the "making sure data written to disk after power loss" part you won't get serialization either in modern storage stacks.
As I mentioned in the other comment, https://www.sqlite.org/fileformat2.html#the_write_ahead_log WAL uses checksum to make sure there is no holes for its writes. I need to do more analysis, but it goes beyond just rely on fwrite to do the right thing for serialize the writes (I think it is "re-order writes" safe, but I cannot guarantee that without thinking more about it).