This project creates a specialized SQLite database for studying the Hebrew Bible (Tanach). It's designed to be a companion tool for studying sensus plenior (the deeper meaning of Scripture) and supports the work at 2nd Book (here and here).
You will notice in the import script we are stripping the niqqud (vowel markings) and other diacritics. That is because we are focused on studying the Hebrew text as it was originally written by God. The niqqud were added centuries after Christ (The Dead Sea Scrolls for instance do not contain those markings).
This is the first phase of a larger project. Currently, we are:
- Parsing the Tanach into a searchable database
- Incorporating Strong's numbers and lemmas for word reference
- Importing dictionary definitions from the Hebrew Lexicon provided by the OpenScriptures project
- Python 3.x
- Git (for cloning with submodules)
-
Clone the repository with submodules:
git clone --recursive [repository-url]
Or if already cloned:
git submodule update --init --recursive
-
Install requirements:
pip install -r requirements.txt
To generate the database:
make
This will:
- Create a new bible.db file
- Parse the Hebrew Bible text
- Import lexical reference data
- Generate the complete database
Additional make commands:
make clean # Remove the bible.db file
make rebuild # Clean and regenrate the database
The project provides several ways to study the Hebrew text:
There is a FastAPI server that provides word formation searches:
- Start the API server:
uvicorn main:app --reload
- Access the API:
- Test endpoint: http://localhost:8000/
- Word formation search: http://localhost:8000/query/{hebrew_word}
Example queries are provided in:
- query-bible.sql - Basic search examples
- search-letter-pairs.sql - Find word relationships through letter substitutions
- search-letter-pairs-with-refs.sql - Same as above but includes verse references
To run the example queries:
sqlite3 bible.db < query-bible.sql
Future development will include:
- Enhanced search tools for word relationships
- Cross-referencing capabilities
- Tools for discovering hidden meanings (sensus plenior)
- Integration with Bible study workflows
- Additional features to support the 2nd Book project
The goal is to make this a widely accessible tool for deeper Bible study, enabling anyone to explore the original Hebrew text and discover its hidden meanings.