Identifying Bible Verses Missing in Various Translations

Background Talking to my brother about a query he wanted help on. KJV Unfortunately, I hijacked the conversation and thought it might be saner to write a query that identifies verses that are in KJV but missing in other versions. Outline In the sample code below, we compare KJV (Kings James Version ) against DBY … Continue reading Identifying Bible Verses Missing in Various Translations

Bible – Cross Reference – Study – Using “scrollmapper/bible_databases” – Use Data

Background Let us create a Stored Procedure that will identify Cross References for a bible verse. Code Stored Procedure bible.crossReferenceFetch SQL SQL - Invoke Outline Let us fetch cross-references for Philippians 4:13 I can do everything through him who gives me strength. SQL SQL - Output Image Text   # Book Chapter# Verse # Text … Continue reading Bible – Cross Reference – Study – Using “scrollmapper/bible_databases” – Use Data

Bible – Cross Reference – Study – Using “scrollmapper/bible_databases” – Load Data

Background In the last week or two opted to explore the steps it will take to utilize the CrossReference section of the GitHub project "ScrollMapper/bible_databases".   Outline Artifacts Identify Artifact Review Artifact Download Artifact Review Downloaded Artifact Load Data Review SQL Apply SQL Review Changes   Tasks Artifacts Identify Artifacts ScrollMapper is available @ scrollmapper … Continue reading Bible – Cross Reference – Study – Using “scrollmapper/bible_databases” – Load Data

SQL and Bible Studies:- Books in each Genre

Background The Bible is a collection of books. One can categorize the books in so many different ways. In this post, we will use someone else work. He has categorized bible books into genres.   SQL The work avails a couple of database platforms. In this post, we will provide working samples for Transact SQL … Continue reading SQL and Bible Studies:- Books in each Genre

SQL and Bible Studies:- Number of Chapters in each book

Background As I play around a bit more with MySQL, and needed a database to play with, I sometimes return to a bible database. ScrollMapper bible_databases GitHub ScrollMapper's bible_databases is available on GitHub. Here is a link to the repository:- scrollmapper / bible_databases Link Textual bible-mysql.sql (MySQL) is the main database and most feature-oriented due … Continue reading SQL and Bible Studies:- Number of Chapters in each book