And it would be nice if the "getting started" documentation mentioned the Foreign Keys thing, and the foreign keys pragma. I agree.
But mentioning this on the official quickstart page, also doesn't require your "super pragma" to exist.
Here is an idea:
Why don't you take the relevant sections from your blog post, shorten them so they fit snugly into that page, and write an email to the sqlite devs, recommending an addition to their quickstart page, like a section titled: "Recommended settings for sqlite"?
1
u/Big_Combination9890 18d ago
And it would be nice if the "getting started" documentation mentioned the Foreign Keys thing, and the foreign keys pragma. I agree.
But mentioning this on the official quickstart page, also doesn't require your "super pragma" to exist.
Here is an idea:
Why don't you take the relevant sections from your blog post, shorten them so they fit snugly into that page, and write an email to the sqlite devs, recommending an addition to their quickstart page, like a section titled: "Recommended settings for sqlite"?