Code Monkey home page Code Monkey logo

bible-database's Introduction

Bible Database

This database files are released to help developers in easily developing Bible applications, Developers also requested to raise patches for any fixes found in the database files.

Usage

This branch contains sql files, sqlite database XML and JSON database for Bible in these languages currently: #. English #. Malayalam #. Hindi #. Telugu #. Tamil #. Kannada #. Oriya #. Gujarati #. Bengali #. Punjabi #. Marathi #. Zulu #. Indonesian #. Xhosa #. Afrikaans #. Sepedi #. Nepali #. Hungarian

SQL Database

SQL Database is having fields Book, Chapter, Versecount which are of type INT and verse field which is VARCHAR. The Book field starts from 0 and Chapter & Versecount from 1. Below is a sample SQL query for fetching John 3:16

Select Book,Chapter,Versecount,verse from bible where Book=42 and Chapter=3 and Versecount=16;

XML Database

XML Database is having fields Book, Chapter, Verse which are to having keys called 'id'. The Book id starts from 0 and Chapter & Verse from 1.

JSON Database

JSON Database have fields Verse & Verseid. Verseid field is a unique id which is a comibination of Book + Chapter + Verse. First two digits represents Book(0 - 65), Second three digits represent Chapter and last three digits represent Verse. For JSON Database, Book, Chapter and Verse starts from 0. Below is a sample PHP code for fetching John 3:16;

>>> <?php >>> $filecontent = file_get_contents("bible.json"); >>> $books = json_decode($filecontent); >>> echo $books->Book[42]->Chapter[2]->Verse[15]->Verse; >>> ?>

Javascript Example

>>> var bible; >>> function readJsonFile() { >>> var rawFile = new XMLHttpRequest(); >>> rawFile.overrideMimeType("application/json"); >>> rawFile.onreadystatechange = function() { >>> if (rawFile.readyState === 4 && rawFile.status == "200") { >>> bible = JSON.parse(rawFile.responseText); >>> } >>> }; >>> rawFile.open("GET", "bible.json", true); >>> rawFile.send(); >>> } >>> >>> function queryverse(book, chapter, verse) >>> { >>> return bible.Book[book - 1].Chapter[chapter - 1].Verse[verse - 1].Verse; >>> }

Users can clone this repo by typing :

git clone https://github.com/godlytalias/Bible-Database.git

Help, bugs, feedback

  1. Users can mail their queries, feedback and suggestions at [email protected]
  2. Developers/Contributor can raise issues at issues or by mail
  3. Pull requests are most welcome, Please fix if any bugs found and push the patches.

Credits

The databases are created by extracting data from Wordproject®

License

GNU GPL Version 3, 29 June 2007.

Please refer this link for detailed description.

All rights belong to Godly T.Alias.

Copyright © 2015

bible-database's People

Contributors

godlytalias avatar samraj-dev avatar sridharrajs avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

bible-database's Issues

Why these repo doesn't have API

It would be nice as JSON is very much built with all these languages, and accessing these APIs with their language and ver_id to fetch data directly.

Releasing scripts

Hi, I'm currently developing a website for a Hungarian church community, and I'd like to add advanced search functionalities, which require the whole Bible, in Hungarian, to be stored in the database. I really don't want to manually add the entire Scripture to my database, but I've found the Hungarian translation on Wordproject.org, so it would be greatly appreciated if you could release the scripts you used to extract the translations found in this repo, so I can extract the Hungarian translation, and maybe contribute it here as a patch or merge request, for others to make good use of.

What version is the English bible?

There are differences between the english bible you included and the King James Version. For example:
Genesis 4:18 in your version reads "And Jared lived an hundred sixty and two years, and he brings forth Enoch:" while in the King james verison it reads ""And Jared lived an hundred sixty and two years, and he begat Enoch:"

Discrepancies like this are all over the place. I understand that the English version you provided is perhaps not the King James Version. However, you need to TELL US what version this actually is.

Add Marathi Bible

Hey,

