What I learned this week Software Iceburg S3 Conditional Writes S3 is a database Business/Finance Interesting Links Math/Stats Travel Other Enjoyed spending time with family on Thanksgiving. Tried my best to do focus as much as possible with them and be off the phone. I worked a few days during the week but was very efficient with my time and made sure I stopped working and stayed not working through evenings and early mornings.

What I learned this week Software Add line numbers to head: head -n 5 example.csv | nl R cheatsheets Hamming codes When using psql from the command line don’t forget to end statements with a ‘;’. Business/Finance Acquired Ikea episode “It is not all that difficult to reach set targets if you do not have to count the cost. Any designer can design a desk that will cost 5000 krona. But only the most skilled can design a good, functional desk that will cost 100 krona.

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.

What I learned this week Software ACID GIT_CURL_VERBOSE=1 git pull –rebase interesting verbose info on HTTPS A few more linux commands: seq generates series of numbers rev reverses input, prints to stdout wc outputs count of lines, words, and characters I was attemping to pull changes from a remote repository, running git pull rebase and just randomly got the response: BUG: remote-curl.c:1528: The entire rpc->buf should be larger than LARGE_PACKET_MAX error: git-remote-https died of signal 6 fatal: expected flush after ref listing I’d never gotten this before.

What I learned this week Software grep -i for case insensitive search (I always forget this flag for some reason so writing it down) cd - history 5 Business/Finance Taxes Interesting Links https://moxie.org/2013/01/07/career-advice.html Math/Stats Travel Looked at Saturn through 16” telescope at Kitt Peak observatory an hour outside of Tucson. Will need to come back and do the climb up to the obervatory on a bike. It sounds like they have some additional cool exhibits opening up that would be fun to check out.

What I learned this week Software Cool visual code editor TMUX after creating a new session tmux new -s gvbackfill: Split window vertically CTRL + B, # Split window horizontally CTRL + B, : and then type split-window Switch window CTRL + B and arrow key AWS Athena is based on Trino, I don’t know why I never know this, but yeah I guess it is. Plain text… SMH Business/Finance Imports dont subtract from GDP