Skip to main content

Search for Django and PostgreSQL

Project description

Search for Django and PostgreSQL.


  • Django >= 1.1

  • django-stringfield >= 0.1.5

  • django-cerial >= 0.0.2


First install the package from pypi using pip:

pip install django-pgindex

Then make pgindex an app in your INSTALLED_APPS:


Sync your database:

python syncdb



Create and Index class and register it to your model, much like registering an admin class to your model. Example:

from django.db import models
from .index import ItemIndex
from pgindex import register

class Item(models.Model):
    title = models.CharField(max_length=100)
    content = models.TextField()

    def get_absolute_url(self):
        return '/item/'

register(Item, ItemIndex)

from pgindex import IndexBase, Vector

class ItemIndex(IndexBase):
    def get_title(self):
        return self.obj.title

    def get_description(self):
        return self.obj.content

    def get_vectors(self):
        return (
            Vector(self.obj.title, weight='A'),
            Vector(self.obj.content, weight='B'),

To search simply use the method which returns a queryset from the pgindex.models.Index model:

from pgindex import search

index_queryset = search('foo')

See tests for examples.

pgindex.IndexBase methods


This should return the title of the indexed object.


This should return the description of the indexed object.


This should return the url of the indexed object.


You can return additional data that will be stored in the index field here, this value will be pickled and depickled.


If this returns False and index will not be created


Can return a datetime.datetime which is the time when the index will be used. Returning None means that it will always be used.


Can return a datetime.datetime which is the time for the index expiration. Returning None means that it will never expire.


This method needs to return a list or tuple of pgindex.Vector instances. This in turn is the base for the text search column.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

django-pgindex-0.8.2.tar.gz (7.0 kB view hashes)

Uploaded source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page