This repository is really great and is helping me with one of my projects! It'd be super great if you could add a marathi bible as well, as it's required by the project.

I have attached this sqlite3 file. Would be great if you could convert the schema into the common one that's being used by remaining of the bibles in this repo!!

Awaiting response,
This would mean the world to me.
Delwin

ERV-mr.zip

Verse Counts not following Afrikaans Bible's structure

I went though your json version of the Afrikaans Bible to do some verification of verse counts for every chapter. My json version follows the Afrikaans Bible's structure.

I found the following differences between your("git") and my("m") version:
([book number, book name, chapter number] - verse counts)

02 Exodus 5 - m:24 git:23
02 Exodus 6 - m:29 git:30
09 I Samuel 20 - m:43 git:42
09 I Samuel 23 - m:28 git:29
09 I Samuel 24 - m:23 git:22
11 I Konings 2 - m:47 git:46
11 I Konings 22 - m:54 git:53
16 Nehemía 8 - m:19 git:18
18 Job 38 - m:38 git:41
18 Job 39 - m:38 git:30
18 Job 40 - m:28 git:24
18 Job 41 - m:25 git:34
19 Psalms 3 - m:9 git:8
19 Psalms 4 - m:9 git:8
19 Psalms 5 - m:13 git:12
19 Psalms 6 - m:11 git:10
19 Psalms 7 - m:18 git:17
19 Psalms 8 - m:10 git:9
19 Psalms 9 - m:21 git:20
19 Psalms 12 - m:9 git:8
19 Psalms 18 - m:51 git:50
19 Psalms 19 - m:15 git:14
19 Psalms 20 - m:10 git:9
19 Psalms 21 - m:14 git:13
19 Psalms 22 - m:32 git:31
19 Psalms 30 - m:13 git:12
19 Psalms 31 - m:25 git:24
19 Psalms 34 - m:23 git:22
19 Psalms 36 - m:13 git:12
19 Psalms 38 - m:23 git:22
19 Psalms 39 - m:14 git:13
19 Psalms 40 - m:18 git:17
19 Psalms 41 - m:14 git:13
19 Psalms 42 - m:12 git:11
19 Psalms 44 - m:27 git:26
19 Psalms 45 - m:18 git:17
19 Psalms 46 - m:12 git:11
19 Psalms 47 - m:10 git:9
19 Psalms 48 - m:15 git:14
19 Psalms 49 - m:21 git:20
19 Psalms 51 - m:21 git:19
19 Psalms 52 - m:11 git:9
19 Psalms 53 - m:7 git:6
19 Psalms 54 - m:9 git:7
19 Psalms 55 - m:24 git:23
19 Psalms 56 - m:14 git:13
19 Psalms 57 - m:12 git:11
19 Psalms 58 - m:12 git:11
19 Psalms 59 - m:18 git:17
19 Psalms 60 - m:14 git:12
19 Psalms 61 - m:9 git:8
19 Psalms 62 - m:13 git:12
19 Psalms 63 - m:12 git:11
19 Psalms 64 - m:11 git:10
19 Psalms 65 - m:14 git:13
19 Psalms 67 - m:8 git:7
19 Psalms 68 - m:36 git:35
19 Psalms 69 - m:37 git:36
19 Psalms 70 - m:6 git:5
19 Psalms 75 - m:11 git:10
19 Psalms 76 - m:13 git:12
19 Psalms 77 - m:21 git:20
19 Psalms 80 - m:20 git:19
19 Psalms 81 - m:17 git:16
19 Psalms 83 - m:19 git:18
19 Psalms 84 - m:13 git:12
19 Psalms 85 - m:14 git:13
19 Psalms 88 - m:19 git:18
19 Psalms 89 - m:53 git:52
19 Psalms 92 - m:16 git:15
19 Psalms 102 - m:29 git:28
19 Psalms 108 - m:14 git:13
19 Psalms 140 - m:14 git:13
19 Psalms 142 - m:8 git:7
20 Spreuke 23 - m:36 git:35
21 Prediker 4 - m:17 git:16
21 Prediker 5 - m:19 git:20
23 Jesaja 8 - m:23 git:22
23 Jesaja 9 - m:20 git:21
27 Daniël 5 - m:30 git:31
27 Daniël 6 - m:29 git:28
28 Hoséa 1 - m:12 git:11
28 Hoséa 2 - m:22 git:23
28 Hoséa 11 - m:11 git:12
28 Hoséa 12 - m:15 git:14
28 Hoséa 13 - m:15 git:16
28 Hoséa 14 - m:10 git:9
33 Miga 4 - m:14 git:13
33 Miga 5 - m:14 git:15
43 Johannes 1 - m:52 git:51
44 Handelinge 19 - m:40 git:41
45 Romeine 7 - m:26 git:25
47 II Korinthiërs 13 - m:13 git:14
64 III Johannes 1 - m:15 git:14
66 Openbaring 12 - m:18 git:17

