https://www.sqlite.org/walformat.html I see this sentence on the above page. Does anybody know what is the underlying C API to achieve this on Mac OS X and Linux? Thanks. "In fact, if there were a mechanism by which SQLite could tell the operating system to never persist the shm file to disk but always hold it in cache memory, SQLite would use that mechanism to avoid any unnecessary disk I/O associated with the shm file."