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

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;. Seems like this is actual recursion count not rows… Testing out with the following code: WITH RECURSIVE digits(d) AS ( SELECT 1 AS d UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9 UNION ALL SELECT 0 ), integers(i) AS ( SELECT d FROM digits /* / UNION ALL / / SELECT i + 1 AS next_i FROM integers WHERE i < 50000800 ) SELECT min(i), max(i), COUNT() FROM integers; We get: min max count 0 50,000,800 500,007,965

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 recording “Going Home” from the Kenny G Live album has become an unconventional mega-hit throughout China.

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. Nitter is a free and open source alternative Twitter front-end focused on privacy and performance. The source is available on GitHub at https://github.com/zedeus/nitter No JavaScript or ads All requests go through the backend, client never talks to Twitter Prevents Twitter from tracking your IP or JavaScript fingerprint Uses Twitter’s unofficial API (no rate limits or developer account required) Lightweight (for @nim_lang, 60KB vs 784KB from twitter.

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. If you’re striuggling to find your local templates you can use find from a parent directory find / -name templates Great overview of all that goes into a fab Andy’s overview of DBs in 2024 Business/Finance I wasn’t familiar with this ev start up until now

What I learned this week Software Turing Machines A system is Turing complete if it can be used to simulate a Turing machine. Don’t throw any “real time” analysis on a shared resource. That resource will get backed up, your “real time” analysis running every hour will stack up in the que as the cluster slows, making the backlog worse, with a ton of work that is no longer real time.

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.” A bloom filter will never give a false-negative, and this is what makes them useful. Google’s BigTable is a distributed key-value store, and uses bloom filters internally to know what keys are stored within.

What I learned this week Software DuckDB interview & cocaine fund. You find yourself in a quest for productivity, feeling productive because of the quest, but not really doing any productive work. DNS rabbit hole Stripe Blog Business/Finance Interesting Links Math/Stats Travel Other Interesting things learned One thing I found particularly absurd Inhaling carbon monoxide for performance Human brain is unreal