Upon inspection, I found things like the following:

  1. Multiple verses in one verse entry:
  • {'Verseid': '44006024', 'Verse': 'Ek dank God deur Jesus Christus, onse Here! (7:26) So dien ek self dan wel met die gemoed die wet van God, maar met die vlees die wet van die sonde."'}

  • {'Verseid': '63000013', 'Verse': 'Maar ek hoop om jou gou te sien, en ons sal van mond tot mond spreek. (1:15) Vrede vir jou! Die vriende groet jou. Groet die vriende by die naam."'}

  • {'Verseid': '65012000', 'Verse': '(12:18) En ek het op die sand van die see gaan staan. (13:1) En ek het ‘n dier uit die see sien opkom met sewe koppe en tien horings, en op sy horings tien krone en op sy koppe ‘n naam van godslastering."'}

  1. Json chapter entry spanning two Bible chapters:
  • {'Verseid': '17039004',
    'Verse': '(39:38) Een maal het ek gespreek, maar sal nie meer antwoord nie; ja, twee maal, maar ek sal nie voortgaan nie."'},
  • {'Verseid': '17039005',
    'Verse': '(40:1) En die HERE het Job uit ‘n storm geantwoord en gesê:"'},

Is there a specific reason for doing it this way? Is this a design choice? I do not want to propose a fixes if it will break your design/intention.

Found minor translations mistake in Malayalam version.

Acts 17:1 - അന്ത്യൊക്ക്യയിലെ സഭയിൽ ബർന്നബാസ്, നീഗർ എന്നു പേരുള്ള ശിമോൻ, കുറേനക്കാരനായ ലൂക്യൊസ്, ഇട പ്രഭുവമായ ഹെരോദാവോടുകൂടെ വളർന്ന മനായേൻ, ശൌൽ എന്നീ പ്രവാചകന്മാരും ഉപദേഷ്ടാക്കന്മാരും ഉണ്ടായിരുന്നു.

Here instead of "ഇട പ്രഭുവമായ" it should be "ഇടപ്രഭുവായ"

Acts 14:6 - ദെർബ്ബ ഇന്ന ലുക്കവോന്യപട്ടണങ്ങളിലേക്കും ചുറ്റുമുള്ള ദേശത്തിലേക്കും

Here instead of "ഇന്ന" it should be "എന്ന"

Acts 17:18 - എപ്പിക്കൂര്യരും സ്തോയിക്കരും ആയ തത്വജ്ഞാനികളിൽ ചിലർ അവനോടു വാദിച്ചു: ഈ വിടുവായൻ എന്തു പറവാൻ പോകുന്നു എന്നു ചിലരും അവൻ യേശുവിനെയും പുനരുത്ഥാനത്തെയും പ്രസംഗിക്ക കൊണ്ടു: ഇവൻ അന്യദേവതകളെ ഘോഷിക്കുന്നവൻ എന്നു തോന്നുന്നു മറ്റു ചിലരും പറഞ്ഞു

