search

scrollmapper / bible_databases

Bible versions and cross-reference databases.
994 stars 347 forks source link

How to Add Additional Bible to SQLite DB #7

Closed coommark closed 8 years ago

coommark commented 8 years ago

Hi, this is such a wonderful work. Thank you lots for this. I have questions. I want to add another King James Bible to the SQLite db, but this one will have these two added features:

  1. All italicized words (words that were added by the translators to help the reader) will be marked by something like <i>word here</i>.
  2. Words of Jesus (Red Letters) will be marked by something like <span class="jw">Jesus words</span>.

I already have an sql db that I have cleaned up the verses which already are marked as above. So this is my request: Can you share the SQLite code you used to insert the verse-id (system) so that I can stick with exactly this system? I am not too familiar with SQLite, in fact this is the first time I will be using it, but I know SQL generally fairly well.

In addition to this, I want to add a couple of other public domain bibles (such as the Catholic Public Domain Version) and have it here maintained by you. Alternatively if this is very complicated, could I send you the databases of these two versions (KJB Red Letter Edition and CPDV) for you to add to the entire database? I think having it added to the entire DB will be helpful for others who may want to develop applications that could leverage the markup for the Red Letter Editions and the other versions (i.e. the CPDV).

scrollmapper commented 8 years ago

It might be best to make a separate database. The ones existing already have a simple predictable format without markup. There is also an issue that github has a limit on filesizes, and the existing databases are pretty close to that limit.

We could start a new database as you mention since it strays from the format a bit, but I'm sure it would be useful to some. The red letter version sounds wonderful.

If you are familiar with SQL sqlite is not much different. If you use python there is SQLAlchemy that bridges the gap between SQL types seamlessly, plus you don't have to write tons of queries. SQLite is wonderful system.

What I'll do when I get a chance, as you mention, is clean up some of the code I've used and post it here in a special "helpers" folder.

coommark commented 8 years ago

@scrollmapper thank you for the response. I figured it will be easier for me to just take everything into MS SQL, do everything there and take it back to SQLite. I've already added the Red Letter KJV. Took many hours cos I had to clean up the markup and extra spaces from the source. The only markup in it now is the italicized words - words added by the KJV translators (I sometimes like to read the Bible without those) and words of Christ marked by a span tag. I will finish adding the Catholic version and two others or so tomorrow. Then I'll export to MySQL and send to you if that's okay? I could separate the DBs if you want it that way. I don't know git that much.

In the final app I am making each version can be downloaded separately, so different DBs. I could send you the individual DBs too. And hey? The cross-reference is wonderful. God bless and increase you for starting this project. It's the best I have found!

coommark commented 8 years ago

Oh and BTW, I used exactly your verse numbering system so it's exactly same schema.

scrollmapper commented 8 years ago

Wonderful! You can email me scrollmapper [at] gmail.com - I'll open you up a dropbox and I can review anything. I'm glad you like this project - if only I had more time I would do more. I am also trying to catch up to another person involving Strong's references, which they want to implement.