What I learned this week Downloading games from the radio it’s cool to read about these times as I’ve never gotten to experience this. April Fools Software Business/Finance Google Finance’s broken feature Interesting Links Math/Stats Travel Other Hilarious post on a vary volatile compound Awesome Chess Project

What I learned this week Software Exploring UV You can run a tool in an ephemeral environment uvx pycowsay ‘hello world!’ uvx is an alias for uv tool run install different python versions uv python install 3.10 3.11 3.12 and pin them in a directory uv python pin 3.11; however, by default, Python versions are automatically downloaded as needed without using uv python install The .python-version file can be used to create a default Python version request.

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. Essentially uses pressurized air instead of hydraulic fluid. Comes with the benefit of being “on” if the system breaks causing the vehicle to break… which has the tradeoff of making them difficult to move.

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. Math/Stats Travel Traveling to LA and Santa Barbara to visit Ben for his Spring Break. Other I don’t take sides I take pictures

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. You could also implement this in other DBMS with ratio_to_report() and repeat()… repeat I hadn’t heard about until this week. There’s some other fun ones in Redshift like initcap() which capitalizes the first letter of each word. Postgres has nice docs on Character Types

What I learned this week Software Mac: To quickly find text, select some text and press ⌘E followed by ⌘G. After copying a file, press ⌥⌘V to move the file instead of pasting a copy of it. Business/Finance Interesting Links Markov Chains One use of Markov chains is to include real-world phenomena in computer simulations. For example, we might want to check how frequently a new dam will overflow, which depends on the number of rainy days in a row.

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 yourself to a relation db?… JK it has its place Business/Finance Interesting Links Electricity Math/Stats Travel San Diego for a friends engagement last weekend, was a good time.

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. Brought my bike and road the coast with Ally which was pretty sweet. Other Reading a bit of Invisible Influence: The more something matters to us the more distinctive we think it is. Mimicking people (subtly) makes you seem more agreeable/appealing.

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 multiple overlapping candidate keys is guaranteed to be in BCNF Elementary key normal form Functional Dependencies A dependency FD: X → Y means that the values of Y are determined by the values of X.

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 Business/Finance Interesting Links IRS auctions Math/Stats Travel Other