Marshall An haokanga

## aws-s3-list-bucket-size.sh

for dir in $(aws s3 ls  | awk '{print $3'}); do
	size=$(aws s3 ls s3://${dir} --recursive  | grep -v -E "(Bucket: |Prefix: |LastWriteTime|^$|--)" | awk 'BEGIN {total=0}{total+=$3}END{print total/1024/1024" MB"}');
	echo "${dir} => $size" | tee -a disk.txt
done

## how-to-setup-lambda-to-talk-to-internet-and-vpc.md

      
              1 file
            
          
              87 forks
            
          
              82 comments
            
          
              489 stars
            
          
                reggi
                / how-to-setup-lambda-to-talk-to-internet-and-vpc.md
            
            
              Last active
              May 17, 2024 10:04
            
          
    How to setup AWS lambda function to talk to the internet and VPC

I'm going to walk you through the steps for setting up a AWS Lambda to talk to the internet and a VPC. Let's dive in.
So it might be really unintuitive at first but lambda functions have three states.

No VPC, where it can talk openly to the web, but can't talk to any of your AWS services.
VPC, the default setting where the lambda function can talk to your AWS services but can't talk to the web.
VPC with NAT, The best of both worlds, AWS services and web.


## MacBookNetworkAliveOnSleep.md

      
              1 file
            
          
              2 forks
            
          
              4 comments
            
          
              13 stars
            
          
                jyore
                / MacBookNetworkAliveOnSleep.md
            
            
              Last active
              January 2, 2024 15:18
            
              
                Keep Your MacBook Network Connections Alive As It Sleeps!
              
          
    MacBookNetworkAliveOnSleep

As someone that regularly has multiple SSH/VPN sessions open, it can be a huge inconvience to lose all the connections when I lock my screen to get up to go to a meeting, lunch, etc. This is especially true for those connections that require two factor authentication. So, how can I tell my MacBook to keep those connections alive, even though my screen is locked?
Well, turns out that it is pretty simple. All that is needed is to run the following command.
cd /System/Library/PrivateFrameworks/Apple80211.framework/Versions/Current/Resources
sudo ./airport en0 prefs DisconnectOnLogout=NO


## PostgreSQL_index_naming.rst

      
              1 file
            
          
              34 forks
            
          
              5 comments
            
          
              180 stars
            
          
                popravich
                / PostgreSQL_index_naming.rst
            
            
              Last active
              May 30, 2024 06:39
            
              
                PostgreSQL index naming convention to remember
              
          
    The standard names for indexes in PostgreSQL are:
{tablename}_{columnname(s)}_{suffix}
where the suffix is one of the following:


pkey for a Primary Key constraint;
key for a Unique constraint;
excl for an Exclusion constraint;
idx for any other kind of index;


## fix-homebrew-npm.md

      
              1 file
            
          
              177 forks
            
          
              361 comments
            
          
              1615 stars
            
          
                DanHerbert
                / fix-homebrew-npm.md
            
            
              Last active
              February 12, 2024 17:18
            
              
                Instructions on how to fix npm if you've installed Node through Homebrew on Mac OS X or Linuxbrew
              
          
    OBSOLETE

This entire guide is based on an old version of Homebrew/Node and no longer applies. It was only ever intended to fix a specific error message which has since been fixed. I've kept it here for historical purposes, but it should no longer be used. Homebrew maintainers have fixed things and the options mentioned don't exist and won't work.
I still believe it is better to manually install npm separately since having a generic package manager maintain another package manager is a bad idea, but the instructions below don't explain how to do that.
Fixing npm On Mac OS X for Homebrew Users

Installing node through Homebrew can cause problems with npm for globally installed packages. To fix it quickly, use the solution below. An explanation is also included at the end of this document.

  
## fix_github_https_repo.sh
#/bin/bash
#-- Script to automate https://help.github.com/articles/why-is-git-always-asking-for-my-password

REPO_URL=`git remote -v | grep -m1 '^origin' | sed -Ene's#.*(https://[^[:space:]]*).*#\1#p'`
if [ -z "$REPO_URL" ]; then
  echo "-- ERROR:  Could not identify Repo url."
  echo "   It is possible this repo is already using SSH instead of HTTPS."
  exit
fi

	for dir in $(aws s3 ls \| awk '{print $3'}); do
	size=$(aws s3 ls s3://${dir} --recursive \| grep -v -E "(Bucket: \|Prefix: \|LastWriteTime\|^$\|--)" \| awk 'BEGIN {total=0}{total+=$3}END{print total/1024/1024" MB"}');
	echo "${dir} => $size" \| tee -a disk.txt
	done
	#/bin/bash
	#-- Script to automate https://help.github.com/articles/why-is-git-always-asking-for-my-password

	REPO_URL=`git remote -v \| grep -m1 '^origin' \| sed -Ene's#.(https://[^[:space:]]).*#\1#p'`
	if [ -z "$REPO_URL" ]; then
	echo "-- ERROR: Could not identify Repo url."
	echo " It is possible this repo is already using SSH instead of HTTPS."
	exit
	fi