News for hackers. Stuff that matters.

A comment on Writing a SQLite clone from scratch in C. Parent comment

Re:Writing a SQLite clone from scratch in C by imtringued on Monday September 04, 2017 @04:11PM (#15170565)
That sounds like a terrible idea even if it were 100% reliable. When you shut down it will have to flush the entire memory at once. If you're syncing to a hdd it can mean several minutes of downtime.
[ Parent | on HN ]
Re:Writing a SQLite clone from scratch in C by pjc50 on Monday September 04, 2017 @04:35PM (#15170700)
A correctly working system will "flush behind", so there should be no difference between a clean shutdown and a power loss. If there's several minutes of unsynced data that's data that will be lost on power off.
[ Parent | on HN ]