title: How to do full text search in Adobe AIR applications?
body: <p>It seems that AIR doesn't come packaged with the powerful <a href="http://www.sqlite.org/fts3.html" rel="nofollow">FTS module</a> for Sqlite (its a hot <a href="http://ideas.adobe.com/ct/ct_a_view_idea.bix?c=9D564F43-979A-4E35-AA21-85A61B6AB8DE&amp;idea_id=83953B0D-48A4-43D0-A3CB-E89F3DFE989C" rel="nofollow">requested feature</a>)</p>
  
  <p>What are the some other alternatives I can use? I want to be able to do simple boolean and phrase queries. Support for stemming would be great but not required. I am targeting the mobile platforms.</p>
  
  <p>So far I've thought of three options:</p>
  
  <ol>
  <li>Write a simple inverted index and a scorer</li>
  <li>Do search on server side (last resort b/c it messes up offline capability)</li>
  <li>Somehow install FTS module with AIR. First indication from googling is that its not feasible (looks like loading of modules is disabled in air)</li>
  </ol>
  
  <p>Are there other alternatives? </p>