Skip to content

Instantly share code, notes, and snippets.

View xzilla's full-sized avatar

Robert Treat xzilla

View GitHub Profile
@xzilla
xzilla / postgres14demos.sql
Last active August 23, 2022 03:06
Whats New In PostgreSQL 14 => Demos Only
\q
/*
What's New In PostgreSQL 14: All Demo Edition
Robert Treat (@robtreat2) - v5 - 2022-08-21
Requirements:
Postgres 14
Pagila Sample Database (https://github.com/xzilla/pagila)
## Table of Contents ##
@xzilla
xzilla / README.MD
Last active July 8, 2022 19:51 — forked from lmarkus/README.MD
Extracting / Exporting custom emoji from Slack

Extracting Emoji From Slack!

Slack doesn't provide an easy way to extract custom emoji from a team. (Especially teams with thousands of custom emoji) This Gist walks you through a relatively simple approach to get your emoji out.

If you're an admin of your own team, you can get the list of emoji directly using this API: https://api.slack.com/methods/emoji.list. Once you have it, skip to Step 3

HOWEVER! This gist is intended for people who don't have admin access, nor access tokens for using that list.

Follow along...

@xzilla
xzilla / postgres12demos.sql
Last active May 29, 2020 20:46
Whats New In PostgreSQL 12 => Demos Only
\q
/*
What's New In PostgreSQL 12: All Demo Edition
Robert Treat (@robtreat2) - v5 - 2020-05-23
Requirements:
Postgres 12
Verifying that +xzilla is my blockchain ID. https://onename.com/xzilla

Keybase proof

I hereby claim:

  • I am xzilla on github.
  • I am xzilla (https://keybase.io/xzilla) on keybase.
  • I have a public key whose fingerprint is 2CF5 5E88 9017 5AAA 5332 A605 8743 5B0A 61E3 EB49

To claim this, I am signing this object:

@xzilla
xzilla / gist:4205488
Created December 4, 2012 16:00
ejs template to remove html tags
create custom filter like so:
ejs.filters.plaintext = function(obj) {
return obj.replace(/(<([^>]+)>)/ig,'');
};
then call it like so:
<%=: item.content.substring(0,94) | plaintext %>