Skip to content

Instantly share code, notes, and snippets.

@jacobrose
jacobrose / FINPAY-775.deduplicate_finpay_data.sql
Last active February 4, 2025 17:37
Inserting duplicate rows into a backup table in preparation for deletion
CREATE TABLE `etsy-data-warehouse-dev.finpay.adyen_settlement_detail_backup_2025_02_04`
CLONE `etsy-data-warehouse-dev.finpay.adyen_settlement_detail`;
ALTER TABLE `etsy-data-warehouse-dev.finpay.adyen_settlement_detail_backup_2025_02_04`
SET OPTIONS (
expiration_timestamp = TIMESTAMP '2025-03-05 18:00:00'
);
CREATE TABLE `etsy-data-warehouse-dev.finpay.adyen_settlement_detail_deduplication_2025_02_04`
LIKE `etsy-data-warehouse-dev.finpay.adyen_settlement_detail`;
INSERT INTO `etsy-data-warehouse-dev.finpay.adyen_settlement_detail_deduplication_2025_02_04` (
@DandyLyons
DandyLyons / NightModeView.swift
Last active June 3, 2025 03:41
NightModeView
//
// NightModeView.swift
//
// Created by Daniel Lyons on 9/12/23.
//
import SwiftUI
struct NightModeView: View {
var body: some View {
10014, 91008, 90210, 92067, 93108, 94024, 10065, 07926, 92661, 21056, 81654, 11976, 11932, 10075, 91302, 10013, 89125, 81611, 10577, 92657, 94528, 10012, 94010, 94920, 11765, 10007, 10021, 10003, 95030, 94957, 33109, 10010, 94062, 94028, 90265, 90077, 10024, 92091, 93953, 90402, 94022, 11930, 02807, 11975, 94610, 94022, 11568, 10023, 92662, 94920, 98039, 90272, 92651, 07976, 90049, 11545, 85253, 10011, 60043, 94970, 92625, 10022, 29941, 94024, 11965, 10580, 10282, 94301, 10001, 93066, 11024, 94904, 08738, 11968, 06830, 91108, 90266, 94611, 81615, 92118, 07931, 07458, 10528, 81657, 92014, 94507, 96821, 29482, 06820, 95070, 93460, 11978, 92663, 06878, 95030, 92037, 06840, 11560, 90274, 81632, 06853, 10533, 11963, 93921, 02481, 07078, 92603, 11960, 08750, 11724, 07632, 91302, 11030, 10009, 22066, 02493, 93923, 90401, 33921, 94123, 10597, 06870, 92660, 90067, 06831, 10069, 06880, 19085, 93067, 91011, 94574, 10506, 90069, 94946, 90212, 90027, 11569, 94010, 19035, 07417, 94939, 11964, 94506, 94515, 10504, 60093, 10
@jacobrose
jacobrose / .bash_profile
Created November 1, 2017 15:02
Help Docker for Mac play nice on your computer, with 'renice'
# docker -- set hyperkit priority to 10 so it doesn't eat the CPU
alias dockerpri='echo -n "docker priority currently: "; ps alx | grep .app/Contents/MacOS/com.docker.hyperkit | grep -v grep | sed "s: *[0-9]* *[0-9]* *[0-9]* *[0-9]* *[0-9]* *\([0-9]*\) .*:\1:"'
alias dockernice='sudo renice 10 $(ps ax | grep .app/Contents/MacOS/com.docker.hyperkit | grep -v grep | sed "s: *\([0-9]*\) .*:\1:"); echo -n "dockerpri: "; dockerpri'

FWIW: I (@rondy) am not the creator of the content shared here, which is an excerpt from Edmond Lau's book. I simply copied and pasted it from another location and saved it as a personal note, before it gained popularity on news.ycombinator.com. Unfortunately, I cannot recall the exact origin of the original source, nor was I able to find the author's name, so I am can't provide the appropriate credits.


Effective Engineer - Notes

What's an Effective Engineer?

{
"fields": [
"location"
],
"query": {
"function_score": {
"functions": [
{
"exp": {
"location": {
@d11wtq
d11wtq / docker-ssh-forward.bash
Created January 29, 2014 23:32
How to SSH agent forward into a docker container
docker run -rm -t -i -v $(dirname $SSH_AUTH_SOCK) -e SSH_AUTH_SOCK=$SSH_AUTH_SOCK ubuntu /bin/bash
@dergachev
dergachev / GIF-Screencast-OSX.md
Last active October 31, 2025 16:45
OS X Screencast to animated GIF

OS X Screencast to animated GIF

This gist shows how to create a GIF screencast using only free OS X tools: QuickTime, ffmpeg, and gifsicle.

Screencapture GIF

Instructions

To capture the video (filesize: 19MB), using the free "QuickTime Player" application:

//
// Regular Expression for URL validation
//
// Author: Diego Perini
// Created: 2010/12/05
// Updated: 2018/09/12
// License: MIT
//
// Copyright (c) 2010-2018 Diego Perini (http://www.iport.it)
//