Checksum

• Clone elm/compiler
• Install stack
• Install required version of cabal using stack --resolver lts-9 install cabal-install (commercialhaskell/stack#3453 (comment))
• PATH=~/.local/bin:$PATH stack init --solver to install the required version of GHC
• PATH=~/.local/bin:$PATH stack build --flag elm:dev to build

Checksum

• Split every character: "something".split(/(?!^)/)

• Never split: "something".split(/^.$/)

Checksum

-- type 'go' to execute the block

-- List all tables

1> select * from information_schema.tables;

-- Describe table
1> exec sp_columns table_name;

Checksum

-- Get size of database

SELECT pg_size_pretty(pg_database_size('database-name'));
                                       
-- Set the current session as read only
SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY;
                                  
-- Locks
-- https://www.postgresql.org/docs/10/functions-admin.html#FUNCTIONS-ADVISORY-LOCKS
SELECT pg_try_advisory_lock(123123213123) as lockObtained;

Checksum

flags: {}
packages:
  - .
extra-deps:
  - language-glsl-0.3.0@sha256:85c1e7bf2cf5d6e604b7a2899c27e2935033425944db200798e57849e64d4c81
  - time-1.9.2@sha256:874e07fb970531b9dcd814f74e00f253ce2f22ccd8272a6c4c137ee9040237fb
resolver: lts-12.14

Checksum

# Requires git and docker

# clone bitwarden_rs
git clone https://github.com/dani-garcia/bitwarden_rs
cd bitwarden_rs

# Use rust docker container to build everything
docker run --rm -it -v `pwd`:/bitwarden rust bash

# Download pi tools and openssl

Checksum

#!/bin/bash

# Dynamic bracket expansion
eval echo "{1..3}"
eval echo "foo-{bar,baz}-{1..3}"

# Merge JSON objects
merged="$(jq -ers '.[0] * .[1]' <(echo '{"name": "foo"}') <(echo '{"age": "baz"}') 2>/dev/null)"

# Check if string is valid JSON

Checksum

const WebSocketProxy = new Proxy(window.WebSocket, {
  construct(target, args) {
    console.log("Proxying WebSocket connection", ...args);
    const ws = new target(...args);
    
    // Configurable hooks
    ws.hooks = {
      beforeSend: () => null,
      beforeReceive: () => null
    };

Checksum

# JSON diff and patch for jq (https://stedolan.github.io/jq/)
# Author: Srinath Sankar
#
# Usage:
# diff: jq -sS 'include "diff-patch"; diff' a.json b.json > patch.json
# patch: jq -sS 'include "diff-patch"; patch' a.json patch.json
#
# Caveats: tested only with top level objects using jq 1.6

def flatten_obj:

Checksum

# A simple assertion library for jq (https://github.com/stedolan/jq)
# Author: Srinath Sankar

def assert(level; expr; msg):
  if expr then
    .
  else
    . |= . + [{ level: level, message: msg }]
  end;