Skip to content

Instantly share code, notes, and snippets.

View pindlebot's full-sized avatar

Ben Gardner pindlebot

View GitHub Profile
sudo su -
yum install -y https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-redhat10-10-2.noarch.rpm
yum install -y postgresql10
sed -i "s/rhel-\$releasever-\$basearch/rhel-latest-x86_64/g" "/etc/yum.repos.d/pgdg-10-redhat.repo"
ln -s /usr/pgsql-10/bin/psql /usr/bin/psql
# test: https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/postgresql10-test-10.5-1PGDG.rhel7.x86_64.rpm
# server: https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/postgresql10-server-10.5-1PGDG.rhel7.x86_64.rpm
# contrib https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/postgresql10-contrib-10.5-1PGDG.rhel7.x86_64.rpm
# docs: https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/postgresql10-docs-10.5-1PGDG.rhel7.x86_64.rpm
module.exports = ({
messageId,
destination,
source,
subject,
snippet,
html,
text
}) => `
WITH data(
@pindlebot
pindlebot / with.psql
Last active September 17, 2018 17:07
WITH a AS (
INSERT INTO messages(user_id, thread_id) values('6a5afc90-2791-4905-813a-5397f15b8a3d', 'b10663fa-20a0-4445-9743-9319dffb962e') RETURNING id AS message_id
),
b AS (
INSERT INTO entities(name) values('ben') RETURNING id AS entity_id
)
INSERT INTO messages_entities(message_id, entity_id) SELECT a.message_id, b.entity_id FROM a, b;
SELECT messages.id, messages_entities.entity_id, entities.name
FROM messages
const got = require('got')
const Canvas = require('canvas')
const assert = require('assert')
const AWS = require('aws-sdk')
const PassThrough = require('stream').PassThrough
require('pdftk-lambda')
function NodeCanvasFactory () {}
global.HTMLElement = class {}
process.on('unhandledRejection', r => console.log(r))
npm uninstall -g rtoinsider-cli
npm i -g rtoinsider-cli@0.0.14
#!/usr/bin/env bash
yum -y update
yum -y install gcc make
cd /usr/local/src
wget http://download.redis.io/releases/redis-5.0-rc4.tar.gz
tar xzf redis-5.0-rc4.tar.gz
cd redis-5.0-rc4
make distclean
make
# include /path/to/local.conf
# include /path/to/other.conf
# bind 127.0.0.1
protected-mode no
port 6379
tcp-backlog 511
# unixsocket /tmp/redis.sock
# unixsocketperm 700
timeout 0
tcp-keepalive 0
#!/usr/bin/env bash
yum -y update
yum -y install gcc make
cd /usr/local/src
wget http://download.redis.io/releases/redis-3.2.0.tar.gz
tar xzf redis-3.2.0.tar.gz
rm -f 3.2.0.tar.gz
cd redis-3.2.0
make distclean
\PassOptionsToPackage{unicode=true}{hyperref} % options for packages loaded elsewhere
\PassOptionsToPackage{hyphens}{url}
%
\documentclass[]{article}
\usepackage{lmodern}
\usepackage{amssymb,amsmath}
\usepackage{ifxetex,ifluatex}
\usepackage{fixltx2e} % provides \textsubscript
\ifnum 0\ifxetex 1\fi\ifluatex 1\fi=0 % if pdftex
\usepackage[T1]{fontenc}
pdftk "${file}" dump_data | grep NumberOfPages | awk '{print $2}' | tr -dc '[0-9]'