The "simple" Bible schema that turns into a data modeling minefield
Jon Skeet's attempt to model Bible text in a tidy translation/book/chapter/verse schema collides with verse ranges, missing verses, alternate numbering, repeated chapters, and out-of-order text. The walkthrough shows how naive domains smuggle in real complexity, and why you should model only the complexity you actually need.