Skip to main content

Hstore module of django orm extensions package (collection of third party plugins build in one unified package).

Project description


Is the library which integrates the `hstore`_ extension of PostgreSQL into Django,

Compatible with django: 1.4 and posible with 1.3. Django 1.5 and python3.2+ compatibility coming soon.

Limitations and notes

- PostgreSQL's implementation of hstore has no concept of type; it stores a mapping of string keys to
string values. This library makes no attempt to coerce keys or values to strings.


The library provides three principal classes:

An ORM field which stores a mapping of string key/value pairs in an hstore column.
An ORM field which builds on DictionaryField to store a mapping of string keys to
django object references, much like ForeignKey.
An ORM manager which provides much of the query functionality of the library.

**NOTE**: the predefined hstore manager inherits all functionality of djorm-ext-expressions module (which is part of django orm extensions package)


Initially define some sample model:

.. code-block:: python

from django.db import models
from djorm_hstore.fields import DictionaryField
from djorm_hstore.models import HStoreManager

class Something(models.Model):
name = models.CharField(max_length=32)
data = DictionaryField(db_index=True)
objects = HStoreManager()

def __unicode__(self):

You then treat the ``data`` field as simply a dictionary of string pairs:

.. code-block:: python

instance = Something.objects.create(name='something', data={'a': '1', 'b': '2'})
assert['a'] == '1'

empty = Something.objects.create(name='empty')
assert == {}['a'] = '1'
assert Something.objects.get(name='something').data['a'] == '1'

You can issue indexed queries against hstore fields:

.. code-block:: python

from djorm_hstore.expressions import HstoreExpression as HE

# equivalence
Something.objects.filter(data={'a': '1', 'b': '2'})

# subset by key/value mapping

# subset by list of keys
Something.objects.where(HE("data").contains(['a', 'b']))

# subset by single key

You can also take advantage of some db-side functionality by using the manager:

.. code-block:: python

# identify the keys present in an hstore field
>>> Something.objects.filter(id=1).hkeys(attr='data')
['a', 'b']

# peek at a a named value within an hstore field
>>> Something.objects.filter(id=1).hpeek(attr='data', key='a')

# remove a key/value pair from an hstore field
>>> Something.objects.filter(name='something').hremove('data', 'b')

In addition to filters and specific methods to retrieve keys or hstore field values,
we can also use annotations, and then we can filter for them.

.. code-block:: python

from djorm_hstore.functions import HstoreSlice, HstorePeek, HstoreKeys

queryset = SomeModel.objects.annotate_functions(
sliced = HstoreSlice("hstorefield", ['v']),
peeked = HstorePeek("hstorefield", "v"),
keys = HstoreKeys("hstorefield"),

Project details

Release history Release notifications

History Node


History Node


This version
History Node


History Node


History Node


Download files

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

Filename, size & hash SHA256 hash help File type Python version Upload date
djorm-ext-hstore-0.4.3.tar.gz (8.3 kB) Copy SHA256 hash SHA256 Source None Mar 8, 2013

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page