Skip to main content

Django complementary index definition and management.

Project description

Describe your database index in json files into your apps

Detailed documentation is in the “docs” directory.

Quick start

  1. Add “json_dbindex” to your INSTALLED_APPS setting like this:

    INSTALLED_APPS = (
        ...
        'json_dbindex',
    )
    
  2. Run python manage.py list_jsindex to list all defined indexes.

Create indexes

Create a file in you app directory called dbindex_create.json with following contents

[{“name”: “django_site_composite_idx”,
“table”: “django_site”,
“columns”: [“domain”,”name”],
“predicat”: “WHERE id > 1000”,
“using”: “btree”,
“database”: “default”,
“unique”: yes},
{“name”: “django_site_name_idx”,
“table”: “django_site”,
“columns”: [{“name”: “gist_trgm_ops”}],
“using”: “gist”,
“extension”: “pg_trgm”}]

Trying to create an existing index will not generate an error, only a logging at level notice will be raised.

Drop indexes

Create a file in you app directory called dbindex_drop.json with following contents.

[{“name”: “django_site_composite_idx”},
{“name”: “django_site_domain_idx”}]

Only the name is required. In the above example two indexes will be dropped. Trying to drop a non existing index will not generate an error, only a logging at level notice will be raised.

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-json-dbindex, version 1.2.3
Filename, size File type Python version Upload date Hashes
Filename, size django-json-dbindex-1.2.3.tar.gz (10.4 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page