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_description(self):
        return self.obj.content

    def get_data(self):
        return self.obj

    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.

Files for django-pgindex, version 0.8.0
Filename, size File type Python version Upload date Hashes
Filename, size django-pgindex-0.8.0.tar.gz (6.8 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page