A (more) complete cheatsheet for Arel, including NamedFunction functions, raw SQL and window functions.
posts = Arel::Table.new(:posts)
posts = Post.arel_table # ActiveRecord
Bo Jeanes bjeanes
IanColdwater
/ twittermute.txt
Last active
August 13, 2026 20:21
Here are some terms to mute on Twitter to clean your timeline up a bit.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Mute these words in your settings here: https://twitter.com/settings/muted_keywords | |
| ActivityTweet | |
| generic_activity_highlights | |
| generic_activity_momentsbreaking | |
| RankedOrganicTweet | |
| suggest_activity | |
| suggest_activity_feed | |
| suggest_activity_highlights | |
| suggest_activity_tweet |
christopherlai
/ Dockerfile
Created
September 16, 2019 22:57
Example Dockerfile for Elixir 1.9.1 umbrella project
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| FROM elixir:1.9.1-alpine as build | |
| ENV MIX_ENV=prod | |
| WORKDIR /build | |
| RUN apk add --no-cache build-base nodejs yarn && \ | |
| mix local.hex --force && \ | |
| mix local.rebar --force |
shayded-exe
/ generate_sequential_uuid.sql
Last active
October 9, 2021 14:32
pgSQL time-based sequential UUID generator based on https://www.2ndquadrant.com/en/blog/sequential-uuid-generators/
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE OR REPLACE FUNCTION generate_sequential_uuid(p_interval_length int DEFAULT 60) | |
| RETURNS uuid | |
| LANGUAGE plpgsql | |
| AS $$ | |
| DECLARE | |
| v_i int; | |
| v_time bigint; | |
| v_bytes int[16] = '{}'; | |
| v_hex text[16] = '{}'; | |
| BEGIN |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| default['sshd']['sshd_config']['AuthenticationMethods'] = 'publickey,keyboard-interactive:pam' | |
| default['sshd']['sshd_config']['ChallengeResponseAuthentication'] = 'yes' | |
| default['sshd']['sshd_config']['PasswordAuthentication'] = 'no' |
thomasloven
/ hass-icons.txt
Last active
April 17, 2023 19:30
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| hass:account | |
| hass:alert | |
| hass:alert-circle | |
| hass:altimeter | |
| hass:apple-safari | |
| hass:apps | |
| hass:arrow-bottom-left | |
| hass:arrow-down | |
| hass:arrow-left | |
| hass:arrow-right |
mcfrojd
/ Shield_Intents.MD
Last active
July 22, 2026 13:34
Working INTENTS to use with Community Hass.io Add-ons: Android Debug Bridge for your Nvidia Shield TV
Latest Update 2021-03-06 : New image showing the new "Services" in Home Assistant and got some tips from the comments below.
Credits and thanks: Home Assistant Forum users & Github users: @ocso, @wiphye, @teachingbirds, @tboyce1, @simbesh, @JeffLIrion @ff12 @rebmemer @siaox @DiederikvandenB @Thebuz @clapbr @Finsterclown
Starts Youtube App
entity_id: media_player.shield
command: >-
Download the latest ugw3 package from https://github.com/Lochnair/vyatta-wireguard/releases and install it on your USG using dpkg -i wireguard-ugw3-<version>.deb.
cd /config/auth
umask 077
mkdir wireguard
cd wireguard
wg genkey > wg_private.key
wg pubkey < wg_private.key > wg_public.key
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| module CheckJEMalloc | |
| require 'ffi' | |
| extend FFI::Library | |
| def self.je_malloc_exists?(jemalloc_so = nil) | |
| if !jemalloc_so.nil? && !jemalloc_so.is_a?(String) | |
| puts "ArgumentError : Only strings allowed as arguments" | |
| return false | |
| end | |
| jemalloc_so = ENV.fetch('LD_PRELOAD','') if jemalloc_so.nil? |
garybernhardt
/ gist:c2fceef67bcba989b2742dad88c9170b
Created
September 17, 2018 18:34
Automatically fix rubocop errors, with one commit per error
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| rubocop | egrep ' (W|C): ' | cut -d ' ' -f 3 | sort -u | sed 's/:$//' | while read cop; do | |
| git checkout . | |
| rubocop -a --only "$cop"; | |
| if [[ $(git diff --stat) != '' ]]; then | |
| git add --all | |
| git commit -m "fix rubocop cop $cop" | |
| fi | |
| done |