This is true that the application process will not have visibility or can rely on the behaviour of the OS. But, SQLite does give you the ability to hint that writes can be stored in the buffer (with pragma sync=x), and you might be able to measure it with ebpf/dtrace probes for kernel functions. Im just wondering if I had two processes that exhibit that pattern (new data written by A, immediately read by B) if they would see oodles of perf increases.