Re: [IndexedDB] Full text search?

On Apr 8, 2012, at 10:19 AM, ext Javier Holguera wrote:

> Hi,
>  
> I’m starting with IndexedDB with a simple sample application. It is a Tasks List which stores its information into a IndexedDB database. I may have chosen a simpler persistence technology, but I wanted to give a try to IndexedDB.
>  
> Anyway, my application should allow searching in the stored tasks by a key word. For example, if I search by “dinner” word, I would like to retrieve entries in the database with names like “Dinner ingredients list”, “Prepare the dinner” or “Ask Mary to do the dinner”. I think it is a typical “Full text Search” example.
>  
> How can it be implemented with IndexedDB? As far as I have read, I can retrieve elements from the database based on any of the object properties, but it must be a complete match. If it is not possible, it would force to move all Object Store records to memory to iterate over them and do the full text search “manually”, which is quite inefficient.
> Thanks for the information.

FYI, "fulltext index" is included in the list of features for the "next" version <http://www.w3.org/2008/webapps/wiki/IndexedDatabaseFeatures>. I think the main proponents of the spec consider v1 of the spec feature complete (bug list is <http://tinyurl.com/Bugz-IndexedDB>).

-AB