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 Someone on Tuesday February 16, 2021 @05:42AM (#26152722)
I don’t think you can atomically append more than one byte to files in unixes (the write call can return after having written some but not all requested bytes)

(Haven’t googled, but if that’s possible, I don’t see why write would have that limitation)

[ Parent | on HN ]
Re:Many small queries are efficient in SQLite by LunaSea on Tuesday February 16, 2021 @07:37AM (#26153305)
Interesting and confirmed in the write() syscall man pages. Thanks!

Do you have any other resources regarding these types of low level "gotchas"?

I remember PostgreSQL having such an issue two years ago for example.

[ Parent | on HN ]
Re:Many small queries are efficient in SQLite by millstone on Tuesday February 16, 2021 @06:23AM (#26152923)
Yeah, and eventually we reach the best-effort bedrock. Maybe the file is on a NFS mount, you call write(), it goes over the wire, who knows what happens!
[ Parent | on HN ]