ahmedre/quran_android — Issue #113: switch translation databases to use fts
Author: ahmedre
Created: 2011-10-22 23:15:33+00:00
State: open

currently, only the new arabic search uses fts... the rest of the translations should too, especially since it is faster and it buys us some cool stuff like snippets.

to do this, i can't just update the database files (well, i can, but we need some way to denote that this is a fts enabled database versus not). instead of checking this in code (somehow checking the schema and figuring out from there), i prefer to introduce a version number to the database, since i think this will help us in the future overall.

note that this means there would ultimately really be two version numbers - the version number of the text, and the version of the schema. this needs to be introduced to make this feature possible. once this is done, it's literally a matter of switching a flag in the database handler when you have a v2+ schema database to enable fts (versus now, where this is a hard-coded check).