SQL

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.

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.

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.

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

This article considers popular options for storing hierarchical data in SQL and NoSQL databases.

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

This article explores essential data integration patterns, including ETL, ELT, Change Data Capture (CDC), Data Federation, Data Virtualization, Data Replication, Publish/Subscribe, Request/Reply, and Point-to-Point Integration. Learn how and when to use these patterns for efficient data handling and real-time analytics.

This article discovers the differences between ETL and ELT processes and how they could be used for data integration.

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

Weekend Reading is a Digest where we share a selection of the most interesting tech articles from different companies found during the week.