Beginning with version 3.7.17, SQLite has the option of accessing disk
content directly using memory-mapped I/O and the new xFetch() and xUnfetch()
methods on sqlite3_io_methods.
As with the docs about atomic commits, this will be one of the best, succinct, and clear docs you’ll read about memory mapped files, the pros and cons, and how SQLite uses them.
If you are a MongoDB user you should read this.
✚ Check out the HN thread to see how many people love SQLite.
Original title and link: Memory-Mapped I/O in SQLite ( ©myNoSQL)