SQLite 3.21 Picks Up F2FS Atomic Write Support

Written by Michael Larabel in Free Software on 24 October 2017 at 05:55 PM EDT. 7 Comments
SQLite 3.21 is now out as the newest feature release for this widely-used embedded database library.

The first feature up for SQLite 3.21 when running atop the Flash-Friendly File-System and with SQLite built with batch atomic write enabled, it now supports the atomic-write capabilities of F2FS. This mode should yield "greatly reduced" transaction overhead. F2FS is the first file-system supporting batch atomic write behavior for SQLite and then doesn't write to the rollback journal for making transactions up to twice as fast while reducing SSD wear and tear.

SQLite 3.21 also now supports ATTACH/DETACH commands inside a transaction, fewer stat system calls are issued now by the Unix VFS, and a variety of bug fixes and other minor improvements. Various microoptimizations to SQLite 3.21 have also yielded around a two percent drop in CPU usage.

Details on all the SQLite 3.21 release available from SQLite.org. I'll likely be trying the new batch atomic write functionality soon.
Related News
About The Author
Michael Larabel

Michael Larabel is the principal author of Phoronix.com and founded the site in 2004 with a focus on enriching the Linux hardware experience. Michael has written more than 20,000 articles covering the state of Linux hardware support, Linux performance, graphics drivers, and other topics. Michael is also the lead developer of the Phoronix Test Suite, Phoromatic, and OpenBenchmarking.org automated benchmarking software. He can be followed via Twitter, LinkedIn, or contacted via MichaelLarabel.com.

Popular News This Week