Architecture Weekly Issue #160. Articles, books, and playlists on architecture and related topics. Split by sections, highlighted with complexity: 🤟 means hardcore, 👷‍♂️ is technically applicable right away,  🍼 - is an introduction to the topic or an overview. Now in telegram and Substack as well.

System Design Course Cohort #5 is open!

Typical system design courses teach technical skills but often overlook the connection to business problems. This course fills that gap, emphasizing the importance of recognizing and addressing business priorities with technical approaches. Learn to go beyond load balancing options and performance tactics by focusing on solving real business challenges. Course is completed by 50+ engineers with great feedback!

SIGN UP HERE

Highlights

Normalization and Relational Division in SQL and MongoDB 👷‍♂️

Did you know the normalization of databases was suggested on the assumptions that clients will be the non-tech personnel accessing the data through printers? That's not the case nowadays, and while normalization provides powerful guarantees, it can be suboptimal in cases of relational divisions where NoSQL dbs can shine. See how!

Normalization and Relational Division in SQL and MongoDB
MongoDB promotes document data modeling rather than the highest normal forms of a relational model.…

#db

Architecture Diagramming Tools(updated with AI Tools!) 🍼

One of my favourite topics is diagramming. Bilgin Ibryam shares a list of great tools(seriously, I am using like top 5 of them) and adds a section with the tools which brings the diagramming game to a new level.

Architecture Diagramming Tools, and the AI Gap
Turning Words Into Architecture — Where’s the AI Tool for That?

#documentation

Query S3 Tables with DuckDB 👷‍♂️

S3 Tables is S3 storage optimized for analytical workloads. And when you hear analytics, you thing DuckDB. Well, now you can use it to read from S3 tables. Grab a tutorial!

Query S3 Tables with DuckDB
DuckDB has gained a new feature in preview, that allows querying of Iceberg data in AWS S3 Tables. Setting up a S3 Table There are multiple steps which need to be performed to set up a S3 Table that can be then queried with tools like DuckDB. As the…

#serverless #analytics #duckdb

Follow-Up

Why I'm No Longer Talking to Architects About Microservices 🍼

The conversations about microservices need to stop. Nobody understand what a microservice really is, and those conversations are far away from real business problems. Iam Miell elaborates on these arguments.

Why I’m No Longer Talking to Architects About Microservices
I’m done talking about microservices: the term is confusing, discussions are abstract, and without organisational change, microservices are pointless

#microservices

Optimizing network footprint in serverless apps 👷‍♂️

When we started getsupplied.ai, the first problem we encountered was how to upload the documents, but minimize the backend networking there? The way we solved it was through S3 pre-signed urls, which works just fine. There are other ways though: data compression, which is extensively covered here.

Optimizing network footprint in serverless applications | Amazon Web Services
This post is authored by Anton Aleksandrov, Principal Solution Architect, AWS Serverless and Daniel Abib, Senior Specialist Solutions Architect, AWS Serverless application developers may commonly encounter scenarios where they need to transport large payloads, especially when building modern cloud applications that need rich data. Examples include analytics services with detailed reports, e-commerce platforms with extensive […]

#serverless #networking

What are the Agentic Workflows? 👷‍♂️

With all the AI hype for building Agentic solutions, the architeture patterns emerge too. How agentic workflow differs from a mere call to an LLM, what are the different patterns with such workflows, read in this article

What Are Agentic Workflows? Patterns, Use Cases, Examples, and More | Weaviate
Agentic workflows give AI agents structure, purpose, and adaptability. This article breaks down their components, patterns, and practical applications.

#ai

Considering design trade-offs when building serverless APIs 👷‍♂️

Serverless or not, trade-offs is the backbone of the software architecture and system design. Do you really need a single-digit latency? Do you need to start with microservices? And tons of other questions carefully put in the artice

Considering design trade-offs when building serverless APIs on AWS
When I talk to customers who are building serverless APIs, the architects often ask for some prescriptive guidance with some authoritative…

#serverless #architecture

Big thanks to Nikita, Constantin, Anatoly, Oleksandr, Dima, Pavel B, Pavel, Robert, Roman, Iyri, Andrey, Lidia, Vladimir, August, Roman, Egor, Roman, Evgeniy, Nadia, Daria, Dzmitry, Mikhail, Nikita, Dmytro, Denis and Mikhail for supporting the newsletter on Patreon! If you like the newsletter, feel free to support it there - with one-time support for example!