Jeff Meyers jeffmeyers

## keybase.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                jeffmeyers
                / keybase.md
            
            
              Created
              November 2, 2021 16:32
            
          
    Keybase proof

I hereby claim:

I am jeffmeyers on github.
I am jmeyers (https://keybase.io/jmeyers) on keybase.
I have a public key ASAgFGlb6wVPH1xc5_8eeXfRiIVx2xeqFjNZU2IJa9KARwo

To claim this, I am signing this object:

  
## remove_empty_s3_files.rb
require 'aws-sdk'

client = Aws::S3::Client.new
bucket = Aws::S3::Bucket.new({
  name: "bucketz",
  client: client
})

empty = bucket.objects.select { |obj| obj.size == 0 }
empty_count = empty.length

## gist:7b9d1ed2f59812b26bef9a4c36503948
aws s3 ls s3://mybucket/ --recursive | wc -l

## dups.sql
DELETE FROM dups a USING (
SELECT MIN(ctid) as ctid, key
  FROM dups
  GROUP BY key HAVING COUNT(*) > 1
) b
WHERE a.key = b.key
AND a.ctid <> b.ctid

## gist:242fefd19f9ecc1db9207e8ca497100d
location ~ /your-endpoint {
  resolver 8.8.8.8;
  proxy_ssl_server_name on;
  set $proxy_pass_1 'API_GATEWAY_URL';
  proxy_pass $proxy_pass_1?$args;
}
	require 'aws-sdk'

	client = Aws::S3::Client.new
	bucket = Aws::S3::Bucket.new({
	name: "bucketz",
	client: client
	})

	empty = bucket.objects.select { \|obj\| obj.size == 0 }
	empty_count = empty.length
	DELETE FROM dups a USING (
	SELECT MIN(ctid) as ctid, key
	FROM dups
	GROUP BY key HAVING COUNT(*) > 1
	) b
	WHERE a.key = b.key
	AND a.ctid <> b.ctid
	location ~ /your-endpoint {
	resolver 8.8.8.8;
	proxy_ssl_server_name on;
	set $proxy_pass_1 'API_GATEWAY_URL';
	proxy_pass $proxy_pass_1?$args;
	}