Skip to content

Instantly share code, notes, and snippets.

@asmega
asmega / gist:3a57a63c5fdf5e2de0acdffb681b7d6f
Created December 23, 2023 10:30
add fingerprint to known hosts
ssh-keyscan -H YOUR.IP.GOES.HERE >> ~/.ssh/known_hosts
@asmega
asmega / index.sh
Created July 31, 2022 18:26
mac resize disk image
hdiutil resize -size 30g ~/path/to/file.sparsebundle
# HELP
hdiutil resize -help
@asmega
asmega / process.rb
Last active September 18, 2022 15:32
ticktick csv export
require "csv"
require "pry"
rows = CSV.read("./ticktick.csv", headers: true)
rows = rows.select { |row| row["Completed Time"].nil? }
CSV.open("./ticktick2.csv", "w") do |csv|
csv << rows[0].headers
rows.each do |row|
@asmega
asmega / gist:7cd47caafc02a0ff51d83444ce98e014
Last active July 9, 2021 12:23
simplest way to upload csv google bigquery
docker pull google/cloud-sdk:latest
docker run --rm -it docker.io/google/cloud-sdk:latest
gcloud auth activate-service-account --key-file=/google-service-account.json
# auto detect csv headers
# replace table contents with csv file
bq load --autodetect --replace mydb.mytable /data.csv
@asmega
asmega / script.sh
Created November 23, 2020 11:57
prevent rails from logging to stdout
unset RAILS_LOG_TO_STDOUT
PGDATA=/usr/local/var/postgres pg_ctl start
// psql client commands
SHOW server_version;
@asmega
asmega / main.sh
Last active July 29, 2019 11:00
brew
brew info node
# switch version
brew switch icu4c 63.1
# adjust brightness in smaller increments
Shift (⇧) + Option (alt) + Brightness
@asmega
asmega / run.sh
Created July 12, 2019 04:59
image manipulation
# correctly orientate images
mogrify -auto-orient *.jpg
for i in {1..1000} ; do
echo "thing"
sleep 3
done