Simple background script to kill git-credential-manager when it hits the 100% cpu bug
This file contains 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
-- Refresh materialized views recursively | |
-- DEPENDS: | |
-- List the tables that a view depends on. | |
-- Thanks to Dave: http://stackoverflow.com/questions/4229468/getting-a-list-of-tables-that-a-view-table-depends-on-in-postgresql | |
create or replace function inf_view_dependencies(v text) | |
returns table (kind text, name text) as $$ | |
SELECT cl_d.relkind::text as kind | |
, cl_d.relname::text AS name | |
FROM pg_rewrite AS r |
This file contains 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
#!/usr/bin/env bash | |
set -eo pipefail | |
set -x | |
while [ "$1" != "" ] | |
do | |
bash secrets_without_certificates.sh -n "$1" | |
shift | |
done |
This file contains 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
-- Based off IETF draft, https://datatracker.ietf.org/doc/draft-peabody-dispatch-new-uuid-format/ | |
create or replace function uuid_generate_v7() | |
returns uuid | |
as $$ | |
declare | |
unix_ts_ms bytea; | |
uuid_bytes bytea; | |
begin | |
unix_ts_ms = substring(int8send(floor(extract(epoch from clock_timestamp()) * 1000)::bigint) from 3); |
This file contains 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
Forked from https://gist.github.com/mateuszwenus/ |
OlderNewer