SQLite 3.21 Picks Up F2FS Atomic Write Support

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.