Does this skill support different database types?

Yes, the skill includes templates for various storage engines, including relational databases like PostgreSQL (asyncpg) and search engines like Elasticsearch.

What is a projection in event-sourced systems?

A projection is a process that transforms a stream of events into a specific read model or state optimized for querying, allowing for efficient data retrieval in CQRS architectures.

Can I use this for real-time dashboards?

Absolutely. It provides patterns for live projections that subscribe to event streams, updating your read models and UI as soon as events are recorded.

How does it handle historical data?

It includes 'Catchup' projection patterns specifically designed to process historical event logs, enabling you to rebuild or update read models from scratch.

What are persistent projections?

Persistent projections store a checkpoint (position) in the event stream, allowing the projector to resume exactly where it left off after a restart or crash.

Event-Sourced Projection Patterns

Name: Event-Sourced Projection Patterns
Author: drgaciw

bydrgaciw

0•

데이터베이스 관리

Builds efficient read models and materialized views from event streams to optimize query performance in event-sourced systems.

This skill provides a comprehensive architectural guide and implementation templates for creating projections in Command Query Responsibility Segregation (CQRS) architectures. It helps developers transform raw event streams into optimized, queryable read models using various patterns such as live subscriptions, catch-up processing, and persistent checkpoints. By implementing these patterns, developers can build real-time dashboards, full-text search indexes, and high-performance reporting views while maintaining a clear separation between write-heavy event stores and read-heavy application interfaces, ensuring scalability and consistency across distributed systems.

주요 기능

010 GitHub stars

02Pre-built templates for SQL-based summaries and Elasticsearch indexing

03Standardized projection architecture for CQRS read sides

04Advanced aggregation patterns for real-time reporting and analytics

05Robust checkpoint management for reliable data recovery

06Support for Live, Catchup, and Persistent projection types

사용 사례

01Creating high-performance read models for complex event-sourced applications

02Optimizing query performance by decoupling data storage from data presentation

03Implementing real-time dashboards and search indexes from distributed event logs

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add drgaciw/academic-compliance-hub-glm projection-patterns

For use in Claude.ai and ChatGPT

Download Skill