justisGipson

Dockerfile:

FROM node:20.10.0-alpine3.17 AS base

RUN apk update && \
   apk add --no-cache postgresql-client && \
   rm -rf /var/cache/apk/*

WORKDIR /usr/src/app

sudo apt-get clean;
sudo apt-get autoclean;
sudo journalctl --vacuum-size=50M;

sudo apt-get autoremove --purge;

sudo docker system prune -a;

sudo apt-get purge $(dpkg -l 'linux-image-*' | awk '/^ii/ &amp;&amp; !/'$(uname -r)'/ {print $2}');

add Docker's official GPG key:

sudo apt-get update sudo apt-get install ca-certificates curl sudo install -m 0755 -d /etc/apt/keyrings sudo curl -fsSL https://download.docker.com/linux/ubuntu/gpg -o /etc/apt/keyrings/docker.asc sudo chmod a+r /etc/apt/keyrings/docker.asc

add the repository to apt sources:

echo
"deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker.asc] https://download.docker.com/linux/ubuntu \

Unique Logins From Activity Table:

SELECT COUNT(DISTINCT "userId") AS unique_logins
FROM activity
WHERE
  "createdAt" >= now() - INTERVAL '3 months' -- or "createdAt" BETWEEN '2022-01-01' AND '2024-03-10'
  AND "userId" NOT IN (
    SELECT id FROM users
    WHERE
      "email" LIKE '%@ellipsiseducation.com%'

web: npm start # or whatever the start command is

Latency

CloudFront

Average Origin Latency:

avg_over_time(aws_cloudfront_origin_latency{<DIMENSION NAME="DIMENSION VALUE">}[5m])

Elastic Beanstalk

Application Latency p99:

Extract all name fields: $[*].name
Find object with a specific id (e.g., id 15): $[?(@.id==15)]
Extract defaultRegion from all jsonData: $[*].jsonData.defaultRegion
Filter objects by authType inside jsonData where authType is keys:

Tabs and Windows

Function	Shortcut
New Tab	`⌘` + `T`
Close Tab or Window	`⌘` + `W` (same as many mac apps)
Go to Tab	`⌘` + `Number Key` (ie: `⌘2` is 2nd tab)
Go to Split Pane by Direction	`⌘` + `Option` + `Arrow Key`
Cycle iTerm Windows	`⌘` + `backtick` (true of all mac apps and works with desktops/mission control)

	import sys
	import time
	from subprocess import CalledProcessError, check_output


	def convert_bytes_to_gb(bytes_value):
	return round(bytes_value / 1000000000, 2)


	def convert_kb_to_gb(kb_value):

	#!/usr/bin/env -S awk -f
	# Usage: /path/to/tf_vars_sort.awk < variables.tf \| tee sorted_variables.tf
	# Note: "chmod +x /path/to/tf_vars_sort.awk" before use
	{
	# skip blank lines at the beginning of file
	if (!resource_type && length($0) == 0) next

	# pick only known Terraform resource definition block names of the 1st level
	# https://github.com/hashicorp/terraform/blob/main/internal/configs/parser_config.go#L55-L163
	switch ($0) {