datascope

postgres 9.2 visibility

Github 星跟踪图

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

项目概况

主要编程语言JavaScript
编程语言Ruby
最后一次提交2014-03-12 14:20:23
创建于2012-11-06T05:43:27
推送于2014-03-12T21:20:23
提交数21
关注者数8
名称与所有者will/datascope
派生数28
星数259
问题数5
打开的问题数3
语言数4
拉请求数3
已启用问题?
已启用Wiki?
已存档?
是分叉?
已锁定?
是镜像?
是私有?
To the top