Discover gists

layout	author	title	revision	version	description
default	mattmc3	Modern SQL Style Guide	2019-01-17	1.0.1	A guide to writing clean, clear, and consistent SQL.

Modern SQL Style Guide

Docker compose as a systemd unit

Create file /etc/systemd/system/docker-compose@.service. SystemD calling binaries using an absolute path. In my case is prefixed by /usr/local/bin, you should use paths specific for your environment.

[Unit]
Description=%i service with docker compose
PartOf=docker.service
After=docker.service

Error

The authenticity of host 'github.com (140.82.113.4)' can't be established.

Fix

ssh-keyscan github.com >> ~/.ssh/known_hosts

Complete Recent Discord Quest

Note

This no longer works in browser! If you absolutely need to use browser instead of desktop app, use an extension to add the string Electron/ anywhere in your user-agent.

How to use this script:

Accept the quest under User Settings -> Gift Inventory
Join a vc
Join the same vc on an alt
Stream any window (can be notepad or something)

	# CLI
	sudo apt update -y
	sudo apt install -y \
	git curl docker.io \
	build-essential pkg-config autoconf bison rustc cargo clang \
	libssl-dev libreadline-dev zlib1g-dev libyaml-dev libreadline-dev libncurses5-dev libffi-dev libgdbm-dev libjemalloc2 \
	libvips imagemagick libmagickwand-dev \
	redis-tools sqlite3 libsqlite3-0 libmysqlclient-dev \
	rbenv apache2-utils

	deb http://archive.ubuntu.com/ubuntu/ jammy main restricted universe multiverse
	# deb-src http://archive.ubuntu.com/ubuntu/ jammy main restricted universe multiverse

	deb http://archive.ubuntu.com/ubuntu/ jammy-updates main restricted universe multiverse
	# deb-src http://archive.ubuntu.com/ubuntu/ jammy-updates main restricted universe multiverse

	deb http://archive.ubuntu.com/ubuntu/ jammy-security main restricted universe multiverse
	# deb-src http://archive.ubuntu.com/ubuntu/ jammy-security main restricted universe multiverse

	deb http://archive.ubuntu.com/ubuntu/ jammy-backports main restricted universe multiverse

	#include <IOKit/IOKitLib.h>
	#include <mach/mach.h>
	#include <stdio.h>
	#include <stdint.h>
	#include <stdlib.h>
	#include <ctype.h>

	void hexdump(void *ptr, int buflen) {
	unsigned char buf = (unsigned char)ptr;
	int i, j;

	WHAT THIS IS
	------------
	The DELL LATITUDE E7440's docking station supports two external displays, and
	the notebook's Haswell architecture supports having three displays active at
	the same time. It works well, but the two external monitors are merged into one
	big display:

	$ xrandr
	Screen 0: minimum 320 x 200, current 5280 x 1080, maximum 32767 x 32767
	eDP1 connected primary 1920x1080+0+0 (normal left inverted right x axis y axis) 309mm x 174mm