Tagged articles

Projection

10 articles · Page 1 of 1
Ray's Galactic Tech
Ray's Galactic Tech
Aug 13, 2026 · Backend Development

Event Sourcing Primer: Rebuilding State Without a Database

This article explains how event sourcing replaces the traditional current‑state table with an immutable event log, allowing systems to reconstruct any state, handle concurrency, support auditing, and power flexible read models through projections, while outlining the necessary architectural components such as aggregates, event stores, snapshots, outbox, idempotency, and the natural transition to CQRS.

CQRSEvent SourcingOutbox
0 likes · 32 min read
Event Sourcing Primer: Rebuilding State Without a Database
Xiaolin Talks Programming
Xiaolin Talks Programming
Jul 13, 2026 · Backend Development

CQRS & Event Sourcing in Spring Boot: Read/Write Separation, Snapshots & Compensation

This guide details implementing CQRS and Event Sourcing in Spring Boot, covering command/query separation, event bus choices (Outbox pattern, Kafka), projection idempotency, state snapshots for performance, Saga-based compensation for distributed transactions, and practical tuning tips for production workloads.

CQRSEvent BusEvent Sourcing
0 likes · 14 min read
CQRS & Event Sourcing in Spring Boot: Read/Write Separation, Snapshots & Compensation
Sohu Tech Products
Sohu Tech Products
Feb 15, 2023 · Fundamentals

Understanding Tile Map Services and Map Tile Principles

This article explains the concepts, standards, and workflows of tile map services, covering WMTS and TMS specifications, map tile fundamentals, projection methods, tile generation, distribution, and rendering techniques with code examples using Leaflet, providing a comprehensive overview for GIS developers.

LeafletProjectionTMS
0 likes · 20 min read
Understanding Tile Map Services and Map Tile Principles
DataFunTalk
DataFunTalk
Jul 28, 2022 · Databases

ClickHouse Overview and the Top 5 Features Released in 2021

This article provides a comprehensive overview of ClickHouse, covering its origins, core characteristics, and the five most important features introduced in 2021—including JIT acceleration, Lambda‑based UDFs, native window functions, zero‑copy replication for S3/HDFS, and the Projection mechanism—highlighting why it remains a leading high‑performance OLAP database for big‑data analytics.

ClickHouseOLAPProjection
0 likes · 15 min read
ClickHouse Overview and the Top 5 Features Released in 2021
DataFunSummit
DataFunSummit
Sep 24, 2021 · Databases

ClickHouse Projection: Design, Implementation, Use Cases, and Production Impact

This article presents an in‑depth overview of ClickHouse Projection, covering its background, core features, architectural details, practical use cases, performance gains, advantages and drawbacks, and real‑world production results, illustrating how Projection enhances OLAP workloads at Kuaishou.

ClickHouseOLAPProjection
0 likes · 22 min read
ClickHouse Projection: Design, Implementation, Use Cases, and Production Impact
Python Crawling & Data Mining
Python Crawling & Data Mining
Sep 12, 2021 · Databases

How ClickHouse Projections Supercharge Query Performance

The article explains ClickHouse's new Projection feature, how it overcomes MergeTree's single‑sort limitation and materialized view drawbacks, provides step‑by‑step commands to create, materialize, and query projections, demonstrates massive performance gains, and outlines the rules for automatic projection selection.

ClickHouseDatabase OptimizationMaterialized View
0 likes · 12 min read
How ClickHouse Projections Supercharge Query Performance
Kuaishou Tech
Kuaishou Tech
Aug 30, 2021 · Databases

ClickHouse Projection: Design, Implementation, and Production Performance

This article presents an in‑depth overview of ClickHouse Projection, covering its background, definition, practical use cases, underlying architecture, query analysis, consistency guarantees, performance comparisons, and real‑world production results, highlighting how it enhances OLAP workloads while maintaining strong data consistency.

ClickHouseDatabase OptimizationMaterialized Views
0 likes · 19 min read
ClickHouse Projection: Design, Implementation, and Production Performance
DataFunTalk
DataFunTalk
Aug 28, 2021 · Databases

ClickHouse Projection: Concepts, Use Cases, Implementation and Production Benefits

This article presents an in‑depth overview of ClickHouse's Projection feature, covering its background, definition, storage and query mechanisms, practical use‑case demonstrations, performance comparisons with competing OLAP systems, and real‑world production results that highlight its advantages and limitations.

ClickHouseDataWarehouseMaterializedView
0 likes · 20 min read
ClickHouse Projection: Concepts, Use Cases, Implementation and Production Benefits