Skip to main content

Timeseries-based datastore extension

Project description


Timeseries data is streams of data that is indexed by timestamp, such as sensing data. Current default CKAN Datastore plugin only index data based on an auto-incremental integer with no support for timeseries data. Perceived that timeseries data is an important capability when working with sensor network, a new plugin that supports operations based on timestamp natively would be necessary. Thus, the purpose of this repository.

* If you are upgrading from version < 0.1.0, the schema has changed. A command has been created to upgrade the schema. Please run the following command:
paster --plugin=ckan datastore_ts -c <path to ini configuration file> upgrade-schema autogen_timestamp _autogen_timestamp


Being developed under CKAN 2.5.2

Requires iso8601:

``` pip install iso8601 ```


.. Add any additional install steps to the list below.
For example installing any non-Python dependencies or adding any required
config settings.

To install ckanext-datastore_ts:

1. Activate your CKAN virtual environment, for example::

. /usr/lib/ckan/default/bin/activate

2. Install the ckanext-datastore_ts Python package into your virtual environment::

pip install ckanext-datastore_ts

3. Add ``datastore_ts`` to the ``ckan.plugins`` setting in your CKAN
config file (by default the config file is located at

4. Restart CKAN. For example if you've deployed CKAN with Apache on Ubuntu::

sudo service apache2 reload

Config Settings
Datastore_ts uses configurations from Datastore plugin so make sure those are set. In brief:

sqlalchemy.url = postgresql://ckan_default:pass@localhost/ckan_default

ckan.datastore.write_url = postgresql://ckan_default:password@localhost/datastore_default

ckan.datastore.read_url = postgresql://datastore_default:password@localhost/datastore_default

Development Installation

To install ckanext-datastore_ts for development, activate your CKAN virtualenv and

git clone
cd ckanext-datastore_ts
python develop
pip install -r dev-requirements.txt

Running the Tests

To run the tests, do::

nosetests --nologcapture --ckan --with-pylons=test-core.ini ckanext/datastore_ts/tests/test.. .py

To run the tests and produce a coverage report, first make sure you have
coverage installed in your virtualenv (``pip install coverage``) then run::

nosetests --nologcapture --with-pylons=test.ini --with-coverage --cover-package=ckanext.datastore_ts --cover-inclusive --cover-erase --cover-tests

Registering ckanext-datastore_ts on PyPI

ckanext-datastore_ts should be availabe on PyPI as If that link doesn't work, then
you can register the project on PyPI for the first time by following these

1. Create a source distribution of the project::

python sdist

2. Register the project::

python register

3. Upload the source distribution to PyPI::

python sdist upload

4. Tag the first release of the project on GitHub with the version number from
the ```` file. For example if the version number in ```` is
0.0.1 then do::

git tag 0.0.1
git push --tags

Releasing a New Version of ckanext-datastore_ts

ckanext-datastore_ts is availabe on PyPI as
To publish a new version to PyPI follow these steps:

1. Update the version number in the ```` file.
See `PEP 440 <>`_
for how to choose version numbers.

2. Create a source distribution of the new version::

python sdist

3. Upload the source distribution to PyPI::

python sdist upload

4. Tag the new release of the project on GitHub with the version number from
the ```` file. For example if the version number in ```` is
0.0.2 then do::

git tag 0.0.2
git push --tags

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for ckanext-datastore_ts, version 0.1.1
Filename, size File type Python version Upload date Hashes
Filename, size ckanext-datastore_ts-0.1.1.tar.gz (57.4 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page