On data, you are of course, welcome to have a look at the databases I'm using although I'd only planned on single data source. This was build from a text file I downloaded from the Gutenburg which I first got into MySQL for the web thing linked to in my last post and later converted to sqlite. It's at
www.jonbanjo.com/kjv.sqlite.zip
I don't know whether it will work (never tried it before) but there are 2 dbs. One is the text that I've considered static and the other is a db that I thought could hold verses with whatever html, I chose to use for highlighting, etc. and I can attach to use the 2 as one database. This is very experimental for me and may prove to be a wrong direction but I thought (if/when I get round to the Android part) it would be interesting to see how it worked out.
The main db can use very simple queries for quite a Google like search. The downside of course with FTS3 is that the database is rather larger that it would be without the full text abilities.
Something along the lines of this would give the Google like search for phrases (text surrounded in double quotes) and a series of words, etc.
Code:
SQLiteDatabase db = KjvApp.getDatabase();
term = DatabaseUtils.sqlEscapeString(<get the text from say a Text edit>);
String sql =
"select bookname, chapternumber, versenumber, versetext from book, chapter, verse where book._id = chapter.bookid and chapter._id = verse.chapterid and verse match " + term;
String[] args = {};
try {
Cursor cursor = db.rawQuery(sql, args);
if (cursor == null){
return;
}
...
Of course again, I am only talking about ideas that may be worth a look, may be inferior to what you already doing, etc. I'm only floating a couple of thoughts that have come to me around. No more than that. I'm perhaps being a bit over enthusiastic about your project going well for you but I certainly do not want to be pushy, "know all" or anything else.