-
- 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.