Here, the correct is like this: എപ്പിക്കൂര്യരും സ്തോയിക്കരും ആയ തത്വജ്ഞാനികളിൽ ചിലർ അവനോടു വാദിച്ചു: ഈ വിടുവായൻ എന്തു പറവാൻ പോകുന്നു എന്നു ചിലരും അവൻ യേശുവിനെയും പുനരുത്ഥാനത്തെയും പ്രസംഗിക്ക കൊണ്ടു: "ഇവൻ അന്യദേവതകളെ ഘോഷിക്കുന്നവൻ എന്നു തോന്നുന്നു" എന്നു മറ്റു ചിലരും പറഞ്ഞു

Here, i have added extra "എന്നു" and added quotes

Acts 17:25 - കൈപ്പണിയായ ക്ഷേത്രങ്ങളിൽ വാസം ചെയ്യുന്നില്ല. താൻ എല്ലാവർക്കും ജീവനും ശ്വാസവും സകലവും കൊടുക്കുന്നവൻ ആകയാൽ വല്ലതിന്നും മുട്ടുള്ളവൻ എന്നപോലെ മാനുഷ്യകൈകളാൽ ശുശ്രൂഷ ആവശ്യപ്പെടുന്നില്ല.

Here, instead of "മാനുഷ്യകൈകളാൽ", it can be either "മാനുഷകൈകളാൽ" or "മനുഷ്യകൈകളാൽ"

Acts 17:26 - ഭൂതലത്തിൽ എങ്ങു കുടിയിരിപ്പാൻ അവൻ ഒരുത്തനിൽനിന്നു മനുഷ്യജാതിയെ ഒക്കെയും ഉളവാക്കി, അവരുടെ നിവാസത്തിന്നു അതിരുകളും കാലങ്ങളും നിശചയിച്ചു.

Here instead of "നിശചയിച്ചു", it should be "നിശ്ചയിച്ചു" or "നിശ്‌ചയിച്ചു"

Acts 18:12 - ഗല്ലിയോൻ അഖായയിൽ ദേശഅധിപതിയായി വാഴുമ്പോൾ യെഹൂദന്മാർ പൌലൊസിന്റെ നേരെ ഒരുമനപ്പെട്ടു എഴുന്നേറ്റു, അവനെ ന്യായാസനത്തിന്റെ മുമ്പാകെ കൊണ്ടു ചെന്നു:

Here instead of "ദേശഅധിപതിയായി", it should be "ദേശാധിപതിയായി "

Acts 19:31 - ആസ്യധിപന്മാരിൽ ചിലർ അവന്റെ സ്നേഹിതന്മാർ ആകയാൽ: രംഗസ്ഥലത്തു ചെന്നു പോകരുതു എന്നു അവരും അവന്റെ അടുക്കൽ ആളയച്ചു അപേക്ഷിച്ചു.

Here instead of "ആസ്യധിപന്മാരിൽ" it should be "ആസ്യാധിപന്മാരിൽ"

Acts 20:34 - എന്റെ മുട്ടിനും എന്നോടുകൂടെയുള്ളവർക്കും വേണ്ടി ഞാൻ ഈ കൈകളാൽ അദ്ധ്വാനിച്ചു എന്നു നങ്ങൾ തന്നേ അറിയുന്നുവല്ലോ.

Here instead of "നങ്ങൾ" it should be "നിങ്ങൾ"

Verse Missing in Tamil/bible.json -> II-Timothy -> 2:1

Verse Missing in Tamil/bible.json -> II-Timothy -> 2:1
II தீமோத்தேயு
2 அதிகாரம்
1. ஆதலால், என் குமாரனே, நீ கிறிஸ்து இயேசுவிலுள்ள கிருபையில் பலப்படு.
This Verse is added and because of this the subsequent verse IDs get changed till II-Timothy Chapter 4

This Correction done by me and the json file attached here. Please review and commit it.

Tamil/bible.json

Thanks,
JONES J

Hungarian translation corrections

According to @godlytalias the recently added Hungarian translation has some issues with some verses (see #13). Being Hungarian, and owning a hard copy of this translation, I will proofread the wordproject.org version, and add the necessary corrections in this thread.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.