Adds first-class support for PostgreSQL features to the Django ORM.
Planned features include:
Obviously this is quite a large project, but I think it would provide a huge amount of value to Django developers.
PostgreSQL is an excellent data store, with a host of useful and efficiently-implemented features. Unfortunately these features are not exposed through Django’s ORM, primarily because the framework has to support several SQL backends and so can only provide a set of features common to all of them.
The features made available here replace some of the following practices:
- Manual denormalization on
save()(such that model saves may result in three or more separate queries).
- Sequences represented by a one-to-many, with an
- Complex types represented by JSON in a text field.
This is a WIP, so the following list may grow and change over time.