News for hackers. Stuff that matters.
Re:Writing a SQLite clone from scratch in C by pletnes on Monday September 04, 2017 @11:30AM (#15168885)
Why not really? From the sqlite docs:

  Beginning with version 3.7.17 (2013-05-20), 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.
Re:Writing a SQLite clone from scratch in C by dkersten on Monday September 04, 2017 @08:30PM (#15171708)
I would say its less that you can’t or shouldn’t use mmap, and more that its not as simple as throwing mmap at it - if you care about crash recovery/not corrupting data (which most databases should care about), but that certainly doesn’t mean that mmap can’t be a part of the solution.