-
- 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!
-
- Private work.
- A lot of new house prep. Money moves, legal, inspections, all.
- Finished re:invent breakout sessions.
- pgvector in rds for vectore storage (to support bedrock and genAI).
- Some security updates.
- CodeCatalyst. CICD. Integration with Q, more. Really useful for PR descriptions/summaries, but you can assign tickets to it as well and it will propose its solution for your approval, allow comments/iteration, then make the code change autonomously.
- Workspaces and virtual desktop migration.
- Made peppermint bark.
- Finished the puzzle advent.
- https://endoflife.date/ – for later reference of EOL dates.
- https://codapi.org/sql/ – great way to compare queries across diff DBs.
- https://blobstreaming.org/why-do-programmers-need-private-offices-with-doors-do-not-disturb – agreed.
- Figma Adobe cancelling merger.
- Spacex would be ~40 on the list of US public companies by mcap (#1 private). Apple -> Microsoft -> Google -> Amazon -> NVIDIA -> Meta -> Tesla. Saudi Aramco the only non-US in global top ten.
- Psql’s
coalesce is useful too if you’re comparing values across multiple cols.
- Did some crypto portfolio management for the first time in a while. Gemini still locked.
- Supercontest. Absolutely unacceptable still on AWS’ part. Waiting on pinpoint. I am a simple user trying to get a simple TFN. It’s been TWO MONTHS.
-
- Private work.
- Back REALLY flared up again.
- Changed trays.
- https://searchplayground.google/ and https://www.youtube.com/watch?v=3KtWfp0UopM
- The nyt xword archive goes back to November 21, 1993 (when the Will Shortz era started). The first published nyt crossword was February 15, 1942.
- 6 more re:invent breakouts.
- In API Gateway you can fiddle around and export swagger or openapi definitions. Then you can point SAM to that file. You don’t need to directly have SAM manage the API.
- Remember an API is the contract between a microservice and anything else. Other microservices, but more importantly – clients.
- API gateway will edge-optimize for you via an AG-managed CF dist. But if you want caching at the edge, manage your own CF dist.
- Remember that while you can use stages in API gateway for prod/dev/etc, splitting environments into separate accounts is a common practice. One for prod, one for dev. Full isolation.
- You can use SAM to locally invoke a CDK-defined lambda function.
- Amplify. Hosting. Client libs. Auth plugins. Lots. Integration with cdk.
- Per-developer cloud sandboxes with amplify.
- Advanced stats on aws for major sports. Kinesis, sagemaker, analytics back to watchers and commentators.
- psql.
- Can join a table with itself to compare columns
- The
lag function is also very useful for comparing rows. If you have one col of points in a line, you can order and show neighbors (for deltas or whatever) with: select x, lag(x) over (order by x) as next_x from Point
- Remember window functions (
partition by). You can run an analysis on multiple rows to compare values, like tacking an average salary by department onto an employee row. You can pass partitions to many other functions, like lag.
rank() can handle ties (tied rank, and next tier jumps accordingly).
- Supercontest.
- The
+!2.5 line for bills/chargers last night was actually supposed to be +12.5. Bill caught. Fixed the line. Emailed the 3 who had already picked that game. API ticket will fix later.
-
- Private work.
- Nutcracker nyc ballet at lincoln center.
- Customized and ordered converse hightops.
- More re:invent.
- Going without saying, but remember to design your consumers to be idempotent (handle the same message more than once) and order-aware (handle messages out of order).
- Analyzing lambda cold starts, minimizing loads, more.
- Cloudformation support is part of the feature release process for other (non-IaC) teams.
- You can integrate github actions (and others) with cloudformation actions. Trigger a deploy on commit, whatever. Of course.
- Patterns to migrate to the cloud. Plan ahead, do it incrementally, understand why, etc.
- Strangler Fig pattern. Breaking down an existing monolith into microservices and incrementally migrating.
- Supercontest.
- Westgate had an exclamation point in the line (
+!2.5) which broke the weekly rollover. Fixed.
