corndog 🌽🐶

multicorn wrapper for datadog

Install (essentials)

sudo apt-get install python-dev pgxnclient
sudo pgxn install multicorn
git clone https://github.com/globalundo/corndog
cd corndog
python setup.py install

Install from scratch on debian jessie

# Add postgresql.ord repo# https://wiki.postgresql.org/wiki/Apt
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
sudo apt-get install wget ca-certificates
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-9.6 postgresql-server-dev-9.6
sudo apt-get install python-dev pgxnclient
sudo apt-get install git
git clone https://github.com/globalundo/corndog
cd corndog
python setup.py install
#sudo sed -i 's/local all postgres peer/local all all trust/g' /etc/postgresql/9.6/main/pg_hba.conf#sudo sed -i "s/#listen_addresses.*/listen_addresses = '*'/g" /etc/postgresql/9.6/main/postgresql.conf#sudo sed -i 's|host.*|host all all 127.0.0.1/32 trust|g' /etc/postgresql/9.6/main/pg_hba.confsudo service postgresql restart#psql -U postgres <<EOF#CREATE DATABASE datadog;#\c datadog#CREATE EXTENSION multicorn;#CREATE SERVER corndog FOREIGN DATA WRAPPER multicorn#options (# wrapper 'corndog.DatadogForeignDataWrapper',# api_key 'YOUR_API_KEY_HERE',# app_key 'YOUR_APP_KEY_HERE'#);#CREATE FOREIGN TABLE metrics (# timestamp float,# value float,# startdate int,# enddate int,# query text,# scope text#) server corndog ;#select * from metrics limit 1;#select * from metrics where query='system.cpu.user{*}' limit 1;#select timestamp, value from metrics where query='system.cpu.user{*}' and startdate = extract(epoch from (now()-'20 days'::interval))::int;#select timestamp, value from metrics where query='system.cpu.user{*}' and startdate = extract(epoch from (now()-'12 hours'::interval))::int and enddate = extract(epoch from (now()-'2 hours'::interval))::int;##EOF

Usage

CREATE EXTENSION multicorn;
CREATE SERVER corndog FOREIGN DATA WRAPPER multicorn
options (
wrapper 'corndog.DatadogForeignDataWrapper',
api_key 'YOUR_API_KEY_HERE',
app_key 'YOUR_APP_KEY_HERE'
);
CREATE FOREIGN TABLE metrics (
timestamp float,
value float,
startdate int,
enddate int,
query text,
scope text
) server corndog;
select*from metrics limit1;
select*from metrics where query='system.cpu.user{*}'limit1;
selecttimestamp, value from metrics where query='system.cpu.user{*}'and startdate = extract(epoch from (now()-'20 days'::interval))::int;
selecttimestamp, value from metrics where query='system.cpu.user{*}'and startdate = extract(epoch from (now()-'12 hours'::interval))::intand enddate = extract(epoch from (now()-'2 hours'::interval))::int;