Weekend Reading #61

Weekend Reading: A weekly roundup of interesting Software Architecture and Programming articles from tech companies. Find fresh ideas and insights every weekend.

This week: SQL interview prep for .NET engineers, Geocodio’s geocoding scalability journey, Netflix’s real-time live recommendations, and Airbnb’s LLM-powered GraphQL mocking.

Part 7: SQL Database Interview Questions and Answers

👉 Great prep material if you’re interviewing, preparing to interview, or mentoring backend developers.

A practical set of SQL and database questions for .NET engineers. Covers indexing, transactions, isolation levels, and real-world database design challenges.

From Millions to Billions

👉 Useful read for anyone tackling high-volume workloads using ClickHouse, Kafka, and Vector.

Geocodio engineers share how they scaled their geocoding platform to handle billions of location lookups. The post explains system design, caching, and data partitioning strategies.

Behind the Streams: Real-Time Recommendations for Live Events Part 3

👉 A solid look at combining streaming data, ML, and personalization at scale.

Netflix reveals how it built a real-time recommendation engine for live sports and events. The system dynamically adjusts suggestions based on user engagement and viewing patterns.

GraphQL Data Mocking at Scale with LLM

👉 Perfect for teams automating data generation in complex GraphQL environments.

Airbnb engineers show how they use LLMs to generate realistic GraphQL mock data for large-scale testing. The setup boosts developer productivity and test coverage.