March 27, 2010
New Project: OpenBibleDB
I have started a new project called OpenBibleDB. I had actually envisioned this project about five years ago. There has never really been a good Bible application that I have been very happy with, except for Crosswire’s Sword Project. I decided what I really wanted was a web based solution, that I could save my study notes to, and access from anywhere. After messing around with Sword’s mod2osis programs, I came up with the idea of just exporting the Sword modules into a relational database, and then write a web-based frontend to access it.
Originally, I planned my project around PostgreSQL and it’s tsearch2 module for fast text searching. I later decided that PostgreSQL waa ideal, but in order to make this application available to the widest audience as possible, I need it to work on MySQL and PHP. So that is this current projects goals.
So right now the process of importing a sword module is to use mod2osis to convert a Sword module to Osis XML format, and then to edit the MySQL connection details in parsexml.py, and then run parsecml.py .
I originally had written this program to output SQL for PostgreSQL. With MySQL’s great limitations, parsexml.py has to run an active database connection for the full duration of the export.
Stay tuned! Files are going up today.
