Project

datascope

0.13
No commit activity in last 3 years
No release in over 3 years
postgres 9.2 visibility
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
 Dependencies

Runtime

>= 0
>= 0
>= 0
rack-coffee
>= 0
>= 0
 Project Readme

Datascope

Visability into your Postgres 9.2 database via pg_stat_statements and cubism and using the json datatype.

http://f.cl.ly/items/440Z1L1n2v3q3c1Q3J0s/datascope.png

Check out a live example

Heroku Deploy

Datascope needs two Postgres 9.2 databases. The first is a DATABASE_URL with the datascope schema, the second is a TARGET_DB with the pg_stat_statements extension.

$ heroku create

$ heroku addons:add heroku-postgresql:dev --version=9.2
Attached as HEROKU_POSTGRESQL_COPPER_URL
$ heroku config:add DATABASE_URL=$(heroku config:get HEROKU_POSTGRESQL_COPPER_URL)
$ heroku pg:psql COPPER
=> \i schema.sql
CREATE TABLE

$ heroku addons:add heroku-postgresql:dev --version=9.2
Attached as HEROKU_POSTGRESQL_GREEN_URL

$ heroku config:add TARGET_DB=$(heroku config:get HEROKU_POSTGRESQL_GREEN_URL)
$ heroku pg:psql GREEN
=> create extension pg_stat_statements;
CREATE EXTENSION

$ git push heroku master
$ heroku scale worker=1

Basic Auth

If you don't want your deployment of datascope to be publicly visible, simply add environment variables for BASIC_AUTH_USER and BASIC_AUTH_PASSWORD.

heroku config:add BASIC_AUTH_USER=admin BASIC_AUTH_PASSWORD=password