title: Solr, Sunspot, SQlite, and Rails
body: <p>I would like to implement a full text search + faceting for my project that uses SQlite3 as the database. I heard that Solr is really powerful. There are Sunspot &amp; Solr tutorials available but only for MySQL. I can't find any document for how to set it up for SQLite3. </p>
  
  <p>Anyone know how to set it up with SQLite3? Or is it not possible?</p>