One of the HN threads I'm assuming they're referring to is the recent discussion of strict tables¹, which reads like the other side of this document. It may be interesting to read the comments on the other side directly.

Although, frankly every SQLite thread basically devolves in to the same thing as the TFA notes.

¹ https://news.ycombinator.com/item?id=28259104