Schema separation for event store and read models #166

New issue

Closed

opened 2026-03-02 22:41:18 +00:00 by ash · 0 comments

ash commented

2026-03-02 22:41:18 +00:00

Owner

Problem

All tables live in public schema. No separation between immutable event log and disposable read models.

Solution

Recommended layout:

eventstore.events / checkpoints / command_log
readmodel.* (all projections)

Use Postgres search_path in connection string — two pools, zero code changes.

Implementation

pgstore.EnsureSchema(ctx, pool, name) helper
Docs: recommended layout, rebuild guide
Migration guide: single-schema to two-schema

No framework changes needed — just pool configuration.

## Problem All tables live in public schema. No separation between immutable event log and disposable read models. ## Solution Recommended layout: ``` eventstore.events / checkpoints / command_log readmodel.* (all projections) ``` Use Postgres search_path in connection string — two pools, zero code changes. ## Implementation 1. pgstore.EnsureSchema(ctx, pool, name) helper 2. Docs: recommended layout, rebuild guide 3. Migration guide: single-schema to two-schema No framework changes needed — just pool configuration.