-
- Private work.
- Changed trays.
- Some stack/queue refreshers.
- Brock Purdy broke the single-season passing yd record for the niners today (more than steve young, joe montana), with 1 week left (which is actually more fair). Niners also clinched 1st.
- Grilled. Beach. Shave ice. Fireworks.
-
- Private work.
- In hawaii finally! About 17hrs door to door.
- Magnus wins both the fide world rapid AND blitz championship.
- Macbook didn’t gracefully handle tz shift. Had to restart. Surprising.
- Supercontest. Added a handful of users to the paid league.
- Some intervals DS&A.
- Lots of planning for 2024.
-
- Private work.
- 1031 is the exchange of one investment property for another, allowing cap gains to be deferred (as long as you close within 180 days).
- Some cool work with intervals and heaps.
- The jumbo loan threshold trigger is different for different counties. Manhattan is $1,089,300.
- Does the rate get better or worse if it’s a jumbo loan? There’s no standard for this, it changes by lender and by market conditions / over time.
- Found old carry-on suitcase, since I need to roll instead of lift. Examined all the motorcycle parts being stored there. 2 sets of extra ninja brake pads and kawasaki air filter – no longer of use. And all the stock panigale components I upgraded away from (bunny ears, fender, opaque clutch cover, etc).
- Figured out the loud noise from the aquarium. Was the sump pump. Clogged and/or malfunctioning. Ordered another one, upgrading from 1050gph to 2100.
- Garden maintenance, laundry, aquarium maintenance, haircut, the usual.
- Chrome apps. Sites that look like native app windows.
- Full start of crypto liquidation. Some direct selloff. Kicked off the undelegation for a few corners. 21-28d unstake period.
- Lots of rugs since last I checked.
- Lots of hacks / drains on DAO vulnerabilities since last I checked.
- Lots of pnl swings, in both directions.
- Optimism is now OP mainnet.
-
- Private work.
- Back in the city.
- To find the smallest common element across many iterables (this is O(mn)):
min(reduce(and_, map(set, myLists)))
- New cashmere tops and bottoms are excellent.
- Housing.
- Money moves. Liquidated a few portfolio segments. Details in gdrive.
- Points are usually paid (baseline) as origination fees. This is a percent of the loan amount, and varies based on credit/dti/etc just like rate.
- You can buy extra points to buy down the rate. But you don’t do this when rates are high. Just save the money and refi soon.
- Remember prequal is just “can buy this much” – it’s earlier. Preapproval is fuller, later.
- Jumbo loans trigger at 1M+, which actually reduce the interest rate.
- Lender meetings.
- Remember having a credit mix improves your score. 3 types: mortgage, revolving, installment. If you add one of those, you’ll actually increase your credit score by adding debt (counterintuitive, like almost all aspects of this obsolete algorithm).
-
- Private work.
- AI was ~26% of all VC in 2023. OpenAI looking at $100B next round.
- Research into subletting current home.
- Warriors and niners losses for christmas!
- More vitriol for aws support / pinpoint. Snippets:
- I appreciate the courtesies – do you have anything beyond the keep-warm servicedesk template? I would like details as to what/why is taking this long.
- I need to see that you are forwarding the valid client urgency to your downstream dependencies, and technical rationale for why resolution has not been met after two months.
- AWS cannot allow this as a standard for basic functionality.
- Supercontest. Updated banner.
-
- Private work.
- Travel yesterday.
- Home inspection complete, report out.
- Pinpoint said they’re STILL working on the registration. I’m deeply embarrassed for aws.
- Ordered 3 copies of the full Puzzle Mania on ebay, $12 each. Finished the 2023 Super Mega nyt crossword: https://squares.io/s/rynegaou
- Updated some old ebay info – most was from stanford and hermosa.
- Monthly puzzle shipments: https://findersseekers.com/
- Hard sql question, mostly CTEs and lead/lag window functions to compare rows. Also – you can have recursive CTEs – selecting from themselves.
generate_series is also very useful – it will create additional rows for you.
-
- Private work.
- Got condo inspected.
- Poole v warriors for the first time last night.
- psql. Played with
rank and row_number (useful when you want to limit ties). For example, if you want the top 3, but there are multiple people tied for third, row_number will only give you a single third based on the order by criteria. Did both with partition by and order by.
- There’s a “mansion tax” on any home over 1M. Law was introduced in 1989. Jokes. Hasn’t had the trigger minimum increase a single time (over 30 years!), not even for inflation. 1% for 1-2M, and increasing proportionally.
- Plus the 1.425% mortgage tax in nyc. Ridiculous!
