SectorLabs/django-postgres-extra
SectorLabs/django-postgres-extra has 767 GitHub stars and 119 forks. GitHot measured 0 stars in 24 hours and 0 in 7 days. Last checked 2026-11-22 05:23 UTC. Last push 2026-10-25.
What you can do
- Conflict handling (atomic upsert) Adds support for PostgreSQL's ON CONFLICT syntax for inserts. Supports DO UPDATE and DO NOTHING. Single statement, atomic and concurrency safe upserts. Supports conditional updates as well.
- Table partitioning Adds support for PostgreSQL 11.x declarative table partitioning. Integrated into Django migrations. Supports all types of partitioning. Includes a command to automatically create time-based partitions.
- Views & materialized views Adds support for creating views & materialized views as any other model. Integrated into Django migrations.
- Locking models & tables Support for explicit table-level locks.
Crecimiento de estrellas medido
- in 24h
- 0
- in 7 days
- 0
- in 15 days
- Recopilando historial
- in 1 month
- Recopilando historial
Cambios netos en períodos que se solapan, no totales diarios. Los datos no disponibles se dejan en blanco. Las estrellas indican interés, no calidad.
Acerca de
Bringing all of PostgreSQL's awesomeness to Django.
DatosREADME.md
Original| :white_check_mark: | Tests | |
| :memo: | License | |
| :package: | PyPi | |
| :four_leaf_clover: | Code coverage | |
| Django Versions | 2.0, 2.1, 2.2, 3.0, 3.1, 3.2, 4.0, 4.1, 4.2, 5.0, 5.1, 5.2 | |
| Python Versions | 3.7, 3.8, 3.9, 3.10, 3.11, 3.12, 3.13 | |
| Psycopg Versions | 2, 3 | |
| :book: | Documentation | Read The Docs |
| :warning: | Upgrade | Upgrade from v1.x |
| :checkered_flag: | Installation | Installation Guide |
| :fire: | Features | Features & Documentation |
| :droplet: | Future enhancements | Potential features |
django-postgres-extra aims to make all of PostgreSQL's awesome features available through the Django ORM. We do this by taking care of all the hassle. As opposed to the many small packages that are available to try to bring a single feature to Django with minimal effort. django-postgres-extra goes the extra mile, with well tested implementations, seamless migrations and much more.
With seamless we mean that any features we add will work truly seamlessly. You should not have to manually modify your migrations to work with fields and objects provided by this package.
:warning: This README is for v2. See the v1 branch for v1.x.
Major features
Conflict handling (atomic upsert)
Adds support for PostgreSQL's
ON CONFLICTsyntax for inserts. SupportsDO UPDATEandDO NOTHING. Single statement, atomic and concurrency safe upserts. Supports conditional updates as well.Table partitioning
Adds support for PostgreSQL 11.x declarative table partitioning. Integrated into Django migrations. Supports all types of partitioning. Includes a command to automatically create time-based partitions.
Views & materialized views
Adds support for creating views & materialized views as any other model. Integrated into Django migrations.
Locking models & tables
Support for explicit table-level locks.
Creating/dropping schemas
Support for managing PostgreSQL schemas.
Truncating tables
Support for
TRUNCATE TABLEstatements (including cascading).
For Django 3.1 and older:
- Conditional unique index
- Case insensitive index
For Django 2.2 and older:
- Unique index
- HStore unique and required constraints on specific HStore keys
Working with the code
Prerequisites
- PostgreSQL 14 or newer.
- Django 5.x or newer.
- Python 3.11 or newer.
These are just for local development. CI for code analysis etc runs against these. Tests will pass on all Python, Django and PostgreSQL versions documented. Linting, formatting and type-checking the code might not work on other Python and/or Django versions.
Getting started
Clone the repository:
λ git clone https://github.com/SectorLabs/django-postgres-extra.gitInstall uv if you don't have it:
λ curl -LsSf https://astral.sh/uv/install.sh | shSync the development/test dependencies (creates
.venvand installs fromuv.lock):λ cd django-postgres-extra λ uv sync --extra dev --extra test λ source .venv/bin/activateuv.lockenforces a 3-day dependency cooldown via[tool.uv] exclude-newerinpyproject.toml, so newly-published versions cannot enter your environment until the community has had time to flag malicious releases.Create a postgres user for use in tests (skip if your default user is a postgres superuser):
λ createuser --superuser psqlextra --pwprompt λ export DATABASE_URL=postgres://psqlextra:<password>@localhost/psqlextraHint: if you're using virtualenvwrapper, you might find it beneficial to put the
exportline in$VIRTUAL_ENV/bin/postactivateso that it's always available when using this virtualenv.Run the tests:
λ poe testRun the benchmarks:
λ poe benchmarkAuto-format code, sort imports and auto-fix linting errors:
λ poe fix
Explorar proyectos relacionados
Cargando…