Comment by SomeOldThrow

Sqlite has put immense effort into this—it’s a better fopen!

That said, my understanding is that handling this with cross-platform, posix-only code is mostly impossible due to behavior like what’s described in the article.