Install and setup Haystack search for Django

So Mysql is crap at doing full text search. So in one of my projects i use Haystack so i can do full text searches.

I have a running Django project up and this is how I setup haystack for my project.


Install and config

sudo pip install django-haystack


in under INSTALLED_APPS add haystack



And also in file add some haystack settings

import os
'default': {
'ENGINE': 'haystack.backends.whoosh_backend.WhooshEngine',
'PATH': os.path.join(os.path.dirname(__file__), 'whoosh_index'),


I have a model that looks like this

from django.db import models
# Create your models here.
class Register(models.Model):
name = models.CharField(max_length=255)
taxed = models.CharField(max_length=100)
kapital = models.CharField(max_length=100)
year = models.CharField(max_length=100)
location = models.CharField(max_length=100)


Then I have an search index that that matches my model

import datetime
from haystack import indexes
from search.models import Register
class RegisterIndex(indexes.SearchIndex, indexes.Indexable):
text = indexes.CharField(document=True,model_attr='name')
taxed = indexes.CharField(model_attr='taxed')
kapital = indexes.CharField(model_attr='kapital')
location = indexes.CharField(model_attr='location')
def get_model(self):
return Register
def index_queryset(self, using=None):
"""Used when the entire index for model is updated."""
return self.get_model().objects.all()


Make it work

Sync up you database sett you mysql settings in and the run this command so that django can setup your database.

python syncd

Adding a lot of DATA to your tabel

build you index

python rebuild_index
WARNING: This will irreparably remove EVERYTHING from your search index in connection 'default'.
Your choices after this are to restore from backups or rebuild via the `rebuild_index` command.
Are you sure you wish to continue? [y/N] y
Removing all documents from your index because you said so.
All documents removed.
Indexing 130 registers


And then when you want to update your index you run

python update_index

So the last thing is to setup some views so I can search fulltext. This is my functions and its a ajax request from my webbapp. And it returns the data


def ajaxsearch(request):
if request.method == 'POST':
search_answer = SearchQuerySet().filter(text=search).filter(town=location)
return render_to_response('test.html',{'search': search_answer},context_instance=RequestContext(request))

and here is the template that prints the data


{% for r in search %}
<div class='alert alert-info'><button type='button' class='close' data-dismiss='alert'>&times;</button><strong>{{ r.text }} {{ r.location }}</strong> <br> <b>{{ r.taxed }}</b>
{% endfor %}

Leave a Reply

%d bloggers like this: