What I learned this week Postgres knowledge dump Software Business/Finance $26BB of BTC $71BB market cap… Interesting Links Math/Stats Travel Other Cool fossils building a picnic table I really enjoy Beau’s videos.

What I learned this week Software Nice overview of jq, was using the aws emr cli to describe clusters so I could SSH into them aws emr describe-cluster –cluster-id and decided to use jq instead of grep -i dns I guess you can use spark in Athena echo {1..10} returns 1-10 < lines awk ‘NR%2 == 0’ filtering raw lines out of text file with awk is pretty handy < lines sample -r 10% quick “random” sample

What I learned this week Software arp -a The arp utility displays and modifies the Internet-to-Ethernet address translation tables used by the address resolution protocol. -a displays or deletes all of the current ARP entries. I passed the AWS Certified Cloud Practiioner Exam this week. I studied for a few hours to make sure I was familiar with some of the more niche offerings and all the marketing jargon that will appear on the test.

What I learned this week Software **.suffix in git ignore, especially helpful if you have a 100mb database locally and a write ahead log. Postgres MVCC Business/Finance Interesting Links Space Suits Math/Stats Travel Other Building a Neural network in pure SQL is hard!

What I learned this week Software Shell You can us curl to make requests using the DICT protocol curl -s "dict://dict.org/d:windmill" | trim Other curl things: -I for HTTP header, -L for redirection unpack handy tool for decompression You can use rm and a pattern to remove all files in a directory rm E1F* removes all files that start with E1F Dagster + DBT Dagster Assets = DBT Models: dbt models are named using file names, which Dagster will also use to create the corresponding asset’s asset key.