iconara

-- Table information like sortkeys, unsorted percentage
-- see http://docs.aws.amazon.com/redshift/latest/dg/r_SVV_TABLE_INFO.html
SELECT * FROM svv_table_info;

-- Table sizes in GB
SELECT t.name, COUNT(tbl) / 1000.0 AS gb
FROM (
  SELECT DISTINCT datname, id, name
  FROM stv_tbl_perm
  JOIN pg_database ON pg_database.oid = db_id

gphilipp

Q&A

Cadillac and Dinosaurs doesn't work with Mame

Cadillac and Dinosaurs and all CPS1 games need the qsound.zip rom present in the Arcade folder of the Game Library in order to work.

Garrett-R

"""How to gzip a string.

This works for Python 3.2.  For 3.1-, look at the original gist (under "Revisions")
"""
import gzip

def gzip_str(string_: str) -> bytes:
    return gzip.compress(string_.encode())

dehamzah

Basic Syntax

$ scp source_file_path destination_file_path

Uploading

Single file

greenido

//
// Goal: Send emails from your google sheet (or forms or CSV)
// Author: Ido Green | @greenido
// Date: Jan 2016
//

//
// Let's have a nice menu to start the process
//
function onOpen() {

ldez

Gmail and GitHub

How to filter emails from GitHub in Gmail and flag them with labels.

The labels in this document are just examples.

Pull Request

Filter	Label

pierrejoubert73

How to add a collapsible section in markdown

1. Example

Click me

Heading

1. Foo
2. Bar
   • Baz

• Qux

flopezluis

#Effective Communication

---

Prepare the conversation.

• Why are we having this conversation?
  Your time is valuable, other people's time is valuable. If you need to use this time, the least you can do is to prepare it. Things such as "what do you want to achieve?", "What info you need to give?", and all following...
• What do you expect from the meeting?
  How many times do you go to a meeting without thinking what's the outcome you want from it?
• Try to understand the audience.:
• How can I get to my audience better?.

JuanMiguelGM

# install this as pre-requisite
brew install bluetoothconnector
brew install switchaudio-osx

# In automator, create a new "Quick Action" Shell Script with no input and in any application: 
# mac and name for the airpods can be found executing: BluetoothConnector

set -e

mac=0c-3b-50-96-75-34