Twisting PostgreSQL into a Document Db and Event Store
summary
Marten converts PostgreSQL into a usable document database and event store by using Postgres JSONB and Npgsql, building documents as single JSONB blobs and events in one append-only table; it relies on Postgres UPSERT for fast writes and PLV8 historically for transforms. The system materializes projections and snapshots so read models are kept up to date and served as prebuilt JSON streamed byte-for-byte, and the team explores Citus sharding to scale very large event tables.
AI-written summary · about
chapters (6)
- 0:00Introduction
- 3:43Why PostgreSQL for Marten?
- 5:20Marten as a Document Database
- 14:11Event sourcing
- 26:22Fast web services
- 33:53Future plans
related talks
01h 00mMarten: Postgresql backed Document Db and Event Store for .NET Development
47mMarten as a Document Store for .NET Applications
01h 00mPractical Event Sourcing with Marten and .NET
33mSchemaless SQL The Best of Both Worlds
26mDesigning for Document Databases in PostgreSQL
01h 00mThe Modern Database Debate: Documents, Tables, or Documents in Tables?
55mBreakout Session
59mPostgreSQL's secret NoSQL superpowers