Skip to content
This repository has been archived by the owner on Nov 25, 2021. It is now read-only.

A Django extension that supports PostgreSQL 11 time ranges and list partitioning.

License

Notifications You must be signed in to change notification settings

chaitin/django-pg-partitioning

Repository files navigation

django-pg-partitioning

https://img.shields.io/badge/License-MIT-orange.svg?style=flat-square https://img.shields.io/badge/Django-2.x-green.svg?style=flat-square&logo=django https://img.shields.io/badge/PostgreSQL-11-lightgrey.svg?style=flat-square&logo=postgresql https://readthedocs.org/projects/django-pg-partitioning/badge/?version=latest&style=flat-square https://img.shields.io/pypi/v/django-pg-partitioning.svg?style=flat-square https://api.travis-ci.org/chaitin/django-pg-partitioning.svg?branch=master https://api.codacy.com/project/badge/Grade/c872699c1b254e90b540b053343d1e81

⚠️

目前已经有了更好用的 Django 插件(比如 django-postgres-extra)使得基于 Django 开发的项目能够方便地使用 PostgreSQL 数据库的高级功能,因此本项目不再维护。你依然可以 fork 本项目并进行二次开发,祝你生活愉快 :)

There are already better Django plugins (such as django-postgres-extra) that make it easy for Django-based projects to use the advanced features of PostgreSQL databases, so this project is no longer maintained. You can still fork this project and do secondary development, have a nice life :)


一个支持 PostgreSQL 11 原生表分区的 Django 扩展,使您可以在 Django 中创建分区表并管理它们。目前它支持两种分区类型:

  • 时间范围分区(Time Range Partitioning):将时序数据分开存储到不同的时间范围分区表中,支持创建连续且不重叠的时间范围分区并进行归档管理。
  • 列表分区(List Partitioning):根据分区字段的确定值将数据分开存储到不同的分区表中。

A Django extension that supports PostgreSQL 11 native table partitioning, allowing you to create partitioned tables in Django and manage them. Currently it supports the following two partition types:

  • Time Range Partitioning: Separate time series data into different time range partition tables, support the creation of continuous and non-overlapping time range partitions and archival management.
  • List Partitioning: Store data separately into different partition tables based on the determined values of the partition key.
Documentation
https://django-pg-partitioning.readthedocs.io

https://raw.githubusercontent.com/chaitin/django-pg-partitioning/master/docs/source/_static/carbon.png

TODO

  • Improve the details of the function.
  • Improve documentation and testing.
  • Optimization implementation.

maybe more...

Contributing

If you want to contribute to a project and make it better, you help is very welcome! Please read through Contributing Guidelines.

License

This project is licensed under the MIT. Please see LICENSE.

Project Practice

https://raw.githubusercontent.com/chaitin/django-pg-timepart/master/docs/source/_static/safeline.svg?sanitize=true