-
- 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.
-
- Private work.
- Watched 6 more aws re:invent breakout sessions on serverless and event-driven architectures.
- Pubsub is usually push. SQS and eventbridge can both support this.
- Integrating two services directly is direct. Integrating a single service as a publisher or subscriber is even easier, and you can scale to way more than n=2.
- The decoupling for EDA is worth a lot.
- Also consider first principles. Every application is event-driven at its core. Time doesn’t mean anything. We have cause and effect. Action and reaction. The software should match the physics of the system.
- EDA avoids throttle, gracefully handles sender/receiver downtime, allows consumption at subscriber’s chosen rate, so many good benefits. Many-many becomes trivial. Eric Johnson: https://www.linkedin.com/in/singledigit/.
- I like this guy’s presentation style: https://www.youtube.com/watch?v=KXR17uwLEC8.
- Serverlessland has a lot of cool patterns. Specify your serverless framework (sam, cdk, serverless, etc) and your language (python, js, etc) and aws services you want to connect (lambda, rds, etc). It will give you a functional template to copypaste. Example: https://serverlessland.com/patterns?framework=CDK&language=Python.
- Step functions, standard vs express. Use the former for longer running tasks, or fewer state transitions. Express is usually better/cheaper for all others.
- Harvested and replanted top 2 gardens.
- psql.
- You can obviously group by multiple cols. Does order matter?
coalesce(value, default) to convert nulls to something else (like 0), rather than using a full case statement. It will return the first non-null value, so you can use with iterables too.- Can also use
ifnull(value, default) for non-iterables in other SQLs.
- JP Morgan Chase alone processes >5k transactions per second. BTC is 7. Eth1 was a few times that. Eth2 can be closer to cc. Solana 65k.
- Supercontest.
- Lambda Web Adapter.
- Run webapps on lambda. https://github.com/awslabs/aws-lambda-web-adapter
- You have to package your app as a docker image. Lambda can run docker images instead of zip files.
- LWA is basically a shim that sits in the docker image between the lambda api and your http api. It will receive the event, handle it as necessary, and forward to your rest api. Then it will take the http resp and convert it to json for lambda return.
- No code changes. Multi-language/platform/framework. You can also continue developing/debugging/packaging/linting/testing in your familiar tools, rather than shifting all those SDLC workflows to new serverless processes.
- What about performance? You’re starting an entire webapp container and launching a webserver on every lambda function, yes. It’s a bit more overhead than starting a basic image with only that endpoint’s code, and no web interface.
- You also lose some granularity. Seems like you only have 1 lambda (basically the domain), and it manages all the routing natively in your app’s web framework. Unless a true serverless stack, where api gateway manages all endpoints and their corresponding lambda functions. This gives you granular logs/metrics/etc, native in the cloud – rather than requiring you to build it alongside your web framework.
-
- Private work.
- Mobile/internet.
- Verizon … still doesn’t have a login interface that works!
- Eventually got into verizone home on browser. Failed at verizon wireless. Used phone for the latter.
- FIOS is $70/mo.
- Plan: Unlimited data/msgs/mins. 2 lines. Both have upgrades.
- 5G play more (mine). 5G / 4G LTE. 5G ultra wideband. 25GB premium mobile hotspot.
- Basically the same as the current Unlimited Plus. Updated. Same price. Few extra perks. Will start next cycle.
- 5G start 1.0 (mom). 5G / 4G LTE. No premium network, no hotspot.
- Basically the same as the current Unlimited Welcome. Updated. $5 cheaper. Few extra perks. Start next cycle.
- Can upgrade to 15 pro max. Retail $1200. 256GB. Trade-in 13 pro max (128GB) for $830. So it’s about $500 after tax and everything to upgrade to latest. Can submit it all on phone, pay, get it delivered, transfer, drop off old phone, done.
- Confirmed amex plat saks credit landed successfully.
- Banks’ usage of “encrypted” email is pretty funny. Very inconvenient.
- If I can leverage the active mortgage hard pull to open another credit line without adding an inquiry, I will. Churn (1) chase freedom flex and (2) chase amazon visa.
-
- Private work.
- My ancestry is ~68% german/french ~25% british/irish ~2% native american.
- Remember (select1) union (select2) in psql. Totally fine with CTEs and everything else. Must match columns.
UNION ALL won’t deduplicate.
- You can also
group by then order by and use an aggregate function in the latter, of course.
- Caught up on advents, niners, warriors, aquarium maintenance, etc.
- Remember you can
group by with multiple cols.
-
- Private work.
DENSE_RANK in psql.- Magnus wins CCT final. 3 NFL. Big UFC. Warriors.
- New york botanical gardens.
