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!

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

#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!

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

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

#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

#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

#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!