{"repo":"fraktalio/fstore-sql","free":true,"listed":false,"github":"https://github.com/fraktalio/fstore-sql","clone":"git clone https://github.com/fraktalio/fstore-sql.git","description":"PostgreSQL as event store - event sourcing & event streaming","language":"PLpgSQL","stars":49,"topics":["event-sourcing","event-streaming","postgresql","sql"],"license":null,"category":"databases-storage","readme_excerpt":"fstore-sql (event-store, based on postgres ) This project offers a seamless SQL model for efficiently prototyping event-sourcing and event-streaming by using Postgres database. Check the schema.sql and extensions.sql! It is all there! No additional tools, frameworks, or programming languages are required at this level. Table of contents Run Postgres Requirements Examples of usage Event Sourcing 1. Registering a simple decider decider1 with two event types it can publish: 'event1', 'event2' 2. Appending two events for the decider f156a3c4-9bd8-11ed-a8fc-0242ac120002 . 3. Get/List events for the decider f156a3c4-9bd8-11ed-a8fc-0242ac120002 Event Streaming 4. Registering a (materialized) view view1 with 1 second pooling frequency, starting from 28th Jan. 5. Appending two events for another decider 2ac37f68-9d66-11ed-a8fc-0242ac120002 . 6a. Stream the events to concurrent consumers/views 6b. Stream the events to concurrent consumers / edge-functions (views) Design fmodel fmodel-kotlin fmodel-ts fmodel-rust fmodel-java FModel Demo Applications Try YugabyteDB References and further reading This model is enabling and supporting: - event-sourcing data pattern (by using Postgres database) to durably store events - Append events to the ordered, append-only log, using entity id / decider id and decider type as a key - Load all the events for a single entity/decider, in an ordered sequence, using the entity id / decider id and decider type as a key - Support optimistic locking/concurrenc","default_branch":null,"files":null,"tree":[],"storefront":"/r/fraktalio","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/fraktalio/fstore-sql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}