News for hackers. Stuff that matters.
Re:Cold Showers: For when people get too hyped up about things by bob1029 on Friday July 24, 2020 @03:30PM (#23943519)
WAL mode is how you address this problem with SQLite.

See: https://www.sqlite.org/wal.html

"Write transactions are very fast since they only involve writing the content once (versus twice for rollback-journal transactions) and because the writes are all sequential. Further, syncing the content to the disk is not required, as long as the application is willing to sacrifice durability following a power loss or hard reboot."

Re:Cold Showers: For when people get too hyped up about things by JAlexoid on Friday July 24, 2020 @09:04PM (#23946042)
As long as you don't mind volatile memory issues, that is.