Joao C Costa joaocc

## .mateuszwenus--save_restore_dependencies.sql
Forked from https://gist.github.com/mateuszwenus/

## README.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                joaocc
                / README.md
            
            
              Created
              March 15, 2023 21:25
                — forked from forivall/README.md
            
              
                git-credential-manager reaper script
              
          
    Simple background script to kill git-credential-manager when it hits the 100% cpu bug

  
## UUID_v7_for_Postgres.sql
-- 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);

## check_multi_namespaces.sh
#!/usr/bin/env bash
set -eo pipefail
set -x

while [ "$1" != "" ]
do
    bash secrets_without_certificates.sh -n "$1"
    shift
done

## inf_refresh_recursive.sql
-- 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

## fulldump.sh
#!/bin/bash
#  $Id: fulldump.sh,v 1.4 2013/10/31 14:25:36 postgres Exp postgres $
#  $Source: /var/lib/postgresql/8.2/RCS/fulldump.sh,v $
#  $Log: fulldump.sh,v $
#
#  Revision 1.4  2013/10/31 14:25:36  postgres
#  Removed pg_dump '-D' option, added $RETVAL
#  default value for the initial case - MS.
#
#  Revision 1.3  2007/09/28 13:29:07  postgres

## pgbackup.sh
#!/bin/bash
set -o nounset

##########################################
# Defaults
##########################################
: ${recipient:=}
: ${host:=localhost}
: ${port:=5432}
: ${databases:=}

## .gitattributes
## Unity ##

*.cs diff=csharp text
*.cginc text
*.shader text

*.mat merge=unityyamlmerge eol=lf
*.anim merge=unityyamlmerge eol=lf
*.unity merge=unityyamlmerge eol=lf
*.prefab merge=unityyamlmerge eol=lf

## Mac1010limits.sh
#!/bin/bash

if [ "$(id -u)" != "0" ]; then
	echo "This script must be run as root" 1>&2
	exit 1
fi

cat <<MAXFILES > /Library/LaunchDaemons/limit.maxfiles.plist
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">

## pedantically_commented_playbook.yml
---
# ^^^ YAML documents must begin with the document separator "---"
#
#### Example docblock, I like to put a descriptive comment at the top of my
#### playbooks.
#
# Overview: Playbook to bootstrap a new host for configuration management.
# Applies to: production
# Description:
#   Ensures that a host is configured for management with Ansible.
	-- 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);
	#!/usr/bin/env bash
	set -eo pipefail
	set -x

	while [ "$1" != "" ]
	do
	bash secrets_without_certificates.sh -n "$1"
	shift
	done
	-- 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
	#!/bin/bash
	# $Id: fulldump.sh,v 1.4 2013/10/31 14:25:36 postgres Exp postgres $
	# $Source: /var/lib/postgresql/8.2/RCS/fulldump.sh,v $
	# $Log: fulldump.sh,v $
	#
	# Revision 1.4 2013/10/31 14:25:36 postgres
	# Removed pg_dump '-D' option, added $RETVAL
	# default value for the initial case - MS.
	#
	# Revision 1.3 2007/09/28 13:29:07 postgres
	#!/bin/bash
	set -o nounset

	##########################################
	# Defaults
	##########################################
	: ${recipient:=}
	: ${host:=localhost}
	: ${port:=5432}
	: ${databases:=}
	## Unity ##

	*.cs diff=csharp text
	*.cginc text
	*.shader text

	*.mat merge=unityyamlmerge eol=lf
	*.anim merge=unityyamlmerge eol=lf
	*.unity merge=unityyamlmerge eol=lf
	*.prefab merge=unityyamlmerge eol=lf
	#!/bin/bash

	if [ "$(id -u)" != "0" ]; then
	echo "This script must be run as root" 1>&2
	exit 1
	fi

	cat <<MAXFILES > /Library/LaunchDaemons/limit.maxfiles.plist
	<?xml version="1.0" encoding="UTF-8"?>
	<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
	---
	# ^^^ YAML documents must begin with the document separator "---"
	#
	#### Example docblock, I like to put a descriptive comment at the top of my
	#### playbooks.
	#
	# Overview: Playbook to bootstrap a new host for configuration management.
	# Applies to: production
	# Description:
	# Ensures that a host is configured for management with Ansible.