Skip to main content

Native postgres bulk update and upsert operations.

Project description

django-pgplus, forked from django-manager-utils, provides several optimized bulk operations for Postgres:

  1. update - For updating a list of models in bulk. Although Django provides a bulk_update in 2.2, it performs individual updates for every row and does not perform a native bulk update.

  2. upsert - For doing a bulk update or insert. This function uses postgres UPDATE ON CONFLICT syntax to perform an atomic upsert operation. There are several options to this function that allow the user to avoid touching rows if they result in a duplicate update, along with returning which rows were updated, created, or untouched.

  3. sync - For syncing a list of models with a table. Does a bulk upsert and also deletes any rows in the source queryset that were not part of the input data.

For more examples, see the django-pgbulk docs.

Documentation

View the django-pgbulk docs here.

Installation

Install django-pgbulk with:

pip3 install django-pgbulk

After this, add pgbulk to the INSTALLED_APPS setting of your Django project.

Contributing Guide

For information on setting up django-pgbulk for development and contributing changes, view CONTRIBUTING.rst.

Primary Authors

  • @wesleykendall (Wes Kendall)

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-pgbulk-1.1.1.tar.gz (14.0 kB view details)

Uploaded Source

Built Distribution

django_pgbulk-1.1.1-py3-none-any.whl (13.8 kB view details)

Uploaded Python 3

File details

Details for the file django-pgbulk-1.1.1.tar.gz.

File metadata

  • Download URL: django-pgbulk-1.1.1.tar.gz
  • Upload date:
  • Size: 14.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.1.12 CPython/3.10.1 Linux/5.13.0-1017-aws

File hashes

Hashes for django-pgbulk-1.1.1.tar.gz
Algorithm Hash digest
SHA256 b431b7091064ba5d2bfa9ae7a47fc3efae0e5c43a7bac5056d43f96d9a7158cd
MD5 ff3320373b4220f4028c94bad1f4656f
BLAKE2b-256 0b96769e877bcbfaa95ec23ea8bbc4c47c65b33dcc8446678a937420794d706d

See more details on using hashes here.

File details

Details for the file django_pgbulk-1.1.1-py3-none-any.whl.

File metadata

  • Download URL: django_pgbulk-1.1.1-py3-none-any.whl
  • Upload date:
  • Size: 13.8 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.1.12 CPython/3.10.1 Linux/5.13.0-1017-aws

File hashes

Hashes for django_pgbulk-1.1.1-py3-none-any.whl
Algorithm Hash digest
SHA256 2576eff7fe9221f4d6468aa9fc80ab72d074952141653413e4d6904a24ede966
MD5 18c3e89c3e17266822ec8d4438845118
BLAKE2b-256 55afd3d5eceec60f48991af8c38c4747adc54410aa2e875d29b2ee14455b0519

See more details on using hashes here.

Supported by

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