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

What I learned this week Software Excel is not a database! (This is not a new learning, but something I’d like to shout loudly) Business/Finance Interesting Links The Man in the Arena: “It is not the critic who counts; not the man who points out how the strong man stumbles, or where the doer of deeds could have done them better. The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood; who strives valiantly; who errs, who comes short again and again, because there is no effort without error and shortcoming; but who does actually strive to do the deeds; who knows great enthusiasms, the great devotions; who spends himself in a worthy cause; who at the best knows in the end the triumph of high achievement, and who at the worst, if he fails, at least fails while daring greatly, so that his place shall never be with those cold and timid souls who neither know victory nor defeat.

What I learned this week Software IEEE 754 on floating point numbers “If you want to know what’s actually reflected in your data, you may need to profile it. Needles in haystacks aren’t revealed by “select * from haystack limit 100”. You’ll probably just get 100 rows of hay.” Business/Finance Walgreens Debt Burden apparently a lot of their fundamental real estate is leased. Interesting Links How does Linux move from an awake machine to a hibernating one?