django-postgres-extra
django-postgres-extra copied to clipboard
SectorLabs
Bringing all of PostgreSQL's awesomeness to Django.
We are using `django-postgres-extra` and loading database settings through .env file and default database is sqllite3 ```python DEFAULT_DATABASE = { 'ENGINE': 'django.db.backends.sqlite3', 'NAME': os.path.join(BASE_DIR, 'db.sqlite3'), } DATABASES = { 'default':...
this pr allows to add constraints per partition our need was to add unique constraints not containing partition key per partition on a range partitioned model. I added `add_constraints_to_partition` function...
In certain conditions `PostgresQuerySet` behaves differently and raises `KeyError` where django `QuerySet` doesn't. In example below, when using named expressions in `.values` clause after `.distinct()` and one of the names...
Would it be advisable to rename `pgmakemigrations` to `makemigrations`? While it smells a little hacky, even [the Django doc talks about this possibility](https://docs.djangoproject.com/en/4.2/howto/custom-management-commands/#overriding-commands), and other notable libraries do it (like...
This PR adds support for Hourly partitions, using the existing time-based partitions functionality. I've added new unit tests, and all the old unit tests still pass. Also added an example...
Dear Sector Labs team, this PR fixes an issue that occurs when we (https://github.com/einhundert) do an annotation that carries the same name as a field of the model whose queryset...
Hello, I would like to open a discussion of whether we would like to add support for temporary table management in this package, and if so how we would do...
## Problem Currently, there's no way to determine if after an UPSERT operation in the database a row was inserted or updated. This functionality can be handy in different use...
Hello, I needed to have composite partitioning (aka nested or subpartitioning), I made the changes to make it work for one level subpartitioning. The principal changes are: 1) Handling "submethod"...
The sql_create_materialized_view schema ends `WITH DATA` - it would be useful in certain cases to create a materialized view using `WITH NO DATA` so that it isn't populated until some...
Metadata
Owner
Metadata
Bringing all of PostgreSQL's awesomeness to Django.