User Tools
start
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
start [2019/03/24 18:11] steve [Other Projects] |
start [2020/12/08 20:55] (current) steve |
||
|---|---|---|---|
| Line 12: | Line 12: | ||
| ===== About ===== | ===== About ===== | ||
| - | This project's goal is to provide open database and text export formats of scriptures in the public domain for use by developers. The [[https://www.lds.org/topics/standard-works|canon of scripture]] is that used by the [[http://churchofjesuschrist.org/|Church of Jesus Christ of Latter-day Saints]], containing: | + | This project's goal is to provide open database and text export formats of scriptures in the public domain for use by developers. The [[https://www.churchofjesuschrist.org/study/manual/gospel-topics/standard-works?lang=eng|canon of scripture]] is that used by the [[http://churchofjesuschrist.org/|Church of Jesus Christ of Latter-day Saints]], containing: |
| ** King James Version of the Holy Bible ** | ** King James Version of the Holy Bible ** | ||
| - | * [[http://docs.nephi.org/scriptures/docbook/ot/|Old Testament]] | + | * Old Testament |
| - | * [[http://docs.nephi.org/scriptures/docbook/nt/|New Testament]] | + | * New Testament |
| ** Translated Scriptures and Modern Revelation ** | ** Translated Scriptures and Modern Revelation ** | ||
| - | * [[http://docs.nephi.org/scriptures/docbook/bom/|The Book of Mormon - Another Testament of Jesus Christ]] | + | * The Book of Mormon - Another Testament of Jesus Christ |
| - | * [[http://docs.nephi.org/scriptures/docbook/dc/|Doctrine and Covenants]] | + | * Doctrine and Covenants |
| - | * [[http://docs.nephi.org/scriptures/docbook/pgp/|The Pearl of Great Price]] | + | * The Pearl of Great Price |
| ===== Downloads ===== | ===== Downloads ===== | ||
| - | Exports are available for: | + | All formats are included in one ZIP file. |
| - | * [[http://docs.nephi.org/scriptures/downloads/lds-scriptures-mysql.sql.zip|MySQL]] | + | Download here at github: [[https://github.com/beandog/lds-scriptures/archive/2020.12.08.zip]] |
| - | * [[http://docs.nephi.org/scriptures/downloads/lds-scriptures-psql.sql.zip|PostgreSQL]] | + | |
| - | * [[http://docs.nephi.org/scriptures/downloads/lds-scriptures-sqlite3.db.zip|SQLite]] | + | Exports are available in English for: |
| - | * [[http://docs.nephi.org/scriptures/downloads/lds-scriptures.csv.zip|CSV]] | + | |
| - | * [[http://docs.nephi.org/scriptures/downloads/lds-scriptures.json.zip|JSON]] | + | * [[MySQL]] |
| - | * [[http://docs.nephi.org/scriptures/downloads/lds-scriptures-excel.zip|Microsoft Excel]] | + | * [[PostgreSQL]] |
| - | * [[http://docs.nephi.org/scriptures/downloads/lds-scriptures.ods.zip|Open Document Spreadsheet]] | + | * [[SQLite]] |
| + | * CSV | ||
| + | * [[JSON]] | ||
| + | * Microsoft Excel | ||
| + | * Open Document Spreadsheet | ||
| + | * Text File | ||
| + | * HTML | ||
| The schemas for the databases are intentionally both normalized and non-normalized, which is why you'll see seemingly duplicate tables. This is so that people who want to jump right in, can start running queries against the scriptures table, while those looking for other indexing or more complex queries can use the other ones. | The schemas for the databases are intentionally both normalized and non-normalized, which is why you'll see seemingly duplicate tables. This is so that people who want to jump right in, can start running queries against the scriptures table, while those looking for other indexing or more complex queries can use the other ones. | ||
| + | |||
| ===== Documentation ===== | ===== Documentation ===== | ||
| * [[ChangeLog]] | * [[ChangeLog]] | ||
| - | * [[http://docs.nephi.org/scriptures/install.txt|Installation]] (old) | ||
| * [[Naming Standards]] | * [[Naming Standards]] | ||
| * [[Omitted Texts]] | * [[Omitted Texts]] | ||
| - | + | * [[http://docs.nephi.org/scriptures/install.txt|Installation]] (old) | |
| + | * [[http://docs.nephi.org/scriptures/docbook/|DocBook export]] | ||
| ===== Development ====== | ===== Development ====== | ||
| + | * [[https://github.com/beandog/lds-scriptures|GitHub repository]] | ||
| + | * [[https://api.nephi.org/|Scripture Search API]] | ||
| * [[Character Encoding]] | * [[Character Encoding]] | ||
| * [[Database Notes]] | * [[Database Notes]] | ||
| Line 67: | Line 75: | ||
| ===== Related Websites ===== | ===== Related Websites ===== | ||
| - | * [[https://scriptures.lds.org/|The Church of Jesus Christ of Latter-day Saints - Scriptures]] | + | * [[https://www.churchofjesuschrist.org/study/scriptures?lang=eng|The Church of Jesus Christ of Latter-day Saints - Scriptures]] |
| + | * [[https://www.churchofjesuschrist.org/study/scriptures/study-helps?lang=eng|The Church of Jesus Christ of Latter-day Saints - Study Helps]] | ||
| + | * [[https://www.churchofjesuschrist.org/bc/content/shared/content/english/pdf/scriptures/approved-adjustments_eng.pdf|The Church of Jesus Christ of Latter-day Saints - 2013 Revisions]] | ||
| * [[https://scriptures.byu.edu/|Brigham Young University - Scripture Citation Index]] | * [[https://scriptures.byu.edu/|Brigham Young University - Scripture Citation Index]] | ||
| * [[http://crosswire.org/sword/|The SWORD Project]] - Open Source Bible Software | * [[http://crosswire.org/sword/|The SWORD Project]] - Open Source Bible Software | ||
| Line 94: | Line 104: | ||
| Just English for now. I get a lot of requests for a Spanish export, which I could do since I can read the language, but I don't feel confident enough to make sure I get a clean copy. Languages other than that, I wouldn't venture to attempt, since I wouldn't be able to make sure they are accurate or not. | Just English for now. I get a lot of requests for a Spanish export, which I could do since I can read the language, but I don't feel confident enough to make sure I get a clean copy. Languages other than that, I wouldn't venture to attempt, since I wouldn't be able to make sure they are accurate or not. | ||
| - | |||
| - | ** Can you make exports for other formats? ** | ||
| - | |||
| - | Sure! Just let me know what you'd like. I used to have some for Microsoft Access and XML, but since they're pretty obscure, I dropped doing it in newer releases. Making a port to another format can be tedious, but once it's cleanly scripted, it's easy to do. | ||
| - | |||
| - | There's some software I don't have access to, otherwise I'd create database exports myself. Examples include Microsoft SQL Server and Oracle. | ||
start.1553472670.txt.gz · Last modified: 2019/03/24 18:11 by steve
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
