REST API calls for TimescaleDB like Kairosdb for Cassandra TSDB

yshashi · May 5, 2023, 8:37am

Dear Community,

Do you know if there is any available opensource application that I can use to do REST API calls to timescaleDB as KairosDB provides to Cassandra for time-series DB. I would share these API calls with outside users so I wanted to have restricted API calls only rather than giving direct access to my timescaleDB. Any thoughts on it from community?

David_Sooter · May 6, 2023, 11:44am

Postgrest might be interesting to look at has great performance and is easy to set up PostgREST Documentation — PostgREST 10.2.0 documentation

jonatasdp · May 7, 2023, 12:01am

I was going to suggest the same! I found this tutorial (needs subscription) from packtpub too:

https://subscription.packtpub.com/book/data/9781838648145/8/ch08lvl1sec86/postgrest-on-timescaledb

Also, this very old but well structured gist with more details:

gist.github.com

https://gist.github.com/steve-chavez/38118d6bb6e80d5edcade8867957d877

docker-compose.yml

version: '3'
services:
  db:
    image: timescale/timescaledb:latest-pg10
    ports:
      - "5432:5432"
    environment:
      POSTGRES_DB: devices_small
      POSTGRES_USER: app_user
  pgrest:

This file has been truncated. show original

quickstart.sh

## Using the devices data set from 
## https://docs.timescale.com/v0.10/tutorials/other-sample-datasets

# Starting containers
docker-compose up -d

# Downloading and loading data and schema
wget -qO- https://timescaledata.blob.core.windows.net/datasets/devices_small.tar.gz | tar xvz
psql -U app_user -d devices_small -h localhost <<EOF
  CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;

This file has been truncated. show original

yshashi · May 8, 2023, 2:38pm

Thanks @jonatasdp @David_Sooter . I will take a look on it