edgedb / edgedb

A graph-relational database with declarative schema, built-in migration system, and a next-generation query language
https://edgedb.com
Apache License 2.0
12.76k stars 390 forks source link

Consider event sourcing projections #1819

Open Swoorup opened 3 years ago

Swoorup commented 3 years ago

This is both a question/request. One of the requirements of event sourcing application is projection/subscription to create read models.

Could edgedb provide mechanism to subscribe from a specific row in the events (append only table) and push changes to the consumers. That would eliminate the need for polling or message brokers like kafka.

elprans commented 3 years ago

We are planning to add support for event pub/sub via a configurable trigger system.

b4stien commented 10 months ago

Is this feature still planned? Is that the proper issue/discussion to track or is there another one?

elprans commented 10 months ago

Yes, EdgeDB 3.0 supports triggers, however a general pub/sub mechanism has not been implemented yet. On the TODO list.