[Tutor] Parsing Bible verses

[tearsfornations]

hey, i recently was working on some custom bible software and created an
sqlite3 database of a few different bibles, one of which is the American
Standard Version (ASV) which you can download here

http://tearsfornations.hostcell.net/bibledoth/asv.bible.sqlite3



here is the create tables

CREATE TABLE bible_info
(
   description VARCHAR(55),
   abbreviation VARCHAR(7),
   comments TEXT,
   font VARCHAR(15),
   format VARCHAR(10),
   strongs BOOLEAN
);

CREATE TABLE [bible_verses] (
[b] int(4)  NULL,
[c] int(4)  NULL,
[v] int(4)  NULL,
[t] text  NULL,
PRIMARY KEY ([b],[c],[v])
);





John Fouhy wrote:
> 
> 2009/5/26 Eduardo Vieira <eduardo.susan at gmail.com>:
>> Now, a little farther on the topic of a Bible database. I'm not sure
>> how I should proceed. I don't really have the db file I need, I will
>> have to generate it somehow, from a bible software, because the
>> version I want is for Portuguese. I have found a bible in sql, a bible
>> in MS Access to give me some ideas on how to structure my database.
>> But my question is do I really need a sql database for my need, since
>> I will be only reading from it? Never adding or updating. One like
>> sqlite. Would a pickled dictionary from Bible_reference to verse be
>> faster? Should I work with anydbm?
> 
> If you don't want to use a database, you should probably use the shelve
> module.
> 
> However, there is really no particular reason not to use a relational
> database.  It seems a solution fairly well suited to your problem.
> Python has a database supplied these days: sqlite3.  I suggest using
> that, rather than MS Access.
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> http://mail.python.org/mailman/listinfo/tutor
> 
> 

-- 
View this message in context: http://www.nabble.com/Parsing-Bible-verses-tp23660711p24725020.html
Sent from the Python - tutor mailing list archive at Nabble.com.