-
- Private work.
- Of course, MSK = managed streaming for kakfa, aws service. Glue is obvioulsy the ETL tool native to AWS, as compared to MWAA.
- K8s lessons: https://hervekhg.medium.com/3-years-managing-kubernetes-clusters-my-10-lessons-b565a5509f0e
- Could use lambda function URLs (free) instead of API gateway, but you lose custom domain, cognito, more.
- Verizon bill increased substantial for an unknown charge, disputed (verizon support is garbage btw, can’t login to site an mobile just spins when you submit a dispute).
- Walked alllll over central park.
join USING (col1, col2) instead of join ON table1.col1 = table2.col2.- Danny Devito on Broadway!
-
- Private work.
- Honey roasted 10lbs peanut butter again, maple syrup for holiday.
- CCT championship now has its two finalists: magnus and wesley.
- psql
UNION ALL.
-
- Private work.
- Tavern on the green.
- Submitted REBNY. Quoted another lawyer. Greenlit chase+boa credit pulls for prequal.
- Gemini sent out a proposed plan of resolution. Each impacted party is supposed to vote to reject/accept it. The document is three hundred and seventy three pages long. Absolute bullshit. Give all the earn customers their money back? How about that? See how it took 8 words?
- Supercontest.
- RDS RI case resolved, refunded. Cost explorer shows the budget alarm in threshold now.
- Still waiting on pinpoint TFN registration.
- Updated banner.
-
- Private work.
- != and <> are the same in most sqls. Also remember “
case X then Y else 0 end“.
- Updated macos to 14.2.
- https://www.forbes.com/sites/alexkonrad/2023/12/11/armada-edge-computing-ai-spacex-starlink/?sh=6988e7386a45
- Some lawyer calls.
- Garden maintenance. The little bumps at the bottom of the tomato vine = root initials. If in soil, they’ll develop roots. If not, they’ll just stay as nodules. Usually happens when there’s a blockage in the main roots – the plant is trying to create more. Totally normal though.
- Use common table expressions (CTEs) instead of conditions against subqueries results. It’s just more logical to think about. WITH my_new_table AS (SELECT * FROM table1) SELECT * FROM my_new_table JOIN table2
-
- Private work.
- The eagles have the worst point differential of any 10-3 team in NFL history: https://www.statmuse.com/nfl/ask/worst-point-differential-of-a-team-with-10-or-more-wins-and-3-or-fewer-losses-in-a-season-nfl
- More re:invent breakout sessions. Almost all serverless content.
- Remember eventbridge can handle routing. Send events to lambda, trigger step functions, whatever.
- SAM Accelerate (
--sync) deploys your code to a dev env in the cloud for testing. That way, you don’t have to mock everything (serverless def requires more mocking that a full local app).
- Application Composer – a UI that you can use to diagram your full stack. It will then autogenerate the templates for you.
- Isolate your lambda code that touches the db, just like you do in the flask app.
- Testing in the cloud against a full dev stack is very very valuable.
- Remember aws itself uses an eventbridge event bus to communicate between aws services.
- Eventbridge’s event bus is the most generic pubsub interface. It has routing rules, filter polices, archive history, etc. It can push, get polled, whatever. It’s the central hub of complete decoupling. SQS is a very specific service for a single queue. Most reliable for FIFO, a bit more overhead. It’s a pretty common model to have eventbridge be the primary bus and messages continue on to specific SQS queues for consumer processing.
- Changed trays. Finished harder gum (probably won’t buy again, just chew regular). Meal prep (smoothies powders liver). Aquarium maintenance.
- Linear = github jira.
- Fireflies is pretty sweet. Played with it a little more today.
- Rogo = llm for business use cases.
- Remember that
where operates before groups/aggregates in sql. having operates after (so you can condition on counts, etc).
-
- Private work.
- CCT Finals started today.
- Mint alternatives.
- Empower.
- Linked all accounts.
- Got mobile app. All set up.
- Empower uses envestnet and yodlee to connect to accounts.
- Shareworks was down for maintenance, but addition to empower was seamless when it was restored.
- Only account addition hiccup was citi. Failed through desktop. Worked through mobile.
- For crypto, you can enter specific holdings and it will autoupdate values. Won’t link to metamask or coinbase or anything. Most of the names are only the bigger ones on eth. So not worth it – I just put total value.
- Good overall interface. Separation of retirement. Solid account list. Perf comparison to primary ETFs.
- Some lender analysis (big banks) and REBNY.
- Supercontest.
- VPC endpoints are not cheap.
- $0.011/hr in us-west-1, per endpoint.
- I had an endpoint in us-west-1a and us-west-1c for my SAM stack. Deleted.
-
- Private work. Meetings today.
- Remember the real AoC: https://adventofcode.com/
- AWS step functions for automating workflows. ETL, lambdas triggering other things, any pipeline really. Has a visual diagramming tool.
- There’s always Serverless Framework (node module) to compete with SAM. It’s more generic, less catered to aws.
- Distilled the ~700 re:invent breakout sessions into ~35 videos I want to watch.
- Mealprep, amazon fresh, haircut, gym, holiday-tipped building+barber, chores.
- Instacart replied with … nothing. They asked to fill out the SAME form again. Great! After two weeks!
- CDK is written in an imperative language like python, but remember that its output is a declarative cloudformation template.
- Did some research on AI notetakers.
- Butter, Fireflies, Otter, Fathom, more.
- There’s also openai Whisper, but I’m not aware of any direct meeting integrations.
- Most are ~$10-20/user/month.
- Moved from mint to credit karma.
- Shareworks integration still broken. Didn’t migrate the MAJORITY of my accounts. Terrible.
- The mint interface is 1000% better than CK.
- Downloaded mobile app.
- Verified email. Played with some settings. Opted out of creditworthiness/other sharing.
- Tried to submit a support case to reinstate my mint. Failed. Multiple times.
- Started chat. Got transferred the usual few. They were not able to recover my account data.
- I was with mint for 2 decades.
- Going to move to an entirely new platform. This one is trash. Terrible strategic decision on Intuit’s part.
