News for hackers. Stuff that matters.

A comment on Many small queries are efficient in SQLite. Parent comment

Re:Many small queries are efficient in SQLite by scaladev on Tuesday February 16, 2021 @05:10AM (#26152577)
Here's another good review of the pain you get if you want to get your data to disk safely.

(SQLite does this for you automatically, BTW.)

"Ensuring data reaches disk"

https://lwn.net/Articles/457667/

[ Parent | on HN ]
Re:Many small queries are efficient in SQLite by ori_b on Tuesday February 16, 2021 @09:50AM (#26154318)
> (SQLite does this for you automatically, BTW.)

Unless you're on nfs. Remote file locking is hard, and I don't think that any nfs implementation has gotten to the point where you can trust SQLite on it.

SQLite does updates in place, which I would trust far less than a rename call.

[ Parent | on HN ]