Alex Rivera | Logout

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

Asked 2011-01-14T04:01:36.243
27

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
sql mysql database-design
Edit
Report

2 Answers

8

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.

answered 2011-01-14T04:06:50.677
1

Mark Rushakoff's answer is probably the best for you specific need. However more generally if need to store content that either has data within the content or if you need to store data about the content a Content Management System is typically used. You can build your own (which WernerCD's answer had a table structure for) or use a CMS product. The list here shows the wide variety of technologies used (around 30 in this list use MySQL)

answered 2011-01-14T04:56:15.903

Your Answer