Introducing EventQL: A Query Language for Event Sourcing Systems
By
goloroden
Front-window bakery material. Catches the eye, delivers the goods.
Summary
The article introduces EventQL, a new event query language developed for EventSourcingDB that addresses the limitations of traditional projections in event sourcing systems. It explains how EventQL enables developers to perform ad-hoc queries on event streams for debugging, analysis, and real-time insights without requiring predefined projections. The language provides SQL-like syntax optimized for event data, allowing filtering, aggregation, and transformation of events across streams. The article covers practical use cases like debugging production issues, business analysis, and creating temporary views, positioning EventQL as a bridge between the flexibility of raw event access and the performance of projections.
Key quotes
· 5 pulledWhile projections are great for predefined, recurring questions, they don't cover everything. Sometimes you need answers on the fly.
You know those moments when you're debugging a production issue and want to see every event of a certain type within a specific time range? That's where EventQL comes in.
EventQL gives you the power to ask questions you didn't know you needed to ask until you needed them.
We designed EventQL to feel familiar to developers who know SQL, but optimized for the unique characteristics of event streams.
The goal was to create a language that bridges the gap between the raw power of accessing events directly and the performance benefits of projections.
You might also wanna read
Postgres-Backed Durable Workflow Execution: An Alternative to External Orchestration Systems
This article explains the concept of durable workflow execution using Postgres as the backing database, as implemented by the DBOS system. I
dbos.dev·3d agoPostgres-Backed Durable Workflow Execution: An Alternative to External Orchestration Systems
This article explains the concept of durable workflow execution using Postgres as the backing database, as implemented by the DBOS system. I
dbos.dev·3d ago
Comparing Transaction Isolation Levels in MySQL and MariaDB Through Automated Hermitage Testing
This article discusses transaction isolation levels (Read Uncommitted, Read Committed, Repeatable Read, Serializable) in MySQL and MariaDB,
theconsensus.dev·24d ago
Columnar Storage as Database Normalization: Understanding the Relational Foundation
The article explains that columnar storage in databases is essentially a form of normalization within the relational model, not a completely
buttondown.com·1mo ago
PgQue: Zero-Bloat Postgres Queue System Using Pure SQL and pg_cron
PgQue is a zero-bloat Postgres queue system that revives the PgQ architecture originally designed at Skype for handling messaging for hundre
github.com·1mo ago
Rethinking Database Usage: When File-Based Storage Might Be Better Than Traditional Databases
The article challenges conventional wisdom about database usage, arguing that databases are essentially just files on disk and that for many
dbpro.app·1mo ago