How does the skill handle system restarts?

It implements persistent projection patterns that utilize checkpointing, allowing the system to track the last processed event and resume correctly after a failure or restart.

Can I use this for real-time data aggregation?

Absolutely. It contains specific templates for aggregating sales, user activity, and other metrics directly from event streams as they occur.

Does it support different database types?

Yes, the skill includes templates for various storage solutions, including relational databases like PostgreSQL for structured summaries and Elasticsearch for full-text search.

What are projection patterns in event sourcing?

Projection patterns are methods used to transform a stream of immutable events into a specific data format or 'read model' that is optimized for fast querying and data retrieval.

When should I use this Claude Code skill?

Use this skill when you need to implement the read-side of a CQRS system, create specialized search indexes from event data, or build real-time monitoring dashboards.

Event Sourcing Projection Patterns

Name: Event Sourcing Projection Patterns
Author: nguyendinhquocx

bynguyendinhquocx

0•

API 开发

Builds efficient read models and materialized views from event streams to optimize query performance in CQRS architectures.

This skill provides a comprehensive framework and set of templates for implementing projection patterns within event-sourced systems. It assists developers in creating decoupled read models, handling real-time data synchronization, and building search indexes or dashboards from raw event data. By leveraging structured patterns for catch-up, persistent, and live projections, it ensures high-performance data retrieval and consistent state management across diverse storage engines like PostgreSQL and Elasticsearch, making it essential for complex backend microservices.

主要功能

01Standardized projection architecture for CQRS read-sides

02Ready-to-use templates for SQL and Elasticsearch integrations

03Support for Live, Catchup, Persistent, and Inline projection types

04Automated checkpointing logic to resume event processing after restarts

05Complex aggregation patterns for real-time reporting and analytics

060 GitHub stars

使用场景

01Generating real-time business dashboards and daily sales aggregations

02Synchronizing relational databases with full-text search engines

03Developing high-performance read models for microservices using CQRS

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nguyendinhquocx/code-ai projection-patterns

For use in Claude.ai and ChatGPT

主要功能

01Standardized projection architecture for CQRS read-sides

02Ready-to-use templates for SQL and Elasticsearch integrations

03Support for Live, Catchup, Persistent, and Inline projection types

04Automated checkpointing logic to resume event processing after restarts

05Complex aggregation patterns for real-time reporting and analytics

060 GitHub stars

使用场景

01Generating real-time business dashboards and daily sales aggregations

02Synchronizing relational databases with full-text search engines

03Developing high-performance read models for microservices using CQRS

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nguyendinhquocx/code-ai projection-patterns

For use in Claude.ai and ChatGPT