An Open Source Column-Store Backend
|Reported by:||anonymous||Owned by:||nobody|
|Component:||Database layer (models, ORM)||Version:||master|
|Has patch:||no||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
Adding a column-store database backend would, transparently, allow Django to become applicable to a wider array of problems. Column-stores are being touted by some leading pioneers in the database community as a solution to some of the prevalent problems in database management specifically exacerbated by row-based storage (i.e. MySQL, postgrs, Oracle, etc.) of large sets.
The shortcomings of column-store backend are both general and specific:
- Column stores are less efficient at inserts and updates due to their aggressive compression and indexing.
- The below implementations are not in the usual palette of database solutions provided by shared web hosts, nor have most web developers paid much attention to the VLDB world.
- Little legacy data is stored in databases of this type, reducing the effectiveness of inspectdb, one of the killer Django hooks.