Home

BibleGet I/O API Wiki

Technical documentation for the BibleGet I/O API, focusing on the standardized database schema that enables interoperability across Bible editions in multiple languages.

Contents

Schema Standards

• Database Schema -- The canonical table structure shared by all Bible editions
• Index Tables -- How {VERSION}_idx tables describe the shape of each edition
• Unique Verse Identification -- The (book, chapter, verse, verseequiv, verseorigin) composite key

Cross-Edition Alignment

• Bible Editions -- Inventory of all editions with their language, canon, and structural traits
• Esther Greek and Hebrew Variants -- Aligning the Septuagint additions across editions
• Daniel Deuterocanonical Additions -- Prayer of Azariah, Susanna, Bel and the Dragon across editions
• Jeremiah Textual Traditions -- MT vs LXX divergences, current state, and future alignment strategy
• Other Textual Divergences -- MT vs LXX in Job, Tobit, Ezekiel, 1 Samuel, Proverbs, Exodus, and more
• Lettered Sub-Verses -- Handling verse subdivisions (verseequiv) across editions
• Deuterocanonical Books -- Catholic vs Protestant canon differences in the schema
• Psalms Numbering -- Vulgate vs Hebrew numbering and the chapter-swap mapping

Reference

• Book Numbering -- The 1-73 book numbering system and section groupings
• Stored Procedures -- Reusable routines for index generation and data maintenance