A theme of architecture this week, with posts on the development of large systems, infrastructure evolution at scale, internal developer toolchains and more.

StackHawk sponsors Devops Weekly

[ICYMI] DAST is Dead! Long Live DAST! The Evolution of Dynamic API security Testing webinar is now available on YouTube. Watch on-demand here.
https://sthwk.com/long-live-dast-webinar

News

A look at one organisation’s approach to building a service that converts text input into SQL queries, in order to improve data analysis efficiency.
https://medium.com/pinterest-engineering/how-we-built-text-to-sql-at-pinterest-30bad30dabff

A post on migrating a large EC2 fleet to use the latest version of the AWS Instance Metadata Service, and enforcing its usage using a variety of tools.
https://slack.engineering/our-journey-migrating-to-aws-imdsv2/

A presentation presenting a model for reasoning about internal platforms, looking at choreography, orchestration and infrastructure composition.
https://speakerdeck.com/danielbryantuk/platformcon-24-platform-orchestrators-the-missing-middle-of-internal-developer-platforms

An interesting retrospective on a specific developer toolchain. While some of the observations are maybe Ruby specific, the general points about unforeseen impact of tooling and the design of software.
https://shopify.engineering/a-packwerk-retrospective

Many modern architectures combine microservices with asynchronous workflows and serverless functions. The following post explores one such evolution.
https://netflixtechblog.com/the-making-of-ves-the-cosmos-microservice-for-netflix-video-encoding-946b9b3cd300

Tools

Index Advisor is a PostgreSQL extension for recommending indexes to improve query performance.
https://github.com/supabase/index_advisor