Search code examples
sqlmysqldatabase-design

What's the best way to store the bible in SQL?

What I'm looking for is a breakdown of table names w/ corresponding fields/types.

The bible I want to store will be in English and needs to support the following:

  • Books
  • Chapters
  • Section Titles (can show up within verses and in-between verses)
  • Smallcaps Text
  • Red Letter Text
  • Verse Numbers
  • Footnotes (can show up within verses and within section titles) (may optionally reference another verse)
  • Cross-references (essentially a footnote that only references another verse and doesn't add any commentary)
  • Anything else I'm forgetting
Solution

  • Rather than reinventing the wheel, you might consider using a "Bible SDK" such as AV Bible, which stores text, formatting, verse numbers, etc. in an open, custom binary format.

    I think they have everything you've listed except cross-references.