ckan / ckan/ideas

Investigate using TimescaleDB in Datastore

Open
#205 0 comments 1 reaction 0 assignees View on GitHub
Dominant language
No language data
Stars
39
Forks
1
PR merge metrics
No merged PRs in 30d

Description

We have a very lightweight wrapper around PostgreSQL for the CKAN datastore. Now that we're extending the datastore for [faster performance, etc](https://ckan.org/2017/08/10/faster-datastore-in-ckan-2-7/), it might pay to look into integrating TimescaleDB as well.

This further enables CKAN to handle use cases beyond data publishing (e.g. streaming data, smart city, data exchange, etc.). And if its packaged as a PostgreSQL extension, it should be largely transparent to CKAN.

cc @wardi @davidread @akulkarni @mfreed

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reviewing CKAN’s lightweight PostgreSQL wrapper for the datastore and the linked datastore performance context. Investigate whether TimescaleDB can be integrated as a PostgreSQL extension for streaming and related use cases, and document a clear feasibility recommendation or integration proposal.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.