Fraktalio logo{ model }

Database

event-sourcing with PostgreSQL database.

  • Events table - a globally ordered ledger
  • Optimistic Locking - for concurrency control
  • Constrains - no misspelled event types, immutable by default

No additional tools, frameworks, or programming languages are required at this level.

Relation model for Event Sourcing

Stream it

event-streaming with PostgreSQL database.

  • Concurrent Consumers - for efficient streaming
  • Pool the DB / Push from DB - two techniques for database pooling and/or pushing events
  • At-Least-Once Delivery - to ensure reliability
  • Persisted Streams - track the progress

No Kafka or other streaming platforms are required at this level.

Relation model for Stream Processing

Fstore SQL - on Github

Event-Sourcing and Event-Streaming with Postgres database. Take me to the code!

Demo Applications

LanguageSource Code
Kotlin (Spring)
Kotlin (Ktor)
Rust (Actix-Web Server)
Rust (PostgreSQL Extension)