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
ProGM
/ arel_cheatsheet_on_steroids.md
Last active
September 21, 2025 09:40
Arel cheatsheet on Steroids
IanColdwater
/ twittermute.txt
Last active
August 18, 2025 07:02
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
August 18, 2025 18:11
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: >-
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
| <select name="user[time_zone]" id="user_time_zone"> | |
| <option value="American Samoa">(GMT-11:00) American Samoa</option> | |
| <option value="International Date Line West">(GMT-11:00) International Date Line West</option> | |
| <option value="Midway Island">(GMT-11:00) Midway Island</option> | |
| <option value="Hawaii">(GMT-10:00) Hawaii</option> | |
| <option value="Alaska">(GMT-09:00) Alaska</option> | |
| <option value="Pacific Time (US & Canada)">(GMT-08:00) Pacific Time (US & Canada)</option> | |
| <option value="Tijuana">(GMT-08:00) Tijuana</option> | |
| <option value="Arizona">(GMT-07:00) Arizona</option> | |
| <option value="Chihuahua">(GMT-07:00) Chihuahua</option> |
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? |