Databases

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.

This chapter explores SQL Database questions that  .NET engineers should be able to answer in an interview.

Weekly tech digest: pagination strategies for large datasets, Uber’s rebuilt Apache Pinot query architecture, and Meta’s ML-based notification ranking system for Instagram.

Learn efficient SQL pagination techniques: offset, keyset, cursor, snapshot, hybrid & more. Understand trade-offs, use cases, and best practices.

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

Weekly tech digest: simple ACID guide, Uber’s HiveSync data lake replication, Atlassian’s new CI/CD platform, and Pinterest’s Moka data processing system.

This week in the Weekend Reading Digest: database normalization guides, Hotstar’s real-time emoji system, Uber’s safe monorepo deployments, and Expedia’s Iceberg Write-Audit-Publish workflow.

Learn the BASE model in databases explained simply for junior developers. Understand how Basically Available, Soft state, and Eventual consistency work in distributed systems like NoSQL.

A beginner-friendly guide to understanding ACID in databases. Learn Atomicity, Consistency, Isolation, and Durability in simple terms with SQL examples and real-world analogies for junior developers.

A hands-on walkthrough of standard forms using a real-world online retail example. We’ll fix anomalies step by step, show the decompositions, and keep performance trade-offs in mind.

Master ASP.NET Core for interviews! Explore middleware, routing, DI, caching, & security with expert Q&A for junior to senior .NET devs.

This chapter explores design patterns, anti-patterns, and principles that are usually used across development on  .NET.