Sam's Blog

What I learned this week Software git stash list list git stashes and then you can drop via: git stash drop stash@{0} git stash REPL stands for Read Evaluate Print Loop Business/Finance Interesting Links How air breaks work.

Recap of my trip to LA from 3/13/2025 -> 3/19/2025 13th Flew to LA, checked the bike no problem (this was my first time flying with my bike).

Collection of thoughts on table creation.

What I learned this week Software Duckdb with the… UI Tarball Merge Statements Git Bundle + CDNs and such Business/Finance Redfin getting acquired Interesting Links The largest ZIP Code, in square miles, in the contiguous U.S. is 30,683 square miles.

What I learned this week Software DuckDB has a bar function which draws a band whose width is proportional to (x - min) and equal to width characters when x = max.

What I learned this week Software Mac: To quickly find text, select some text and press ⌘E followed by ⌘G.

What I learned this week Software To initialize a submodule in a local repo: git submodule init which reads from .gitmodules and then git submodule update Nice intro to cuda with embedded quiz Docker & UV in Dagster Click house query performance Guide you…

What I learned this week Software Business/Finance Interesting Links Math/Stats Travel Got back from Hawaii on a red-eye and then the next day drove to San Diego for a friends proposal.

What I learned this week Software Some light Wikpedia reading on db normalization: Boyce–Codd normal form (BCNF or 3.5NF) If a relational schema is in BCNF, then all redundancy based on functional dependency has been removed A 3NF table that does not have…

Recap of our trip to Kauai, HI from 2025-02-05 to 2025-02-12. 2025-02-05: Landed after a 7 hour flight due to a strong head wind, but we had the middle seat open!

What I learned this week Software To obtain only the remote URL of a local repo: git config --get remote.origin.url Can also remove and add a new origin: git remote remove origin git remote add origin Nice explain plan visualizer Go Daddy infosec issues B…

What I learned this week Software Splitting network into two subnets to make life miserable for wifi stealers Redshift max recursion rows is defaults to 50,000,000 SHOW max_recursion_rows;.

What I learned this week Software uV is the way Cute namesapce Zine Great explanation of a Hash Join from the cofounder of DBT back in 2018 Business/Finance Bad Econ of WTF happened in 1971 Interesting Links Math/Stats Travel Other Since 1989, Kenny G’s r…

One step back, two steps forward: Stop building on top off bad decisions and fix the bad decisions.

What I learned this week Software Symbolic Linking is pretty cool: ln -s /Users/iamsam/Desktop/symlinkorigin.txt /Users/iamsam/Desktop/symlinkdest.txt Can set up a file to point to another file… Xcancel is an instance of Nitter.

What I learned this week Software Couldn’t find where Datagrip stores its live templates. find / -name templates and it is here: /System/Volumes/Data/Users/my_user/Library/Application Support/JetBrains/DataGrip2024.1/templates stored as xml.

What I learned this week Software Turing Machines A system is Turing complete if it can be used to simulate a Turing machine.

It was my dad’s birthday recently, which sparked a bit of reflection.

What I learned this week Software Better python notebooks Map of github Bloom Filters to speed up Joins in SQLite A good deep dive on Bloom Filters from Sam Bloom filters can give definite “no"s, but they can’t be certain about “yes.”

What I learned this week Software DuckDB interview & cocaine fund.

What I learned this week Software Great video on threading Cluster by, partition and sort does not guarantee a total order of output.

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.

I was talking to one of our partner teams in a developing market.

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 ‘;’.

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.

Intelligent and deep-thinking people may hold opposite opinions of one another.

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..…

Last Tuesday I went to The Parlor.

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.

What I learned this week Software **.suffix in git ignore, especially helpful if you have a 100mb database locally and a write ahead log.

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…

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

A few considerations before building that extremely wide table.

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…

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 A…

$$$ I wanted to quickly jot down my current positions on personal finance topics.

What I learned this week Software Excel is not a database!

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.

What I learned this week Software RAND(1) Does not throw an error in Redshift SQL but RANDOM(1) does.

What I learned this week Software echo $?

What I learned this week I’ve decided to build a habit around recording interesting things I learn/refresh my memory on each week.

Travel/Stay Spent three days in Glacier National Park this summer, and it was one of my favorite visits.

Background Had the opportunity to hike half dome via the (John Muir Trail) JMT on July 10th, 2024.

An overview of what’s to come: I was originally writing this as a high-level introduction to send people when they encounter things like 6/4 returning 1 instead of 1.5 in some Database Management Systems (DBMS)… overtime its sprawled far beyond that.

Olive Oil: During my daily morning ritual of waking up at 4:30 AM and immediately ingesting a ½ cup of [Trader Joes Extra Virgin Spanish Olive Oil] (Sponsored link), I decided I’d like to try and solve the NY Time’s Connections.

The database management system (DBMS) I’ll reference today is Redshift (AWS Cloud Datawarehouse offering) which is based on Postgres.

A Chess Puzzle I recently encountered a chess puzzle that revolved around capturing my opponents material due to a forced mate in one threat.

For some people, not red lining all the time is a skill in and of itself.

Stress I’ve been meaning to jot down my thoughts on this for a while, but I keep running into things that tweak my mental model about stress.

Two months as a BIE Promoted to BIE on the same team I have been on since September.