SectorLabs/django-postgres-extra
SectorLabs/django-postgres-extra has 767 GitHub stars and 120 forks. GitHot measured 0 stars in 24 hours. Last checked 2026-11-15 15:48 UTC. Last push 2026-10-25.
可以做什么
- 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.
实测星标增长
- 24小时
- 0
- 7天
- 更新延迟
- 15天
- 更新延迟
- 1个月
- 更新延迟
各周期内的星标净变化,周期相互重叠,并非每日新增。缺失的测量保持空白。星标代表关注度,不代表软件质量。
关于
Bringing all of PostgreSQL's awesomeness to Django.
数据README.md
原文| :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