Skip to content

Instantly share code, notes, and snippets.

View rafaelverger's full-sized avatar

Rafael Nunes Verger rafaelverger

View GitHub Profile
@rafaelverger
rafaelverger / homebrew-install-older-version.md
Created January 31, 2022 14:54
Homebrew: Install an older version of a formula

Homebrew: Install an older version of a formula

kubernetes-cli (v1.10.3) taken as example

  1. Downgrade Homebrew to the commit which upgrades the formula to the specific version that we want
$ cd "$(brew --repo homebrew/core)"
$ git log Formula/kubernetes-cli.rb

...
@rafaelverger
rafaelverger / vwdependencies.sql
Created August 28, 2018 21:23 — forked from adamantnz/vwdependencies.sql
Redshift - view table/schema dependencies
CREATE OR REPLACE VIEW dbo.vwdependencies
AS
SELECT DISTINCT c_p.oid AS tbloid
,n_p.nspname AS schemaname
,c_p.relname AS NAME
,n_c.nspname AS refbyschemaname
,c_c.relname AS refbyname
,c_c.oid AS viewoid
FROM pg_class c_p
JOIN pg_depend d_p ON c_p.relfilenode = d_p.refobjid