Pushing data to PostgreSQL from couchbase DB

jishabee · February 7, 2018, 7:23am

How to push the couchbase db data to PostgreSQL ? I’m quite new to couchbase and PostgreSQL.
Kindly help me

avsej · February 7, 2018, 7:34am

Could you describe your setup and usecase? Every time your applications sends new JSON object into Couchbase, you want to upsert the same object into postgresql?

jishabee · February 7, 2018, 9:19am

Basically I need to create a dashboard using Grafana for an app. Currently the app is using couchbase db. So need push the data to PostgreSQL.

avsej · February 7, 2018, 9:27am

Because grafana itself can only access postgresql in your setup?

jishabee · February 7, 2018, 10:00am

all these db are available so thouht in this way.

avsej · February 7, 2018, 10:17am

No, there is no grafana datasource for Couchbase yet, but you could try to use SimpleJson datasource and write service, which will export data you need as JSON.

Here is the most simple implementation using javascript programming language:

github.com

bergquist/fake-simple-json-datasource/blob/master/index.js

var express = require('express');
var bodyParser = require('body-parser');
var _ = require('lodash');
var app = express();

app.use(bodyParser.json());

var timeserie = require('./series');

var now = Date.now();

for (var i = timeserie.length -1; i >= 0; i--) {
  var series = timeserie[i];
  var decreaser = 0;
  for (var y = series.datapoints.length -1; y >= 0; y--) {
    series.datapoints[y][1] = Math.round((now - decreaser) /1000) * 1000;
    decreaser += 50000;
  }
}

This file has been truncated. show original