ckanext-tabledesigner_hashcolumns

Provides binary column types sized appropriately for hash values for datastore using ckanext-tabledesigner.

• MD5
• SHA1
• SHA224
• SHA256
• SHA384
• SHA512

Binary storage uses half the space that text storage does for hex values, helping memory pressure especially on the indexes.

Requirements

Compatibility with core CKAN versions:

CKAN version	Compatible?
2.10 and earlier	no. Requires tabledesigner
2.11	yes

Installation

1. This extension requires an extension for postgresql that is not included in the standard distribution or contrib modules.

Install hashtypes[https://pgxn.org/dist/hashtypes/], https://github.com/adjust/hashtypes in your datastore database, then add the extension to the datastore db.

create extension hashtypes;

2. Install as usual for any ckan extension. This extension does not require the editable flag.

pip install git+https://github.com/derilinx/ckanext-tabledesigner_hashcolumns.git

3. Add tabledesigner_hashcolumns to the ckan.plugins setting in your CKAN config file (by default the config file is located at /etc/ckan/default/ckan.ini).

Config settings

• ckanext.tabledesigner_hashcolumns.enabled -- optional list of the specific hash types that should be enabled.

License

AGPL