DMeechan

-- Postgres lets you create a 'constant table' that can be used in a query without actually persisting it
-- Source: https://www.postgresql.org/docs/current/queries-values.html

-- There's a couple ways we can use it:

WITH ages (id) AS (VALUES (13), (21), (32), (32), (78), (78))
SELECT DISTINCT id from ages;

SELECT DISTINCT id
FROM (VALUES (13), (21), (32), (32), (78), (78)) ages (id);

DMeechan

My Windows Setup

Most of the programs on my Windows PC are installed using Scoop (think brew but for Windows). But before installing Scoop, let's set up the Terminal.

Windows Terminal

I use Windows Terminal (preview) from the Windows Store.

You can find my profiles.json config here.

DMeechan

// To view the default settings, hold "alt" while clicking on the "Settings" button.
// For documentation on these settings, see: https://aka.ms/terminal-documentation

{
    "$schema": "https://aka.ms/terminal-profiles-schema",

    "defaultProfile": "{574e775e-4f2a-5b96-ac1e-a2962a402336}",

    "profiles":

DMeechan

Bulk rename videos like this:

20191109_212029.mp4 (in the format: yearMonthDay_hourMinuteSecond)

to:

2019-11-09_21-20-29.mp4 (year-month-day_hour-minute-second)

By running this bash command:

DMeechan

// runTests();

const fs = require("fs");

const fileOne = "../exports/someA.csv";
const fileTwo = "../exports/someB.csv";
const fileThree = "../exports/someC.csv";
const outputFile = "../exports/someOut.csv";

const arrayOne = readFile(fileOne);

DMeechan

Clean up local branches 🏚

Prune merged branches

Delete all local branches which are merged to master (or whatever branch you choose to checkout)

git checkout master
git branch --merged | egrep -v "(^\*|master|dev)" | xargs git branch -d

DMeechan

Handy Neo4j Commands

Learn more on this page in the Neo4j docs.

Created with help from @DaniSancas's Neo4j Cypher cheatsheet.

Finding all nodes

View all nodes

DMeechan

await client.indices.get({ index: "*" })

DMeechan

Prerequisites (Mac)

• brew install gnupg

Setting up GitHub / GitLab

1. Check public key ID: gpg --list-secret-keys --keyid-format LONG
2. Then where it says sec rsa4096/KEY_ID, take the KEY_ID and put it into the command below:
3. Copy public key: gpg --armor --export KEY_ID | pbcopy
4. Open up GitHub (or GitLab): open https://github.com/settings/keys

DMeechan

Keybase proof

I hereby claim:

• I am dmeechan on github.
• I am dmeechan1 (https://keybase.io/dmeechan1) on keybase.
• I have a public key whose fingerprint is 0E1C BB5A 2C69 62B7 D5DD 365A 73F2 F9BF 5083 D4EF

To claim this, I am signing this object: