SQL

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.

Unique identifiers are crucial for ensuring data integrity and uniqueness in applications. They help track, reference, and ensure consistency across various systems and services. This article contains a Cheat Sheet and descriptions of the different types of unique identifier generators, their methods, and tradeoff analysis to help you choose the best option for your application.

В этой статье рассмотрим роадмап, как развиваться и что учить для тех, кто хочет программировать на Rust.

В этой статье рассмотрим roadmap Go developerов и на что нужно сделать упор при глубоком изучении Go.