title: Efficient Django full-text search without Haystack
body: <p>What's the next best option for database-agnostic full-text search for Django without Haystack?</p>
  
  <p>I have a model like:</p>
  
  <pre><code>class Paper(models.Model):
      title = models.CharField(max_length=1000)
  
  class Person(models.Model):
      name = models.CharField(max_length=100)
  
  class PaperReview(models.Model):
      paper = models.ForeignKey(Paper)
      person = models.ForeignKey(Person)
  </code></pre>
  
  <p>I need to search for papers by title and reviewer name, but I also want to search from the perspective of a person and find which papers they have and haven't reviewed. With Haystack, it's trivial to implement a full-text index to search by title and name fields, but as far as I can tell, there's no way to do the "left outer join" necessary to find papers without a review by a specific person.</p>