Skip to main content

No project description provided

Project description


Using Postgres as a NoSQL database. Intended for providing a shared storage space between different django projects


PyPI version

pip install dj-pgnosql

Note: this package doesn't specify any requirements, but assumes that your project is setup to use Postgres with a version of Django that supports JSONField

  • Add pgnosql to INSTALLED_APPS in

Recommended usage (with a custom database)

We recommend that you configure pgnosql to use a different database from your project's default database.

The idea is that you might have multiple django projects which connect to this KV store as a means to easily share data between services

Configure a seperate database connection:

    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': os.environ.get('DATABASE_NAME', 'postgres'),
        'USER': os.environ.get('DATABASE_USER', 'postgres'),
        'HOST': os.environ.get('DATABASE_HOST', 'postgres'),
        'PORT': 5432,
    'pgnosql': { # <- this is our nosql db
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': os.environ.get('NOSQL_DATABASE_NAME', 'postgres'),
        'USER': os.environ.get('NOSQL_DATABASE_USER', 'postgres'),
        'HOST': os.environ.get('DATABASE_HOST', 'postgres'),
        'PORT': 5432,

Add the DB router

DATABASE_ROUTERS = ['pgnosql.routers.NoSQLRouter']

This router will send queries to the NoSQL database if the model is from the pgnosql app. Otherwise will send it to the default database

Run migrations:

You'll need to specify that you're running them for the pgnosql database.

web python migrate pgnosql --database=pgnosql

You're all setup.

Shared access between two services


from pgnosql.models import KV
key = "foo"
value = {"bar": "bus"}

KV.set(key, value) # value must be json
KV.get(key) # {"bar": "bus"}

You can obviously also just use Django's standard ORM

Model fields:

key = models.CharField(max_length=100, db_index=True)
value = JSONField(default=dict)
index = models.CharField(max_length=255, db_index=True, help_text='You can provide an index to make this key searchable')

time_to_live = models.PositiveIntegerField(default=0)
created_date = models.DateTimeField(auto_now_add=True)
modified_date = models.DateTimeField(auto_now=True)


dj=pgnosql supplies a few sub-modules for dealing with Specific use-cases


A shared user object

# Get a user
from pgnosql.user import GlobalUser
user_id = 1
user = GlobalUser(user_id)

# set arbitary data on a user:
user_data = {"foo": "bar"}
>> {"foo": "bar"}





Notes on versioning:

| | |__ Patch
| |____ Minor
|______ Major
  • Patch: tweaks, improvements and bug fixes - backward compatible. Inclides new functionality in the API interface - but not changes to to it
  • Minor: Changes to the existing API interface
  • Major: Changes to db schema/Django models



With docker (recommended)

docker-compose run --rm web python test

Generate Spec Docs:

docker-compose run --rm web python test --testrunner=testreporter.runner.BDDTestRunner

See spec.txt


Why not use something like Redis or Mongo?

Our main motivation for building this library is due to the strong support for Postgres in Django. In most cases - if you're already using Django - you'll be able to use this library with no extra dependencies.

You also get all of Django's built in support for Postgress including:

  • Easy to test
  • Configuration baked in
  • You're probably already using Postgres for your normal models. Now you don't need to add another piece of machinery
  • Django Admin support
  • Django ORM support
  • ...

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

dj-pgnosql-1.0.0.tar.gz (7.8 kB view hashes)

Uploaded source

Supported by

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