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

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.

主な機能

Standardized projection architecture for CQRS read-sides
Ready-to-use templates for SQL and Elasticsearch integrations
Support for Live, Catchup, Persistent, and Inline projection types
Automated checkpointing logic to resume event processing after restarts
Complex aggregation patterns for real-time reporting and analytics
0 GitHub stars

ユースケース

Generating real-time business dashboards and daily sales aggregations
Synchronizing relational databases with full-text search engines
Developing 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

Download Skill

GitHub

概要