BrianSigafoos

# frozen_string_literal: true

class ApplicationComponent < ViewComponent::Base
  private

  # Reference: https://www.youtube.com/watch?v=YVYRus_2KZM&t=302s
  def fetch_or_fallback(allowed_values, given_value, fallback)
    if allowed_values.include?(given_value)
      given_value
    else

BrianSigafoos

[
  {
    "key": "cmd+q",
    "command": "-workbench.action.quit",
  },
  {
    "key": "alt+cmd+.",
    "command": "workbench.action.terminal.focusAtIndex1"
  },
  {

BrianSigafoos

Stripe CLI

• Install the Stripe CLI with: brew install stripe/stripe-cli/stripe
• Login to our Stripe account: stripe login
• Listen for Stripe webhooks using Latest API version and forward to:
  • yarn stripe:listen, which does:
  • stripe listen --latest --forward-to http://localhost:3000/webhook_events/stripe
• Replay events locally with stripe trigger <event type>:
  • stripe trigger checkout.session.completed

BrianSigafoos

SELECT tablename FROM pg_tables WHERE schemaname = 'public';
-- Move out of public
DO
$$
DECLARE
    row record;
BEGIN
    FOR row IN SELECT tablename FROM pg_tables WHERE schemaname = 'public' -- and other conditions, if needed
    LOOP
        EXECUTE 'ALTER TABLE public.' || quote_ident(row.tablename) || ' SET SCHEMA valimail_defend_stage_reporting_20181127_super;';

BrianSigafoos

SELECT
    t.schemaname,
    t.tablename,
    indexname,
    c.reltuples AS num_rows,
    pg_size_pretty(pg_relation_size(quote_ident(t.schemaname)::text || '.' || quote_ident(t.tablename)::text)) AS table_size,
    pg_size_pretty(pg_relation_size(quote_ident(t.schemaname)::text || '.' || quote_ident(indexrelname)::text)) AS index_size,
    pg_relation_size(quote_ident(t.schemaname)::text || '.' || quote_ident(t.tablename)::text) AS table_size_raw,
    pg_relation_size(quote_ident(t.schemaname)::text || '.' || quote_ident(indexrelname)::text) AS index_size_raw,
    CASE WHEN indisunique THEN 'Y'

BrianSigafoos

Stimulus cheatsheet

• Website: https://stimulusjs.org/
• GitHub repo: https://github.com/stimulusjs/stimulus
• Handbook: https://stimulusjs.org/handbook/introduction
• Discourse: https://discourse.stimulusjs.org/

Lifecycle callbacks

• initialize: once, when the controller is first instantiated
• connect: anytime the controller is connected to the DOM

BrianSigafoos

#!/bin/sh

DB_DUMP=$HOME/<filename>.dump
DB_NAME=<db name>

if [ -f $DB_DUMP ]; then
	echo Creating database: $DB_NAME
	createdb $DB_NAME > /dev/null 2>&1

	if [ "$?" != "0" ]; then

BrianSigafoos

sudo apt-get -y update
sudo apt-get install -y build-essential libcurl4-openssl-dev unzip software-properties-common git libpcre3-dev libpcre3

adding zlib, openssl and pcre

cd && mkdir sources && cd sources
wget https://downloads.sourceforge.net/project/pcre/pcre/8.41/pcre-8.41.tar.gz && tar xzvf pcre-8.41.tar.gz

BrianSigafoos

# Original source: https://gist.github.com/hopsoft/56ba6f55fe48ad7f8b90
# Merged with: https://gist.github.com/kofronpi/37130f5ed670465b1fe2d170f754f8c6
# Benefits of: https://gist.github.com/e12e/e0c7d2cc1d30d18c8050b309a43450ac
# And fixes of: https://gist.github.com/joelvh/f50b8462611573cf9015e17d491a8a92
namespace :db do
  desc 'Dumps the database to backups'
  task dump: :environment do
    dump_fmt   = ensure_format(ENV['format'])
    dump_sfx   = suffix_for_format(dump_fmt)
    backup_dir = backup_directory(Rails.env, create: true)

BrianSigafoos

#!/bin/bash

#
# Initial script to create users when launching an Ubuntu server EC2 instance
#

declare -A USERKEY

#
# Create one entry for every user who needs access. Be sure to change the key to their